select date_trunc('day',block_timestamp) as date,
symbol_out,
count(distinct tx_hash) as n_swaps,
count(distinct origin_from_address) as n_wallets,
sum(coalesce(amount_out_usd,0)) as swapped_amount_usd
from optimism.velodrome.ez_swaps
where block_timestamp >= CURRENT_DATE - 30
group by date, symbol_out