Chain Metrics
Daily chain-level aggregates including transaction counts, active addresses, gas usage, and contract deployments.
10 tables.
| Table | Chain | Notable |
|---|---|---|
agent.ethereum_chain_daily | Ethereum | |
agent.base_chain_daily | Base | |
agent.arbitrum_chain_daily | Arbitrum | |
agent.tempo_chain_daily | Tempo | Extended schema with stablecoin + fee + bridge metrics (see below) |
Tempo also has more granular activity tables. All are ReplacingMergeTree — use FINAL — except tempo_fee_payments, which doesn't need it.
| Table | What it is |
|---|---|
agent.tempo_daily_chain_stats | Daily block/transaction counts, gas used, unique senders, contract deployments |
agent.tempo_contract_calls_daily | Daily call count, unique callers, and gas per contract (split by call type) |
agent.tempo_contract_deployments | Individual contract deployment events with deployer address |
agent.tempo_fee_metrics_daily | Daily transaction fee metrics — totals, percentiles, sponsorship share, fee token split |
agent.tempo_fee_payments | Individual fee payment events (payer, fee token, USD amount) |
agent.tempo_user_cohorts | Weekly cohort retention — cohort size, active users, retention rate |
What's Included
Daily aggregates in the style of Artemis ez_metrics:
- Transaction count
- Active senders / receivers (HLL approximate, ~2% error)
- Average gas price (Gwei)
- Total native value transferred (ETH, not USD)
- Contract deployments
Good to Know
- Active address counts use HyperLogLog (
uniq()) — approximately 2% error margin, not exact. - Native value transferred is in ETH, not USD — join with prices tables for valuation.
- For L2s (Base, Arbitrum): gas price reflects L2 execution gas only, excludes L1 data posting fees.
- Contract deployments on Base/Arbitrum are typically higher than Ethereum due to lower gas costs.
Tempo Chain Metrics Schema
agent.tempo_chain_daily has an extended schema with stablecoin, bridge, fee, and DEX metrics beyond the standard EVM columns.
| Column | Type | Description |
|---|---|---|
block_date | Date | |
total_blocks | UInt64 | |
total_txs | UInt64 | Total transactions (including system) |
user_txs | UInt64 | User-initiated transactions |
dau | UInt64 | Daily active users |
wau | UInt64 | Weekly active users |
mau | UInt64 | Monthly active users |
new_users | UInt64 | First-time users |
returning_users | UInt64 | |
total_transfers | UInt64 | |
stablecoin_transfer_volume | Float64 | Daily stablecoin volume (USD) |
stablecoin_dau | UInt64 | |
stablecoin_txns | UInt64 | |
bridge_net_flow_usd | Float64 | Net bridge inflow/outflow |
total_fees_usd | Float64 | |
avg_fee_usd | Float64 | |
median_fee_usd | Float64 | |
sponsored_fee_pct | Float64 | % of fees sponsored |
dex_volume_usd | Float64 | |
dex_trade_count | UInt64 | |
contract_deployments_from_traces | UInt64 | |
batched_tx_count | UInt64 | Tempo-specific batched payment transactions |