select

BLOCK_TIMESTAMP,

TX_HASH,

PLATFORM_NAME,

SELLER_ADDRESS,

BUYER_ADDRESS,

TOKENID,

PRICE,

PRICE_USD

from base.nft.ez_nft_sales

where NFT_ADDRESS = '0x07152bfde079b5319e5308c43fb1dbc9c76cb4f9')

select

count(*) as "# of Trades",

count(distinct tx_hash) as "# of Trade Txs",

count(distinct SELLER_ADDRESS) as "# of Sellers",

count(distinct BUYER_ADDRESS) as "# of Buyers",

count(distinct TOKENID) as "# of Traded NFTs",

sum(PRICE) as "Trade Volume (ETH)",

sum(PRICE_USD) as "Trade Volume (USD)",

count(distinct PLATFORM_NAME) as "Trade Platforms",

min(PRICE) as "Cheapest NFT",

max(PRICE) as "Most Expensive NFT",

avg(PRICE) as "Average NFT Price",

median(PRICE) as "Median NFT Price"

from main