Delamir-6014Untitled Query
    Updated 2022-11-17

    with
    eth_users as (
    select * from (
    select
    from_address as user,
    min(block_timestamp) as min_date,
    count(distinct tx_hash) as txs
    from ethereum_core.fact_transactions
    group by 1
    )
    where min_date >= '2022-01-01'
    )

    select *,
    sum(users) over(order by date) as cum_users
    from (
    select
    date(min_date) as date,
    count(distinct user) as users,
    count(txs) as TXs
    from eth_users
    group by 1
    )
    Run a query to Download Data