Query editor
select date_trunc('DAY',block_time) as DAY,blockchain,sum(token_bought_amount) as Bought,SUM(amount_usd) AS VOLfrom dex.tradeswhere token_bought_symbol ='BTC'and block_time >= date('2024-01-01')GROUP BY 1,2ORDER BY 1,2
Query editor
1select date_trunc('DAY',block_time) as DAY,2blockchain,3sum(token_bought_amount) as Bought,4SUM(amount_usd) AS VOL5from dex.trades6where token_bought_symbol ='BTC'7and block_time >= date('2024-01-01')8GROUP BY 1,29ORDER BY 1,2