select
date_trunc('week', block_timestamp) as week,
sum(PRICE) * 10 as usd_volume,
avg(price) * 10 as flow_avg_volume1,
SELLER
from
flow.core.ez_nft_sales
where
tx_succeeded = 'TRUE'
and week >= '2023-01-01'
group by
1,
SELLER
having
usd_volume > 100000
order by
usd_volume desc
limit
50