datavortexTop Collections By Buyers And Sellers
Updated 2025-02-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH TopCollections AS (
SELECT
project_name
FROM
aptos.nft.fact_nft_sales
WHERE
block_timestamp >= current_timestamp - INTERVAL '1 month'
AND project_name IS NOT NULL
AND project_name <> ''
GROUP BY
project_name
ORDER BY
COUNT(DISTINCT fact_nft_sales_id) DESC
LIMIT
10
),
BuyersSellers AS (
SELECT
project_name,
buyer_address,
seller_address
FROM
aptos.nft.fact_nft_sales
WHERE
block_timestamp >= current_timestamp - INTERVAL '1 month'
)
SELECT
tc.project_name,
COUNT(DISTINCT bs.buyer_address) AS NumberOfBuyers,
COUNT(DISTINCT bs.seller_address) AS NumberOfSellers
FROM
TopCollections tc
JOIN BuyersSellers bs ON tc.project_name = bs.project_name
GROUP BY
tc.project_name
ORDER BY
QueryRunArchived: QueryRun has been archived