block_id,

block_timestamp,

tx_id,

tx_status,

event_attributes:"collateral_token" as collateral_token,

event_attributes:"0_amount"/1000000 as collateral_liquidated,

event_attributes:"1_repay_amount"/1000000 as UST_repaid,

event_attributes:"1_borrower" as borrower_address,

event_attributes:"liquidator" as liquidator_address

FROM terra.msg_events

WHERE event_type = 'from_contract' and event_attributes:"0_action" = 'liquidate_collateral' and date_trunc('hour',block_timestamp) > '2021-11-09 00:00:00.000'