select SYMBOL_out, count(DISTINCT(tx_hash)) as total_tx, count(DISTINCT(origin_from_address)) as total_user,
sum(amount_out_usd) as volume, avg(amount_in_usd) as avg_volume
from ethereum.core.ez_dex_swaps
where block_timestamp::date >= CURRENT_DATE - 15
and amount_out_usd < 10000000
group by 1
order by 2 desc
limit 5