BlockTrackeractive users
    Updated 2024-10-15
    select
    date_trunc('{{granularity}}', block_timestamp) as date,
    count(DISTINCT sender) as user
    from aptos.core.fact_transactions
    where block_timestamp :: date >= dateadd(day, -{{past_days}}, current_date())
    and date < current_date
    group by 1





    QueryRunArchived: QueryRun has been archived