count(distinct(tx_hash)) as frequency, sum(amount_out_usd) as volume, count(distinct trader ) as swappers

from near.defi.ez_dex_swaps

where block_timestamp>=current_date-90 and block_timestamp<trunc(current_date,'week')

group by 1

order by 1 desc