xeejsgr478Top 10 OSMO holders over time changes
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
28
29
30
31
32
33
34
35
36
›
⌄
WITH start_year AS (
SELECT
address,
SUM(balance/POW(10,decimal)) AS past_balance
FROM
osmosis.core.fact_daily_balances
WHERE
date = '2022-01-01'
AND
balance_type = 'liquid'
AND
currency = 'uosmo'
GROUP BY address
),
current_date AS (
SELECT
address,
SUM(balance/POW(10,decimal)) AS current_balance
FROM
osmosis.core.fact_daily_balances
WHERE
date = CURRENT_DATE()
AND
currency = 'uosmo'
GROUP BY address
)
SELECT
a.address,
a.past_balance,
b.current_balance
FROM
start_year a
JOIN
current_date b
ON a.address = b.address
ORDER BY a.past_balance DESC
Run a query to Download Data