Query editor
with trades as (SELECT evt_block_time, evt_tx_hash, contract_address, action, marketId, value, 'abstract' as chain FROM myriad_abstract.predictionmarketv3_evt_marketactiontxWHERE action IN (0,1)UNION ALLSELECT evt_block_time, evt_tx_hash, contract_address, action, marketId, value, chain FROM myriad_multichain.predictionmarketv3_4_evt_marketactiontxWHERE action IN (0,1)UNION ALLSELECT evt_block_time, evt_tx_hash, contract_address, action, marketId, value, 'abstract' as chain FROM myriad_abstract.predictionmarketv3_3_points_evt_marketactiontxWHERE action IN (0,1)UNION ALLSELECT evt_block_time, evt_tx_hash, contract_address, action, marketId, value, 'abstract' as chain FROM myriad_abstract.predictionmarketv4_evt_marketactiontxWHERE action IN (0,1)),markets as (SELECT * FROM query_5971135)SELECT date_trunc('day', evt_block_time) as day,SUM(value*price/POW(10, decimals))/2 as "USD Volume",SUM(SUM(value*price/POW(10, decimals))/2) OVER(ORDER BY DATE_TRUNC('day', evt_block_time)) as "Cumulative USD Volume"FROM trades tRIGHT JOIN markets m ON t.contract_address = m.contract_address AND t.marketId = m.marketIdLEFT JOIN prices.usd p ON m.token = CAST(p.contract_address AS VARCHAR) AND t.chain = p.blockchain AND DATE_TRUNC('minute', t.evt_block_time) = p.minuteWHERE p.blockchain IN ('abstract', 'linea', 'bnb')GROUP BY 1