signers[0] as claimant,

sum(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 total_claimed

from solana.core.fact_events

where succeeded

and program_id = 'CUEB3rQGVrvCRTmyjLrPnsd6bBBsGbz1Sr49vxNLJkGR'

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

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

group by 1

order by 2 desc

limit 10