maybeyonasopyn_position_liquidated
Updated 2022-06-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
select
block_timestamp,
tx_hash,
liquidator,
vault,
debt_amount,
collateral_amount
from (
select
block_timestamp,
tx_hash,
regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data,
'0x'|| substr(segmented_data[0],25) as liquidator,
ethereum.public.udf_hex_to_int(segmented_data[1]) as vault,
ethereum.public.udf_hex_to_int(segmented_data[2])/pow(10,18) as debt_amount,
ethereum.public.udf_hex_to_int(segmented_data[3])/pow(10,18) as collateral_amount
from ethereum.core.fact_event_logs
where contract_address = '0x64187ae08781b09368e6253f9e94951243a493d5'
and topics[0] = '0x158ba9ab7bbbd08eeffa4753bad41f4d450e24831d293427308badf3eadd8c76'
)
limit 100
-- 0x158ba9ab7bbbd08eeffa4753bad41f4d450e24831d293427308badf3eadd8c76 -- liq