feyikemiTotal Holders
Updated 2024-11-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
›
⌄
WITH Tb1 AS (
SELECT
TO_ADDRESS AS Wallet,
AMOUNT AS USD_AMOUNT
-- AMOUNT_USD AS USD_Amount
FROM
near.core.ez_token_transfers
WHERE 1=1
AND CONTRACT_ADDRESS = 'blackdragon.tkn.near'
-- AND Block_timestamp >= '2024-02-26'
-- AND TO_ADDRESS != '0x0000000000000000000000000000000000000000' -- Null Address
UNION ALL
SELECT
FROM_ADDRESS AS Wallet,
AMOUNT AS USD_AMOUNT
-- -AMOUNT_USD AS USD_Amount
FROM
near.core.ez_token_transfers
WHERE 1=1
AND CONTRACT_ADDRESS = 'blackdragon.tkn.near'
-- AND Block_timestamp >= '2024-02-26'
-- AND FROM_ADDRESS != '0x0000000000000000000000000000000000000000' -- Null Address
)
SELECT
COUNT(DISTINCT Wallet) AS Total_Holders
FROM Tb1
WHERE USD_AMOUNT > 0
-- HAVING SUM(USD_AMOUNT) > 0
-- WHERE (SELECT SUM(USD_Amount) FROM Tb1 AS t2 WHERE t2.Wallet = Tb1.Wallet) > 0
QueryRunArchived: QueryRun has been archived