hessNumber of New Users Per First 10 Days of Each Month
    Updated 2023-01-11
    with sender as ( select min(block_timestamp::date) as date, tx_sender
    from terra.core.fact_transactions
    group by 2)

    select date, case when MONTH_NAME = 'January' then 'January 2023' else month_name end as month,MONTH_OF_YEAR, count(DISTINCT(tx_sender)) as total_user, rank() over (partition by month order by date asc) as rank
    from sender a join ethereum.core.dim_dates b on a.date = b.date_day
    group by 1,2,3
    qualify rank <= 10
    Run a query to Download Data