kasadeghTotal Unique Addresses Since July 1, 2022
    Updated 2022-07-09
    with daily as (
    select BLOCK_TIMESTAMP::date as day,count(distinct FROM_ADDRESS) as total_unique_addresses
    from polygon.core.fact_transactions
    where BLOCK_TIMESTAMP::date>='2022-07-1'
    group by day
    order by day
    )

    select sum (total_unique_addresses) as total_unique_addresses, avg(total_unique_addresses) average_daliy_unique_addresses
    from daily

    Run a query to Download Data