niloosmo part 2
Updated 2022-10-27
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
›
⌄
WITH
TOP100 AS (select
ADDRESS,
SUM (BALANCE/pow(10,DECIMAL)) AS BALANCE
FROM osmosis.core.fact_daily_balances
WHERE CURRENCY = 'uosmo'
AND DATE = '2022-10-26'
GROUP BY 1 ORDER BY BALANCE DESC LIMIT 100)
select
DATE,
BALANCE_TYPE,
SUM (BALANCE/pow(10,DECIMAL)) AS BALANCE
FROM osmosis.core.fact_daily_balances
WHERE CURRENCY = 'uosmo'
AND ADDRESS IN (SELECT ADDRESS FROM TOP100)
AND DATE BETWEEN '2022-01-01' and '2022-10-26'
GROUP BY 1,2
Run a query to Download Data