SELECT DISTINCT S.token0

from ethereum.dex_liquidity_pools S

where platform = 'sushiswap'

) ,

launch 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 cast(block_timestamp as date) as swap_date , D.token_address ,sum(amount_usd) as usd , count(tx_id)

from ethereum.dex_swaps D, launch L

where D.token_address = L.token_address

and platform='sushiswap'

group by 1 ,2