Elprognerd4-Number of New Users (Daily)
    Updated 2023-01-07
    select
    date_trunc('day', enterance_date) as date,
    case when date < '2023-01-01' then 'Before 2023'
    else '2023'
    END as "Time",
    count(user) as "Number of New Users",
    sum("Number of New Users") over (order by date) as "Cumulative Number of New Users (Past 2 Month)"
    from (
    select
    tx_sender as user,
    min(block_timestamp) as enterance_date
    from terra.core.fact_transactions
    group by 1
    )
    where enterance_date > current_date - interval '60 days'
    group by 1
    order by 1
    Run a query to Download Data