Query editor
WITH--V1 weekly users on polygonv1_users_on_polygon AS (SELECTevt_block_time,traderFROMsynfutures_v1_polygon.Amm_evt_TradeWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)UNION ALLSELECTevt_block_time,traderFROMsynfutures_v1_polygon.Amm_evt_DepositWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)UNION ALLSELECTevt_block_time,traderFROMsynfutures_v1_polygon.Amm_evt_WithdrawWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)UNION ALLSELECTevt_block_time,liquidator AS traderFROMsynfutures_v1_polygon.Amm_evt_LiquidateWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)UNION ALLSELECTevt_block_time,traderFROMsynfutures_v1_polygon.Amm_evt_AddLiquidityWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)UNION ALLSELECTevt_block_time,traderFROMsynfutures_v1_polygon.Amm_evt_RemoveLiquidityWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)UNION ALLSELECTevt_block_time,traderFROMsynfutures_v1_polygon.Amm_evt_NewAccountWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)),v1_weekly_users_on_polygon AS (