date(date_trunc('day', block_timestamp)) as date,

sum(amount_in_usd) as total_swapping_volume

from optimism.velodrome.ez_swaps

group by date