asset_name,

avg(price_usd) as price

from algorand.prices_swap

where date_trunc('day', block_hour) = '2022-03-01'

group by asset_name

order by price desc

limit 10