(select

PRICE as volume ,

NFT_ADDRESS ,

SELLER_ADDRESS as sellers ,

BUYER_ADDRESS as buyers ,

TX_HASH as sale_tx ,

BLOCK_TIMESTAMP ::date as date ,

TOKENID ,

PRICE_USD ,

TOTAL_FEES,

PLATFORM_FEE ,

CREATOR_FEE ,

TOTAL_FEES_USD ,

PLATFORM_FEE_USD ,

CREATOR_FEE_USD,

TX_FEE,

from

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

NFT_ADDRESS=('0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d')

, ethh as (select

date ,

count (distinct TOKENID) as "Number of TOKENID",

count (distinct sellers) as "seller",

count (distinct buyers) as "buyer",

count (distinct sale_tx) as "sale_txs",

sum(volume) as "volumes" ,

sum(PRICE_USD) as PRICE_USDs ,

sum(TOTAL_FEES) as TOTAL_FEESs ,

sum(PLATFORM_FEE) as PLATFORM_FEEs ,

sum(CREATOR_FEE) as CREATOR_FEEs ,

sum(TOTAL_FEES_USD) as TOTAL_FEES_USDs ,

sum(PLATFORM_FEE_USD) as PLATFORM_FEE_USDs ,