Updated 2025-03-07

    SELECT
    COUNT(DISTINCT t.tx_hash) AS "total transactions",
    COUNT(DISTINCT t.from_address) AS "total wallets",
    SUM(f.tx_fee) AS "total fees",
    SUM(f.tx_fee) / NULLIF(COUNT(DISTINCT t.from_address), 0) AS "avg fee per wallet"
    FROM
    kaia.core.fact_traces t
    JOIN kaia.core.fact_transactions f ON t.tx_hash = f.tx_hash
    WHERE
    t.to_address IN (
    '0x0d0966da8e610376f723e42fdfc7a7383a1efd05',
    '0x2f0bcecce06b6eb32a83073984d0b793640aeaf6',
    '0xd37f28c6c51420054b1fb1362288d07ba40440e8',
    '0xb06cef4ff184f218c5318a2f2319d8a77a3b7dc2',
    '0x97fa0937b99896f2415baf37ce002623dc3b905d',
    '0x2e930f07b30c566e8ac7dd018ee895cfa0732a71'
    )
    AND t.tx_succeeded = TRUE;

    Last run: 2 months ago
    total transactions
    total wallets
    total fees
    avg fee per wallet
    1
    204586210585057364.9807225950.006957908298
    1
    49B
    50s