Skip to content
Dune Analytics

@tianqi / keep staked

SQL query results

Loading
 

SQL query

1select * from keep_v110."TokenStaking_evt_OperatorStaked";
270.97M
3select sum(value)/1e18 from
4(select value from keep_v110."TokenStaking_evt_OperatorStaked" t
5union all
6select -value from keep_v110."TokenStaking_call_cancelStake" t inner join keep_v110."TokenStaking_evt_OperatorStaked" a on a.operator = t."_operator"
7union all
8select (t."newAmount"-a.value) as value from keep_v110."TokenStaking_evt_TopUpCompleted" t inner join keep_v110."TokenStaking_evt_OperatorStaked" a on a.operator = t.operator
9)a
10
11select * from keep_v110."TokenStaking_evt_TopUpInitiated";
12select (t."newAmount"-a.value) as value from keep_v110."TokenStaking_evt_TopUpCompleted" t inner join keep_v110."TokenStaking_evt_OperatorStaked" a on a.operator = t.operator;
13
14select * from keep_v110."TokenStaking_call_balanceOf";
15select * from keep_v110."TokenStaking_evt_RecoveredStake";
16select * from keep_v110."TokenStaking_evt_StakeDelegated";
17select * from keep_v110."TokenStaking_evt_StakeOwnershipTransferred"
18select * from keep_v110."TokenStaking_evt_Undelegated" t inner join keep_v110."TokenStaking_evt_OperatorStaked" a on a.operator = t.operator