SELECT

'Spot' AS trade_type,

DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week_start,

QUOTE_DELTA_AMOUNT AS quoteDelta,

IS_TAKER AS isTaker

FROM

arbitrum.vertex.ez_spot_trades

WHERE

EVENT_NAME = 'FillOrder'

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

),

Perpetual_Trades AS (

SELECT

'Perpetual' AS trade_type,

DATE_TRUNC('week', BLOCK_TIMESTAMP) AS week_start,

QUOTE_DELTA_AMOUNT AS quoteDelta,

IS_TAKER AS isTaker

FROM

arbitrum.vertex.ez_perp_trades

WHERE

EVENT_NAME = 'FillOrder'

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

),

Combined_Trades AS (

SELECT * FROM Spot_Trades

UNION ALL

SELECT * FROM Perpetual_Trades

SELECT

week_start,

trade_type,

SUM(CASE WHEN quoteDelta > 0 THEN quoteDelta ELSE -quoteDelta END) AS "weekly traded volume"

FROM

Combined_Trades