i_danTOKEN INFO
Updated 2024-11-28
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
ADDRESS_NAME
, PROJECT_NAME
, address
-- , CASE WHEN address = lower('0x420FcA0121DC28039145009570975747295f2329') THEN 'COQ'
-- WHEN address = lower('0x184ff13B3EBCB25Be44e860163A5D8391Dd568c1') THEN 'KIMBO'
-- WHEN address = lower('0xAcFb898Cff266E53278cC0124fC2C7C94C8cB9a5') THEN 'NOCHILL'
-- WHEN address = lower('0xB44B645b5058F7e393F3AE6Af58A4CEf67006196') THEN 'STICK'
-- WHEN address = lower('0x65378b697853568dA9ff8EaB60C13E1Ee9f4a654') THEN 'HUSKY'
-- WHEN address = lower('0x5Ac04b69bDE6f67C0bd5D6bA6fD5D816548b066a') THEN 'TECH'
-- WHEN address = lower('0x8aD25B0083C9879942A64f00F20a70D3278f6187') THEN 'MEOW'
-- WHEN address = lower('0x18E3605B13F10016901eAC609b9E188CF7c18973') THEN 'HEFE'
-- WHEN address = lower('0x214dD1B5cBE543D4189Ab39832F1BC1eEDEBb1d3') THEN 'JUNIOR'
-- WHEN address = lower('0xEbB5d4959B2FbA6318FbDa7d03cd44aE771fc999') THEN 'KONG'
-- WHEN address = lower('0x4A5Bb433132B7E7F75D6A9a3e4136bB85CE6E4d5') THEN 'BOOTY'
-- WHEN address = lower('0x4F94b8AEF08c92fEfe416af073F1Df1E284438EC') THEN 'WOLF'
-- WHEN address = lower('0x87bbFc9DCB66Caa8ce7582A3F17B60a25cd8A248') THEN '$Td'
-- WHEN address = lower('0xE8385CECb013561b69bEb63FF59f4d10734881f3') THEN 'GEC'
-- WHEN address = lower('0x47c3118Ad183712Acd42648e9E522e13690f29a0') THEN 'MEAT'
-- WHEN address = lower('0x3377aCA4c0BFD021be6bd762b5f594975e77f9CF') THEN 'KOVIN'
-- WHEN address = lower('0xAcFb898Cff266E53278cC0124fC2C7C94C8cB9a5') THEN 'NOCHILL'
-- WHEN address = lower('0xAcFb898Cff266E53278cC0124fC2C7C94C8cB9a5') THEN 'NOCHILL'
-- WHEN address = lower('0xAcFb898Cff266E53278cC0124fC2C7C94C8cB9a5') THEN 'NOCHILL'
-- WHEN address = lower('0xAcFb898Cff266E53278cC0124fC2C7C94C8cB9a5') THEN 'NOCHILL'
-- END AS token
FROM avalanche.core.dim_labels
WHERE address IN (lower('0xAcFb898Cff266E53278cC0124fC2C7C94C8cB9a5')
-- , lower('0x184ff13B3EBCB25Be44e860163A5D8391Dd568c1')
-- , lower('0x420FcA0121DC28039145009570975747295f2329')
-- , lower('0xB44B645b5058F7e393F3AE6Af58A4CEf67006196')
-- , lower('0x65378b697853568dA9ff8EaB60C13E1Ee9f4a654')
-- , lower('0x5Ac04b69bDE6f67C0bd5D6bA6fD5D816548b066a')
-- , lower('0x8aD25B0083C9879942A64f00F20a70D3278f6187')
-- , lower('0x18E3605B13F10016901eAC609b9E188CF7c18973')
-- , lower('0x214dD1B5cBE543D4189Ab39832F1BC1eEDEBb1d3')
-- , lower('0xEbB5d4959B2FbA6318FbDa7d03cd44aE771fc999')
QueryRunArchived: QueryRun has been archived