select date_trunc('day',block_timestamp) as date,
symbol_in,
count(distinct tx_hash) as n_swaps,
count(distinct origin_from_address) as n_wallets,
sum(coalesce(amount_in_usd,0)) as swapped_amount_usd
from optimism.sushi.ez_swaps
where date(block_timestamp) >= '2022-07-01'
group by date, symbol_in