the query I used for the BTC-USD data is as follows

SELECT 
    timestamp,
    first(price) AS open,
    last(price) AS close,
    min(price),
    max(price),
    sum(amount) AS volume
FROM trades
WHERE symbol ='BTC-USD' 
AND timestamp > '2022-11-22 01:32:08'
--AND timestamp <= '2022-11-22 11:44:00'
SAMPLE BY 1s ALIGN TO CALENDAR
order by timestamp desc;

the same query but for ETH produces up-to-date/live-ticking results

SELECT 
    timestamp,
    first(price) AS open,
    last(price) AS close,
    min(price),
    max(price),
    sum(amount) AS volume
FROM trades
WHERE symbol ='ETH-USD' 
AND timestamp > '2022-11-22 01:32:08'
SAMPLE BY 1s ALIGN TO CALENDAR
order by timestamp desc;

my guess is - the ETL pipeline is broken for BTC-USD , either the “listener” ( Websocket subscription for trades from some crypto exchange website) , or perhaps the component that feeds/pumps the data to the database. Or, equally likely, the crypto exchange(s) from which the BTC-USD data gets streamed to QuestDB has a malfunction in their public websocket API channel (tho strange that it’s limited to BTC-USD and doesn’t affect ETH-USD).

also QuestDB sales team (if you’re on this channel), I’d love to have a discussion of a commercial / supported user license for QuestDB… our company has purchased a fair amount (1 PB at least) of historical tick data, but it’s all sitting in gzipped CSVs on Amazon S3 buckets. And we have subscription to more live tick data with Coinmetrics, but the interface to retrieve that data is clunky. Our Engineering department is leaning toward BigQuery for a solution, but I personally think QuestDB or a similar time series database would work better for this use case.

but in the mean-time, if you could let me know when this BTC-USD thing is fixed on the demo site, that would help me sell (demo) your guys product internally 🙂 ,

I’ve spent my fair share of time with tick databases (KDB, Reuters FASTick, etc) and DBs in general… yours ranks nicely , in my view

I didn’t even know I was making a Radiohead reference, until I typed it up and posted…happens a lot with me, this spontaneous song reference generation. Happy Thanksgiving 🦃 to those who celebrate

btw, Pei, thanks for the heads-up about the demo project being fixed for BTC-USD now (and for the explanation as to the root causes & the fix that was done ) , Also, checked the demo website, it’s working correctly for BTC-USD now ,

thanks a lot team

🙏 (now I really have something to be thankful for 🙂 )

I’m stepping away to get some dinner for now (8pm here in Korea), but I’ll be back with questions (hopefully useful ones) soon