WITH previous_traders AS (

SELECT DISTINCT trader

FROM near.defi.ez_dex_swaps

WHERE block_timestamp < '2024-01-01'

),

new_traders AS (

SELECT DISTINCT s.trader

FROM near.defi.ez_dex_swaps s

WHERE s.block_timestamp >= '2024-01-01'

AND s.block_timestamp <= '2024-12-31'

AND s.trader NOT IN (SELECT trader FROM previous_traders)

),

returning_traders AS (

SELECT DISTINCT s.trader

FROM near.defi.ez_dex_swaps s

WHERE s.block_timestamp >= '2024-01-01'

AND s.block_timestamp <= '2024-12-31'

AND s.trader IN (SELECT trader FROM previous_traders)

),

new_traders_weekly AS (

-- Active new traders in 2024 for each week

SELECT

s.trader,

DATE_TRUNC('WEEK', s.block_timestamp) AS week_start_date

FROM near.defi.ez_dex_swaps s

WHERE s.block_timestamp >= '2024-01-01'

AND s.block_timestamp <= '2024-12-31'

AND s.trader IN (SELECT trader FROM new_traders)

GROUP BY s.trader, week_start_date

),

returning_traders_weekly AS (

-- Active returning traders in 2024 for each week

SELECT

s.trader,