afonsoAverage Voter Number of Terra Network per Week
    Updated 2023-01-12
    with t as (
    select
    date_trunc('week', a.block_timestamp)::date as week,
    count(distinct voter) as voters_count,
    sum(coalesce(vote_weight, 0)) as total_voting_weight
    from Terra.core.fact_governance_votes a
    join Terra.core.fact_governance_submit_proposal b
    using(proposal_id)
    group by 1
    )

    select
    avg(voters_count) as average_voters_count,
    avg(total_voting_weight) as average_voting_weight
    from t
    Run a query to Download Data