Query editor
WITH-- Get all NewAccount eventsall_new_account_events AS (SELECTDATE_TRUNC('week', evt_block_time) AS week,COUNT(DISTINCT trader) as new_usersFROMsynfutures_v1_polygon.Amm_evt_NewAccountWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)GROUP BY1UNION ALLSELECTDATE_TRUNC('week', evt_block_time) AS week,COUNT(DISTINCT trader) as new_usersFROMsynfutures_v1_bnb.Amm_evt_NewAccountWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)GROUP BY1UNION ALLSELECTDATE_TRUNC('week', evt_block_time) AS week,COUNT(DISTINCT trader) as new_usersFROMsynfutures_v1_ethereum.Amm_evt_NewAccountWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)GROUP BY1UNION ALLSELECTDATE_TRUNC('week', evt_block_time) AS week,COUNT(DISTINCT trader) as new_usersFROMsynfutures_v1_arbitrum.Amm_evt_NewAccountWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)GROUP BY1)SELECTweek,SUM(new_users) as new_usersFROMall_new_account_eventsGROUP BY1