select

project_name,

round(sum(mint_price_eth * nft_count),0) as eth_spent

from ethereum.core.ez_nft_mints

where project_name is not null

and nft_count > 0

and nft_count is not null

and project_name not in ('uniswap')

and block_timestamp > current_date - interval '7 days'

group by 1

order by eth_spent desc

limit 10