feyikemi2024-05-24 03:35 PM
Updated 2024-05-24
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
COUNT(DISTINCT USER_ADDRESS) AS Total_Holders,
-- CURRENT_BAL AS GHST_Value,
-- USD_Value_now AS USD_Value
FROM
ethereum.core.ez_current_balances
WHERE
contract_address = '0x3F382DbD960E3a9bbCeaE22651E88158d2791550' -- $GHST Contract Address
AND LAST_ACTIVITY_BLOCK_TIMESTAMP::DATE >= CURRENT_DATE - INTERVAL '30 days'
QueryRunArchived: QueryRun has been archived