mohamadreza221166top_50_bigger_holders
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
WITH nft_transfers AS(
SELECT *
FROM ethereum.core.ez_nft_transfers
WHERE nft_address = lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
),
transfers AS(
SELECT NFT_FROM_ADDRESS AS ADDRESS, sum(1) AS AMOUNT, -1 AS flag
FROM nft_transfers
GROUP BY NFT_FROM_ADDRESS
UNION
SELECT NFT_TO_ADDRESS AS ADDRESS, sum(1) AS AMOUNT, 1 AS flag
FROM nft_transfers
GROUP BY NFT_TO_ADDRESS
)
SELECT T1.ADDRESS, sum(T1.Amount * flag) holded_amount
FROM transfers T1
GROUP BY T1.ADDRESS
ORDER BY 2 DESC
LIMIT 50
Run a query to Download Data