date_trunc('day', block_timestamp)::date as day,

symbol_in,

symbol_out,

count(distinct (origin_from_address)) as wallets_number,

count(distinct (tx_hash)) as tx_num,

sum(amount_in_usd) as amount_usd

from optimism.velodrome.ez_swaps

where block_timestamp >= current_date - interval '{{ days}} days'

group by day, symbol_in, symbol_out

having amount_usd > 0