permarytransaction count
    Updated 2025-03-18
    SELECT
    'Avalanche' AS chain,
    count(*) as transaction_count
    FROM avalanche.core.ez_token_transfers
    WHERE contract_address = LOWER('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E')
    AND block_timestamp >= '2024-09-01'

    UNION ALL

    SELECT
    'Ethereum' AS chain,
    count(*) as transaction_count
    FROM ethereum.core.ez_token_transfers
    WHERE contract_address = LOWER('0x70e8dE73cE538DA2bEEd35d14187F6959a8ecA96')
    AND block_timestamp >= '2024-09-01'

    UNION ALL

    SELECT
    'Polygon' AS chain,
    count(*) as transaction_count
    FROM polygon.core.ez_token_transfers
    WHERE contract_address = LOWER('0xDC3326e71D45186F113a2F448984CA0e8D201995')
    AND block_timestamp >= '2024-09-01';

    Last run: about 1 month ago
    CHAIN
    TRANSACTION_COUNT
    1
    Avalanche261462
    2
    Ethereum11515
    3
    Polygon311739
    3
    60B
    10s