📊Chain Metrics

Precomputed metrics to analyze and compare onchain activity across chains

Tables

There are two ways to query for chain metrics:

  1. using crosschain.metrics.overview, which makes it easy to compare metrics across chains (if included)

  2. using <chain>.metrics.overview, which makes it easy to view relevant metrics for your desired chain

Table Name DescriptionChain Coverage

crosschain.metrics.overview

Daily metrics, grouped by chain, covering onchain activity such as transactions, users, fees, tokens transfers, DEXes, NFTs, stablecoins and more. Metrics are not available for all chains. The column values will be null if not available for the given chain.

  • arbitrum

  • avalanche

  • base

  • bitcoin

  • bsc

  • ethereum

  • optimism

  • polygon

  • polygon_zkevm

  • scroll

  • solana

<chain>.metrics.overview

Daily metrics for a single chain. Only includes metrics that are available.

  • All chains above

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

Column NameDescription

chain

The name of the blockchain

activity_date

The date for which metrics are being calculated. Only includes completed days.

avg_block_time

The average time between blocks

avg_transactions_per_second

The average number of transactions per second, calculated as the average number of transactions per block divided by the average block time (in seconds)

active_addresses

The number of distinct wallet addresses that have initiated successful transactions

new_addresses

The number of distinct wallet addresses that have initiated their first successful transactions

returning_addresses

The number of distinct wallet addresses, that are not new, that have initiated successful transactions

newly_funded_addresses

The number of distinct wallet addresses that have been funded for the first time with either native tokens or ERC20 tokens

total_transactions

The total number of transactions, including both successful and failed transactions

success_transactions

The total number of successful transactions only

failed_transactions

The total number of failed transactions only

active_contracts

The total number of distinct smart contracts that have been interacted with

new_deployed_contracts

The total number of new smart contracts deployed

total_contract_calls

The total number of contract calls

tvl_usd

The total value locked in DeFi protocols in USD terms, sourced from DefiLlama

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 programs, 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 becomes more complete or is updated

Last updated