select

FLOOR(block_id / 100000) as block_id,

date(block_timestamp) as date,

--index,

--event_type,

stake_account,

--pre_tx_staked_balance,

post_tx_staked_balance,

(post_tx_staked_balance - pre_tx_staked_balance)/1000000000 as stake_change,

vote_account

--node_pubkey

from solana.core.ez_staking_lp_actions

where succeeded = true

order by block_id asc

select

stake_account,

date,

max(post_tx_staked_balance)

--block_id,

--max(date) as date,

from base

group by stake_account, date

--order by asc