Query editor
WITH liquidation_events AS (SELECTgas_price * gas_used / POWER(10, 18) AS hype_consumed, hash, gas_price, gas_used, priority_fee_per_gas, "type" AS tx_type, block_number, block_time, "from" AS liquidatorFROM hyperevm.transactionsWHERE hash IN (SELECTtx_hashFROM hyperevm.logsWHERE contract_address = 0x68e37dE8d93d3496ae143F2E900490f6280C57cDAND topic0 = 0xa4946ede45d0c6f06a0f5ce92c9ad3b4751452d2fe0e25010783bcab57a67e41AND date_diff('day', block_time, current_timestamp) <= {{last_n_day}})), block_gas AS (SELECTnumber, base_fee_per_gasFROM hyperevm.blocks hbWHERE number IN (SELECT block_number FROM liquidation_events WHERE tx_type = 'Legacy'))SELECTdate_trunc('day', le.block_time) AS ds, le.tx_type, SUM(hype_consumed) AS hype_consumed, MAX(CASEWHEN tx_type = 'Legacy' THEN (le.gas_price - bg.base_fee_per_gas) / POWER(10, 9)WHEN tx_type = 'DynamicFee' THEN le.priority_fee_per_gas / POWER(10, 9)ELSE 0 END) AS max_prio_fee_paid, COUNT(distinct liquidator) AS liquidator_count, COUNT(hash) AS liquidation_countFROM liquidation_events leLEFT JOIN block_gas bgON le.block_number = bg.numberGROUP BY 1, 2ORDER BY 1 DESC