jackguyGoverning the Cosmos
    Updated 2023-06-04
    with tab1 as (
    SELECT
    proposal_id as p_id,
    PROPOSAL_TYPE as p_type,
    block_timestamp as p_time
    FROM cosmos.core.fact_governance_submit_proposal
    )

    SELECT
    p_time,
    p_type,
    p_id,
    COUNT(DISTINCT VOTER) as voters,
    sum(VOTE_WEIGHT) as voting_power
    FROM cosmos.core.fact_governance_votes
    LEFT outer JOIN tab1
    ON p_id = proposal_id
    WHERE p_time is not NULL
    GROUP BY 1,2,3
    Run a query to Download Data