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

count(DISTINCT tx_hash) as Swaps,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) as Count_users,

Sum(amount_out_usd) as Vol_Swap

FROM optimism.sushi.ez_swaps

WHERE block_timestamp BETWEEN '2022-07-01' AND '2022-08-01'

GROUP BY Date

Order by Date