DATE_TRUNC('month', BLOCK_TIMESTAMP) AS date,

CASE

WHEN BLOCK_TIMESTAMP >= '2024-01-01' AND BLOCK_TIMESTAMP < '2024-04-01' THEN 'Q1'

WHEN BLOCK_TIMESTAMP >= '2024-04-01' AND BLOCK_TIMESTAMP < '2024-07-01' THEN 'Q2'

WHEN BLOCK_TIMESTAMP >= '2024-07-01' AND BLOCK_TIMESTAMP < '2024-10-01' THEN 'Q3'

ELSE 'Q4'

END AS quarter,

CASE

WHEN PRICE_USD <= 100 THEN '0 - 100 $'

WHEN PRICE_USD < 1000 AND PRICE_USD >=100 THEN '100 - 1000 $'

WHEN PRICE_USD < 10000 AND PRICE_USD >=1000 THEN '1000 - 10000 $'

ELSE 'More than 10,000 $'

END AS type,

COUNT(*) AS sales,

COUNT(DISTINCT BUYER_ADDRESS) AS buyers,

COUNT(DISTINCT SELLER_ADDRESS) AS sellers,

SUM(PRICE_USD) AS usd_volume,

AVG(PRICE_USD) AS avg_usd_volume,

MAX(PRICE_USD) AS max_usd_volume,

MEDIAN(PRICE_USD) AS med_usd_volume,

MIN(PRICE_USD) AS min_usd_volume,

SUM(PLATFORM_FEE_USD) AS platform_fee

near.nft.ez_nft_sales

date >= '2024-01-01'

AND NFT_ADDRESS = 'tinkerunion_nft.enleap.near'

GROUP BY

date,

quarter,

type

ORDER BY

date ASC