with

lst_labels as (

select *

from (

values

('9eG63CdHjsfhHmobHgLtESGC8GabbmRcaSpHAZrtmhco', 'mSOL', 'Marinade')

,('W1ZQRwUfSkDKy2oefRBUWph82Vr2zg9txWMA8RQazN5', 'stSOL', 'Lido')

,('6iQKfEyhr3bZMotVkW6beNZz5CPAkiwvgV2CTje9pVSS', 'jitoSOL', 'Jito')

,('6WecYymEARvjG5ZyqkrVQ6YkhPfujNzWpSPwNKXHCbV2', 'bSOL', 'BlazeStake')

,('HbJTxftxnXgpePCshA8FubsRj9MW4kfPscfuUfn44fnt', 'jSOL', 'JPool')

,('AzZRvyyMHBm8EHEksWxq4ozFL7JxLMydCDMGhqM6BVck', 'scnSOL', 'Socean')

,('3b7XQeZ8nSMyjcQGTFJS5kBw4pXS2SqtB9ooHCnF2xV9', 'LST', 'Marginfi')

) as t(authority, symbol, label)

),

all_actions as (

select

date_trunc('day', actions.block_timestamp) as date

, tx_id

, stake_account

, iff(stake_authority = authority

or withdraw_authority = authority

, post_tx_staked_balance

, 0) as post_tx_staked_balance

, stake_active

, event_type

, stake_authority

, withdraw_authority

, symbol

, label