SELECT

tx_id,

block_timestamp,

stake_account AS user,

validator_name,

platform,

post_tx_staked_balance - pre_tx_staked_balance AS amount,

post_tx_staked_balance_usd - pre_tx_staked_balance_usd AS amount_usd,

event_type AS event_name

FROM solana.marinade.ez_native_staking_actions

WHERE event_type = 'delegate'

AND succeeded

AND post_tx_staked_balance - pre_tx_staked_balance > 0

UNION ALL

SELECT

tx_id,

block_timestamp,

stake_account AS user,

validator_name,

platform,

withdraw_amount AS amount,

ABS(post_tx_staked_balance_usd - pre_tx_staked_balance_usd) AS amount_usd,

event_type AS event_name

FROM solana.marinade.ez_native_staking_actions

WHERE event_type = 'withdraw'

AND succeeded

AND withdraw_amount > 0

),

first_stake AS (

SELECT

user,

MIN(DATE_TRUNC('month', block_timestamp)) AS first_stake_month