Updated 2025-03-01
    select
    count(distinct tx_hash) as transactions,
    count(distinct from_address) as users,
    transactions / datediff('seconds', min(block_timestamp), max(block_timestamp)) as tps,
    sum(tx_fee) as volume_fee,
    avg(tx_fee) as average_fee_amount,
    transactions / count(distinct block_timestamp::date) as daily_average_transactions,
    users / count(distinct block_timestamp::date) as daily_average_users
    from
    ink.core.fact_transactions
    where
    tx_succeeded


    QueryRunArchived: QueryRun has been archived