mz0111Untitled Query
Updated 2022-10-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with earlyHolders as (
select
address,
balance/pow (10,decimal) as early_OSMO_Balance
from osmosis.core.fact_daily_balances
where currency = 'uosmo'
and date = '2022-01-01'
order by 2 DESC
limit 100
)
select
address,
balance/pow (10,decimal) as current_OSMO_Balance,
early_OSMO_Balance
from osmosis.core.fact_daily_balances join earlyHolders USING(address)
where currency = 'uosmo'
and date = CURRENT_DATE - 1
order by 2 DESC
limit 100
Run a query to Download Data