count(distinct tx_hash) as swap_count,

count(distinct origin_from_address) as unique_user,

swap_count/count(distinct date_trunc(day, block_timestamp)) as average_tx_day,

unique_user/count(distinct date_trunc(day, block_timestamp)) as average_user_day

from optimism.velodrome.ez_swaps

where block_timestamp::date < CURRENT_DATE and platform = 'velodrome'