amirrzOsmosis Holders by Token
Updated 2022-10-26
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
›
⌄
WITH
tab1 as ( SELECT
date_trunc('day', recorded_at) as day,
symbol,
avg(price) as price
FROM
osmosis.core.dim_prices
WHERE
recorded_at > '2022-01-01' GROUP BY 1,2
)
SELECT project_name as balance_type,
count(DISTINCT osmosis.core.fact_daily_balances.address) as holders,
sum((balance/ power(10, decimal)) * price) as bal,
sum((balance/ power(10, decimal)) * price) / count(DISTINCT osmosis.core.fact_daily_balances.address) as avg_bal
FROM
osmosis.core.fact_daily_balances
LEFT outer JOIN osmosis.core.dim_labels
ON
CURRENCY = osmosis.core.dim_labels.ADDRESS
LEFT OUTER JOIN tab1
on
project_name = symbol
AND day = date
WHERE
date > '2022-05-10'
GROUP BY 1
HAVING bal BETWEEN 500000 AND 1000000000
Run a query to Download Data