Query editor
WITH legs AS (SELECT 'Morpho Blue' AS provider, evt_tx_hash AS tx_hash, evt_block_date AS block_date,caller AS borrower, token AS token_address, assets AS amount_raw, CAST(0 AS uint256) AS fee_rawFROM morpho_blue_base.morphoblue_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNION ALLSELECT 'Aave V3', evt_tx_hash, evt_block_date, initiator, asset, amount, premiumFROM (SELECT evt_tx_hash, evt_index, evt_block_date, initiator, asset, amount, premiumFROM aave_v3_base.l2pool_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAYUNIONSELECT evt_tx_hash, evt_index, evt_block_date, initiator, asset, amount, premiumFROM aave_v3_base.pool_evt_flashloanWHERE evt_block_date >= CURRENT_DATE - INTERVAL '30' DAY)),priced AS (SELECT l.*,CAST(l.amount_raw AS DOUBLE) / POW(10, COALESCE(p.decimals, 18)) * p.price AS borrowed_usd,CAST(l.fee_raw AS DOUBLE) / POW(10, COALESCE(p.decimals, 18)) * p.price AS fee_usdFROM legs lLEFT JOIN prices.day p ON p.blockchain = 'base' AND p.contract_address = l.token_addressAND p.timestamp = CAST(l.block_date AS TIMESTAMP))SELECT provider, COUNT(DISTINCT tx_hash) AS transactions,COUNT(DISTINCT borrower) AS unique_borrowers,SUM(borrowed_usd) AS borrowed_usd,APPROX_PERCENTILE(borrowed_usd, 0.5) AS median_leg_usd,SUM(fee_usd) AS provider_fee_usd,100.0 * COUNT_IF(borrowed_usd IS NOT NULL) / COUNT(*) AS price_coverage_pctFROM pricedGROUP BY 1ORDER BY transactions DESC