(select

PRICE as volume ,

PRICE_USD AS USD,

NFT_ADDRESS ,

SELLER_ADDRESS as sellers ,

BUYER_ADDRESS as buyers ,

TX_HASH as sale_tx ,

BLOCK_TIMESTAMP ::date as date ,

PLATFORM_NAME as platform

from

ethereum.core.ez_nft_sales where CURRENCY_ADDRESS='ETH' and EVENT_TYPE='sale' and

lower(NFT_ADDRESS)=lower('0x960b7a6bcd451c9968473f7bbfd9be826efd549a')

, eth_metadata as (

select CONTRACT_NAME as name , CREATED_AT_TIMESTAMP::date as created_time , CONTRACT_ADDRESS as NFT_created , eth.*,TOKEN_METADATA

from ethereum.core.dim_nft_metadata right join eth on NFT_address = CONTRACT_ADDRESS

, ethh as (select

platform ,--TOKEN_METADATA,

count (distinct NFT_address) as "Number of collections",

count (distinct sellers) as "seller",

count (distinct buyers) as "buyer",

count (distinct sale_tx) as "sale_txs",

sum(volume) as "volumes" ,

SUM(USD) AS "USD" from eth_metadata

group by 1--,3

)

select * from ethh