Query editor
WITH market_registry AS (SELECTid AS market_id,-- Extraemos AMBOS tokensfrom_hex(json_extract_scalar(marketParams, '$.loanToken')) AS loan_token_address,from_hex(json_extract_scalar(marketParams, '$.collateralToken')) AS collateral_token_address,-- Extraemos el LLTV para contexto de riesgoCAST(json_extract_scalar(marketParams, '$.lltv') AS DOUBLE) / 1e18 AS lltvFROM morpho_blue_ethereum.MorphoBlue_evt_CreateMarket),supply_flow AS (SELECT id, COALESCE(SUM(CAST(assets AS DOUBLE)), 0) AS supply_amountFROM (SELECT id, assets FROM morpho_blue_ethereum.MorphoBlue_evt_SupplyUNION ALLSELECT id, -1 * CAST(assets AS DOUBLE) FROM morpho_blue_ethereum.MorphoBlue_evt_Withdraw)GROUP BY 1),borrow_flow AS (SELECT id, COALESCE(SUM(CAST(assets AS DOUBLE)), 0) AS borrow_amountFROM (SELECT id, assets FROM morpho_blue_ethereum.MorphoBlue_evt_BorrowUNION ALLSELECT id, -1 * CAST(assets AS DOUBLE) FROM morpho_blue_ethereum.MorphoBlue_evt_Repay)GROUP BY 1),metrics_raw AS (SELECTs.id AS market_id,s.supply_amount AS raw_supply,COALESCE(b.borrow_amount, 0) AS raw_borrowFROM supply_flow sLEFT JOIN borrow_flow b ON s.id = b.id)SELECT-- Nombres Legibles: "USDC / WBTC (86%)"l.symbol || ' / ' || COALESCE(c.symbol, 'No Collat') || ' (' || CAST(ROUND(reg.lltv * 100, 0) AS VARCHAR) || '%)' AS market_name,-- Métricas Financierasm.raw_supply / power(10, l.decimals) AS total_supply,m.raw_borrow / power(10, l.decimals) AS total_borrow,-- EL KPI ESTRELLA: Utilization RateTRY(m.raw_borrow / m.raw_supply) * 100 AS utilization_rate,m.market_idFROM metrics_raw mJOIN market_registry reg ON m.market_id = reg.market_id-- Join para Loan TokenLEFT JOIN tokens.erc20 l ON reg.loan_token_address = l.contract_address AND l.blockchain = 'ethereum'-- Join para Collateral TokenLEFT JOIN tokens.erc20 c ON reg.collateral_token_address = c.contract_address AND c.blockchain = 'ethereum'