daniel1234567NFT Holders
Updated 2022-12-07
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
›
⌄
SELECT
*
from
ethereum.core.ez_current_balances
where contract_address IN (select nft_address FROM ethereum.core.ez_nft_sales group by nft_address)
AND LAST_ACTIVITY_BLOCK_TIMESTAMP > current_date - 1
LIMIT 2
-- WITH top_buyers AS (
-- select count(distinct(buyer_address)) AS n_buyers, nft_address
-- FROM ethereum.core.ez_nft_sales
-- GROUP BY nft_address
-- ORDER BY n_buyers DESC
-- LIMIT 100
-- ),
-- top_minters AS (
-- select count(distinct(NFT_TO_ADDRESS)) AS n_buyers, nft_address
-- FROM ethereum.core.ez_nft_mints
-- GROUP BY nft_address
-- ORDER BY n_buyers DESC
-- LIMIT 100
-- )
-- SELECT
-- contract_address, count(last_activity_block)
-- from
-- ethereum.core.ez_current_balances
-- where
-- contract_address IN (select nft_address FROM top_buyers)
-- OR
-- contract_address IN (select nft_address FROM top_minters)
-- group by 1
Run a query to Download Data