libruaryBuyersByProject
Updated 2024-12-10
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
›
⌄
WITH WeeklyBuyers AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS activity_week,
nft_collection,
COUNT(DISTINCT buyer) AS daily_active_nft_buyers
FROM flow.NFT.ez_nft_sales
GROUP BY activity_week, nft_collection
),
TopCollections AS (
SELECT
nft_collection,
SUM(daily_active_nft_buyers) AS total_buyers
FROM WeeklyBuyers
GROUP BY nft_collection
ORDER BY total_buyers DESC
LIMIT 10
)
SELECT
wb.activity_week,
wb.nft_collection,
wb.daily_active_nft_buyers
FROM WeeklyBuyers wb
JOIN TopCollections tc ON wb.nft_collection = tc.nft_collection
ORDER BY wb.activity_week ASC, wb.daily_active_nft_buyers DESC;
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived