This schema contains comprehensive on-chain datasets for tracking Bitcoin fundamental data across multiple metrics categories, including network activity, fees, market data, developer activity, and ETF flows.
Available Tables
Bitcoin data is available in the main metrics table:
- ez_metrics: Aggregated metrics for the Bitcoin network and ecosystem
Table Schema
Network and Usage Metrics
| Table Name | Column Name | Description |
|---|
| ez_metrics | chain_dau | Daily unique users on the Bitcoin network |
| ez_metrics | chain_wau | Weekly unique users on the Bitcoin network |
| ez_metrics | chain_mau | Monthly unique users on the Bitcoin network |
| ez_metrics | chain_txns | Daily transactions on the Bitcoin network |
| ez_metrics | dau | Same as chain_dau (legacy naming) |
| ez_metrics | wau | Weekly active users (legacy naming) |
| ez_metrics | mau | Monthly active users (legacy naming) |
| ez_metrics | txns | Same as chain_txns (legacy naming) |
Fee and Revenue Metrics
| Table Name | Column Name | Description |
|---|
| ez_metrics | chain_fees | The total transaction fees paid on the Bitcoin network |
| ez_metrics | chain_avg_txn_fee | The average transaction fee on the Bitcoin network |
| ez_metrics | fees | Same as chain_fees (legacy naming) |
| ez_metrics | fees_native | Transaction fees in native BTC (legacy naming) |
| ez_metrics | avg_txn_fee | Same as chain_avg_txn_fee (legacy naming) |
| ez_metrics | ecosystem_revenue | The total USD value generated by the protocol from all user-paid fees |
| ez_metrics | ecosystem_revenue_native | The total native BTC value generated by the protocol from all user-paid fees |
| ez_metrics | revenue | Total revenue (legacy naming) |
Market and Supply Metrics
| Table Name | Column Name | Description |
|---|
| ez_metrics | price | The price of Bitcoin in USD |
| ez_metrics | market_cap | The market cap of Bitcoin in USD |
| ez_metrics | fdmc | The fully diluted market cap of Bitcoin in USD |
| ez_metrics | tvl | The total value locked in Bitcoin protocols |
| ez_metrics | gross_emissions | The amount of block rewards in USD value |
| ez_metrics | gross_emissions_native | The amount of block rewards in native BTC |
| ez_metrics | circulating_supply_native | The circulating supply of Bitcoin in native tokens |
| ez_metrics | issuance | Bitcoin issuance in BTC (legacy naming) |
| ez_metrics | circulating_supply | Bitcoin circulating supply (legacy naming) |
Trading and DeFi Metrics
| Table Name | Column Name | Description |
|---|
| ez_metrics | chain_nft_trading_volume | The total volume of NFT trading on Bitcoin |
| ez_metrics | chain_spot_volume | Total spot DEX volume on Bitcoin |
| ez_metrics | nft_trading_volume | Same as chain_nft_trading_volume (legacy naming) |
| ez_metrics | dex_volumes | Same as chain_spot_volume (legacy naming) |
ETF Metrics
| Table Name | Column Name | Description |
|---|
| ez_metrics | net_etf_flow | The net flow of Bitcoin ETFs in USD |
| ez_metrics | net_etf_flow_native | The net flow of Bitcoin ETFs in native BTC |
| ez_metrics | cumulative_etf_flow | The cumulative flow of Bitcoin ETFs in USD |
| ez_metrics | cumulative_etf_flow_native | The cumulative flow of Bitcoin ETFs in native BTC |
Developer Activity Metrics
| Table Name | Column Name | Description |
|---|
| ez_metrics | weekly_commits_core_ecosystem | The number of commits to the Bitcoin core ecosystem |
| ez_metrics | weekly_commits_sub_ecosystem | The number of commits to the Bitcoin sub-ecosystem |
| ez_metrics | weekly_developers_core_ecosystem | The number of developers who have made commits to the Bitcoin core ecosystem |
| ez_metrics | weekly_developers_sub_ecosystem | The number of developers who have made commits to the Bitcoin sub-ecosystem |
Sample Queries
Basic Network Activity Query
-- Pull fundamental network activity data for Bitcoin
SELECT
date,
chain_txns,
chain_dau,
chain_fees,
chain_avg_txn_fee,
price
FROM
art_share.bitcoin.ez_metrics
WHERE
date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
date ASC
Supply and Emissions Analysis
-- Analyze Bitcoin supply and block rewards
SELECT
date,
circulating_supply_native,
gross_emissions_native,
gross_emissions,
price
FROM
art_share.bitcoin.ez_metrics
WHERE
date >= DATEADD(year, -1, CURRENT_DATE())
ORDER BY
date ASC
ETF Flow Tracking
-- Track Bitcoin ETF flows
SELECT
date,
net_etf_flow,
net_etf_flow_native,
cumulative_etf_flow,
cumulative_etf_flow_native,
price
FROM
art_share.bitcoin.ez_metrics
WHERE
date >= '2023-01-01'
ORDER BY
date ASC
Developer Activity Monitoring
-- Monitor Bitcoin ecosystem development activity
SELECT
date,
weekly_developers_core_ecosystem,
weekly_developers_sub_ecosystem,
weekly_commits_core_ecosystem,
weekly_commits_sub_ecosystem
FROM
art_share.bitcoin.ez_metrics
WHERE
date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
date ASC
Comprehensive Market Metrics
-- Track comprehensive Bitcoin market metrics
SELECT
date,
price,
market_cap,
fdmc,
tvl,
chain_spot_volume,
chain_nft_trading_volume
FROM
art_share.bitcoin.ez_metrics
WHERE
date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
date ASC
