maybeyonasorb_distinct_weekly_users
    Updated 2021-12-06
    with weekly as (
    select
    last_day(block_timestamp,'week') as weekend,
    count(distinct origin_address) as distinct_users
    from ethereum.udm_events
    where contract_address = '0xff56cc6b1e6ded347aa0b7676c85ab0b3d08b0fa'
    group by 1
    )

    select
    weekend,
    distinct_users,
    sum(distinct_users) over (order by weekend rows between unbounded preceding and current row) as user_growth
    from weekly

    -- limit 100
    Run a query to Download Data