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 NameColumn NameDescription
ez_metricschain_dauDaily unique users on the Bitcoin network
ez_metricschain_wauWeekly unique users on the Bitcoin network
ez_metricschain_mauMonthly unique users on the Bitcoin network
ez_metricschain_txnsDaily transactions on the Bitcoin network
ez_metricsdauSame as chain_dau (legacy naming)
ez_metricswauWeekly active users (legacy naming)
ez_metricsmauMonthly active users (legacy naming)
ez_metricstxnsSame as chain_txns (legacy naming)

​
Fee and Revenue Metrics

Table NameColumn NameDescription
ez_metricschain_feesThe total transaction fees paid on the Bitcoin network
ez_metricschain_avg_txn_feeThe average transaction fee on the Bitcoin network
ez_metricsfeesSame as chain_fees (legacy naming)
ez_metricsfees_nativeTransaction fees in native BTC (legacy naming)
ez_metricsavg_txn_feeSame as chain_avg_txn_fee (legacy naming)
ez_metricsfeesThe total USD value generated by the protocol from all user-paid fees
ez_metricsfees_nativeThe total native BTC value generated by the protocol from all user-paid fees
ez_metricsrevenueTotal revenue (legacy naming)

​
Market and Supply Metrics

Table NameColumn NameDescription
ez_metricspriceThe price of Bitcoin in USD
ez_metricsmarket_capThe market cap of Bitcoin in USD
ez_metricsfdmcThe fully diluted market cap of Bitcoin in USD
ez_metricstvlThe total value locked in Bitcoin protocols
ez_metricsgross_emissionsThe amount of block rewards in USD value
ez_metricsgross_emissions_nativeThe amount of block rewards in native BTC
ez_metricscirculating_supply_nativeThe circulating supply of Bitcoin in native tokens
ez_metricsissuanceBitcoin issuance in BTC (legacy naming)
ez_metricscirculating_supplyBitcoin circulating supply (legacy naming)

​
Trading and DeFi Metrics

Table NameColumn NameDescription
ez_metricschain_nft_trading_volumeThe total volume of NFT trading on Bitcoin
ez_metricschain_spot_volumeTotal spot DEX volume on Bitcoin
ez_metricsnft_trading_volumeSame as chain_nft_trading_volume (legacy naming)
ez_metricsdex_volumesSame as chain_spot_volume (legacy naming)

​
ETF Metrics

Table NameColumn NameDescription
ez_metricsnet_etf_flowThe net flow of Bitcoin ETFs in USD
ez_metricsnet_etf_flow_nativeThe net flow of Bitcoin ETFs in native BTC
ez_metricscumulative_etf_flowThe cumulative flow of Bitcoin ETFs in USD
ez_metricscumulative_etf_flow_nativeThe cumulative flow of Bitcoin ETFs in native BTC

​
Developer Activity Metrics

Table NameColumn NameDescription
ez_metricsweekly_commits_core_ecosystemThe number of commits to the Bitcoin core ecosystem
ez_metricsweekly_commits_sub_ecosystemThe number of commits to the Bitcoin sub-ecosystem
ez_metricsweekly_developers_core_ecosystemThe number of developers who have made commits to the Bitcoin core ecosystem
ez_metricsweekly_developers_sub_ecosystemThe 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