maybeyonassol_monke_stake_overall
Updated 2022-02-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
28
29
30
31
32
33
34
35
36
›
⌄
-- select * from solana.events
-- where tx_id = '4LmQFYcQwwuPvMkMGxyVoQU1Rx6GQXYjtpuBXMsmAv7uvS87s47mrNat1Z578GXesAmwMyYvC7LR3jYEeGNuKeeA'
-- limit 100
with delegate as (
select
block_timestamp,
tx_id,
instruction:parsed:info:stakeAuthority::string as user,
instruction:parsed:info:stakeAccount::string as stake_proxy,
instruction:parsed:info:voteAccount::string as validator
from solana.staking_lp_actions
where event_type = 'delegate'
and instruction:programId::string = 'Stake11111111111111111111111111111111111111'
),
stake_amt as (
select
tx_id,
instruction:parsed:info:newAccount::string as stake_proxy,
instruction:parsed:info:lamports/pow(10,9) as amt
from solana.events
where tx_id in (select tx_id from delegate)
),
data as (
select
block_timestamp,
d.tx_id,
validator,
user,
d.stake_proxy,
amt
from delegate d join stake_amt a on d.tx_id = a.tx_id and d.stake_proxy=a.stake_proxy
where block_timestamp >= '2022-02-01'
and validator = 'DfpdmTsSCBPxCDwZwgBMfjjV8mF8xHkGRcXP8dJBVmrq' --monkeDAO validator
)
Run a query to Download Data