angealUntitled Query
Updated 2022-12-06
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
›
⌄
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
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)
Run a query to Download Data