KaskoazulNEAR R2: Most voted proposals
    Updated 2022-08-02
    with votes_raw as (
    select fc.tx_hash
    ,parse_json(fc.args):id as proposal
    ,parse_json(fc.args):action as vote
    ,t.tx_receiver as proposer
    ,t.tx_signer as voter
    from near.core.fact_actions_events_function_call fc
    join near.core.fact_transactions t
    on fc.tx_hash = t.tx_hash
    where method_name = 'act_proposal' --and args:id = 13
    and deposit = 0
    )

    Run a query to Download Data