SELECT

from_address,

MIN(block_timestamp) AS min_date

FROM

thorchain.defi.fact_swaps

GROUP BY

from_address

),

new_users AS (

SELECT

date_trunc('day', min_date) AS date,

COUNT(DISTINCT from_address) AS new_user_count

FROM

users

WHERE

min_date between '2024-11-01' and '2024-11-30'

GROUP BY

date

),

old_users AS (

SELECT

date_trunc('day', block_timestamp) AS date,

COUNT(DISTINCT

CASE

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

THEN NULL

ELSE from_address

END

) AS old_user_count,

COUNT(DISTINCT from_address) AS total_user_count

FROM

thorchain.defi.fact_swaps

WHERE