DATE_TRUNC('month', BLOCK_TIMESTAMP) AS date,

case

when date >= '2024-01-01'

and date < '2024-04-01' then 'Q1'

when date >= '2024-04-01'

and date < '2024-07-01' then 'Q2'

when date >= '2024-07-01'

and date < '2024-10-01' then 'Q3'

else 'Q4'

end as quarter,

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

1,

2