SELECT

block_timestamp::date AS date,

tx_hash,

price,

price_usd,

seller_address,

buyer_address AS buyer,

TOKEN_ID,

NFT_ADDRESS

FROM near.nft.ez_nft_sales

WHERE platform_name = 'Mitte'

--AND block_timestamp >= '2024-01-01'

AND block_timestamp < current_date

SELECT

date,

COUNT(DISTINCT tx_hash) AS transactions,

COUNT(*) AS sales,

COUNT(DISTINCT buyer) AS buyers,

COUNT(DISTINCT seller_address) AS sellers,

SUM(price) AS volume,

AVG(price) AS avg_nft_price,

MEDIAN(price) AS median_nft_price,

MAX(price) AS max_nft_price,

SUM(price) / NULLIF(COUNT(DISTINCT buyer), 0) AS avg_per_buyer,

COUNT(DISTINCT TOKEN_ID) AS unique_nfts_sold,

COUNT(DISTINCT seller_address) / NULLIF(COUNT(*), 0) AS sales_per_seller,

SUM(price_usd) AS volume_usd

FROM tb1

GROUP BY 1

ORDER BY 1 ASC