Query editor
with all_tx as (selectblock_date, sum(volume) as volume, sum(swaps) as swaps, 'Ethereum' as chainfrom query_5475763 -- NZDD DEX Trading - overtime (Ethereum)group by 1,4unionselectblock_date, sum(volume) as volume, sum(swaps) as swaps, 'Base' as chainfrom query_5475983 -- NZDD DEX Trading - overtime (Base)group by 1,4unionselectblock_date, sum(volume) as volume, sum(swaps) as swaps, 'Polygon' as chainfrom query_5476013 -- NZDD DEX Trading - overtime (Polygon)group by 1,4)select *,row_number() over (partition by chain order by block_date desc) as rnfrom all_txorder by 1 desc