Raydium

Raydium Schema Description and Methodology

This schema contains comprehensive on-chain datasets for tracking Raydium fundamental data across multiple metrics categories, including trading activity, fees, revenue streams, token economics, and market data.

Available Tables

Raydium data is available in two main tables:

• ez_metrics: Aggregated metrics for the entire Raydium protocol with detailed token supply data
• ez_metrics_by_chain: Contains the same metrics as ez_metrics (where applicable), but broken down by blockchain. Use this table when you need to analyze performance across different chains.

Table Schema

Trading and Activity Metrics

Table Name	Column Name	Description
ez_metrics	spot_volume	The total volume on Raydium’s CPMM, AMM v4, and CLMM
ez_metrics	spot_dau	The number of daily active traders on Raydium’s CPMM, AMM v4, and CLMM
ez_metrics	spot_txns	The number of daily trades on Raydium’s CPMM, AMM v4, and CLMM
ez_metrics	tvl	The total value locked in Raydium’s AMM, CPMM, and CLMM pools
ez_metrics	trading_volume	Total trading volume (legacy naming, same as spot_volume)
ez_metrics	unique_traders	Number of unique traders (legacy naming, same as spot_dau)
ez_metrics	number_of_swaps	Total number of swap transactions (legacy naming, same as spot_txns)

Fee and Revenue Metrics

Table Name	Column Name	Description
ez_metrics	spot_fees	The trading fees generated from swaps on all Raydium platforms
ez_metrics	pool_creation_fees	The fees collected from creating new pools on Raydium
ez_metrics	ecosystem_revenue	The total USD value generated from all user-paid fees on Raydium’s CPMM, AMM, and CLMM, prior to the split with network participants
ez_metrics	fees	Combined trading fees and pool creation fees (legacy naming)
ez_metrics	revenue	Total revenue (legacy naming)

Cash Flow Distribution Metrics

Table Name	Column Name	Description
ez_metrics	buyback_cash_flow	Portion of revenue allocated to buy back RAY tokens
ez_metrics	treasury_cash_flow	Revenue allocated to the protocol’s treasury. For Raydium’s CPMM and CLMM that is 4% of fees, and 0% for AMM v4
ez_metrics	service_cash_flow	The share of protocol revenue accrued to Raydium LPs. On Raydium’s AMM, that is 88% of fees, while on the CPMM and CLMM it is 84% of fees
ez_metrics	buybacks	The USD value of RAY tokens actually bought back by the protocol
ez_metrics	buyback_native	The amount of RAY tokens bought back in native token units
ez_metrics	treasury_fees	Fees allocated to the treasury in USD (legacy naming)
ez_metrics	treasury_fees_native	Fees allocated to the treasury in native token units (legacy naming)

Market and Token Metrics

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

Token Supply Metrics

Table Name	Column Name	Description
ez_metrics	circulating_supply_native	The circulating supply of RAY in native tokens
ez_metrics	net_supply_change_native	The net change in the circulating supply of RAY in native tokens
ez_metrics	gross_emissions_native	The amount of new RAY tokens emitted
ez_metrics	premine_unlocks_native	The amount of native tokens unlocked from premine

Sample Queries

Trading Activity Analysis

-- Analyze Raydium trading activity
SELECT
    date,
    spot_volume,
    spot_dau,
    spot_txns,
    tvl
FROM
    art_share.raydium.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

Revenue Stream Breakdown

-- Analyze Raydium revenue streams
SELECT
    date,
    ecosystem_revenue,
    spot_fees,
    pool_creation_fees
FROM
    art_share.raydium.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

Cash Flow Distribution

-- Track how Raydium revenue is distributed
SELECT
    date,
    ecosystem_revenue,
    buyback_cash_flow,
    treasury_cash_flow,
    service_cash_flow
FROM
    art_share.raydium.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date ASC

Token Economics Analysis

-- Track RAY token supply changes
SELECT
    date,
    price,
    circulating_supply_native,
    gross_emissions_native,
    premine_unlocks_native,
    net_supply_change_native
FROM
    art_share.raydium.ez_metrics
WHERE
    date >= '2022-01-01'
ORDER BY
    date ASC

TVL and Protocol Metrics Correlation

-- Analyze correlation between TVL, trading volume and user activity
SELECT
    date,
    tvl,
    spot_volume,
    spot_dau,
    price
FROM
    art_share.raydium.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC

Chain-specific Analysis

-- Analyze Raydium metrics on Solana
SELECT
    date,
    chain,
    spot_volume,
    spot_dau,
    tvl,
    ecosystem_revenue,
    buyback_cash_flow
FROM
    art_share.raydium.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
    AND chain = 'solana'
ORDER BY
    date ASC