SELECT DISTINCT S.token0

from ethereum.dex_liquidity_pools S

where platform = 'sushiswap'

) ,

launch as (

SELECT T.token0 , 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

)

,

coin as (

SELECT launched_date_on_sushiswap , C.symbol as symbol, C.token_address as contract_address

from launch L , ethereum.token_prices_hourly C

where L.token0 = C.token_address

and hour::date = '2022-04-08'

order by 1 desc

)

,

sel as (

SELECT symbol, sum(AMOUNT_USD) as swap, count(tx_id)

from coin C , ethereum.dex_Swaps

where TOKEN_ADDRESS = contract_address

and platform = 'sushiswap'

and block_timestamp::date >='2022-03-01'

group by 1

)

,

ho as (

SELECT DISTINCT S.symbol

from sel S , coin C