contracts.name,

contracts.symbol,

contracts.address,

sales.nft_address,

COUNT(DISTINCT sales.tx_hash) as no_of_transactions,

sum(sales.price) as eth_volume,

sum(sales.price_usd) as usd_volume,

sum(sales.tx_fee_usd) as fees_usd,

sum(sales.tx_fee) as fees_eth

ethereum.core.ez_nft_sales sales

JOIN ethereum.core.dim_contracts contracts ON sales.nft_address = contracts.address

block_timestamp >= (current_date - 7)

AND currency_symbol IN ('ETH', 'WETH')

GROUP BY

1,

2,

3,

4

ORDER BY

usd_volume DESC

10;