Query editor
selectdate_trunc('day', time) as day,sum(case when coin = 'BTC' then funding end) as btc_daily_funding,sum(case when coin = 'ETH' then funding end) as eth_daily_fundingfrom hyperliquid.market_datawhere (coin = 'BTC' or coin = 'ETH')and time > cast('2024-01-01 00:00' as timestamp)group by 1order by 1 desc