maybeyonasopyn_position_liquidated
    Updated 2022-06-29
    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