SELECT

tx_id

FROM solana.core.ez_events_decoded

WHERE 1 = 1

AND block_timestamp::date >= '2024-02-20'

AND program_id = 'voTpe3tHQ7AjQHMapgSue2HJFAh2cGsdokqN3XqmVSj'

AND event_type = 'increaseLockedAmount'

mint

, count(DISTINCT tx_from) AS unique_lockers

, count(DISTINCT tx_id) AS lock_actions

, sum(amount) AS jup_locked

, max(amount) AS max_jup_locked

, max(block_timestamp) as last_tracked_transaction

, any_value(tx_id)

FROM solana.core.fact_transfers

WHERE 1 = 1

and block_timestamp::date >= '2024-02-20'

-- AND mint = 'JUPyiwrYJFskUPiHa7hkeR8VUtAeFoSYbKedZNsDvCN'

AND tx_id IN (SELECT tx_id from locks)

GROUP BY mint