Morpho

-- 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

-- 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

-- 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,
    fees,
    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

-- 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

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

-- 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

-- 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