Query editor
with amm as (WITH markets as (SELECTfixedProductMarketMaker AS market_address, collateralToken AS collateralFROM limitless_base.FixedProductMarketMakerFactory_evt_FixedProductMarketMakerCreationUNION ALLSELECTfixedProductMarketMaker AS market_address, collateralToken AS collateralFROM limitless_exchange_prod_hanson_v0_1_base.FixedProductMarketMakerFactory_evt_FixedProductMarketMakerCreation)SELECTDATE_TRUNC('day', block_time) as "Date", SUBSTR(topic1, 13, 20)FROM base.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 limitless_base.ctfexchange_evt_orderfilled -- single-outcome markets makersUNION ALLSELECT DATE_TRUNC('day', evt_block_time) as "Date", takerFROM limitless_base.ctfexchange_evt_orderfilled -- single-outcome markets takersUNION ALLSELECT DATE_TRUNC('day', evt_block_time) as "Date", makerFROM limitless_base.negriskctfexchange_evt_orderfilled -- multi-outcome markets makersUNION ALLSELECT DATE_TRUNC('day', evt_block_time) as "Date", takerFROM limitless_base.negriskctfexchange_evt_orderfilled -- multi-outcome markets takersUNION ALLSELECT * FROM amm),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),firstseen as (SELECT MIN("Date") AS "Date", "User" as unique_users FROM dailyGROUP BY 2)SELECT DISTINCT f."Date", "New", "Old", COUNT(unique_users) OVER (ORDER BY f."Date") as "Cumulative Unique Users" FROM firstseen f