Query editor
WITHv2_users_on_polygon AS (SELECTevt_block_time,taker AS traderFROMsynfutures_v2_polygon.Underlying_evt_TradeUNION ALLSELECTevt_block_time,traderFROMsynfutures_v2_polygon.Underlying_evt_DepositUNION ALLSELECTevt_block_time,traderFROMsynfutures_v2_polygon.Underlying_evt_WithdrawUNION ALLSELECTevt_block_time,liquidator as traderFROMsynfutures_v2_polygon.Underlying_evt_LiquidateUNION ALLSELECTevt_block_time,traderFROMsynfutures_v2_polygon.Underlying_evt_NewAccount),v2_daily_users_on_polygon AS (SELECTDATE_TRUNC('day', evt_block_time) AS day,COUNT(DISTINCT trader) AS active_usersFROMv2_users_on_polygonGROUP BY1)SELECTday,SUM(active_users) AS active_usersFROMv2_daily_users_on_polygonGROUP BY1