This schema contains comprehensive datasets for tracking Morpho fundamental data across multiple metrics categories, including lending activity, deposits, loans, fees, token economics, and market data.

​
Available Tables

Morpho data is available in two main tables:

  • ez_metrics: Main aggregated metrics for the entire Morpho protocol
  • ez_metrics_by_chain: Metrics broken down by blockchain

​
Table Schema

​
Lending Activity Metrics

Table NameColumn NameDescription
ez_metricslending_dauThe number of daily active users on Morpho
ez_metricslending_txnsThe number of daily transactions on Morpho
ez_metricsdaily_borrows_usdThe USD value of daily borrows
ez_metricsdaily_supply_usdThe USD value of daily supply
ez_metricsdauLegacy naming for lending_dau
ez_metricstxnsLegacy naming for lending_txns

​
Deposits and Loans Metrics

Table NameColumn NameDescription
ez_metricslending_depositsThe total amount of tokens deposited (in USD)
ez_metricslending_loansThe total outstanding loans (in USD)
ez_metricslending_loan_capacityThe total amount of loans available (in USD)
ez_metricstvlThe total value locked in Morpho (deposits - loans)
ez_metricsdepositsLegacy naming for lending_deposits
ez_metricsborrowsLegacy naming for lending_loans
ez_metricssuppliesLegacy naming for lending_loan_capacity
ez_metricstotal_available_supplyLegacy naming for lending_loan_capacity

​
Fee and Revenue Metrics

Table NameColumn NameDescription
ez_metricslending_interest_feesThe total amount of interest fees generated on Morpho
ez_metricsecosystem_revenueThe total value generated by the protocol from all fees
ez_metricsfeesLegacy naming for lending_interest_fees
ez_metricsfees_cumulativeThe cumulative sum of fees over time

​
Token Supply Metrics

Table NameColumn NameDescription
ez_metricscirculating_supply_nativeThe circulating supply of MORPHO in native tokens
ez_metricsnet_supply_change_nativeThe net change in the circulating supply of MORPHO
ez_metricspremine_unlocks_nativeThe amount of native tokens unlocked from premine

​
Market and Token Metrics

Table NameColumn NameDescription
ez_metricspriceThe price of MORPHO token in USD
ez_metricsmarket_capThe market cap of MORPHO token in USD
ez_metricsfdmcThe fully diluted market cap of MORPHO token in USD
ez_metricstoken_volumeThe trading volume of MORPHO token in USD
ez_metricstoken_turnover_circulatingThe turnover of MORPHO based on circulating supply
ez_metricstoken_turnover_fdvThe turnover of MORPHO based on fully diluted valuation

​
Metrics by Chain

The ez_metrics_by_chain table provides a breakdown of Morpho’s performance across different blockchains. It includes the following columns:

Table NameColumn NameDescription
ez_metrics_by_chaindateThe date of the recorded metrics
ez_metrics_by_chainchainThe specific blockchain (Ethereum, etc.)
ez_metrics_by_chaindauDaily active users on this chain
ez_metrics_by_chaintxnsNumber of transactions on this chain
ez_metrics_by_chaindaily_borrows_usdThe USD value of daily borrows on this chain
ez_metrics_by_chaindaily_supply_usdThe USD value of daily supply on this chain
ez_metrics_by_chaintotal_available_supplyAvailable loan capacity on this chain
ez_metrics_by_chainfeesInterest fees generated on this chain
ez_metrics_by_chainlending_loansOutstanding loans on this chain
ez_metrics_by_chainlending_loan_capacityLoan capacity on this chain
ez_metrics_by_chainlending_depositsTotal deposits on this chain
ez_metrics_by_chaintvlTotal value locked on this chain
ez_metrics_by_chainlending_interest_feesInterest fees on this chain
ez_metrics_by_chainecosystem_revenueProtocol revenue on this chain

​
Sample Queries

​
Basic Protocol Activity Query

-- Pull fundamental activity data for the Morpho protocol
SELECT
    date,
    lending_dau,
    lending_txns,
    lending_deposits,
    lending_loans,
    tvl,
    price
FROM
    art_share.morpho.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Lending Metrics Analysis

-- Analyze Morpho lending metrics
SELECT
    date,
    lending_deposits,
    lending_loans,
    lending_loan_capacity,
    lending_loans / lending_loan_capacity * 100 as utilization_rate,
    tvl
FROM
    art_share.morpho.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Revenue Analysis

-- Analyze Morpho revenue and interest fees
SELECT
    date,
    lending_interest_fees as daily_fees,
    SUM(lending_interest_fees) OVER (ORDER BY date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as cumulative_fees,
    ecosystem_revenue,
    lending_deposits,
    lending_interest_fees / lending_deposits * 365 * 100 as annualized_yield_percentage
FROM
    art_share.morpho.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Token Economics Analysis

-- Track MORPHO token metrics
SELECT
    date,
    price,
    market_cap,
    fdmc,
    circulating_supply_native,
    net_supply_change_native,
    premine_unlocks_native
FROM
    art_share.morpho.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Cross-Chain Comparison

-- Compare Morpho metrics across different blockchains
SELECT
    date,
    chain,
    lending_deposits,
    lending_loans,
    tvl,
    ecosystem_revenue
FROM
    art_share.morpho.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    chain, date ASC

​
User Activity and Growth Analysis

-- Track Morpho user growth and activity
SELECT
    date,
    lending_dau,
    lending_txns,
    lending_txns / lending_dau as avg_txns_per_user,
    daily_borrows_usd,
    daily_supply_usd
FROM
    art_share.morpho.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC

​
Protocol Economics Analysis

-- Analyze Morpho protocol economics
SELECT
    date,
    lending_deposits,
    lending_loans,
    tvl,
    lending_interest_fees,
    lending_interest_fees / lending_loans * 365 * 100 as annualized_borrowing_rate,
    price,
    token_volume
FROM
    art_share.morpho.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC