with top_10_swap_from_velo as (

select

sum(amount_in_usd) as swap_from_volume,

symbol_out as token_name

from optimism.velodrome.ez_swaps

where block_timestamp::date < CURRENT_DATE and platform = 'velodrome'

and symbol_in = 'VELO'

group by token_name order by swap_from_volume desc limit 10

)

select *

from top_10_swap_from_velo