with native_stake as (

select

block_timestamp,

tx_id,

'Stake' as type,

validator_name,

stake_account,

withdraw_authority as staker,

post_tx_staked_balance/1e9 as amount

solana.gov.ez_staking_lp_actions

where block_timestamp::date >= '2023-07-18'

and event_type = 'initialize'

and succeeded = TRUE

and stake_authority in ('noMa7dN4cHQLV4ZonXrC29HTKFpxrpFbDLK5Gub8W8t', 'stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq')

and withdraw_authority not in ('noMa7dN4cHQLV4ZonXrC29HTKFpxrpFbDLK5Gub8W8t', 'stWirqFCf2Uts1JBL1Jsd3r6VBWhgnpdPxCTe1MFjrq')

limit 100

, native_unstake as (

select block_timestamp,

tx_id,

'Unstake' as type,

null as validator_name,

null as stake_account,

PARSE_JSON(instruction:parsed):PrepareForRevoke:user as staker,

PARSE_JSON(instruction:parsed):PrepareForRevoke:amount/1e9 as amount

from solana.core.fact_events

where block_timestamp::date >= '2023-07-18'

and succeeded = TRUE

and program_id = 'MemoSq4gqABAXKb96qnH8TysNcWxMyWCqXgDLGmfcHr'

and instruction:parsed ilike '%PrepareForRevoke%'

, base as (