count(distinct signers[0]) as claimers,

count(distinct tx_id) as claims,

ROUND(sum(decoded_args:amount / pow(10, 6)), 2) as claimed_jup,

ROUND(sum(decoded_args:amount / pow(10, 6)) / count(distinct tx_id), 2) as average_claim,

50000000 - ROUND(sum(decoded_args:amount / pow(10, 6)), 2) as unclaimed_jup,

(100 * ROUND(sum(decoded_args:amount / pow(10, 6)), 2)) / 50000000 AS pct_claimed,

(100 - (100 * ROUND(sum(decoded_args:amount / pow(10, 6)), 2)) / 50000000) AS pct_unclaimed

FROM solana.core.ez_events_decoded

WHERE 1 = 1

AND event_type = 'increaseLockedAmount'

AND program_id = 'voTpe3tHQ7AjQHMapgSue2HJFAh2cGsdokqN3XqmVSj'

AND block_timestamp >= '2025-04-09 22:48:00'

AND succeeded