with t1 as (SELECT
from_address as new_user,
min(block_timestamp) as date1
from polygon.core.fact_transactions
GROUP by 1)
SELECT
date_trunc('day', date1) as date,
case when date < '2023-01-18' then 'Before hard fork'
else 'After hard fork' end as date_cat,
count(*) as n_new_users
from t1
where date1 >= '2023-01-01'
GROUP by 1, 2
order by 1