mariyaMagic Eden top 20 Whales
Updated 2022-04-17
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
WITH sales as (
SELECT PURCHASER, SUM(SALES_AMOUNT) total_sales, COUNT(*) AS sale_count
FROM solana.fact_nft_sales
WHERE SUCCEEDED = 'TRUE'
AND DATE(BLOCK_TIMESTAMP) >= '2022-03-01' and marketplace = 'magic eden v1' or marketplace = 'magic eden v2' and succeeded = 'TRUE'
GROUP BY PURCHASER
)
SELECT top 20 *
FROM sales
where sale_count >= 50
ORDER BY total_sales DESC
Run a query to Download Data