KeyrockAverage wallet txs
    Updated 2024-03-04
    SELECT
    AVG(total_transactions) as average_txs
    FROM
    (
    SELECT
    sender as wallet,
    COUNT(DISTINCT tx_hash) as total_transactions
    FROM
    aptos.core.fact_transactions
    where
    success = TRUE
    AND wallet != ''
    GROUP BY
    wallet
    )
    Last run: about 1 year ago
    AVERAGE_TXS
    1
    14.687884
    1
    13B
    64s