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

order by

eth_spent desc