RamaharAverage $OSMO balance
    Updated 2022-11-23
    with voter_status as (
    select voter,
    count (distinct tx_id) as 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 balance
    from osmosis.core.fact_daily_balances
    where currency = 'uosmo' and address in (select voter from voter_status)
    and date = (select MAX(date) from osmosis.core.fact_daily_balances)


    Run a query to Download Data