select

block_timestamp

, program_id

, instruction

, inner_instruction

, tx_id

from solana.core.fact_events

where 1 = 1

and block_timestamp > '2025-01-22 15:29:00'

and program_id in ('DiS3nNjFVMieMgmiQFm6wgJL7nevk4NrhXKLbtEH1Z2R', 'voTpe3tHQ7AjQHMapgSue2HJFAh2cGsdokqN3XqmVSj')

and (

substr(livequery.utils.udf_base58_to_hex(instruction:data), 3, 16) = '4eb1627bd215bb53' -- new_claim

or

substr(livequery.utils.udf_base58_to_hex(instruction:data), 3, 16) = '05a87635482ecb92' -- increaseLockedAmount

)

and succeeded

, claim_amount as (

select

tx_id

, instruction:accounts[4] as claimant

, array_size(inner_instruction:instructions) as inner_size

, inner_instruction:instructions[1]:parsed:info:amount / 1e6 as jup_amount

from cte

where program_id = 'DiS3nNjFVMieMgmiQFm6wgJL7nevk4NrhXKLbtEH1Z2R'

, tx_labelled as (

select

tx_id

, count_if(program_id = 'DiS3nNjFVMieMgmiQFm6wgJL7nevk4NrhXKLbtEH1Z2R') as claim_events

, count_if(program_id = 'voTpe3tHQ7AjQHMapgSue2HJFAh2cGsdokqN3XqmVSj') as stake_events

, iff(claim_events + stake_events = 1, 'onlyClaim', 'claimAndStake') as tx_label