Jito

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	fees	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_fee_allocation	Revenue distributed to equity holders (3-5% of tip fees depending on date)
ez_metrics	treasury_fee_allocation	Revenue allocated to the protocol’s treasury (2.7% of tip fees after March 7, 2025)
ez_metrics	strategy_fee_allocation	Revenue distributed to entities managing capital deployment (0.3% of tip fees after March 7, 2025)
ez_metrics	validator_fee_allocation	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

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

👋 Welcome

📜 Data Reference

🌎 Prediction Markets

🔢 Artemis Sheets

🖥️ API

❄️ Snowflake Share

🖼️ Artemis Terminal

🔍 Research

📞 Contact Us

Available Tables

Table Schema

Block Infrastructure Metrics

Liquid Staking Metrics

Fee and Revenue Metrics

Cash Flow Distribution Metrics

Market and Token Metrics

Token Supply Metrics

Sample Queries

Block Infrastructure Analysis

Liquid Staking Performance

Revenue Stream Breakdown

Cash Flow Distribution

Token Economics Analysis

Comprehensive Protocol Growth

Chain-specific Analysis

​Available Tables

​Table Schema

​Block Infrastructure Metrics

​Liquid Staking Metrics

​Fee and Revenue Metrics

​Cash Flow Distribution Metrics

​Market and Token Metrics

​Token Supply Metrics

​Sample Queries

​Block Infrastructure Analysis

​Liquid Staking Performance

​Revenue Stream Breakdown

​Cash Flow Distribution

​Token Economics Analysis

​Comprehensive Protocol Growth

​Chain-specific Analysis

Available Tables

Table Schema

Block Infrastructure Metrics

Liquid Staking Metrics

Fee and Revenue Metrics

Cash Flow Distribution Metrics

Market and Token Metrics

Token Supply Metrics

Sample Queries

Block Infrastructure Analysis

Liquid Staking Performance

Revenue Stream Breakdown

Cash Flow Distribution

Token Economics Analysis

Comprehensive Protocol Growth

Chain-specific Analysis