gigiokobaUSERS INFO
    Updated 2025-02-09
    WITH transfer_data AS (
    SELECT
    BLOCK_NUMBER,
    BLOCK_TIMESTAMP,
    TX_HASH,
    FROM_ADDRESS,
    TO_ADDRESS,
    AMOUNT,
    AMOUNT_USD,
    SYMBOL
    FROM
    avalanche.core.ez_token_transfers
    WHERE
    CONTRACT_ADDRESS = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b'
    AND FROM_ADDRESS != '0x0000000000000000000000000000000000000000'
    AND FROM_ADDRESS IS NOT NULL
    AND TO_ADDRESS IS NOT NULL
    AND AMOUNT IS NOT NULL
    AND SYMBOL IS NOT NULL
    ),
    transfer_summary AS (
    SELECT
    FROM_ADDRESS AS address,
    'sender' AS type,
    COUNT(*) AS transfer_count,
    SUM(AMOUNT) AS total_transferred,
    SUM(AMOUNT_USD) AS total_usd
    FROM
    transfer_data
    GROUP BY
    FROM_ADDRESS
    UNION ALL
    SELECT
    TO_ADDRESS AS address,
    'receiver' AS type,
    COUNT(*) AS transfer_count,
    Last run: 14 days ago
    ADDRESS
    TYPE
    TRANSFER_COUNT
    TOTAL_TRANSFERRED
    TOTAL_USD
    1
    0xaaaea1fb9f3de3f70e89f37b69ab11b47eb9ce6freceiver12842101638.9994970884947627.56990898
    2
    0xaaa3f202babcf7d6493afbc0caee03af9c64f984receiver2415196013.5795355269727409.84034072
    3
    0xaaa3f202babcf7d6493afbc0caee03af9c64f984sender5608094539.43922595710326111.117272
    4
    0x244a4a90e148ec318a85f8c138a274e16ffe3032sender23670321.895888496667462.192211378
    5
    0xaaa823aa799bda3193d46476539bcb1da5b71330sender11863545.7016627024491744.11165903
    6
    0xaaa78e8c4241990b4ce159e105da08129345946areceiver98959786.65344404510481458.0053368
    7
    0xaaa78e8c4241990b4ce159e105da08129345946asender98959786.65344404510481458.0053368
    8
    0xb0336b14d76d373b9ec711efef67a5922e0cad62receiver1039958048.28823767417084263.4283072
    9
    0xc73df1e68fc203f6e4b6270240d6f82a850e8d38receiver322657972.36567199812225257.7915161
    10
    0xc73df1e68fc203f6e4b6270240d6f82a850e8d38sender44757969.8741856512338166.8821524
    11
    0xb0336b14d76d373b9ec711efef67a5922e0cad62sender862656650.78253960916612822.5665528
    12
    0xaaaf3d9cdd3602d117c67d80eec37a160c8d9869receiver5949719.1972818973528540.32332221
    13
    0xaaaf3d9cdd3602d117c67d80eec37a160c8d9869sender246549716.0750650413541224.6714829
    14
    0x88de50b233052e4fb783d4f6db78cc34fea3e9fcreceiver1301039311.4926910986104781.51454073
    15
    0x88de50b233052e4fb783d4f6db78cc34fea3e9fcsender992439299.15708776103551.83848817
    16
    0x13e09b6a2919413f8436ecb3b963a47a6fe5c616receiver366634727.6373053685406297.54505926
    17
    0x13e09b6a2919413f8436ecb3b963a47a6fe5c616sender931334220.1127947865962456.23055967
    18
    0xc1f141909cea52f5315c19c1121cef1dc86f4926receiver282530656.533534832425949.178357652
    19
    0xc1f141909cea52f5315c19c1121cef1dc86f4926sender281930656.356303279466745.956841318
    20
    0xaaa45c8f5ef92a000a121d102f4e89278a711faareceiver44225945.6861224592938295.28522903
    ...
    16625
    1MB
    7s