-- forked from b8872ef3-6cbb-48b3-9022-64eedf7b1c2d
select
date(joined_date) as date,
case
when joined_date::date > '2023-01-17' then 'After Hard Fork'
else 'Before Hard Fork'
end as
Type,
count(from_address) as new_user
from
(
select
from_address,
min(block_timestamp::date) as joined_date
from polygon.core.fact_transactions
where
block_timestamp::date >= '2022-12-17'
and block_timestamp::date < '2023-02-18'
group by 1
)
group by 1,2