Maple

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 Name	Column Name	Description
ez_metrics	lending_deposits	The total amount of tokens deposited (in USD) on Maple
ez_metrics	lending_loans	The total outstanding loans (in USD) on Maple
ez_metrics	tvl	The total value locked in the Maple protocol
ez_metrics	tvl_net_change	The net change in the total value locked in Maple
ez_metrics	outstanding_supply	The total amount of outstanding supply (legacy naming)
ez_metrics	net_deposits	Total deposits in the protocol (legacy naming)
ez_metrics	token_holder_count	Number of SYRUP token holders

Fee and Revenue Metrics

Table Name	Column Name	Description
ez_metrics	interest_fees	Fees generated from interest payments on loans
ez_metrics	platform_fees	Fees collected by the Maple platform
ez_metrics	delegate_fees	Fees collected by pool delegates
ez_metrics	fees	The total USD value generated by Maple from all user-paid fees
ez_metrics	fees	Total fees collected (legacy naming)
ez_metrics	revenue	Total revenue (legacy naming)
ez_metrics	token_incentives	Incentives distributed in SYRUP tokens
ez_metrics	total_expenses	Total expenses including token incentives
ez_metrics	protocol_earnings	Revenue minus expenses

Cash Flow Distribution Metrics

Table Name	Column Name	Description
ez_metrics	fee_sharing_token_fee_allocation	Revenue distributed to users who commit tokens to receive a share of protocol fees
ez_metrics	treasury_fee_allocation	Revenue allocated to the protocol’s treasury
ez_metrics	service_fee_allocation	The share of protocol revenue accrued to service providers (33% of delegate fees)
ez_metrics	token_fee_allocation	The share of protocol revenue accrued to token holders (66% of delegate fees)
ez_metrics	primary_supply_side_revenue	Revenue accrued to supply-side participants (legacy naming)
ez_metrics	total_supply_side_revenue	Total revenue accrued to supply-side participants (legacy naming)
ez_metrics	buybacks	The amount of tokens actually bought back by the protocol in USD
ez_metrics	buybacks_native	The amount of tokens actually bought back by the protocol in native token units

Treasury Metrics

Table Name	Column Name	Description
ez_metrics	treasury	The USD value in the protocol treasury
ez_metrics	treasury_native	The native value of tokens in the protocol treasury
ez_metrics	net_treasury	The USD value in the treasury excluding the protocol’s own tokens
ez_metrics	net_treasury_native	The native value in the treasury excluding the protocol’s own tokens
ez_metrics	own_token_treasury	The USD value of the protocol’s own tokens in the protocol treasury
ez_metrics	own_token_treasury_native	The native value of the protocol’s own tokens in the protocol treasury
ez_metrics	treasury_value	The USD value in the protocol treasury (legacy naming)
ez_metrics	treasury_value_native	The native value of tokens in the protocol treasury (legacy naming)
ez_metrics	net_treasury_value	The value in the treasury excluding the protocol’s own tokens (legacy naming)

Market and Token Metrics

Table Name	Column Name	Description
ez_metrics	price	The price of SYRUP in USD
ez_metrics	market_cap	The market cap of SYRUP token in USD
ez_metrics	fdmc	The fully diluted market cap of SYRUP token in USD
ez_metrics	token_volume	The trading volume of SYRUP token in USD
ez_metrics	token_turnover_circulating	The turnover of SYRUP based on circulating supply
ez_metrics	token_turnover_fdv	The turnover of SYRUP based on fully diluted valuation

Token Supply Metrics

Table Name	Column Name	Description
ez_metrics	circulating_supply_native	The circulating supply of SYRUP in native tokens
ez_metrics	gross_emissions_native	The amount of native SYRUP tokens emitted
ez_metrics	gross_emissions	The USD value of SYRUP tokens emitted
ez_metrics	premine_unlocks_native	The amount of native tokens unlocked from premine
ez_metrics	locked_syrup_native	The 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

👋 Welcome

📜 Data Reference

🌎 Prediction Markets

🔢 Artemis Sheets

🖥️ API

❄️ Snowflake Share

🖼️ Artemis Terminal

🔍 Research

📞 Contact Us

Available Tables

Table Schema

Lending and Activity Metrics

Fee and Revenue Metrics

Cash Flow Distribution Metrics

Treasury Metrics

Market and Token Metrics

Token Supply Metrics

Sample Queries

Lending Activity Analysis

Revenue Stream Breakdown

Cash Flow Distribution

Treasury Analysis

Token Economics Analysis

Pool Performance Comparison

Token Treasury Breakdown

​Available Tables

​Table Schema

​Lending and Activity Metrics

​Fee and Revenue Metrics

​Cash Flow Distribution Metrics

​Treasury Metrics

​Market and Token Metrics

​Token Supply Metrics

​Sample Queries

​Lending Activity Analysis

​Revenue Stream Breakdown

​Cash Flow Distribution

​Treasury Analysis

​Token Economics Analysis

​Pool Performance Comparison

​Token Treasury Breakdown

Available Tables

Table Schema

Lending and Activity Metrics

Fee and Revenue Metrics

Cash Flow Distribution Metrics

Treasury Metrics

Market and Token Metrics

Token Supply Metrics

Sample Queries

Lending Activity Analysis

Revenue Stream Breakdown

Cash Flow Distribution

Treasury Analysis

Token Economics Analysis

Pool Performance Comparison

Token Treasury Breakdown