date_trunc(day,block_timestamp)::date as date

,count(DISTINCT ORIGIN_FROM_ADDRESS) as traders

,count(DISTINCT tx_hash) as swaps

,count(DISTINCT POOL_NAME) as pools

,sum(AMOUNT_IN_USD) as volume_usd

,avg(AMOUNT_IN_USD) as avg_volume_usd

,sum(traders) over(order by date) as growth_traders

,sum(swaps) over(order by date) as growth_swaps

,sum(volume_usd) over(order by date) as growth_volume_usd

from optimism.velodrome.ez_swaps

group by 1

order by 1