messariPolygon Days Active per Address Q2'23
    with
    base as (
    select
    from_address as address,
    count(distinct date(block_timestamp)) as active_days
    from polygon.core.fact_transactions
    where date(block_timestamp) between '{{Start_date}}' and '{{End_date}}'
    group by 1
    )
    select
    active_days as days_active_in_quarter,
    count(active_days) as number_of_addresses
    from
    base
    group by 1
    order by 1 asc


    Run a query to Download Data