zakkisyed10 most recent Sushiswap tokens
Updated 2022-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select distinct(token_address),
CASE
WHEN token_address like '0x6759d6af2615d6bf0ce9bbd9ebad31b0fa5c87d0' then 'KREEP'
WHEN token_address like '0x91d365c949a0600638adfaed8081abd46fd83b30' then 'CHEDDA'
WHEN token_address like '0xd9d5dc8697b28f54c87c0ff580b91a315faffd42' then 'PORK'
WHEN token_address like '0x794b4a0f0d8957ea043d29de0bce393a0c08ebc2' then 'CNY'
WHEN token_address like '0xe00639a1f59b52773b7d39d9f9bef07f6248dbae' then 'DAOX'
WHEN token_address like '0x7683fb13eaf69b4616559480fa260246b77a730d' then 'FRANK'
WHEN token_address like '0x88ada4bcaac711b36ccf455cba28950a4c6fbd52' then 'GUSHIE'
WHEN token_address like '0xfaa2e20473d8b132c0d8649afc56182b75f0fcbf' then 'FWY'
WHEN token_address like '0x4bcd559af66d8b1aa8be4578f4101111cc0b27a6' then '19DAO'
WHEN token_address like '0xc3c5c16bcb9613f5e694075c2e6ee4010cb94721' then '1776'
ELSE 'token_name'
END AS token_names,
min(block_timestamp) as earliest_date
from ethereum.dex_swaps
where platform = 'sushiswap'
group by 1
order by 3 DESC
limit 10
Run a query to Download Data