SELECT tx_sender, min(block_timestamp) as join_date

FROM terra.core.fact_transactions

GROUP BY 1

SELECT join_date::date as date,

COUNT(DISTINCT tx_sender) as new_wallets,

sum(new_wallets) over (order by date) as cum_new_wallets,

CASE WHEN date < '2023-01-14' THEN 'Before Station Announcement'

ELSE 'After Station Announcement' END as time_label

FROM new_users

WHERE date BETWEEN '2023-01-01' and '2023-01-21'

GROUP BY 1