datavortex7 days after
    Updated 2025-02-27
    SELECT
    COUNT(DISTINCT t.tx_hash) AS "total transactions",
    COUNT(DISTINCT t.from_address) AS "total wallets"
    FROM
    kaia.core.fact_traces t
    WHERE
    t.to_address IN (
    '0x0d0966da8e610376f723e42fdfc7a7383a1efd05',
    '0x2f0bcecce06b6eb32a83073984d0b793640aeaf6',
    '0xd37f28c6c51420054b1fb1362288d07ba40440e8',
    '0xb06cef4ff184f218c5318a2f2319d8a77a3b7dc2',
    '0x97fa0937b99896f2415baf37ce002623dc3b905d',
    '0x2e930f07b30c566e8ac7dd018ee895cfa0732a71'
    )
    AND t.tx_succeeded = TRUE
    AND t.block_timestamp BETWEEN DATE('2025-01-28')
    AND DATEADD(day, 7, DATE('2025-01-28'));
    Last run: 2 months ago
    total transactions
    total wallets
    1
    734934464445
    1
    17B
    4s