tx_id as "Transaction",

block_timestamp as "Block timestamp",

post_balances[account.index] / 1e9 as "Unstaked balance",

instruction.value:parsed.info.voteAccount as "Delinquent validator",

account.value:pubkey as "Stake account"

solana.core.fact_transactions txs,

lateral flatten(input => txs.instructions) as instruction,

lateral flatten(input => txs.account_keys) as account

date_trunc('day', block_timestamp) between '2023-12-01' and '2023-12-31'

and array_contains('ByeByeS4EhEhAPmqE2nULzwzx9yK1Ee47We3TCQ5Bwys'::variant, signers)

and succeeded = TRUE

and account.value:pubkey = instruction.value:parsed.info.stakeAccount

order by

date_trunc('day', block_timestamp) desc

limit 10000