select trunc(block_timestamp,'day') as day,
count(DISTINCT origin_from_address) as count_tx,
count(DISTINCT tx_hash) as count_tx,
sum(amount_in_usd) as Volume_usd,
avg(amount_in_usd) as average_volume,
max(amount_in_usd) as max_volume
from optimism.velodrome.ez_swaps
where block_timestamp::date >= '2022-06-15'
group by 1