Query editor
-- Todo:-- Bring Redbelly dex tradeswith all_tx as (-- Get ethereumselectDATE_TRUNC('{{period}}', "date") as "date", sum(volume) as volume, sum(swaps) as swaps, 'Ethereum' as chainfrom query_6752297 -- AUDF DEX Trading - overtime (Ethereum)group by 1,4union-- Get polygonselectDATE_TRUNC('{{period}}', "date") as "date", sum(volume) as volume, sum(swaps) as swaps, 'Polygon' as chainfrom query_6752299 -- AUDF DEX Trading - overtime (Polygon)group by 1,4union-- Get baseselectDATE_TRUNC('{{period}}', "date") as "date", sum(volume) as volume, sum(swaps) as swaps, 'Base' as chainfrom query_6752372 -- AUDF DEX Trading - overtime (Base)group by 1,4union-- Get avalancheselectDATE_TRUNC('{{period}}', "date") as "date", sum(volume) as volume, sum(swaps) as swaps, 'Base' as chainfrom query_6752381 -- AUDF DEX Trading - overtime (Avalanche)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