Query editor
with--slow direct stake (stake to ByKUX, which eventually gets transferred/delegated), get amount from datadeposit_sol as (SELECTdate_trunc('week', block_time) as week, sum(bytearray_to_bigint(bytearray_reverse(bytearray_substring(data, 2, 8)))/ pow(10,9) --lamports) as depositedFROM solana.instruction_callsWHERE executing_account = 'SPoo1Ku8WFXoNDMHPsrGSTSG1Y47rzgn41SLUNakuHy'AND contains(account_arguments, 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn')AND bytearray_substring(data, 1, 1) = 0x0e --depositsol, inst 14AND tx_successGROUP BY 1order by 2 desc)--immediate JitoSOL swap in from another stake pool, get amount based on balance changes due to "merge" deposits (i.e. close one staking account and merge it into the Jito one. I'm basically hoping it's merge only and not possible to split), deposit_stake as (SELECTdate_trunc('week', c.block_time) as week, sum(c_merge.stake) as depositedFROM solana.instruction_calls cLEFT JOIN staking_solana.stake_actions c_mergeON c_merge.block_slot = c.block_slotAND c_merge.tx_id = c.tx_idAND c_merge.outer_instruction_index = c.outer_instruction_indexAND c_merge.action = 'merge'WHERE c.executing_account = 'SPoo1Ku8WFXoNDMHPsrGSTSG1Y47rzgn41SLUNakuHy'AND contains(c.account_arguments, 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn')AND bytearray_substring(c.data, 1, 1) = 0x09 --depositstake, inst 9 0x09AND c.tx_success-- --depositstake example-- AND (c.tx_id = '2Aw158FnEz959yYtGivMdsrnypKeXnfYdjD5PCmTXKRB4UiAVNXiuQnep3zKyisDFEKS6HByezQsEJQNH5ACSsfi'-- AND c.block_slot = 215721392)group by 1)--slow direct unstake (split to different stake account, then wait to deactivate and withdraw), get amount from data, withdraw_stake as (SELECTdate_trunc('week', block_time) as week, sum(bytearray_to_bigint(bytearray_reverse(bytearray_substring(data, 2, 8)))/ pow(10,9) --lamports) as withdrawnFROM solana.instruction_callsWHERE executing_account = 'SPoo1Ku8WFXoNDMHPsrGSTSG1Y47rzgn41SLUNakuHy'AND contains(account_arguments, 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn')AND bytearray_substring(data, 1, 1) = 0x0a --withdrawstake, inst 10 --this burns JitoSOL and does a split callAND tx_successGROUP BY 1order by 2 desc