binhachonCopy of Untitled Query
Updated 2021-12-25
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
›
⌄
with collateral_token_contract as (
select 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp' as contract_address
union
select 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun' as contract_address
),
collateral_token_price as (
select
date_trunc('hour', block_timestamp) as hour,
currency,
symbol,
price_usd
from
terra.oracle_prices
where currency in (select contract_address from collateral_token_contract)
),
single_liquidation as (
select
tx_id,
block_timestamp,
event_attributes:"0_borrower"::string as borrower,
event_attributes:liquidator::string as liquidator,
event_attributes:collateral_token::string as collateral_token,
event_attributes:collateral_amount::float/1e6 as collateral_amount
from terra.msg_events
where event_type = 'from_contract'
and tx_status = 'SUCCEEDED'
and event_attributes:"0_action"::string = 'liquidate_collateral'
and event_attributes:collateral_token::string is not null
),
double_liquidation_0 as (
select
tx_id,
block_timestamp,
event_attributes:"0_borrower"::string as borrower,
event_attributes:"0_liquidator"::string as liquidator,
event_attributes:"0_collateral_token"::string as collateral_token,
Run a query to Download Data