@tianqi / 绑定的ETH

SQL query

1--赎回后解押的ETH
2with released_bond as(
3select -amount as amount from keep_v110."KeepBonding_evt_BondReleased" t 
4inner join keep_v110."KeepBonding_evt_BondCreated" a 
5on a."referenceID" = t."referenceID" and a."operator" = t."operator"),
6--？只知道清算的时候会执行这个，其他还有啥场景？？
7seized_bond as (
8select -amount as amount from keep_v110."KeepBonding_evt_BondSeized" t 
9)
10
11select sum(amount)/1e18 as Bonded from
12(select amount from keep_v110."KeepBonding_evt_BondCreated"
13union all
14select amount from released_bond
15union all
16select amount from seized_bond)a
17