dweinstein33Comps / MATIC / DAA
    Updated 2024-01-16
    select
    block_timestamp::date as "Date",
    count(distinct from_address) as "Values"
    from
    polygon.core.fact_transactions
    where
    block_timestamp::date >= (current_date - 90)
    and status = 'SUCCESS'
    group by
    "Date"
    qualify
    "Date" < last_value("Date") over (order by "Date")
    order by
    "Date" desc
    QueryRunArchived: QueryRun has been archived