Query editor
WITH tbl_cteAS(SELECT date_trunc('day',block_time) AS "Day", COUNT(DISTINCT "evt_tx_hash") AS "Distinct Transactions", SUM(CASE WHEN currency_symbol NOT IN ('USDT','USDC') THEN currency_amount_per_row ELSE NULL END) AS "ETH Volume", SUM(usd_volume) AS "USD Volume", SUM(value) AS "Tokens Traded", 1.0*SUM(value)/COUNT(DISTINCT "evt_tx_hash") AS "Tokens per Transaction"FROM dune_user_generated.tbl_gem_transactions tWHERE currency_symbol IN ('ETH','WETH','USDT','USDC')AND NOT (t.token_id = '' OR t.token_id IS NULL)GROUP BY date_trunc('day',block_time))SELECT *, SUM("Distinct Transactions") OVER(ORDER BY "Day" ASC) AS "Cummulative Transactions", SUM("ETH Volume") OVER(ORDER BY "Day" ASC) AS "Cummulative ETH Volume", SUM("USD Volume") OVER(ORDER BY "Day" ASC) AS "Cummulative USD Volume", SUM("Tokens Traded") OVER(ORDER BY "Day" ASC) AS "Cummulative Tokens Traded"FROM tbl_cteWHERE "Day" > '2022-01-08'ORDER BY "Day" DESC;--{{full dash refresh}}