Query editor
WITH base_dates AS (-- Generate all dates from February 29, 2024, to the current dateSELECT day AS dateFROM UNNEST(SEQUENCE(CAST('2024-02-29' AS DATE),CURRENT_DATE,INTERVAL '1' DAY)) AS t(day)),base_events AS (-- Gather all relevant user events on the Base platform from distinct actionsSELECT DISTINCT trader, evt_block_timeFROM (SELECT trader, evt_block_time FROM synfutures_base_v3_base.Gate_evt_DepositWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION DISTINCTSELECT trader, evt_block_time FROM synfutures_base_v3_base.Instruments_evt_FillWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION DISTINCTSELECT trader, evt_block_time FROM synfutures_base_v3_base.Instruments_evt_AddWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION DISTINCTSELECT trader, evt_block_time FROM synfutures_base_v3_base.Instruments_evt_AdjustWHERE evt_block_time >= TIMESTAMP '2024-02-29')),base_unique_daily_users AS (-- Calculate daily unique users for BaseSELECT DATE_TRUNC('day', evt_block_time) AS date, traderFROM base_eventsGROUP BY DATE_TRUNC('day', evt_block_time), trader),base_cumulative_users AS (-- Calculate cumulative unique users for Base up to each dateSELECT d.date,COUNT(DISTINCT u.trader) AS cumulative_base_usersFROM base_dates dLEFT JOIN base_unique_daily_users u ON u.date <= d.dateGROUP BY d.date),blast_dates AS (-- Generate all dates from February 29, 2024, to the current dateSELECT day AS dateFROM UNNEST(SEQUENCE(CAST('2024-02-29' AS DATE),CURRENT_DATE,INTERVAL '1' DAY)) AS t(day)),blast_events AS (-- Gather all relevant user events on the Blast platform from distinct actionsSELECT DISTINCT trader, evt_block_timeFROM (