MLDZMNterradash3
    Updated 2023-01-10
    select
    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
    Run a query to Download Data