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 | fees | The total USD value generated by the protocol from all user-paid fees |
| ez_metrics | fees_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