Query editor
WITH markets AS(SELECT fixedProductMarketMakerFROM polymarketfactory_polygon.FixedProductMarketMakerFactory_evt_FixedProductMarketMakerCreationWHERE collateralToken = 0x2791bca1f2de4661ed88a30c99a7a9449aa84174)SELECT date_trunc('day', block_time) AS day,sum(usd) AS usdFROM(SELECT block_time,bytearray_to_uint256(substr(DATA, 1, 32)) / 1e6 AS usdFROM polygon.logsWHERE topic0 IN (0x4f62630f51608fc8a7603a9391a5101e58bd7c276139366fc107dc3b67c3dcf8, 0xadcf2a240ed9300d681d9a3f5382b6c1beed1b7e46643e0c7b42cbe6e2d766b4)AND contract_address IN(SELECT *FROM markets)AND block_number >= 4023680UNION ALL SELECT block_time,amountFROM polymarket_polygon.market_trades) aWHERE block_time > CURRENT_TIMESTAMP - INTERVAL '3' MONTHGROUP BY 1ORDER BY 1