select

date_trunc('week',block_timestamp) as date,

POOL_NAME,

count(distinct tx_hash) as no_swaps,

count(distinct ORIGIN_FROM_ADDRESS) as no_trader,

sum(AMOUNT_OUT_USD) as volume_usd,

avg(AMOUNT_OUT_USD) as avg_volume_usd,

median(AMOUNT_OUT_USD) as median_volume_usd

from avalanche.core.ez_dex_swaps

where block_timestamp>='2023-01-01'

and POOL_NAME is not null

group by 1,2 having volume_usd is not null

QUALIFY DENSE_RANK() OVER (partition by date ORDER BY volume_usd DESC) <= 5