flipside

    (Cosmos) Number of Proposals Per Month
    jennifertran(Cosmos) Number of Proposals Per Month
    Updated 2023-06-16
    select
    count(distinct proposal_id) as number_of_proposals,
    date_trunc('month', block_timestamp) as month
    from
    cosmos.core.fact_governance_submit_proposal
    where
    block_timestamp >= dateadd('year', -2, current_date)
    group by
    month


    Run a query to Download Data