date(block_timestamp) as day,

count(distinct tx_hash) as no_of_swaps,

count(distinct origin_from_address) as no_of_swappers,

sum(amount_out_usd) as volume_usd

from optimism.velodrome.ez_swaps

group by day

order by day desc