mz0111Untitled Query
    Updated 2022-11-25
    with first_tx as (
    select
    origin_from_address as user_address,
    min(block_timestamp)::date as min_date
    from ethereum.core.fact_event_logs
    where lower(contract_address) = lower('0x2e9d63788249371f1DFC918a52f8d799F4a38C94')
    group by user_address
    HAVING min_date >= CURRENT_DATE - 36

    )

    select
    count(user_address) as new_address,
    min_date,
    sum(new_address) over (order by min_date asc) as cumulative_address
    from first_tx
    group by min_date
    Run a query to Download Data