date_trunc('day',first_transaction_stamp) as date,

case

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

else 'Before holidays' end as days,

count (distinct sender) as new_users,

sum(new_users) over (order by date) as cum_newcomers

from (

select

distinct TX_SENDER as sender,

min(block_timestamp) as first_transaction_stamp

from terra.core.fact_transactions

WHERE tx_id is not null

group by 1

)

where date>='2022-12-01'

group by 1