select tokenid,
max(price_usd) as usd_volume_max,
min(price_usd) as usd_volume_min,
median(price_usd) as usd_volume_median,
avg(price_usd) as usd_volume_avg,
sum(price_usd) as usd_volume_total,
count(distinct(tx_hash)) as tx_num
from ethereum.core.ez_nft_sales
where 1 = 1
and nft_address = '0x60bb1e2aa1c9acafb4d34f71585d7e959f387769' -- Art Gobblers
and price_usd > 0
group by tokenid
order by usd_volume_max desc
limit 10