Query editor
WITH base_all_events AS (SELECT trader AS user_address, evt_block_time AS block_timeFROM synfutures_base_v3_base.Gate_evt_DepositWHERE evt_block_time >= TIMESTAMP '2024-02-26'UNION ALLSELECT trader, evt_block_timeFROM synfutures_base_v3_base.Gate_evt_WithdrawWHERE evt_block_time >= TIMESTAMP '2024-02-26'UNION ALLSELECT trader, evt_block_timeFROM synfutures_base_v3_base.Instruments_evt_FillWHERE evt_block_time >= TIMESTAMP '2024-02-26'UNION ALLSELECT trader, evt_block_timeFROM synfutures_base_v3_base.Instruments_evt_AddWHERE evt_block_time >= TIMESTAMP '2024-02-26'UNION ALLSELECT trader, evt_block_timeFROM synfutures_base_v3_base.Instruments_evt_RemoveWHERE evt_block_time >= TIMESTAMP '2024-02-26'UNION ALLSELECT trader, evt_block_timeFROM synfutures_base_v3_base.Instruments_evt_AdjustWHERE evt_block_time >= TIMESTAMP '2024-02-26'),base_weekly_users AS (-- Calculate weekly users for Base (any interaction counts)SELECTDATE_TRUNC('week', block_time) AS week_start,COUNT(DISTINCT user_address) AS base_active_usersFROM base_all_eventsGROUP BY DATE_TRUNC('week', block_time)),blast_all_events AS (-- Get ALL possible events from Blast protocolSELECT trader AS user_address, evt_block_time AS block_timeFROM synfutures_blast_v3_blast.Gate_evt_DepositWHERE evt_block_time >= TIMESTAMP '2024-02-26'UNION ALLSELECT trader, evt_block_timeFROM synfutures_blast_v3_blast.Gate_evt_WithdrawWHERE evt_block_time >= TIMESTAMP '2024-02-26'UNION ALLSELECT call_tx_from, call_block_time