CryptoIcicleSushi-64.New to the Menu
Updated 2022-04-10
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
›
⌄
-- New to the Menu
-- Payout 13.55 SUSHI
-- Grand Prize 40.65 SUSHI
-- Level Beginner
-- Q64. What are the 10 most recent assets (coins) supported by sushi?
select token_address, first_swap,
CASE token_address
WHEN '0xae837eacbae2a6ba166ce0ded5c72340f212835c' THEN 'Persistence (XPRT)'
WHEN '0xa693b19d2931d498c5b318df961919bb4aee87a5' THEN 'UST (Wormhole) (UST)'
WHEN '0xdb2fc08aad83627dd92532094ae44203283f2810' THEN 'FVCK_AVATAR (FVCKA)'
WHEN '0x32920ae0696c419338c928f4fff60a1b808bd3ea' THEN 'The Official KronicKatz (KRONIC)'
WHEN '0x4c3a8eceb656ec63eae80a4ebd565e4887db6160' THEN 'Soku (SOKU)'
WHEN '0xc7230badf274995f1933598c249c824fde26f426' THEN 'Suteku (SUTEKU)'
WHEN '0xcc91875714f044a1033b9d3215719bb8ff3f26c8' THEN 'ChargeV2 (ChargeV2)'
WHEN '0x66d592cc979d441a3e4dbb6e043c3bdad241dab7' THEN 'Zero Money (ZERO)'
WHEN '0xf642fb8a7cd8e52f71117f9cd2680755f35a5599' THEN 'yearofthebanner (BANNER)'
WHEN '0x1ee35ad662c74d23ca59013d461060dc29b8321a' THEN 'Berry (Berry)'
END as token_name
from (
select
token_address,
address_name,
min(block_timestamp) as first_swap
from ethereum.dex_swaps s left join ethereum.labels l on s.token_address = l.address
where platform = 'sushiswap'
group by token_address, address_name
order by first_swap desc
)
order by first_swap desc
limit 10
Run a query to Download Data