nitsFLOW Non Whales Top Projects
Updated 2022-10-20Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with f_ as
(SELECT DISTINCT buyer as b from flow.core.fact_nft_sales
where price > 2400),
s_ as
(SELECT DISTINCT purchaser as p from solana.core.fact_nft_sales
where succeeded and sales_amount > 240),
e_ as
(SELECT DISTINCT buyer_address as b from ethereum.core.ez_nft_sales
where price_usd > 2520*100),
flow_whale as
(SELECT nft_collection, COUNT(DISTINCT buyer) as popular
from flow.core.fact_nft_sales
where buyer not in (SELECT * from f_) and tx_succeeded
GROUP by 1 )
SELECT * from flow_whale
ORDER by 2 desc
-- UNION ALL
-- SELECT * FROM flow.core.fact_nft_sales
limit 10
Run a query to Download Data