Query editor
with amm as (WITH markets as (SELECTfixedProductMarketMaker AS market_address, collateralToken AS collateralFROM polymarketfactory_polygon.FixedProductMarketMakerFactory_evt_FixedProductMarketMakerCreation)SELECTDATE_TRUNC('day', block_time) as "Date", SUBSTR(topic1, 13, 20)FROM polygon.logs bINNER JOIN markets m ON b.contract_address = m.market_addressWHERE topic0 IN (0x4f62630f51608fc8a7603a9391a5101e58bd7c276139366fc107dc3b67c3dcf8, 0xadcf2a240ed9300d681d9a3f5382b6c1beed1b7e46643e0c7b42cbe6e2d766b4)),daily as (SELECT DATE_TRUNC('day', evt_block_time) as "Date", maker as "User"FROM polymarket_polygon.ctfexchange_evt_orderfilled -- single-outcome markets makersUNION ALLSELECT DATE_TRUNC('day', evt_block_time) as "Date", takerFROM polymarket_polygon.ctfexchange_evt_orderfilled -- single-outcome markets takersUNION ALLSELECT DATE_TRUNC('day', evt_block_time) as "Date", makerFROM polymarket_polygon.negriskctfexchange_evt_orderfilled -- multi-outcome markets makersUNION ALLSELECT DATE_TRUNC('day', evt_block_time) as "Date", takerFROM polymarket_polygon.negriskctfexchange_evt_orderfilled -- multi-outcome markets takersUNION ALLSELECT DATE_TRUNC('day', evt_block_time) as "Date", makerFROM polymarket_v2_polygon.ctfexchange_evt_orderfilledUNION ALLSELECT DATE_TRUNC('day', evt_block_time) as "Date", takerFROM polymarket_v2_polygon.ctfexchange_evt_orderfilledUNION ALLSELECT * FROM ammUNION ALLSELECT DATE_TRUNC('day', evt_block_time) as "Date", makerFROM polymarket_v3_polygon.exchange_evt_orderfilledUNION ALLSELECT DATE_TRUNC('day', evt_block_time) as "Date", takerFROM polymarket_v3_polygon.exchange_evt_orderfilled),oldandnew as (SELECT "Date", new_users as "New", (unique_users - new_users) as "Old"FROM (SELECT sq."Date", COUNT(*) AS new_usersFROM (SELECT "User" as unique_users, MIN("Date") AS "Date"FROM dailyGROUP BY 1ORDER BY 1) sqGROUP BY 1) ssq LEFT JOIN (SELECT "Date" AS "Date", COUNT(DISTINCT "User") AS unique_usersFROM dailyGROUP BY 1ORDER BY 1) t2 USING("Date")ORDER BY 1 DESC