SELECT

t.tx_id,

t.block_timestamp,

t.instructions[1]:accounts[1] AS addrs

FROM

solana.core.fact_transactions t

INNER JOIN solana.core.fact_events e

USING (block_timestamp, tx_id)

WHERE

succeeded = 'true'

AND block_timestamp::date >= '2023-02-01'

AND program_id = '6HW8dXjtiTGkD4jzXs7igdFmZExPpmwUrRN5195xGup'

AND t.signers[0]::string = 'FK1VcVh5PqEUm8U3aEz69DRSNSCjD6cMjzGx3KKbiE8'

AND event_type IS NULL

AND array_contains('Program log: Instruction: Activate stake pool'::VARIANT, log_messages);