(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('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')

, 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 as "name" ,

count (distinct sale_tx) as "value"

from eth_metadata

group by 1--,3

)

select * from ethh