SELECT

DATE_TRUNC('week', block_timestamp) AS week,

COUNT(DISTINCT trader) AS weekly_traders,

COUNT(DISTINCT digest) AS weekly_trades,

SUM(CASE WHEN is_taker = FALSE THEN amount_usd ELSE 0 END) AS weekly_volume,

SUM(fee_amount) AS weekly_fees

FROM

arbitrum.vertex.ez_perp_trades

WHERE

trader != '0x0000000000000000000000000000000000000000'

AND subaccount != '0x0000000000000000000000000000000000000000000000000000000000000001'

GROUP BY

DATE_TRUNC('week', block_timestamp)

),

cumulative_data AS (

SELECT

week,

weekly_traders,

weekly_trades,

weekly_volume,

weekly_fees,

SUM(weekly_traders) OVER (ORDER BY week) AS cumulative_traders,

SUM(weekly_trades) OVER (ORDER BY week) AS cumulative_trades,

SUM(weekly_volume) OVER (ORDER BY week) AS cumulative_volume,

SUM(weekly_fees) OVER (ORDER BY week) AS cumulative_fees

FROM

weekly_data

SELECT

week,

weekly_traders,

cumulative_traders,

weekly_trades,

cumulative_trades,