ErsvanSmart Money NFT Traders - General
Updated 2022-06-08
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
min (ad,min,minP) AS (
SELECT PURCHASER, MINT, MINT_PRICE FROM solana.fact_nft_mints WHERE SUCCEEDED = TRUE AND BLOCK_TIMESTAMP > '2022-01-01'
),
tra (ad,min,id) AS (
SELECT TX_FROM, MINT, TX_ID FROM solana.fact_transfers WHERE BLOCK_TIMESTAMP > '2022-01-01'
),
topMin (ad,num) AS (
SELECT AD, COUNT(*) AS NUM
FROM min
GROUP BY ad
ORDER BY NUM DESC
LIMIT 10
),
topNFT(ad,min,minP) AS (
SELECT
min.ad,
min.min,
min.minP
FROM
min
JOIN topMin ON topMin.ad = min.ad
),
topTra (ad,num) AS (
SELECT tra.ad, COUNT(*) AS NUM
FROM
tra
JOIN min ON min.min = tra.min
WHERE tra.ad = min.ad
GROUP BY tra.ad
ORDER BY NUM DESC
LIMIT 10
),
topAd (ad,min,numMin,numTra,avg) AS(
SELECT
topTra.ad AS address,
Run a query to Download Data