tx_id,

ixs.value:accounts[3] stake_account,

ixs.value:accounts[1] bond_account,

post_balances[accounts.index] / 1e9 balance

from solana.core.fact_transactions,

LATERAL FLATTEN(input => instructions) ixs,

LATERAL FLATTEN(input => account_keys) accounts

where 1=1

and BLOCK_TIMESTAMP > CURRENT_DATE - 7

-- and tx_id = '5zo1rLGnUdvphHZnw385gxGxpj2vrC5LyXJzGG5o5uRFNQDtK7mtSjbodKNhgnQhidkfW9kDeE6trR2sJmSast4q'

and ixs.value:programId = 'vBoNdEvzMrSai7is21XgVYik65mqtaKXuSdMBJ1xkW4'

and ixs.value:data = 'AjNYrvLyYzh'

and bond_account = '3zVyxrxkR2a3oWoBku7CaAG7UW6JS65vqyoTdG1Djig9'

and stake_account = accounts.value:pubkey

limit 100