Chain Metrics

​

Tables

​

Sample Queries

1) Get historical metrics for all available chains

select * from crosschain.metrics.overview order by activity_date desc

2) Get metrics from the last 90 days for Ethereum

select
    *
from crosschain.metrics.overview
where 1=1
    and chain = 'ethereum'
    and activity_date >= current_date - interval '90 days'
order by activity_date desc

3) Get total transaction fees / chain revenue for Base

select
    activity_date,
    transaction_fees, -- in native token, i.e. ETH
    transaction_fees_usd -- in USD
from base.metrics.overview

​

Table Columns

​

Notes

• Fee Metrics

  • average transfer fee metrics are based on simple transaction types with single, direct transfers between two wallet addresses, e.g.

    • for EVM chains, native token transfers where the input is 0x and ERCX token transfers where the transfer functions are called directly by the transacting user

    • for Solana, we exclude transfers initiated via program and instead limit to transactions with only 1 transfer initiated by the address sending the token (i.e. signer = from_address)

  • average_transaction_fees and average_transaction_fees_usd exclude system transactions or other 0 fee transactions, as they would skew metrics downwards

• Token Transfer Metrics

  • user_initiated metrics exclude transactions initiated by contracts

  • For EVM, native_token_transfer_count accounts for all native token transfers including gas/fee payments, but native_token_value_transfer_count excludes those, limiting it to transfers between EOAs/contracts. Similarly, on Solana, native_token_value_transfer_count excludes SOL transfers for rent which is needed for the creation or closure of token accounts

  • currently, there are only volume metrics for usd stablecoins, as we don’t currently have prices/exchange rate conversions for non-USD currencies

• Solana Nuances

  • The SPL token standard can be flexibly used for both fungible and non-fungible tokens (NFTs). We identify NFTs by their mint address.

• Other

  • USD metrics (e.g. erc20_transfer_volume_usd , dex_volume_usd , nft_volume_usd) are subject to changes as our token/DEX/NFT coverage & price data become more complete or are updated

​

How It Works:

We regularly process vast amounts of blockchain data, computing essential metrics like daily active addresses, transaction volumes, and gas usage.

These metrics are stored in easily accessible tables, allowing you to retrieve them with a single line of query.

​

Use Cases:

• Generate time-series data for visualizations without the need to write custom code.

• Effortlessly compare metrics across different periods and blockchains.

• Easily integrate blockchain metrics into your applications or dashboards.