Query editor
with amm as (WITH markets as (SELECTfixedProductMarketMaker AS market_address, collateralToken AS collateralFROM polymarketfactory_polygon.fixedproductmarketmakerfactory_evt_fixedproductmarketmakercreation),collaterals AS (SELECT minute, contract_address, decimals, AVG(price) as priceFROM prices.usdWHERE blockchain = 'polygon'and contract_address IN (SELECT collateral FROM markets)GROUP BY 1,2,3)SELECTDATE_TRUNC('day', block_time) as "Day",SUM(bytearray_to_uint256(substr(DATA, 1, 32)) / POW(10, c.decimals*c.price)) as VolumeFROM polygon.logs bINNER JOIN markets m ON b.contract_address = m.market_addressLEFT JOIN collaterals c ON m.collateral = c.contract_address AND DATE_TRUNC('minute', b.block_time) = c.minuteWHERE topic0 IN (0x4f62630f51608fc8a7603a9391a5101e58bd7c276139366fc107dc3b67c3dcf8, 0xadcf2a240ed9300d681d9a3f5382b6c1beed1b7e46643e0c7b42cbe6e2d766b4)GROUP BY 1)SELECT "Day", SUM("Volume") as "Volume", SUM(SUM("Volume")) OVER (ORDER BY "Day") as "Cumulative Volume" FROM (SELECT DATE_TRUNC('day', evt_block_time) as "Day",CASEWHEN CAST(makerAssetId AS VARCHAR) = '0' THEN CAST(makerAmountFilled AS DOUBLE) / 1e6WHEN CAST(takerAssetId AS VARCHAR) = '0' THEN CAST(takerAmountFilled AS DOUBLE) / 1e6END AS "Volume"FROM polymarket_polygon.ctfexchange_evt_orderfilledUNION ALLSELECT DATE_TRUNC('day', evt_block_time) as "Day",CASEWHEN CAST(makerAssetId AS VARCHAR) = '0' THEN CAST(makerAmountFilled AS DOUBLE) / 1e6WHEN CAST(takerAssetId AS VARCHAR) = '0' THEN CAST(takerAmountFilled AS DOUBLE) / 1e6END AS "Volume"FROM polymarket_polygon.negriskctfexchange_evt_orderfilledUNION ALLSELECT * FROM ammUNION ALLSELECT DATE_TRUNC('day', evt_block_time) as "day",CASEWHEN side = 0 THEN (CAST(makerAmountFilled AS DOUBLE) + CAST(fee AS DOUBLE) )/ 1e6WHEN side = 1 THEN CAST(takerAmountFilled AS DOUBLE) / 1e6END AS "Volume"FROM polymarket_v2_polygon.ctfexchange_evt_orderfilledUNION ALLSELECT DATE_TRUNC('day', evt_block_time) as "day",CASEWHEN side = 0 THEN (CAST(makerAmountFilled AS DOUBLE) + CAST(fee AS DOUBLE) )/ 1e6WHEN side = 1 THEN CAST(takerAmountFilled AS DOUBLE) / 1e6END AS "Volume"FROM polymarket_v3_polygon.exchange_evt_orderfilled)GROUP BY 1