shadilNew to the Menu
    Updated 2022-04-14
    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