Query editor
WITH fee_incurring_swaps AS (SELECT DISTINCT tx_hash, blockchainFROM dune.sushi_labs.result_revenue_2_0_recordsWHERE block_time < date_trunc('day', CURRENT_TIMESTAMP)AND transfer_type = 'SWAP_FEE'),-- one row per (chain, tx), carry month + taker + summed volumetrades_tx AS (SELECTtr.blockchain,tr.tx_hash,DATE_TRUNC('month', MIN(tr.block_time)) AS month,MIN(tr.taker) AS taker,SUM(tr.amount_usd) AS volume_txFROM (SELECT * FROM sushiswap_agg.tradesUNION ALLSELECT * FROM dune.sushi_labs.result_rp_trades_spellbook_pr) as trGROUP BY 1,2),monthly_chain_agg AS (SELECTt.month,t.blockchain,COUNT(*) AS swaps, -- 1 row per txCOUNT(DISTINCT t.taker) AS users,SUM(t.volume_tx) AS volumeFROM trades_tx tINNER JOIN fee_incurring_swaps fON t.blockchain = f.blockchainAND t.tx_hash = f.tx_hashGROUP BY 1,2)SELECTmonth,blockchain,swaps,users,volume,SUM(swaps) OVER (PARTITION BY blockchain ORDER BY month) AS swaps_cumulative,SUM(users) OVER (PARTITION BY blockchain ORDER BY month) AS users_cumulative,SUM(volume) OVER (PARTITION BY blockchain ORDER BY month) AS volume_cumulativeFROM monthly_chain_aggORDER BY month, blockchain;