Query editor
with daily as (selectblock_date, chain, rn, sum(volume) as volume, sum(swaps) as swapsfrom query_5478137 -- NZDD DEX Trading - overtime (Multichain)group by block_date, chain, rn),ovr as (selectblock_date,volume,chain,rn,swaps,sum(volume) over (partition by chain order by block_date) as vol_ovr_chain,sum(swaps) over (partition by chain order by block_date) as swp_ovr_chain,sum(volume) over (order by block_date) as vol_ovr_all,sum(swaps) over (order by block_date) as swp_ovr_allfrom daily)select *from ovrwhere rn = 1order by block_date desc