DESTINATION | TRANSACTIONS | ACTIVE_USERS | |
---|---|---|---|
1 | Pharaoh | 319412 | 5816 |
2 | Odos | 280831 | 6341 |
3 | Trader Joe | 92780 | 3769 |
4 | 0x22c81c051a134c81ce370d82fa26975ae9d100b4 | 50701 | 2156 |
5 | 0x70afd56af7068d46f5d341dfb95cd55e87419ff7 | 31080 | 6 |
6 | 0x596cb4e6418daa638069cd9c461eff1d8f05a7ac | 26644 | 6 |
7 | 0x0e88ba3e37104b44615c3bb445ed8c949e55036e | 26432 | 4 |
8 | 0x7e30f114fe291978bd5877c1cf003421dfc062a2 | 15188 | 6 |
9 | 0xffff003a6bad9b743d658048742935fffe2b6ed7 | 14725 | 2925 |
10 | 0x718697795ea474c3aa09ed58f17345d701763356 | 12695 | 7 |
11 | 0xd224c08486ce2e0fdf2e37ae9e0e9167f087fa75 | 11770 | 7 |
12 | 0xdaa1269548cb0aa5d32874bc65ba1008c6a14107 | 10470 | 10336 |
13 | 0x979a7283b779b9f7c2945c53ecf3c3f90a23219a | 10221 | 7 |
14 | 0x84c0e95ca3d704c2f25fbdf427b53828b38d50c0 | 10041 | 6 |
15 | 0xd323f9931a069ad889c6e90d6be79e7b02ef6c39 | 9678 | 17 |
16 | 0xfa789138f5db53e140f0eecdb646245bec4ec6c8 | 9252 | 6 |
17 | 0x45a62b090df48243f12a21897e7ed91863e2c86b | 8121 | 2013 |
18 | 0x1dac23e41fc8ce857e86fd8c1ae5b6121c67d96d | 8093 | 1953 |
19 | 0xc04b4999abe6509ff5d7bfe3ded30df6598c2c8e | 7106 | 60 |
20 | 0xbb409f3507d47a4a5fc1c345e1fcdfc1cf2c1892 | 7059 | 298 |
Ali3NDestinations of KET Transactions in Avalanche
Updated 2 hours ago
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
›
⌄
select case when origin_to_address in ('0x5b0d74c78f2588b3c5c49857edb856cc731dc557','0x7ccda6e26dced1ba275c67cd20235790ed615a8d') then 'CLY Stake'
when origin_to_address = '0xd8c4cfa978862f4653bfccc1a6e3e9fff1a6dc54' then 'Avalaunch Sale'
when origin_to_address = '0xefac81f709d314604a7daee9ca234da978c2be20' then 'Colony DAO'
when origin_to_address = '0x188bed1968b795d5c9022f6a0bb5931ac4c18f00' then 'Trader Joe'
when origin_to_address = '0x364e232d9880e4a3e8505debbc2f93c6a896233f' then 'CLY Airdrop'
when origin_to_address = '0x486af39519b4dc9a7fccd318217352830e8ad9b4' then 'Benqi'
when origin_to_address = '0x784da19e61cf348a8c54547531795ecfee2affd1' then 'Benqi'
when origin_to_address = '0x35bd6aeda81a7e5fc7a7832490e71f757b0cd9ce' then 'Benqi'
when origin_to_address = '0x77533a0b34cd9aa135ebe795dc40666ca295c16d' then 'Benqi'
when origin_to_address = '0xe54ca86531e17ef3616d22ca28b0d458b6c89106' then 'Pangolin'
when origin_to_address = '0x1f806f7c8ded893fd3cae279191ad7aa3798e928' then 'Pangolin'
when origin_to_address = '0xd49b406a7a29d64e081164f6c3353c599a2eeae9' then 'Pangolin'
when origin_to_address = '0x574d3245e36cf8c9dc86430eadb0fdb2f385f829' then 'Pangolin'
when origin_to_address in ('0xaaa78e8c4241990b4ce159e105da08129345946a','0xaaaf3d9cdd3602d117c67d80eec37a160c8d9869'
,'0xaaae58986b24e422740c8f22b3efb80bcbd68159','0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b') then 'Pharaoh'
when origin_to_address ='0x88de50b233052e4fb783d4f6db78cc34fea3e9fc' then 'Odos'
when origin_to_address = '0x999dc3ce5399b44dcda15869004e9dc31ee8fcde' then 'Ennead'
when origin_to_address = '0xf6687cd56aec1a0faaba12feb6781398ab47fb21' then 'Swap Aggregator'
when origin_to_address = '0x6a000f20005980200259b80c5102003040001068' then 'Paraswap'
when origin_to_address = '0x215e18801977c2c930807dcb0538a7d00f147d83' then 'Uniswap'
else coalesce (initcap(project_name),origin_to_address) end as Destination,
count (distinct tx_hash) as Transactions,
count (distinct origin_from_address) as Active_Users
from avalanche.core.ez_token_transfers t1 left outer join avalanche.core.dim_labels t2 on t1.to_address = t2.address
where contract_address = '0xffff003a6bad9b743d658048742935fffe2b6ed7'
group by 1
order by 2 desc
Last run: about 2 hours agoAuto-refreshes every 24 hours
...
462
23KB
105s