feyikemi$GHST Top 20 Holders
Updated 2024-09-20
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
34
35
36
›
⌄
WITH Tab1 AS (
SELECT
TO_ADDRESS AS Wallet,
AMOUNT_USD AS USD_Amount
FROM
polygon.core.ez_token_transfers
WHERE 1=1
AND CONTRACT_ADDRESS = LOWER('0x385eeac5cb85a38a9a07a70c73e0a3271cfb54a7')
AND Block_timestamp::Date >= '2024-01-01'
AND TO_ADDRESS != '0x0000000000000000000000000000000000000000' -- Null Address
UNION ALL
SELECT
FROM_ADDRESS AS Wallet,
AMOUNT_USD*(-1) AS USD_Amount
FROM
polygon.core.ez_token_transfers
WHERE 1=1
AND CONTRACT_ADDRESS = LOWER('0x385eeac5cb85a38a9a07a70c73e0a3271cfb54a7')
AND Block_timestamp::Date >= '2024-01-01'
AND FROM_ADDRESS != '0x0000000000000000000000000000000000000000' -- Null Address
)
SELECT
Wallet AS Holders,
SUM(USD_Amount) AS USD_Value
FROM
Tab1
GROUP BY
1
HAVING
USD_Value > 0
ORDER BY
USD_Value DESC
LIMIT
QueryRunArchived: QueryRun has been archived