Query editor
with myriad as (with trades as (SELECT evt_block_time, evt_tx_hash, user, 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, user, 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, user, 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, user, 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('week', block_time) as "Week", COUNT(DISTINCT user) as "Unique Users"FROM trades tRIGHT JOIN markets m ON t.contract_address = m.contract_address AND t.marketId = m.marketIdGROUP BY 1),limitless as (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('week', block_time) as "Week", SUBSTR(topic1, 13, 20)FROM base.logs bINNER JOIN markets m ON b.contract_address = m.market_addressWHERE topic0 IN (0x4f62630f51608fc8a7603a9391a5101e58bd7c276139366fc107dc3b67c3dcf8, 0xadcf2a240ed9300d681d9a3f5382b6c1beed1b7e46643e0c7b42cbe6e2d766b4)),weekly as (SELECT DATE_TRUNC('week', evt_block_time) as "Week", maker as "User"FROM limitless_base.ctfexchange_evt_orderfilled -- single-outcome markets makersUNION ALLSELECT DATE_TRUNC('week', evt_block_time) as "Week", takerFROM limitless_base.ctfexchange_evt_orderfilled -- single-outcome markets takersUNION ALLSELECT DATE_TRUNC('week', evt_block_time) as "Week", makerFROM limitless_base.negriskctfexchange_evt_orderfilled -- multi-outcome markets makersUNION ALLSELECT DATE_TRUNC('week', evt_block_time) as "Week", takerFROM limitless_base.negriskctfexchange_evt_orderfilled -- multi-outcome markets takersUNION ALLSELECT * FROM amm)