2844Surge token's name
Updated 2022-04-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select distinct (token_address),
case
when token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then 'WETH'
when token_address = '0x6b175474e89094c44da98b954eedeac495271d0f' then 'Dai'
when token_address = '0x6b3595068778dd592e39a122f4f5a5cf09c90fe2' then 'Sushi'
when token_address = '0x0bc529c00c6401aef6d220be8c6ea1667f6ad93e' then 'YFI'
when token_address = '0x70bef3bb2f001da2fddb207dae696cd9faff3f5d' then 'NST'
when token_address = '0x5a98fcbea516cf06857215779fd812ca3bef1b32' then 'LDO'
when token_address = '0x2ba592f78db6436527729929aaf6c908497cb200' then 'CREAM'
end as Token_name
from ethereum.dex_swaps
where token_address ='0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' or
token_address ='0x6b175474e89094c44da98b954eedeac495271d0f' OR
token_address ='0x6b3595068778dd592e39a122f4f5a5cf09c90fe2' OR
token_address ='0x0bc529c00c6401aef6d220be8c6ea1667f6ad93e' OR
token_address ='0x70bef3bb2f001da2fddb207dae696cd9faff3f5d' OR
token_address ='0x5a98fcbea516cf06857215779fd812ca3bef1b32' OR
token_address ='0x2ba592f78db6436527729929aaf6c908497cb200'
Run a query to Download Data