Chain Metrics

​

Tables

​

Sample Queries

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

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

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:

​

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.