alirsOsmos-G-15
Updated 2022-11-24
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with voters as (
select voter,
count (distinct tx_id) as Number_of_votes
from osmosis.core.fact_governance_votes
where tx_status = 'SUCCEEDED'
and proposal_id=362
group by 1)
select avg (balance/pow(10,decimal)) as OSMO_Balance
from osmosis.core.fact_daily_balances
where currency = 'uosmo'
and date = (select max(date) from osmosis.core.fact_daily_balances)
and address in (select voter from voters)
Run a query to Download Data