WITH staking_actions AS (

SELECT

date_trunc('week', block_timestamp) AS date,

SUM(CASE WHEN STAKE_ACTION = 'stake' THEN AMOUNT ELSE 0 END) AS stake_amount,

SUM(CASE WHEN STAKE_ACTION = 'withdraw/claim' THEN AMOUNT ELSE 0 END) AS withdraw_amount

FROM

arbitrum.vertex.ez_staking_actions

WHERE

(STAKE_ACTION = 'withdraw/claim' AND FROM_ADDRESS = LOWER('0x5be754ad77766089c4284d914f0cc37e8e3f669a'))

OR

(STAKE_ACTION = 'stake' AND TO_ADDRESS = LOWER('0x5be754ad77766089c4284d914f0cc37e8e3f669a'))

AND SYMBOL = 'VRTX'

GROUP BY

date_trunc('week', block_timestamp)

date,

stake_amount,

'222835990' AS circulating_supply,

-withdraw_amount AS unstake_amount,

stake_amount - withdraw_amount AS net_flow_stake,

SUM(stake_amount - withdraw_amount) OVER (ORDER BY date) AS cumulative_net_flow_stake,

((cumulative_net_flow_stake / circulating_supply)* 100) AS percentage_staked

staking_actions

ORDER BY

date DESC;