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 NameColumn NameDescription
ez_metricsspot_volumeThe total volume on Raydium’s CPMM, AMM v4, and CLMM
ez_metricsspot_dauThe number of daily active traders on Raydium’s CPMM, AMM v4, and CLMM
ez_metricsspot_txnsThe number of daily trades on Raydium’s CPMM, AMM v4, and CLMM
ez_metricstvlThe total value locked in Raydium’s AMM, CPMM, and CLMM pools
ez_metricstrading_volumeTotal trading volume (legacy naming, same as spot_volume)
ez_metricsunique_tradersNumber of unique traders (legacy naming, same as spot_dau)
ez_metricsnumber_of_swapsTotal number of swap transactions (legacy naming, same as spot_txns)

​
Fee and Revenue Metrics

Table NameColumn NameDescription
ez_metricsspot_feesThe trading fees generated from swaps on all Raydium platforms
ez_metricspool_creation_feesThe fees collected from creating new pools on Raydium
ez_metricsfeesThe total USD value generated from all user-paid fees on Raydium’s CPMM, AMM, and CLMM, prior to the split with network participants
ez_metricsfeesCombined trading fees and pool creation fees (legacy naming)
ez_metricsrevenueTotal revenue (legacy naming)

​
Cash Flow Distribution Metrics

Table NameColumn NameDescription
ez_metricsbuyback_fee_allocationPortion of revenue allocated to buy back RAY tokens
ez_metricstreasury_fee_allocationRevenue allocated to the protocol’s treasury. For Raydium’s CPMM and CLMM that is 4% of fees, and 0% for AMM v4
ez_metricsservice_fee_allocationThe 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_metricsbuybacksThe USD value of RAY tokens actually bought back by the protocol
ez_metricsbuyback_nativeThe amount of RAY tokens bought back in native token units
ez_metricstreasury_feesFees allocated to the treasury in USD (legacy naming)
ez_metricstreasury_fees_nativeFees allocated to the treasury in native token units (legacy naming)

​
Market and Token Metrics

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

​
Token Supply Metrics

Table NameColumn NameDescription
ez_metricscirculating_supply_nativeThe circulating supply of RAY in native tokens
ez_metricsnet_supply_change_nativeThe net change in the circulating supply of RAY in native tokens
ez_metricsgross_emissions_nativeThe amount of new RAY tokens emitted
ez_metricspremine_unlocks_nativeThe 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,
    fees,
    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,
    fees,
    buyback_fee_allocation,
    treasury_fee_allocation,
    service_fee_allocation
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,
    fees,
    buyback_fee_allocation
FROM
    art_share.raydium.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
    AND chain = 'solana'
ORDER BY
    date ASC