0xaimanUntitled Query
    Updated 2022-07-05
    (with se as (select tx_id,instruction:parsed:info:stakeAuthority as staker ,
    instruction:parsed:info:stakeAccount as stake_act,event_type
    from solana.core.fact_events

    where event_type is not null --and tx_id='3SVGeFnyzg1mpuoQj6mW93Q7CQvEk5EeK8BTqBcG6U8k9UNDhPV9WRY46qoPs1vgYEiQ7pBryxTtCPFJFyLAqcmu'

    order by 2),

    txn as (
    select block_timestamp,

    account_keys[1]:pubkey as stac,
    tx_id, pre_balances[0]/10e8 as SOL_prebal,
    post_balances[0]/10e8 as SOL_postbal,
    SOL_prebal-SOL_postbal as SOl_staked
    from solana.core.fact_transactions
    )

    select txn.block_timestamp,staker, stac,event_type, se.tx_id, SOl_staked
    from se inner join txn on se.tx_id=txn.tx_id)
    Run a query to Download Data