noanuman-1x1vZpCurrent AVG. $ Held in TOKEN
Updated 2024-10-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
27
28
29
30
31
›
⌄
WITH token_address AS (
SELECT LOWER('0xaaeE1A9723aaDB7afA2810263653A34bA2C21C7a') AS tokenADR
),
-- Get the current token holders and their balances
current_holders AS (
SELECT
user_address,
CAST(SUM(current_bal) AS DOUBLE) AS total_balance
FROM ETHEREUM.core.ez_current_balances
WHERE contract_address = (SELECT tokenADR FROM token_address)
AND current_bal > 0
GROUP BY user_address
),
-- Get the latest token price
token_price AS (
SELECT
price
FROM ETHEREUM.price.ez_prices_hourly
WHERE token_address = (SELECT tokenADR FROM token_address)
ORDER BY hour DESC
LIMIT 1
)
-- Calculate the average holder $ value
SELECT
AVG(c.total_balance * tp.price) AS average_holder_value_usd
FROM current_holders c
CROSS JOIN token_price tp;
QueryRunArchived: QueryRun has been archived