Afonso_DiazUntitled Query
    Updated 2023-01-22
    with t as (
    select
    block_timestamp::date as day,
    count(distinct to_address) as active_holders_count
    from ethereum.core.fact_token_transfers
    where contract_address = '0x92d6c1e31e14520e676a687f0a93788b716beff5'
    and block_timestamp > current_date - 90
    group by 1
    )

    select avg(active_holders_count) as average_active_holders_count
    from t
    Run a query to Download Data