ADDRESS | TYPE | TRANSFER_COUNT | TOTAL_TRANSFERRED | TOTAL_USD | |
---|---|---|---|---|---|
1 | 0xaaaea1fb9f3de3f70e89f37b69ab11b47eb9ce6f | receiver | 12842 | 101638.999497088 | 4947627.56990898 |
2 | 0xaaa3f202babcf7d6493afbc0caee03af9c64f984 | receiver | 24151 | 96013.579535526 | 9727409.84034072 |
3 | 0xaaa3f202babcf7d6493afbc0caee03af9c64f984 | sender | 56080 | 94539.439225957 | 10326111.117272 |
4 | 0x244a4a90e148ec318a85f8c138a274e16ffe3032 | sender | 236 | 70321.895888496 | 667462.192211378 |
5 | 0xaaa823aa799bda3193d46476539bcb1da5b71330 | sender | 118 | 63545.701662702 | 4491744.11165903 |
6 | 0xaaa78e8c4241990b4ce159e105da08129345946a | receiver | 989 | 59786.653444045 | 10481458.0053368 |
7 | 0xaaa78e8c4241990b4ce159e105da08129345946a | sender | 989 | 59786.653444045 | 10481458.0053368 |
8 | 0xb0336b14d76d373b9ec711efef67a5922e0cad62 | receiver | 10399 | 58048.288237674 | 17084263.4283072 |
9 | 0xc73df1e68fc203f6e4b6270240d6f82a850e8d38 | receiver | 3226 | 57972.365671998 | 12225257.7915161 |
10 | 0xc73df1e68fc203f6e4b6270240d6f82a850e8d38 | sender | 447 | 57969.87418565 | 12338166.8821524 |
11 | 0xb0336b14d76d373b9ec711efef67a5922e0cad62 | sender | 8626 | 56650.782539609 | 16612822.5665528 |
12 | 0xaaaf3d9cdd3602d117c67d80eec37a160c8d9869 | receiver | 59 | 49719.197281897 | 3528540.32332221 |
13 | 0xaaaf3d9cdd3602d117c67d80eec37a160c8d9869 | sender | 2465 | 49716.075065041 | 3541224.6714829 |
14 | 0x88de50b233052e4fb783d4f6db78cc34fea3e9fc | receiver | 13010 | 39311.492691098 | 6104781.51454073 |
15 | 0x88de50b233052e4fb783d4f6db78cc34fea3e9fc | sender | 9924 | 39299.1570877 | 6103551.83848817 |
16 | 0x13e09b6a2919413f8436ecb3b963a47a6fe5c616 | receiver | 3666 | 34727.637305368 | 5406297.54505926 |
17 | 0x13e09b6a2919413f8436ecb3b963a47a6fe5c616 | sender | 9313 | 34220.112794786 | 5962456.23055967 |
18 | 0xc1f141909cea52f5315c19c1121cef1dc86f4926 | receiver | 2825 | 30656.533534832 | 425949.178357652 |
19 | 0xc1f141909cea52f5315c19c1121cef1dc86f4926 | sender | 2819 | 30656.356303279 | 466745.956841318 |
20 | 0xaaa45c8f5ef92a000a121d102f4e89278a711faa | receiver | 442 | 25945.686122459 | 2938295.28522903 |
gigiokobaUSERS INFO
Updated 2025-02-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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
...
16625
1MB
7s