maybeyonassol_monke_stake_overall
    Updated 2022-02-17
    -- select * from solana.events
    -- where tx_id = '4LmQFYcQwwuPvMkMGxyVoQU1Rx6GQXYjtpuBXMsmAv7uvS87s47mrNat1Z578GXesAmwMyYvC7LR3jYEeGNuKeeA'
    -- limit 100

    with delegate as (
    select
    block_timestamp,
    tx_id,
    instruction:parsed:info:stakeAuthority::string as user,
    instruction:parsed:info:stakeAccount::string as stake_proxy,
    instruction:parsed:info:voteAccount::string as validator
    from solana.staking_lp_actions
    where event_type = 'delegate'
    and instruction:programId::string = 'Stake11111111111111111111111111111111111111'
    ),
    stake_amt as (
    select
    tx_id,
    instruction:parsed:info:newAccount::string as stake_proxy,
    instruction:parsed:info:lamports/pow(10,9) as amt
    from solana.events
    where tx_id in (select tx_id from delegate)
    ),
    data as (
    select
    block_timestamp,
    d.tx_id,
    validator,
    user,
    d.stake_proxy,
    amt
    from delegate d join stake_amt a on d.tx_id = a.tx_id and d.stake_proxy=a.stake_proxy
    where block_timestamp >= '2022-02-01'
    and validator = 'DfpdmTsSCBPxCDwZwgBMfjjV8mF8xHkGRcXP8dJBVmrq' --monkeDAO validator
    )

    Run a query to Download Data