Query editor
-- select *-- ,cum_vol/1000000000 as cum_vol_1-- ,vol/1000000 as vol_1-- from-- (SELECTblock_date as dt,blockchain,SUM(amount_usd) AS vol-- Count(1) AS txs,-- Count(distinct tx_from) AS user,,SUM(SUM(amount_usd)) OVER (PARTITION BY blockchain ORDER BY block_date) AS cum_vol-- ,SUM(SUM(amount_usd)) OVER (ORDER BY block_date ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as vol_7dFROM dex.tradesWHERE block_month >= DATE('2025-08-01')and (token_sold_address in (0x5FA487BCa6158c64046B2813623e20755091DA0b, 0xfdd22ce6d1f66bc0ec89b20bf16ccb6670f55a5a)or token_bought_address in (0x5FA487BCa6158c64046B2813623e20755091DA0b, 0xfdd22ce6d1f66bc0ec89b20bf16ccb6670f55a5a))GROUP BY 1,2-- ) a-- where dt >= DATE('2025-01-01')order by 1 desc, cum_vol desc