This schema contains comprehensive on-chain datasets for tracking Maple fundamental data across multiple metrics categories, including lending activity, fee distribution, treasury management, token economics, and market data.

​
Available Tables

Maple data is available in several tables:
  • ez_metrics: Aggregated metrics for the entire Maple protocol with detailed token supply and treasury data
  • ez_metrics_by_chain: Contains key metrics broken down by blockchain
  • ez_metrics_by_pool: Metrics organized by individual Maple lending pools
  • ez_metrics_by_token: Treasury and revenue metrics broken down by token

​
Table Schema

​
Lending and Activity Metrics

Table NameColumn NameDescription
ez_metricslending_depositsThe total amount of tokens deposited (in USD) on Maple
ez_metricslending_loansThe total outstanding loans (in USD) on Maple
ez_metricstvlThe total value locked in the Maple protocol
ez_metricstvl_net_changeThe net change in the total value locked in Maple
ez_metricsoutstanding_supplyThe total amount of outstanding supply (legacy naming)
ez_metricsnet_depositsTotal deposits in the protocol (legacy naming)
ez_metricstoken_holder_countNumber of SYRUP token holders

​
Fee and Revenue Metrics

Table NameColumn NameDescription
ez_metricsinterest_feesFees generated from interest payments on loans
ez_metricsplatform_feesFees collected by the Maple platform
ez_metricsdelegate_feesFees collected by pool delegates
ez_metricsfeesThe total USD value generated by Maple from all user-paid fees
ez_metricsfeesTotal fees collected (legacy naming)
ez_metricsrevenueTotal revenue (legacy naming)
ez_metricstoken_incentivesIncentives distributed in SYRUP tokens
ez_metricstotal_expensesTotal expenses including token incentives
ez_metricsprotocol_earningsRevenue minus expenses

​
Cash Flow Distribution Metrics

Table NameColumn NameDescription
ez_metricsfee_sharing_token_fee_allocationRevenue distributed to users who commit tokens to receive a share of protocol fees
ez_metricstreasury_fee_allocationRevenue allocated to the protocol’s treasury
ez_metricsservice_fee_allocationThe share of protocol revenue accrued to service providers (33% of delegate fees)
ez_metricstoken_fee_allocationThe share of protocol revenue accrued to token holders (66% of delegate fees)
ez_metricsprimary_supply_side_revenueRevenue accrued to supply-side participants (legacy naming)
ez_metricstotal_supply_side_revenueTotal revenue accrued to supply-side participants (legacy naming)
ez_metricsbuybacksThe amount of tokens actually bought back by the protocol in USD
ez_metricsbuybacks_nativeThe amount of tokens actually bought back by the protocol in native token units

​
Treasury Metrics

Table NameColumn NameDescription
ez_metricstreasuryThe USD value in the protocol treasury
ez_metricstreasury_nativeThe native value of tokens in the protocol treasury
ez_metricsnet_treasuryThe USD value in the treasury excluding the protocol’s own tokens
ez_metricsnet_treasury_nativeThe native value in the treasury excluding the protocol’s own tokens
ez_metricsown_token_treasuryThe USD value of the protocol’s own tokens in the protocol treasury
ez_metricsown_token_treasury_nativeThe native value of the protocol’s own tokens in the protocol treasury
ez_metricstreasury_valueThe USD value in the protocol treasury (legacy naming)
ez_metricstreasury_value_nativeThe native value of tokens in the protocol treasury (legacy naming)
ez_metricsnet_treasury_valueThe value in the treasury excluding the protocol’s own tokens (legacy naming)

​
Market and Token Metrics

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

​
Token Supply Metrics

Table NameColumn NameDescription
ez_metricscirculating_supply_nativeThe circulating supply of SYRUP in native tokens
ez_metricsgross_emissions_nativeThe amount of native SYRUP tokens emitted
ez_metricsgross_emissionsThe USD value of SYRUP tokens emitted
ez_metricspremine_unlocks_nativeThe amount of native tokens unlocked from premine
ez_metricslocked_syrup_nativeThe amount of locked SYRUP tokens in native token units

​
Sample Queries

​
Lending Activity Analysis

-- Analyze Maple lending activity
SELECT
    date,
    lending_deposits,
    lending_loans,
    tvl,
    tvl_net_change
FROM
    art_share.maple.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Revenue Stream Breakdown

-- Analyze Maple revenue streams
SELECT
    date,
    fees,
    interest_fees,
    platform_fees,
    delegate_fees,
    protocol_earnings
FROM
    art_share.maple.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Cash Flow Distribution

-- Track how Maple revenue is distributed
SELECT
    date,
    fees,
    fee_sharing_token_fee_allocation,
    treasury_fee_allocation,
    service_fee_allocation,
    token_fee_allocation
FROM
    art_share.maple.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date ASC

​
Treasury Analysis

-- Analyze Maple's treasury composition
SELECT
    date,
    treasury,
    net_treasury,
    own_token_treasury,
    own_token_treasury_native
FROM
    art_share.maple.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC

​
Token Economics Analysis

-- Track SYRUP token metrics
SELECT
    date,
    price,
    market_cap,
    fdmc,
    circulating_supply_native,
    gross_emissions_native,
    premine_unlocks_native,
    locked_syrup_native,
    buybacks_native
FROM
    art_share.maple.ez_metrics
WHERE
    date >= '2022-01-01'
ORDER BY
    date ASC

​
Pool Performance Comparison

-- Compare performance across different Maple pools
SELECT
    date,
    pool_name,
    fees,
    platform_fees,
    delegate_fees,
    tvl,
    outstanding_supply
FROM
    art_share.maple.ez_metrics_by_pool
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    pool_name, date ASC

​
Token Treasury Breakdown

-- Analyze Maple's treasury by token
SELECT
    date,
    token,
    treasury_value_native,
    revenue_native,
    protocol_earnings_native
FROM
    art_share.maple.ez_metrics_by_token
WHERE
    date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
    token, date ASC