Query editor
-- Todo:-- Bring Hedera/XDC dex tradeswith all_tx as (-- Get ethereumselectDATE_TRUNC('{{period}}', "date") as "date", sum(volume) as volume, sum(swaps) as swaps, 'Ethereum' as chainfrom query_5560061 -- AUDD 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_5977190 -- AUDD DEX Trading - overtime (Base)group by 1,4union-- Get stellarselectDATE_TRUNC('{{period}}', "date") as "date", sum(volume_in_usd) as volume, sum(swaps) as swaps, 'Stellar' as chainfrom query_5544159 -- AUDD DEX Trading - overtime (Stellar)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