andreafiandroAverage wallet txs
    Updated 2024-01-10
    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: over 1 year ago
    AVERAGE_TXS
    1
    14.687884
    1
    13B
    64s