Query editor
WITH liquidation_events AS (SELECTblock_time, tx_hash, varbinary_substring(data, 65, 32) AS seized_amount_hex, varbinary_to_uint256(varbinary_substring(data, 65, 32)) AS seized_amount_uintFROM hyperevm.logsWHERE contract_address = 0x68e37dE8d93d3496ae143F2E900490f6280C57cDAND topic0 = 0xa4946ede45d0c6f06a0f5ce92c9ad3b4751452d2fe0e25010783bcab57a67e41AND date_diff('day', block_time, current_timestamp) <= {{last_n_day}}), liquidation_seized AS (SELECTle.block_time, le.tx_hash, logs.contract_address, le.seized_amount_uintFROM hyperevm.logs logsINNER JOIN liquidation_events leON logs.tx_hash = le.tx_hashAND logs.data = le.seized_amount_hexWHERE logs.topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3efAND logs.topic1 = 0x00000000000000000000000068e37de8d93d3496ae143f2e900490f6280c57cd -- collateral sent from morpho vaultAND date_diff('day', logs.block_time, current_timestamp) <= {{last_n_day}}), liquidation_priced AS (SELECTls.block_time, ls.tx_hash, pm.symbol, ls.seized_amount_uint * price / power(10, decimals) AS usd_amount, ls.seized_amount_uint / power(10, decimals) AS amountFROM liquidation_seized lsLEFT JOIN prices.minute pmON date_trunc('minute', pm.timestamp) = date_trunc('minute', ls.block_time)AND pm.contract_address = ls.contract_addressAND pm.blockchain = 'hyperevm'WHERE date_diff('day', pm.timestamp, current_timestamp) <= {{last_n_day}})SELECTdate_trunc('day', block_time) AS ds, symbol, count(tx_hash) AS tx_count, sum(amount) AS amount_liquidated, sum(usd_amount) AS usd_liquidatedFROM liquidation_pricedGROUP BY 1, 2ORDER BY 1 DESC