datavortexTotal Transactions on C chain
    Updated 2025-03-19
    SELECT
    COUNT(DISTINCT from_address) AS "Total Wallets",
    COUNT(DISTINCT tx_hash) AS "Total Transactions",
    ROUND(COUNT(tx_hash) / COUNT(DISTINCT from_address), 2) AS "avg transactions per user",
    SUM(tx_fee) AS "total tx fee avax",
    (SUM(tx_fee) / COUNT(tx_hash)) AS "avg fee per tx avax"
    FROM
    avalanche.core.fact_transactions
    WHERE
    to_address IN (
    LOWER('0x483416eB3aFA601B9C6385f63CeC0C82B6aBf1fb'),
    LOWER('0xe397784960f814ba35c9ee0bc4c9dffdf86925f9'),
    LOWER('0xef0cdae2ffeeefa539a244a16b3f46ba75b8c810'),
    LOWER('0xe3b3f75f99da4ff26aa867ef70b48f8f6b2d4958')
    )
    AND tx_succeeded = TRUE
    Last run: 3 months ago
    Total Wallets
    Total Transactions
    avg transactions per user
    total tx fee avax
    avg fee per tx avax
    1
    1708523666513.85233.4955682670.0009866079406
    1
    52B
    3s