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 Name | Column Name | Description |
|---|
| ez_metrics | block_infra_txns | The number of transactions on Jito’s block infrastructure (total tips processed daily) |
| ez_metrics | block_infra_dau | The number of daily active tippers leveraging Jito’s block infrastructure |
| ez_metrics | block_infra_fees | Fees generated from Jito’s block infrastructure (tips) |
| ez_metrics | txns | Total transactions (legacy naming, same as block_infra_txns) |
| ez_metrics | dau | Daily active users (legacy naming, same as block_infra_dau) |
| ez_metrics | tip_txns | Transactions related to tips (legacy naming) |
| ez_metrics | tip_dau | Daily active users for tipping (legacy naming) |
| ez_metrics | tip_fees | Fees from tips (legacy naming) |
Liquid Staking Metrics
| Table Name | Column Name | Description |
|---|
| ez_metrics | tvl | The total value locked in Jito liquid staking |
| ez_metrics | tvl_net_change | The net change in the total value locked in Jito liquid staking |
| ez_metrics | lst_fees | Fees generated from Jito’s liquid staking service |
| ez_metrics | amount_staked_usd | Value staked in USD (legacy naming, same as tvl) |
| ez_metrics | amount_staked_usd_net_change | Net change in staked value (legacy naming, same as tvl_net_change) |
| ez_metrics | withdraw_management_fees | Fees from withdrawal management (legacy naming, same as lst_fees) |
Fee and Revenue Metrics
| Table Name | Column Name | Description |
|---|
| ez_metrics | ecosystem_revenue | The total USD value generated by Jito from all user-paid fees |
| ez_metrics | fees | Total fees collected (legacy naming, sum of tip_fees and lst_fees) |
| ez_metrics | revenue | Total revenue (legacy naming) |
| ez_metrics | supply_side_fees | Fees distributed to supply-side participants (legacy naming) |
| ez_metrics | tip_revenue | Revenue from tips (legacy naming) |
Cash Flow Distribution Metrics
| Table Name | Column Name | Description |
|---|
| ez_metrics | equity_cash_flow | Revenue distributed to equity holders (3-5% of tip fees depending on date) |
| ez_metrics | treasury_cash_flow | Revenue allocated to the protocol’s treasury (2.7% of tip fees after March 7, 2025) |
| ez_metrics | strategy_cash_flow | Revenue distributed to entities managing capital deployment (0.3% of tip fees after March 7, 2025) |
| ez_metrics | validator_cash_flow | Portion of revenue allocated to validators (94-95% of tip fees depending on date) |
Market and Token Metrics
| Table Name | Column Name | Description |
|---|
| ez_metrics | price | The price of JTO in USD |
| ez_metrics | market_cap | The market cap of JTO token in USD |
| ez_metrics | fdmc | The fully diluted market cap of JTO token in USD |
| ez_metrics | token_volume | The trading volume of JTO token in USD |
| ez_metrics | token_turnover_circulating | The turnover of JTO based on circulating supply |
| ez_metrics | token_turnover_fdv | The turnover of JTO based on fully diluted valuation |
Token Supply Metrics
| Table Name | Column Name | Description |
|---|
| ez_metrics | circulating_supply_native | The circulating supply of JTO in native tokens |
| ez_metrics | net_supply_change_native | The net change in the circulating supply of JTO in native tokens |
| ez_metrics | emissions_native | The amount of new JTO tokens emitted |
| ez_metrics | premine_unlocks_native | The amount of native tokens unlocked from premine |
| ez_metrics | burns_native | The 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
-- 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,
ecosystem_revenue,
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,
ecosystem_revenue,
equity_cash_flow,
treasury_cash_flow,
strategy_cash_flow,
validator_cash_flow
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,
ecosystem_revenue,
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,
ecosystem_revenue,
validator_cash_flow
FROM
art_share.jito.ez_metrics_by_chain
WHERE
date >= DATEADD(month, -3, CURRENT_DATE())
AND chain = 'solana'
ORDER BY
date ASC
