Delamir-6014E03 Top 20 days with most new users
    Updated 2022-11-17
    with user_list as (
    select
    from_address as users,
    min(block_timestamp) as min_date,
    count( tx_hash) as txs
    from ethereum_core.fact_transactions
    -- where min_date >= '2022-01-01'
    group by 1
    )
    , ts as (
    select
    min_date::date as date,
    count(users) as number_users
    from user_list
    -- where date >= '2021-01-01' and date < '2022-01-01'
    group by 1
    order by 1
    )
    select
    date,
    sum(number_users) over (order by date) as Cumulative,
    number_users
    from ts
    group by 1,3
    order by 3 desc
    limit 20
    Run a query to Download Data