PROJECT_NAME,

SUM(TOTAL_PRICE_USD) AS total_mint_volume

FROM

aptos.nft.ez_nft_mints

WHERE

BLOCK_TIMESTAMP >= DATEADD(day, -7, CURRENT_DATE) and project_name not ilike '%position%' and project_name not ilike '%liquidswap%'

GROUP BY

PROJECT_NAME

HAVING total_mint_volume<1000000

ORDER BY

total_mint_volume DESC

LIMIT 10;