Query editor
-- Fees paid to Base by lending transactions against the debt they serve, by protocol and month, January 2025 to October 2026.-- A lending transaction is a successful transaction with at least one supply, withdraw, borrow, repay, collateral or liquidation event on Aave v3, Morpho (markets and vaults),-- Moonwell, Compound v3, Euler v2 or Fluid, read from saved event tables built from each protocol's decoded events. Each transaction is counted once, under the protocol of its first lending event.-- chain_fee_usd = gas used x gas price paid (the base fee plus the priority fee) in ETH x the day's ETH price. The L1 data fee is shown apart. Transactions with a liquidation are shown apart.-- Borrowed and supplied are day-end totals per market from saved daily tables, priced at the day's token price and averaged over the month; a dollar-year is that average times days over 365.-- The last_12_months columns cover November 2025 to October 2026 and repeat on every row. month_label is the month as text for a chart axis.-- Morpho totals keep to markets on its public list. Market days with no price are left out, never counted as zero. fee_bps_of_borrowed = chain fee per dollar-year borrowed, in hundredths of a percent.WITH core AS (SELECT 'aave_v3' AS protocol, tx_hash, block_date, evt_index, verb FROM dune.paigeisonfire.result_base_value_capture_lending_events_aave_v3_hist_2025q1 WHERE block_date >= DATE '2025-01-01' AND block_date < DATE '2026-11-01' AND verb IN ('supply','withdraw','borrow','repay','supply_collateral','withdraw_collateral','liquidate_repay','liquidate_seize')UNION ALL SELECT 'aave_v3' AS protocol, tx_hash, block_date, evt_index, verb FROM dune.paigeisonfire.result_base_value_capture_lending_events_aave_v3_hist_2025q2 WHERE block_date >= DATE '2025-01-01' AND block_date < DATE '2026-11-01' AND verb IN ('supply','withdraw','borrow','repay','supply_collateral','withdraw_collateral','liquidate_repay','liquidate_seize')UNION ALL SELECT 'aave_v3' AS protocol, tx_hash, block_date, evt_index, verb FROM dune.paigeisonfire.result_base_value_capture_lending_events_aave_v3_hist_2025q3 WHERE block_date >= DATE '2025-01-01' AND block_date < DATE '2026-11-01' AND verb IN ('supply','withdraw','borrow','repay','supply_collateral','withdraw_collateral','liquidate_repay','liquidate_seize')UNION ALL SELECT 'aave_v3' AS protocol, tx_hash, block_date, evt_index, verb FROM dune.paigeisonfire.result_base_value_capture_lending_events_aave_v3_hist_2025q4 WHERE block_date >= DATE '2025-01-01' AND block_date < DATE '2026-11-01' AND verb IN ('supply','withdraw','borrow','repay','supply_collateral','withdraw_collateral','liquidate_repay','liquidate_seize')UNION ALL SELECT 'aave_v3' AS protocol, tx_hash, block_date, evt_index, verb FROM dune.paigeisonfire.result_base_value_capture_lending_events_aave_v3_hist_2026q1 WHERE block_date >= DATE '2025-01-01' AND block_date < DATE '2026-11-01' AND verb IN ('supply','withdraw','borrow','repay','supply_collateral','withdraw_collateral','liquidate_repay','liquidate_seize')UNION ALL SELECT 'aave_v3' AS protocol, tx_hash, block_date, evt_index, verb FROM dune.paigeisonfire.result_base_value_capture_lending_events_aave_v3_hist_2026q2 WHERE block_date >= DATE '2025-01-01' AND block_date < DATE '2026-11-01' AND verb IN ('supply','withdraw','borrow','repay','supply_collateral','withdraw_collateral','liquidate_repay','liquidate_seize')UNION ALL SELECT 'aave_v3' AS protocol, tx_hash, block_date, evt_index, verb FROM dune.paigeisonfire.result_base_value_capture_lending_events_aave_v3_hist WHERE block_date >= DATE '2025-01-01' AND block_date < DATE '2026-11-01' AND verb IN ('supply','withdraw','borrow','repay','supply_collateral','withdraw_collateral','liquidate_repay','liquidate_seize')UNION ALL SELECT 'compound_v3' AS protocol, tx_hash, block_date, evt_index, verb FROM dune.paigeisonfire.result_base_value_capture_lending_events_compound_v3_hist WHERE block_date >= DATE '2025-01-01' AND block_date < DATE '2026-11-01' AND verb IN ('supply','withdraw','borrow','repay','supply_collateral','withdraw_collateral','liquidate_repay','liquidate_seize')UNION ALL SELECT 'euler_v2' AS protocol, tx_hash, block_date, evt_index, verb FROM dune.paigeisonfire.result_base_value_capture_lending_events_euler_v2_hist WHERE block_date >= DATE '2025-01-01' AND block_date < DATE '2026-11-01' AND verb IN ('supply','withdraw','borrow','repay','supply_collateral','withdraw_collateral','liquidate_repay','liquidate_seize')UNION ALL SELECT 'fluid' AS protocol, tx_hash, block_date, evt_index, verb FROM dune.paigeisonfire.result_base_value_capture_lending_events_fluid_hist WHERE block_date >= DATE '2025-01-01' AND block_date < DATE '2026-11-01' AND verb IN ('supply','withdraw','borrow','repay','supply_collateral','withdraw_collateral','liquidate_repay','liquidate_seize')UNION ALL SELECT 'moonwell' AS protocol, tx_hash, block_date, evt_index, verb FROM dune.paigeisonfire.result_base_value_capture_lending_events_moonwell_hist WHERE block_date >= DATE '2025-01-01' AND block_date < DATE '2026-11-01' AND verb IN ('supply','withdraw','borrow','repay','supply_collateral','withdraw_collateral','liquidate_repay','liquidate_seize')UNION ALL SELECT 'morpho' AS protocol, tx_hash, block_date, evt_index, verb FROM dune.paigeisonfire.result_base_value_capture_lending_events_morpho_blue_hist WHERE block_date >= DATE '2025-01-01' AND block_date < DATE '2026-11-01' AND verb IN ('supply','withdraw','borrow','repay','supply_collateral','withdraw_collateral','liquidate_repay','liquidate_seize')UNION ALL SELECT 'morpho' AS protocol, tx_hash, block_date, evt_index, verb FROM dune.paigeisonfire.result_base_value_capture_lending_events_morpho_vaults_hist WHERE block_date >= DATE '2025-01-01' AND block_date < DATE '2026-11-01' AND verb IN ('supply','withdraw','borrow','repay','supply_collateral','withdraw_collateral','liquidate_repay','liquidate_seize')),core_txs AS (SELECT tx_hash, block_date, MIN_BY(protocol, evt_index) AS protocol, MAX(CASE WHEN verb LIKE 'liquidate%' THEN 1 ELSE 0 END) AS is_liq FROM core GROUP BY 1, 2),eth AS (SELECT CAST(timestamp AS DATE) AS day, MAX(price) AS price FROM prices.day WHERE blockchain = 'base' AND contract_address = 0x4200000000000000000000000000000000000006 AND timestamp >= TIMESTAMP '2025-01-01' AND timestamp < TIMESTAMP '2026-11-01' GROUP BY 1),fees AS (SELECT date_trunc('month', tx.block_date) AS month, x.protocol,SUM(CASE WHEN x.is_liq = 0 THEN CAST(tx.gas_used AS DOUBLE) * CAST(tx.gas_price AS DOUBLE) / 1e18 * p.price END) AS chain_fee_usd,SUM(CASE WHEN x.is_liq = 1 THEN CAST(tx.gas_used AS DOUBLE) * CAST(tx.gas_price AS DOUBLE) / 1e18 * p.price END) AS liquidation_chain_fee_usd,SUM(CAST(COALESCE(tx.l1_fee, 0) AS DOUBLE) / 1e18 * p.price) AS l1_data_fee_usd,COUNT(*) AS transactions, SUM(x.is_liq) AS liquidation_transactionsFROM base.transactions txJOIN core_txs x ON x.tx_hash = tx.hash AND x.block_date = tx.block_dateLEFT JOIN eth p ON p.day = tx.block_dateWHERE tx.block_date >= DATE '2025-01-01' AND tx.block_date < DATE '2026-11-01' AND tx.successGROUP BY 1, 2),tok AS (SELECT contract_address, decimals FROM tokens.erc20 WHERE blockchain = 'base'),pday_raw AS (SELECT contract_address, CAST(timestamp AS DATE) AS day, price, decimals FROM prices.day WHERE blockchain = 'base' AND timestamp >= TIMESTAMP '2025-01-01' AND timestamp < TIMESTAMP '2026-11-01'),pday AS (SELECT contract_address, day, decimals, CASE WHEN price > 100 * approx_percentile(price, 0.5) OVER (PARTITION BY contract_address) THEN NULL ELSE price END AS price FROM pday_raw),f AS (SELECT 'aave_v3' AS protocol, day, underlying, CAST(borrow_total_raw AS DOUBLE) AS debt_raw, CAST(supply_total_raw AS DOUBLE) AS supply_raw, decimals AS dec_hint FROM dune.paigeisonfire.result_base_value_capture_lending_factors_aave_v3 WHERE day >= DATE '2025-01-01' AND day < DATE '2026-11-01'UNION ALL SELECT 'euler_v2', day, underlying, CAST(borrow_total_raw AS DOUBLE), CAST(supply_total_raw AS DOUBLE), NULL FROM dune.paigeisonfire.result_base_value_capture_lending_factors_euler_v2 WHERE day >= DATE '2025-01-01' AND day < DATE '2026-11-01'UNION ALL SELECT 'fluid', day, underlying, CAST(borrow_total_raw AS DOUBLE), CAST(supply_total_raw AS DOUBLE), decimals FROM dune.paigeisonfire.result_base_value_capture_lending_factors_fluid WHERE day >= DATE '2025-01-01' AND day < DATE '2026-11-01' AND factor_kind = 'liquidity_token'UNION ALL SELECT 'moonwell', day, underlying, CAST(totalborrows_day AS DOUBLE), CAST(supply_total_raw AS DOUBLE), decimals FROM dune.paigeisonfire.result_base_value_capture_lending_factors_moonwell WHERE day >= DATE '2025-01-01' AND day < DATE '2026-11-01'UNION ALL SELECT 'morpho', day, underlying, CAST(borrow_total_raw AS DOUBLE), CAST(supply_total_raw AS DOUBLE), NULL FROM dune.paigeisonfire.result_base_value_capture_lending_factors_morpho_blue WHERE day >= DATE '2025-01-01' AND day < DATE '2026-11-01' AND listed_source = 'api_whitelisted'UNION ALL SELECT 'compound_v3', day, underlying, CAST(borrow_total_raw AS DOUBLE), CAST(supply_total_raw AS DOUBLE), decimals FROM dune.paigeisonfire.result_base_value_capture_lending_factors_compound_v3 WHERE day >= DATE '2025-01-01' AND day < DATE '2026-11-01'),bal_day AS (SELECT r.protocol, r.day,SUM(r.debt_raw / POWER(10, COALESCE(t.decimals, r.dec_hint, p.decimals)) * p.price) AS borrowed_usd,SUM(r.supply_raw / POWER(10, COALESCE(t.decimals, r.dec_hint, p.decimals)) * p.price) AS supplied_usd,SUM(CASE WHEN p.price IS NULL AND r.debt_raw > 0 THEN 1 ELSE 0 END) AS unpriced_market_daysFROM f r LEFT JOIN tok t ON t.contract_address = r.underlying LEFT JOIN pday p ON p.contract_address = r.underlying AND p.day = r.dayGROUP BY 1, 2),bal AS (SELECT protocol, date_trunc('month', day) AS month, AVG(borrowed_usd) AS avg_borrowed_usd, AVG(supplied_usd) AS avg_supplied_usd, COUNT(*) AS days, SUM(unpriced_market_days) AS unpriced_market_days FROM bal_day GROUP BY 1, 2),o AS (SELECT CAST(b.month AS DATE) AS month,