Query editor
WITH token_prices AS (SELECTtoken_bought_address AS token,block_date AS day,AVG(amount_usd / token_bought_amount) AS price_usdFROM dex.tradesWHERE blockchain = 'hyperevm'AND amount_usd IS NOT NULLAND token_bought_amount > 0GROUP BY 1, 2)SELECThypurrfi_hyperevm.pool_evt_borrow.evt_block_date AS day,SUM((hypurrfi_hyperevm.pool_evt_borrow.amount / 1e18)* token_prices.price_usd) AS total_borrow_volume_usdFROM hypurrfi_hyperevm.pool_evt_borrowLEFT JOIN token_pricesON hypurrfi_hyperevm.pool_evt_borrow.reserve = token_prices.tokenAND hypurrfi_hyperevm.pool_evt_borrow.evt_block_date = token_prices.dayWHERE hypurrfi_hyperevm.pool_evt_borrow.evt_block_date >= DATE '2025-02-18'AND hypurrfi_hyperevm.pool_evt_borrow.evt_block_date < CURRENT_DATEGROUP BY 1ORDER BY 1 DESC;