first_transaction_stamp::DATE as date,

case

when first_transaction_stamp>='2022-12-25' then 'Holidays and new year'

else 'Before holidays' end as days,

count (distinct sender) as new_users

from (

select

distinct PROPOSER as sender,

min(block_timestamp) as first_transaction_stamp

from flow.core.fact_transactions

where tx_succeeded = 'TRUE'

and block_timestamp >= '2022-12-01'

group by 1

)

where first_transaction_stamp>='2022-12-01'

group by 1,2