0xaimanSOL Staker Activity 2
    Updated 2022-04-17
    select swap_program , count(tx_id) as n_txn
    from
    (with swap as (select swapper, swap_program, block_timestamp, tx_id
    from solana.fact_swaps

    where block_timestamp>='2022-04-01'
    --where tx_id='5pYC73Qqvi8L5qTLHj5BzPvxWNAJyWmNbu6Yy6TspehQe5rtw7K2X2ChtcvCcPnsw9sedfaLWeyw3vkDdghnczTL'

    ),

    stake as (

    select block_timestamp as date, instruction:parsed:info:stakeAuthority as wa
    from solana.fact_events
    where --tx_id='kn8xEQdb92z4LBsXtcfXptfUxRtRB57FV4fniiyH7pe9ykc37zn2vqfXCAagkAkqYHpYTmbn6CQDjDhh9vMQrPm' and
    event_type='delegate' and instruction:program='stake'
    and block_timestamp>='2022-04-01'

    )

    select swapper, swap_program, block_timestamp, tx_id
    from swap
    inner join stake on swap.swapper=stake.wa
    )

    group by 1 order by 1
    Run a query to Download Data