Available Tables
BSC data is available in several tables:- ez_metrics: Main aggregated metrics for the BSC network
- ez_metrics_by_category_v2: Metrics broken down by transaction category
- ez_metrics_by_application_v2: Metrics broken down by application
- ez_metrics_by_subcategory: Metrics broken down by subcategory
- ez_metrics_by_contract_v2: Metrics broken down by contract
Table Schema
Network and Usage Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | chain_txns | Daily transactions on the BSC network |
| ez_metrics | chain_dau | Daily unique users on BSC |
| ez_metrics | chain_wau | Weekly unique users on BSC |
| ez_metrics | chain_mau | Monthly unique users on BSC |
| ez_metrics | chain_avg_txn_fee | The average transaction fee on BSC |
| ez_metrics | chain_median_txn_fee | The median transaction fee on BSC |
| ez_metrics | returning_users | The number of returning users on BSC |
| ez_metrics | new_users | The number of new users on BSC |
| ez_metrics | dau_over_100_balance | The number of users with balances over $100 |
| ez_metrics | txns | Legacy naming for chain_txns |
| ez_metrics | dau | Legacy naming for chain_dau |
| ez_metrics | wau | Legacy naming for chain_wau |
| ez_metrics | mau | Legacy naming for chain_mau |
| ez_metrics | avg_txn_fee | Legacy naming for chain_avg_txn_fee |
| ez_metrics | median_txn_fee | Legacy naming for chain_median_txn_fee |
| ez_metrics | dau_over_100 | Legacy naming for dau_over_100_balance |
User Classification Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | sybil_users | The number of sybil users (suspected bots) on BSC |
| ez_metrics | non_sybil_users | The number of non-sybil users on BSC |
| ez_metrics | low_sleep_users | Users with continuous activity (possible bots) |
| ez_metrics | high_sleep_users | Users with normal activity patterns (likely humans) |
Fee and Revenue Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | chain_fees | The total transaction fees paid on BSC (in USD) |
| ez_metrics | fees | Total revenue generated from transaction fees (USD) |
| ez_metrics | fees_native | Total revenue from transaction fees in BNB |
| ez_metrics | burned_fee_allocation | USD value of BNB burned (10% of transaction fees) |
| ez_metrics | burned_fee_allocation_native | Amount of native BNB burned (10% of fees) |
| ez_metrics | fees | Legacy naming for chain_fees |
| ez_metrics | fees_native | Transaction fees in native BNB tokens |
| ez_metrics | revenue | Legacy naming for burned_fee_allocation |
| ez_metrics | revenue_native | Legacy naming for burned_fee_allocation_native |
Volume and Trading Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | chain_spot_volume | Total spot DEX volume on BSC |
| ez_metrics | chain_nft_trading_volume | The total volume of NFT trading on BSC |
| ez_metrics | dex_volumes | Legacy naming for chain_spot_volume |
| ez_metrics | nft_trading_volume | Legacy naming for chain_nft_trading_volume |
Stablecoin Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | stablecoin_total_supply | The total supply of stablecoins on BSC |
| ez_metrics | stablecoin_txns | The number of stablecoin transactions |
| ez_metrics | stablecoin_dau | Daily active users of stablecoins |
| ez_metrics | stablecoin_mau | Monthly active users of stablecoins |
| ez_metrics | stablecoin_transfer_volume | The total volume of stablecoin transfers |
| ez_metrics | stablecoin_tokenholder_count | The number of unique stablecoin tokenholders |
Developer Activity Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | weekly_contracts_deployed | The number of new contracts deployed on BSC |
| ez_metrics | weekly_contract_deployers | The number of addresses deploying contracts |
| ez_metrics | weekly_commits_core_ecosystem | Commits to the BSC core ecosystem repositories |
| ez_metrics | weekly_commits_sub_ecosystem | Commits to BSC sub-ecosystem repositories |
| ez_metrics | weekly_developers_core_ecosystem | Developers contributing to core repositories |
| ez_metrics | weekly_developers_sub_ecosystem | Developers contributing to sub-ecosystem repositories |
Market and Token Metrics
| Table Name | Column Name | Description |
|---|---|---|
| ez_metrics | price | The price of BNB token in USD |
| ez_metrics | market_cap | The market cap of BNB token in USD |
| ez_metrics | fdmc | The fully diluted market cap of BNB token in USD |
| ez_metrics | tvl | The total value locked in BSC protocols |
Sample Queries
Basic Network Activity Query
-- Pull fundamental network activity data for BSC
SELECT
date,
chain_txns,
chain_dau,
chain_fees,
chain_avg_txn_fee,
chain_median_txn_fee,
price
FROM
art_share.bsc.ez_metrics
WHERE
date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
date ASC
Fee and Revenue Analysis
-- Analyze BSC fee and revenue metrics
SELECT
date,
chain_fees,
fees,
burned_fee_allocation,
burned_fee_allocation / fees * 100 as burn_percentage,
chain_txns,
chain_fees / chain_txns as fee_per_transaction,
burned_fee_allocation / chain_txns as burn_per_transaction
FROM
art_share.bsc.ez_metrics
WHERE
date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
date ASC
User Growth Analysis
-- Analyze user growth and retention on BSC
SELECT
date,
chain_dau,
new_users,
returning_users,
new_users / NULLIF(chain_dau, 0) * 100 as new_user_percentage,
returning_users / NULLIF(chain_dau, 0) * 100 as returning_user_percentage,
LAG(chain_dau, 7) OVER (ORDER BY date) as dau_week_ago,
chain_dau / NULLIF(dau_week_ago, 0) - 1 as weekly_dau_growth
FROM
art_share.bsc.ez_metrics
WHERE
date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
date ASC
User Classification Analysis
-- Analyze different user types on BSC
SELECT
date,
chain_dau,
sybil_users,
non_sybil_users,
low_sleep_users,
high_sleep_users,
dau_over_100_balance,
non_sybil_users / NULLIF(chain_dau, 0) * 100 as non_sybil_percentage,
high_sleep_users / NULLIF(chain_dau, 0) * 100 as high_sleep_percentage,
dau_over_100_balance / NULLIF(chain_dau, 0) * 100 as wealthy_user_percentage
FROM
art_share.bsc.ez_metrics
WHERE
date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
date ASC
Trading Volume Analysis
-- Analyze trading volumes on BSC
SELECT
date,
chain_spot_volume,
chain_nft_trading_volume,
chain_spot_volume / NULLIF(chain_nft_trading_volume, 0) as dex_to_nft_ratio,
LAG(chain_spot_volume, 7) OVER (ORDER BY date) as dex_volume_week_ago,
chain_spot_volume / NULLIF(dex_volume_week_ago, 0) - 1 as weekly_dex_volume_growth,
tvl,
chain_spot_volume / NULLIF(tvl, 0) as capital_efficiency_ratio
FROM
art_share.bsc.ez_metrics
WHERE
date >= DATEADD(month, -1, CURRENT_DATE())
ORDER BY
date ASC
Stablecoin Analysis
-- Track stablecoin usage on BSC
SELECT
date,
stablecoin_total_supply,
stablecoin_dau,
stablecoin_transfer_volume,
stablecoin_transfer_volume / NULLIF(chain_spot_volume, 0) * 100 as stablecoin_to_dex_ratio
FROM
art_share.bsc.ez_metrics
WHERE
date >= DATEADD(month, -2, CURRENT_DATE())
ORDER BY
date ASC
Developer Activity Monitoring
-- Track developer activity on BSC
SELECT
date,
weekly_contracts_deployed,
weekly_contract_deployers,
weekly_commits_core_ecosystem,
weekly_commits_sub_ecosystem,
weekly_developers_core_ecosystem,
weekly_developers_sub_ecosystem,
weekly_contracts_deployed / NULLIF(weekly_contract_deployers, 0) as avg_contracts_per_deployer,
weekly_commits_core_ecosystem / NULLIF(weekly_developers_core_ecosystem, 0) as avg_commits_per_core_dev
FROM
art_share.bsc.ez_metrics
WHERE
date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
date ASC
BSC vs Token Price Analysis
-- Analyze relationship between BSC usage and BNB price
SELECT
date,
chain_dau,
chain_txns,
price,
market_cap,
tvl,
market_cap / NULLIF(tvl, 0) as mcap_to_tvl_ratio,
price / NULLIF(LAG(price, 30) OVER (ORDER BY date), 0) - 1 as monthly_price_change,
chain_dau / NULLIF(LAG(chain_dau, 30) OVER (ORDER BY date), 0) - 1 as monthly_dau_change
FROM
art_share.bsc.ez_metrics
WHERE
date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY
date ASC
Fee Efficiency Analysis
-- Analyze fee efficiency on BSC
SELECT
date,
chain_txns,
chain_fees,
chain_dau,
tvl,
chain_fees / NULLIF(chain_txns, 0) as fees_per_transaction,
chain_fees / NULLIF(chain_dau, 0) as fees_per_user,
chain_fees / NULLIF(tvl, 0) * 365 * 100 as annualized_fee_yield,
burned_fee_allocation / NULLIF(market_cap, 0) * 365 * 100 as annualized_burn_rate
FROM
art_share.bsc.ez_metrics
WHERE
date >= DATEADD(month, -3, CURRENT_DATE())
ORDER BY
date ASC
Application-specific Analysis
-- Analyze metrics for specific applications on BSC
SELECT
date,
app,
friendly_name,
category,
txns,
dau,
returning_users,
new_users
FROM
art_share.bsc.ez_metrics_by_application_v2
WHERE
date >= DATEADD(month, -2, CURRENT_DATE())
AND app IN ('pancakeswap', 'venus', 'biswap')
ORDER BY
app, date ASC
Monthly Performance Dashboard
-- Create a monthly performance dashboard for BSC
SELECT
DATE_TRUNC('month', date) as month,
AVG(chain_dau) as avg_daily_users,
SUM(chain_txns) as total_transactions,
SUM(chain_fees) as total_fees,
SUM(burned_fee_allocation) as total_burned,
AVG(chain_avg_txn_fee) as avg_transaction_fee,
AVG(tvl) as avg_tvl,
AVG(price) as avg_token_price,
LAST_VALUE(market_cap) OVER (PARTITION BY DATE_TRUNC('month', date) ORDER BY date) as end_of_month_market_cap,
LAST_VALUE(stablecoin_total_supply) OVER (PARTITION BY DATE_TRUNC('month', date) ORDER BY date) as end_of_month_stablecoin_supply
FROM
art_share.bsc.ez_metrics
WHERE
date >= DATEADD(year, -1, CURRENT_DATE())
GROUP BY
DATE_TRUNC('month', date)
ORDER BY
month ASC