Skip to content
Dune Analytics

@tianqi / New Query

SQL query results

Loading
 

SQL query

1with ever_created as (
2select t.amount from keep_v110."KeepBonding_evt_BondCreated" t
3),
4
5ever_released as (
6select t.amount from keep_v110."KeepBonding_evt_BondCreated" t
7inner join keep_v110."KeepBonding_evt_BondReleased" a on a."referenceID" = t."referenceID" and a."operator" = t."operator"
8),
9
10ever_seized as(
11select amount from keep_v110."KeepBonding_evt_BondSeized")
12
13--24.63k
14--unbonded ETH
15select sum(amount)/1e18 as unbounded from(
16select amount from ever_created
17union all
18select -amount from ever_released
19union all
20select -amount from ever_seized )a