Query editor
WITH monthly_volume AS (SELECTDATE_TRUNC('month', block_time) AS date,stable.symbol,--stable.contract_address,--stable.chain,SUM(amount) AS monthly_transfer_volume -- keep raw amounts for “big numbers”FROM tokens.transfers trINNER JOIN dune.serotonin_data.result_stablecoin_registry stableON tr.blockchain = stable.chainAND tr.contract_address = stable.contract_addressWHERE "from" <> 0x0000000000000000000000000000000000000000AND "to" <> 0x0000000000000000000000000000000000000000AND block_time > CURRENT_DATE - INTERVAL '24' MONTHAND stable.symbol IN ('PYUSD', 'PYUSD', 'USDG', 'USDP', 'USDL', 'USDL', 'PAXG')GROUP BY 1, stable.symbol)SELECTdate,symbol,monthly_transfer_volume,SUM(monthly_transfer_volume) OVER(PARTITION BY symbol ORDER BY date) AS cumulative_volumeFROMmonthly_volumeORDER BY date, symbol