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_v2_polygon.Underlying_evt_NewAccountGROUP BY1)SELECTweek,SUM(new_users) as new_usersFROMall_new_account_eventsGROUP BY1