alirsOsmos-G-15
    Updated 2022-11-24
    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