Skip to content
Dune Analytics

@tianqi / Liquidation Details

Liquidation Details

Loading
 

About queries and results

Dune Analytics lets you explore, create, and share Ethereum analytics. You can find an endless amount of great queries and dashboards on Dune.

We have decoded Ethereum smart contract data so you can do powerful analysis with simple SQL queries and visualise the query results into beautiful graphs.

Dune Analytics is free for everyone forever. If you want extra features like private queries, export your results and more check out our Pro plan.

SQL query results

Loading
 

SQL query

1with bonded_eth as(
2select date_trunc('day',a.evt_block_time) as d_date,
3t."_depositContractAddress" as dpaddress,
4a.operator,--签名者
5a.amount/1e18 as bonded_eth --绑定的ETH数量
6from keep_v110."TBTCSystem_evt_StartedLiquidation" t
7inner join keep_v110."KeepBonding_evt_BondSeized" a on a.destination = t."_depositContractAddress"
8order by 1),
9
10unbonded_eth as (
11select date_trunc('day',a.evt_block_time) as d_date,
12t."_depositContractAddress" as dpaddress,
13a.operator,--签名者
14a.amount/1e18 as bonded_eth --绑定的ETH数量
15 from keep_v110."TBTCSystem_evt_Liquidated" t
16inner join keep_v110."KeepBonding_evt_UnbondedValueDeposited" a on a.evt_tx_hash = t.evt_tx_hash --从这里可以查到tBTC的交易情况
17)
18
19select t.d_date,
20t.operator,
21t.dpaddress as deposite_contract,
22t.bonded_eth as start_liquidation_amount,
23(t.bonded_eth-a.bonded_eth) as actual_liquidated_amount,
24a.bonded_eth as liquidation_left_amount
25from bonded_eth t inner join unbonded_eth a on a.operator = t.operator and a.dpaddress = t.dpaddress...