SniperTotal Transactions
    Updated 2025-02-22
    select
    count(DISTINCT tx_hash) as transactions,
    count(DISTINCT from_address) as users,
    transactions/users as "Avg Tx Per User"
    from kaia.core.fact_transactions
    where TX_SUCCEEDED = 'TRUE' or TX_SUCCEEDED = 'true'
    and block_timestamp>= '2024-01-01'
    Last run: about 2 months ago
    TRANSACTIONS
    USERS
    Avg Tx Per User
    1
    19231168435737153533.520401
    1
    33B
    150s