Query editor
-- Todo:-- Bring Redbelly dex trades-- Bring Solana dex tradeswith all_tx as (-- Get ethereumselectDATE_TRUNC('{{period}}', "date") as "date", sum(volume) as volume, sum(swaps) as swaps, 'Ethereum' as chainfrom query_6378612 -- AUDM DEX Trading - overtime (Ethereum)group by 1,4union-- -- Get baseselectDATE_TRUNC('{{period}}', "date") as "date", sum(volume) as volume, sum(swaps) as swaps, 'Base' as chainfrom query_7707558 -- AUDM DEX Trading - overtime (Base)group by 1,4-- union-- Get solana-- select-- DATE_TRUNC('{{period}}', "date") as "date"-- , sum(volume) as volume-- , sum(swaps) as swaps-- , 'Base' as chain-- from query_5977190 -- AUDM DEX Trading - overtime (Base)-- group by 1,4)select*, sum(volume) over (partition by chain order by "date" asc) as cum_volume, sum(swaps) over (partition by chain order by "date" asc) as cum_swaps, sum(volume) over (order by "date" asc) as cum_volume_all, sum(swaps) over ( order by "date" asc) as cum_swaps_all, sum(volume) over (partition by "date" order by "date" asc) as volume_bydate, row_number() over (partition by chain order by "date" desc) as rnfrom all_txorder by 1 desc