zakkisyed10 most recent Sushiswap tokens
    Updated 2022-04-13
    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