Query editor
SELECTblock_date-- ,concat(project,token_pair) as pair,project,SUM(amount_usd) AS Daily_vol-- ,count(1) as txs-- ,count(distinct tx_from) as users,SUM(SUM(amount_usd)) OVER (ORDER BY block_date) AS cum_volFROM dex.tradesWHERE blockchain = 'mantle'-- and block_month >= DATE('2023-07-01')and block_month >= DATE('2025-07-01')-- and block_date >= current_date - interval '24' hourand (token_bought_address = 0x78c1b0C915c4FAA5FffA6CAbf0219DA63d7f4cb8 ortoken_sold_address = 0x78c1b0C915c4FAA5FffA6CAbf0219DA63d7f4cb8)-- and token_sold_address = 0xDeadDeAddeAddEAddeadDEaDDEAdDeaDDeAD0000GROUP BY 1,2order by block_date desc, Daily_vol desc