sakineh5021-nIQRzBNew to the Menu (token name from etherscan)
Updated 2022-04-11
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
›
⌄
with token as (
SELECT DISTINCT S.token0
from ethereum.dex_liquidity_pools S
where platform = 'sushiswap'
) ,
lauch as ( SELECT T.token0 as token_address, min(creation_time::date) as launched_date_on_sushiswap
from ethereum.dex_liquidity_pools S , token T
where platform = 'sushiswap'
and T.token0 = S.token0
and creation_time is not NULL
group by 1
order by 2 desc
limit 10
)
SELECT 'UST(Wharmhole)' as token_name , LAUNCHED_DATE_ON_SUSHISWAP
from lauch
where TOKEN_ADDRESS = '0xa693b19d2931d498c5b318df961919bb4aee87a5'
UNION
SELECT 'FLOKI' as token_name , LAUNCHED_DATE_ON_SUSHISWAP
from lauch
where TOKEN_ADDRESS = '0x67cc621ab2d086a101cff3340df0a065ac75827c'
UNION
SELECT 'SPJ' as token_name , LAUNCHED_DATE_ON_SUSHISWAP
from lauch
where TOKEN_ADDRESS = '0x9e780beee23f424c26dd075075a90e7b8714ac3d'
UNION
SELECT 'SOKU' as token_name , LAUNCHED_DATE_ON_SUSHISWAP
from lauch
where TOKEN_ADDRESS = '0x4c3a8eceb656ec63eae80a4ebd565e4887db6160'
UNION
SELECT 'YETIS' as token_name , LAUNCHED_DATE_ON_SUSHISWAP
from lauch
where TOKEN_ADDRESS = '0x6bb901c959bc5bc148e5964d52ab9c05747f222c'
UNION
Run a query to Download Data