Ali3NDestinations of KET Transactions in Avalanche
    Updated 2 hours ago
    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
    DESTINATION
    TRANSACTIONS
    ACTIVE_USERS
    1
    Pharaoh3194125816
    2
    Odos2808316341
    3
    Trader Joe927803769
    4
    0x22c81c051a134c81ce370d82fa26975ae9d100b4507012156
    5
    0x70afd56af7068d46f5d341dfb95cd55e87419ff7310806
    6
    0x596cb4e6418daa638069cd9c461eff1d8f05a7ac266446
    7
    0x0e88ba3e37104b44615c3bb445ed8c949e55036e264324
    8
    0x7e30f114fe291978bd5877c1cf003421dfc062a2151886
    9
    0xffff003a6bad9b743d658048742935fffe2b6ed7147252925
    10
    0x718697795ea474c3aa09ed58f17345d701763356126957
    11
    0xd224c08486ce2e0fdf2e37ae9e0e9167f087fa75117707
    12
    0xdaa1269548cb0aa5d32874bc65ba1008c6a141071047010336
    13
    0x979a7283b779b9f7c2945c53ecf3c3f90a23219a102217
    14
    0x84c0e95ca3d704c2f25fbdf427b53828b38d50c0100416
    15
    0xd323f9931a069ad889c6e90d6be79e7b02ef6c39967817
    16
    0xfa789138f5db53e140f0eecdb646245bec4ec6c892526
    17
    0x45a62b090df48243f12a21897e7ed91863e2c86b81212013
    18
    0x1dac23e41fc8ce857e86fd8c1ae5b6121c67d96d80931953
    19
    0xc04b4999abe6509ff5d7bfe3ded30df6598c2c8e710660
    20
    0xbb409f3507d47a4a5fc1c345e1fcdfc1cf2c18927059298
    ...
    462
    23KB
    105s