from

(SELECT *, instruction:parsed:info:lamports as amt, case when event_type = 'createAccountWithSeed' then (amt)/pow(10,9)

when event_type = 'withdraw' then (amt)/pow(10,9)*(-1) end as net_deposits from solana.events

where ( event_type = 'createAccountWithSeed' or event_type = 'withdraw' ) and succeeded = 'TRUE' and net_deposits is not NULL )

GROUP by 1

),

net_solana_staked as

(SELECT day, net_deposits , sum(net_deposits) over (order by day) as cumulative_deposits, deposit_size from

(SELECt day, case when day = '2021-12-29' then 393*pow(10,6) else total_deposits end as net_deposits, deposit_size

from solana_staked

where day> '2021-12-28')

where day> '2022-01-01')

SELECT *, from

(SELECT date(block_timestamp) as day_, sum(amt) as total_txs, avg(amt) as avg_tx_size

from

(SELECT *, instruction:parsed:info:lamports as amt from solana.events

where succeeded = 'TRUE' and amt is not NULL )

GROUP by 1 )

INNER join net_solana_staked

on day = day_

limit 1000