Query editor
WITH dates AS (SELECT day as dateFROM UNNEST(SEQUENCE(CAST('2024-02-29' AS DATE),CURRENT_DATE,INTERVAL '1' DAY)) AS t(day)),base_daily_transactions AS (SELECT DATE_TRUNC('day', evt_block_time) as date, COUNT(DISTINCT tx_hash) as daily_tx_countFROM (SELECT evt_block_time, evt_tx_hash as tx_hash FROM synfutures_base_v3_base.Instruments_evt_TradeWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_FillWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_PlaceWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_CancelWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_LiquidateWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_SettleWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_FundingFeeWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_UpdatePositionWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_RecycleInsuranceFundWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_AddWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_AdjustWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_ClaimProtocolFeeWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_RemoveWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_SweepWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_UpdateAmmStatusWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_UpdateConditionWHERE evt_block_time >= TIMESTAMP '2024-02-29'UNION ALLSELECT evt_block_time, evt_tx_hash FROM synfutures_base_v3_base.Instruments_evt_UpdateFeeState