Query editor
WITH-- Get all NewAccount eventsall_new_account_events AS (SELECTDATE_TRUNC('day', evt_block_time) AS day,COUNT(DISTINCT trader) as new_usersFROMsynfutures_v2_polygon.Underlying_evt_NewAccountGROUP BY1)SELECTday,SUM(new_users) as new_usersFROMall_new_account_eventsGROUP BY1