select
distinct top 10 token_in as "Tokens Bought",
symbol_in as "Token Name",
count (*) as "The number of times a token is Bought",
sum(AMOUNT_IN_USD) as "The Amount of token is Bought (USD Scale)"
from flipside_prod_db.ethereum_core.ez_dex_swaps
where block_timestamp BETWEEN '2022-05-08' and '2022-05-14'
group by 1,2
order by 3 desc