Query editor
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),daily as (SELECT DATE_TRUNC('day', evt_block_time) as "Date", user as userFROM trades tRIGHT JOIN markets m ON t.contract_address = m.contract_address AND t.marketId = m.marketId),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 fINNER JOIN oldandnew o ON f."Date" = o."Date"