select tx_id from solana.core.fact_events

where succeeded=TRUE -- block_timestamp::date >= date('2022-01-01' ) and

and event_type='delegate'

select date(a.block_timestamp) as day, c.tx_from as wallet, sum(instruction:parsed:info:lamports/pow(10,9)) as tot_staked_sol from solana.core.fact_events a join staked_txns b

on a.tx_id=b.tx_id join solana.core.fact_transfers c on a.tx_id = c.tx_id

where succeeded='TRUE' and a.block_timestamp::date >= date('2022-01-01' )--and tot_staked_sol is not null and tot_staked_sol > 0

group by day, wallet