0xaimanSOL Staker Activity 2
Updated 2022-04-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
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