SniperTotal Transactions
    Updated 2024-10-02
    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'