Query editor
WITHv1_trades_on_polygon AS (SELECTdate_trunc('week', evt_block_time) as week,count(*) as trade_countFROMsynfutures_v1_polygon.Amm_evt_TradeWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)Group by1),v1_trades_on_bnb AS (SELECTdate_trunc('week', evt_block_time) as week,count(*) as trade_countFROMsynfutures_v1_bnb.Amm_evt_TradeWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)Group by1),v1_trades_on_ethereum AS (SELECTdate_trunc('week', evt_block_time) as week,count(*) as trade_countFROMsynfutures_v1_ethereum.Amm_evt_TradeWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)Group by1),v1_trades_on_arbitrum AS (SELECTdate_trunc('week', evt_block_time) as week,count(*) as trade_countFROMsynfutures_v1_arbitrum.Amm_evt_TradeWHEREevt_block_time <= CAST('2023-02-01' AS TIMESTAMP)Group by1),v1_all_trades AS (SELECT*FROMv1_trades_on_polygonUNION ALLSELECT*FROMv1_trades_on_bnbUNION ALLSELECT*FROMv1_trades_on_ethereum