This schema contains comprehensive on-chain datasets for tracking Jito fundamental data across multiple metrics categories, including block infrastructure, liquid staking, fee distribution, token economics, and market data.

​
Available Tables

Jito data is available in two main tables:
  • ez_metrics: Aggregated metrics for the entire Jito protocol with detailed token supply and revenue data
  • ez_metrics_by_chain: Contains key metrics broken down by blockchain (currently Solana)

​
Table Schema

​
Block Infrastructure Metrics

Table NameColumn NameDescription
ez_metricsblock_infra_txnsThe number of transactions on Jito’s block infrastructure (total tips processed daily)
ez_metricsblock_infra_dauThe number of daily active tippers leveraging Jito’s block infrastructure
ez_metricsblock_infra_feesFees generated from Jito’s block infrastructure (tips)
ez_metricstxnsTotal transactions (legacy naming, same as block_infra_txns)
ez_metricsdauDaily active users (legacy naming, same as block_infra_dau)
ez_metricstip_txnsTransactions related to tips (legacy naming)
ez_metricstip_dauDaily active users for tipping (legacy naming)
ez_metricstip_feesFees from tips (legacy naming)

​
Liquid Staking Metrics

Table NameColumn NameDescription
ez_metricstvlThe total value locked in Jito liquid staking
ez_metricstvl_net_changeThe net change in the total value locked in Jito liquid staking
ez_metricslst_feesFees generated from Jito’s liquid staking service
ez_metricsamount_staked_usdValue staked in USD (legacy naming, same as tvl)
ez_metricsamount_staked_usd_net_changeNet change in staked value (legacy naming, same as tvl_net_change)
ez_metricswithdraw_management_feesFees from withdrawal management (legacy naming, same as lst_fees)

​
Fee and Revenue Metrics

Table NameColumn NameDescription
ez_metricsfeesThe total USD value generated by Jito from all user-paid fees
ez_metricsfeesTotal fees collected (legacy naming, sum of tip_fees and lst_fees)
ez_metricsrevenueTotal revenue (legacy naming)
ez_metricssupply_side_feesFees distributed to supply-side participants (legacy naming)
ez_metricstip_revenueRevenue from tips (legacy naming)

​
Cash Flow Distribution Metrics

Table NameColumn NameDescription
ez_metricsequity_fee_allocationRevenue distributed to equity holders (3-5% of tip fees depending on date)
ez_metricstreasury_fee_allocationRevenue allocated to the protocol’s treasury (2.7% of tip fees after March 7, 2025)
ez_metricsstrategy_fee_allocationRevenue distributed to entities managing capital deployment (0.3% of tip fees after March 7, 2025)
ez_metricsvalidator_fee_allocationPortion of revenue allocated to validators (94-95% of tip fees depending on date)

​
Market and Token Metrics

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

​
Token Supply Metrics

Table NameColumn NameDescription
ez_metricscirculating_supply_nativeThe circulating supply of JTO in native tokens
ez_metricsnet_supply_change_nativeThe net change in the circulating supply of JTO in native tokens
ez_metricsemissions_nativeThe amount of new JTO tokens emitted
ez_metricspremine_unlocks_nativeThe amount of native tokens unlocked from premine
ez_metricsburns_nativeThe amount of JTO tokens burned

​
Sample Queries

​
Block Infrastructure Analysis

-- Analyze Jito's block infrastructure usage
SELECT
    date,
    block_infra_txns,
    block_infra_dau,
    block_infra_fees
FROM
    art_share.jito.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Liquid Staking Performance

-- Track Jito's liquid staking performance
SELECT
    date,
    tvl,
    tvl_net_change,
    lst_fees
FROM
    art_share.jito.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Revenue Stream Breakdown

-- Analyze Jito's revenue sources
SELECT
    date,
    fees,
    block_infra_fees,
    lst_fees
FROM
    art_share.jito.ez_metrics
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
    date ASC

​
Cash Flow Distribution

-- Track how Jito revenue is distributed
SELECT
    date,
    fees,
    equity_fee_allocation,
    treasury_fee_allocation,
    strategy_fee_allocation,
    validator_fee_allocation
FROM
    art_share.jito.ez_metrics
WHERE
    date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
    date ASC

​
Token Economics Analysis

-- Track JTO token supply changes
SELECT
    date,
    price,
    circulating_supply_native,
    net_supply_change_native,
    emissions_native,
    premine_unlocks_native,
    burns_native
FROM
    art_share.jito.ez_metrics
WHERE
    date >= '2023-06-01'
ORDER BY
    date ASC

​
Comprehensive Protocol Growth

-- Track comprehensive Jito growth metrics
SELECT
    date,
    block_infra_txns,
    block_infra_dau,
    tvl,
    fees,
    price,
    market_cap
FROM
    art_share.jito.ez_metrics
WHERE
    date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
    date ASC

​
Chain-specific Analysis

-- Analyze Jito metrics on Solana
SELECT
    date,
    chain,
    block_infra_txns,
    block_infra_dau,
    tvl,
    fees,
    validator_fee_allocation
FROM
    art_share.jito.ez_metrics_by_chain
WHERE
    date >= DATEADD(month, -3, CURRENT_DATE())
    AND chain = 'solana'
ORDER BY
    date ASC