block_timestamp

, tx_id

, signers[0] as claimant

, utils.udf_hex_to_int(to_char(reverse(to_binary(substr(utils.udf_base58_to_hex(instruction :data), length(utils.udf_base58_to_hex(instruction :data)) - 23, 16))))) / pow(10, 6) as amount

from solana.core.fact_events

where succeeded

and program_id = 'CUEB3rQGVrvCRTmyjLrPnsd6bBBsGbz1Sr49vxNLJkGR'

and substr(livequery.utils.udf_base58_to_hex(instruction :data), 3, 16) = '3ec6d6c1d59f6cd2' -- Claim

and block_timestamp >= '2024-12-17 13:00:00.000'

order by block_timestamp

limit 100