SELECT

signers[0] AS user_wallet,

decoded_instruction:args:amount::int / POW(10, 6) AS amount,

event_type,

block_timestamp

FROM

solana.core.ez_events_decoded

WHERE

program_id = 'voTpe3tHQ7AjQHMapgSue2HJFAh2cGsdokqN3XqmVSj' -- JUP staking program ID

AND event_type IN ('increaseLockedAmount')

AND block_timestamp::date < '2024-11-01' -- Added time limit

),

net_staked AS (

SELECT

user_wallet,

SUM(

CASE

WHEN event_type = 'increaseLockedAmount' THEN amount

ELSE 0

END

) AS net_staked_amount

FROM

staking_events

GROUP BY

user_wallet

),

total_staked AS (

SELECT

SUM(net_staked_amount) AS total_staked_amount

FROM

net_staked

),