l.block_number,

l.block_timestamp,

l.tx_hash,

t.tx_fee as tx_fee_eth,

t.tx_fee * price as tx_fee_usd ,

l.collateral,

l.collateral_balance,

l.normalized_stablecoin_debt,

l.vault,

l.liquidated_wallet,

l.auction_id

from ethereum.maker.ez_liquidations l

inner join ethereum.core.fact_transactions t

on l.tx_hash = t.tx_hash

left join ethereum.core.fact_hourly_token_prices p

on hour = date_trunc('hour', l.block_timestamp)

where p.token_address is null

and l.tx_status = 'SUCCESS'