dannyamahcombined totals
    Updated 2025-02-07
    with supply_reduction AS (
    SELECT
    'Supply Reduction Proposal' AS proposal,
    value:VOTERS::float as voters,
    value:TOTAL_VOTE_WEIGHT::float AS vote_weight
    FROM (
    SELECT
    livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/64db7361-4c90-4020-8290-a1766dcda0a2/data/latest') as response
    ), lateral FLATTEN (input => response:data)
    ),

    microgrants AS (
    SELECT
    'Microgrants Proposal' AS proposal,
    value:VOTERS::float as voters,
    value:TOTAL_VOTE_WEIGHT::float AS vote_weight
    FROM (
    SELECT
    livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/ee4cca74-96cf-4fda-9fb0-52a95a38a6be/data/latest') as response
    ), lateral FLATTEN (input => response:data)
    ),

    jup_juice AS (
    SELECT
    'Jup and Juice WG' AS proposal,
    value:VOTERS::float as voters,
    value:TOTAL_VOTE_WEIGHT::float AS vote_weight
    FROM (
    SELECT
    livequery.live.udf_api('https://flipsidecrypto.xyz/api/v1/queries/d9721550-a969-4f4c-b0f7-464897828d8c/data/latest') as response
    ), lateral FLATTEN (input => response:data)
    ),

    asr AS (
    SELECT
    'Utilize Excess Jupuary for ASR' AS proposal,
    Last run: about 1 month ago
    PROPOSAL
    Total Voters
    Total Vote Weight
    1
    Microgrants Proposal153430267190807.502854
    1
    50B
    4s