noanuman-1x1vZpMedian Holder Value
Updated 2024-10-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- forked from Median Holder Value @ https://flipsidecrypto.xyz/studio/queries/5d12f9d5-fb07-43c0-a15a-acd784e21a17
WITH token_address AS (
SELECT LOWER('0xaaeE1A9723aaDB7afA2810263653A34bA2C21C7a') AS tokenADR
),
current_holders AS (
SELECT
user_address,
CAST(SUM(usd_value_now) AS DOUBLE) AS dollar_amount
FROM ETHEREUM.core.ez_current_balances
WHERE contract_address = (SELECT tokenADR FROM token_address)
AND current_bal > 0
GROUP BY user_address
)
SELECT
PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY dollar_amount) AS median_holder_value
FROM current_holders;
QueryRunArchived: QueryRun has been archived