SELECT

trader,

MIN(block_timestamp) AS min_date

FROM

near.defi.ez_dex_swaps

GROUP BY

trader

),

new_users AS (

SELECT

date_trunc('day', min_date) AS date,

COUNT(DISTINCT trader) AS new_user_count

FROM

users

WHERE

min_date between '2024-12-01' and '2024-12-31'

GROUP BY

date

),

old_users AS (

SELECT

date_trunc('day', block_timestamp) AS date,

COUNT(DISTINCT

CASE

WHEN trader IN (SELECT trader FROM users WHERE date_trunc('day', min_date) = date_trunc('day', block_timestamp))

THEN NULL

ELSE trader

END

) AS old_user_count,

COUNT(DISTINCT trader) AS total_user_count

FROM

near.defi.ez_dex_swaps

WHERE