binhachonCopy of Untitled Query
    Updated 2021-12-25
    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