SELECT

trader,

DATE_TRUNC('week', block_timestamp) AS weekly, -- Alias 'weekly' for the week start

MIN(block_timestamp) AS first_trade_time

FROM

arbitrum.vertex.ez_perp_trades

WHERE

trader != '0x0000000000000000000000000000000000000000'

AND subaccount != '0x0000000000000000000000000000000000000000000000000000000000000001'

GROUP BY

trader,

weekly

),

new_traders AS (

SELECT

trader,

weekly

FROM

weekly_traders

WHERE

first_trade_time >= weekly

),

weekly_new_traders_count AS (

SELECT

wt.weekly,

COUNT(DISTINCT nt.trader) AS new_traders_count

FROM

weekly_traders wt

LEFT JOIN new_traders nt

ON wt.trader = nt.trader

GROUP BY

wt.weekly

SELECT