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
8