SELECT

DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week_start,

CONCAT(SYMBOL, '-USDC') AS symbol,

IS_TAKER AS isTaker,

digest

FROM

arbitrum.vertex.ez_spot_trades

WHERE

EVENT_NAME = 'FillOrder'

AND BLOCK_TIMESTAMP >= TIMESTAMP '2023-04-26'

AND IS_TAKER = TRUE

),

Perpetual_Trades AS (

SELECT

DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week_start,

SYMBOL AS symbol,

IS_TAKER AS isTaker,

digest

FROM

arbitrum.vertex.ez_perp_trades

WHERE

EVENT_NAME = 'FillOrder'

AND BLOCK_TIMESTAMP >= TIMESTAMP '2023-04-26'

AND IS_TAKER = TRUE

),

Combined_Trades AS (

SELECT * FROM Spot_Trades

UNION ALL

SELECT * FROM Perpetual_Trades

SELECT

week_start,

symbol,

COUNT(DISTINCT digest) AS "total_trades"