shadilNew to the Menu
Updated 2022-04-14
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 token0_tbl as (
SELECT
token0 as token,
min(date(creation_time)) as min_date
from ethereum.dex_liquidity_pools
where platform ='sushiswap'
and creation_time is not NULL
group by token
order by min_date DESC
),
token1_tbl as (
SELECT
token1 as token,
min(date(creation_time)) as min_date
from ethereum.dex_liquidity_pools
where platform ='sushiswap'
and creation_time is not NULL
group by token
order by min_date DESC
),
all_tbl as (
SELECT * from token0_tbl
UNION
SELECT * from token1_tbl
)
SELECT
token,
case when token = '0x56c0cfdea3f8659863a231c7f298c0a48038f6d2' then 'Octus Bridge (BRIDGE)'
when token = '0x29d578cec46b50fa5c88a99c6a4b70184c062953' then 'Wrapped Ever (WEVER)'
when token = '0x6759d6af2615d6bf0ce9bbd9ebad31b0fa5c87d0' then 'KREEPY CLUB (KREEP)'
when token = '0xd9d5dc8697b28f54c87c0ff580b91a315faffd42' then 'Pork1984 (PORK)'
when token = '0x91d365c949a0600638adfaed8081abd46fd83b30' then 'Cheddaz (CHEDDA)'
when token = '0x794b4a0f0d8957ea043d29de0bce393a0c08ebc2' then 'Chinese Yuan (CNY)'
when token = '0x66d592cc979d441a3e4dbb6e043c3bdad241dab7' then 'ZERO'
when token = '0x7683fb13eaf69b4616559480fa260246b77a730d' then 'frankfrank (FRANK)'
Run a query to Download Data