par_rnNTU 01
Updated 2024-12-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
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
FROM
near.nft.ez_nft_sales
WHERE
BLOCK_TIMESTAMP :: date >= '2024-01-01'
AND NFT_ADDRESS = 'tinkerunion_nft.enleap.near'
QueryRunArchived: QueryRun has been archived