thejoycegenerous-sapphire
Updated 2024-11-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
SELECT
PLATFORM_NAME,
COUNT(*) AS total_nft_sales,
SUM(PRICE) AS total_sales_volume_near,
SUM(PRICE_USD) AS total_sales_volume_usd,
COUNT(DISTINCT BUYER_ADDRESS) AS unique_buyers
FROM
near.nft.ez_nft_sales
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -30, CURRENT_DATE)
GROUP BY
PLATFORM_NAME
ORDER BY
total_sales_volume_usd DESC;