block_timestamp::date as days,

count(distinct tx_hash) as number_of_swaps,

count(distinct origin_from_address) as number_of_unique_swapper,

sum(amount_in_usd) as volume_of_swap

from optimism.velodrome.ez_swaps

where block_timestamp::date <= current_date - 1

group by days

order by days