Skip to main content
​
Breaking
  • Human’s manual: Rename six breakdown datasets to <grain>_by_<axis>. Queries on metrics_project_chains read metrics_projects_by_chain, and the same holds for metrics_app_chains, metrics_dex_pool_tokens, metrics_dex_pool_pairs, metrics_perp_market_tokens and metrics_order_book_market_tokens.
  • Metric definitions: Rename the measures to put the noun first, with the window in the noun and qualifiers after it. user_dau reads daily_active_users and source_transfer_volume reads transfer_volume_source, in table and column names alike.
  • Assets metrics: Rename the seven _total measures for market cap, mints, redemptions and transfers to bare names. Queries on a _total_daily table and its _total column read the same name without _total, with values unchanged.
  • Projects registry: Remove the Unichain, opBNB and Immutable zkEVM projects, keeping their chains under Uniswap, BSC and Immutable. Queries on these project ids read metrics_chains with chain_id unichain, opbnb or immutablezkevm.
  • Projects metrics: Remove the unknown and offchain chain ids from metrics_projects_by_chain and metrics_apps_by_chain. Those rows count at project and app grain.
  • Apps registry:
    • Rename the app makerdao-lending to makerdao-issuance, Sky’s stablecoin issuance. Queries filter on app_id = 'makerdao-issuance'.
    • Rename the app lighter-dex to lighter-app, a derivatives app named Lighter. Queries filter on app_id = 'lighter-app'.
  • Financial statements:
    • Restrict the statements to projects that report fees. The 20 projects with only treasury lines read metrics_projects.treasury_daily and treasury_net_daily.
    • Rename the measure columns to the new measure names. user_dau reads daily_active_users and tokenholders reads token_holders.
  • Disclosures: Remove not_launched from issuance_status. A program member the issuer’s list does not name reads null.
New
  • Project screener: Add screeners.projects, each project’s latest value, all-time high and low, and its average, change and trend over six windows from 1 day to 365 days, for 60 measures.
  • Chain screener: Add screeners.chains, the same aggregations for 30 chain measures, the chain’s own and its apps’.
  • Asset screener: Add screeners.assets, screeners.assets_by_chain and screeners.asset_tokens, the same aggregations per asset, per asset on each chain and per asset token.
  • User retention: Add reports_projects.user_retention_monthly, monthly signup cohorts for every project with the share of each cohort active in each of the twelve months from signup.
  • Attested country: Add the country of residence Coinbase attested for a wallet, by address and chain family.
  • Assets registry: Add dimensions.assets_by_chain, every curated asset on each chain it is deployed to.
  • Assets metrics:
    • Add the asset-by-chain grain, metrics_assets_by_chain.
    • Add DeFi TVL and DEX trading volume per asset, per asset and app, and per deployment and app, as app_tvl and app_trading_volume.
    • Add holders across every deployment of an asset.
  • Stablecoins metrics: Add the stablecoin-by-chain grain from metrics_assets_by_chain.
  • Real-world assets metrics: Add the asset-by-chain grain from metrics_assets_by_chain.
  • Projects metrics:
    • Add price-to-fees and price-to-revenue (circulating and fully diluted), take rate, token turnover and staking market cap per project.
    • Add token market data, contract activity and thirteen standardized measures per project, among them trade count, open interest and bridge deposits.
    • Add active addresses, contract transactions, gas used, token holders, treasury and expenses per project and chain.
  • Chains metrics:
    • Add eleven app_* measures for what the apps on a chain do, from app TVL and fees to gas used and monthly active addresses.
    • Add daily, weekly and monthly active addresses, expenses, token incentives, cost of revenue and bridge deposits per chain.
    • Add transactions, transactions per second, block time, fees per transaction, validators, deployments and staked value per chain.
  • Apps metrics:
    • Add the thirteen standardized measures at app grain.
    • Add expenses per app and per app and chain.
    • Add seventeen measures per app and chain, among them token incentives, trade count and outstanding supply.
  • Human’s manual: Add Screeners as a dataset type, screeners.<things> with <measure>_<window>_<aggregation> columns.
Expanded
  • Accounts registry:
    • Extend accounts from labelled addresses to every address the catalog holds, with region and funding for each.
    • Extend accounts with attested_country and attested_at, on every EVM chain of an attested address.
  • Chains registry: Extend chains with logo, market_sectors and primary_market_sector.
  • Apps registry: Extend to issuance apps for Circle, Superstate, Usual, Reflexer, Aave GHO, Curve crvUSD, Dinari USD+, Flying Tulip USD and Hydrated Dollar.
  • Apps metrics: Extend TVL, trading volume, active loans, fees, supply-side fees and revenue per app and chain to every app the Explorer reports.
  • Financial statements: Extend the weekly, monthly, quarterly and yearly statements from 8 to 35 lines.
  • Disclosures: Extend with excluded_jurisdictions, the jurisdictions an asset may not be offered in.
Fixed
​
Breaking
  • DEX registry: Rekey every DEX pool table on app_id and retire the protocols and deployments dimensions. Queries that used the older protocol_id read app_id instead, and those that used deployment_id filter on app_id and chain_id together.
  • Projects registry:
    • Restrict the registry to the projects the Explorer lists. A project not listed there no longer has a row.
    • Remove status_label and archival_strategy. Read primary_market_sector for the lead sector and market_sectors for the full ordered list.
  • Assets registry: Remove product_id from project_relations. Each element is now a project id and a relation.
  • Disclosures: Rekey governing_law, governing_law_subdivision, dispute_resolution_country, regulatory_framework and regulator by jurisdiction, as arrays, and remove the GLOBAL jurisdiction. Unnest the column and filter on jurisdiction.
  • Real-world assets registry: Remove token_permissions_label from the asset tokens table. Join dimensions.asset_token_fields on the permission id for the copy.
New
  • Funding: Add where an account’s funds came from, across 182 venues, from October 2015.
  • Real-world assets registry:
    • Add disclosure fields, each term’s title, definition and value copy, 58 terms in all.
    • Add token fields, the 68 values behind token_standard, token_extensions and token_permissions.
  • Arc: Add a chain section with six layers, from raw blocks to real-world assets.
Expanded
  • Projects registry: Extend with url, logo, primary_market_sector, listing_date, archived_at, archived_reason, coingecko_id and coinmarketcap_id.
  • Accounts registry: Extend accounts with funding_confidence, funding_evidence_edges, funding_first_edge_at, funding_jurisdiction, funding_jurisdiction_name, funding_venue_project_id, funding_venue_source, funding_venue_type, funding_wallet_count and funding_wallets_without_country.
  • DEX trades:
    • Extend to BisonFi, Tessera V and GoonFi on Solana.
    • Extend to Circle StableFX on Arc, with its three USDC corridors to EURC, MXNB and BRLA.
  • Agentic payments: Extend to x402 settlements on XDC and Arc.
  • Disclosures: Extend every term with a <term>_status companion, and key a group affiliate’s licences under its own market with affiliate_entity.
  • Tron:
    • Extend blocks with version and witness_signature.
    • Extend transactions with receipt_info_exchange_id, receipt_info_inject_another_amount and receipt_info_withdraw_another_amount, and internal transactions with extra.
    • Extend wallet blocks with contract_ret, signature, permission_id, fee_limit, expiration, transaction_timestamp, ref_block_bytes, ref_block_hash, contract_address, call_value, call_token_value and token_id.
    • Extend wallet blocks with resource, balance, receiver_address, lock, lock_period, frozen_balance, unfreeze_balance and parameter_value.
Fixed
  • Fact tables: Fix the twelve facts_* tables to serve as materialized tables, same columns, queryable from any subscriber project.
  • Disclosures: Fix subscription_time and redemption_time to settlement duration bands: instant, daily, weekly, monthly, quarterly.
​
Breaking
  • Real-world assets: Move the section to /catalog/real-world-assets and narrow it to tokenized stocks, funds and commodities. Links to the former address redirect.
New
  • Disclosures: Add dimensions.asset_disclosures, a typed column per term with its evidence beside it, for 46 assets.
  • Arc raw: Add blocks, transactions, logs and traces, from the first block.
  • XDC raw: Add traces, from May 2019.
Expanded
  • DEX trades: Extend to PumpSwap and EulerSwap, the latter with 1,248 pools.
  • Real-world assets registry:
    • Extend asset tokens with token_standard, token_extensions, decimals and first_issued_onchain, on 97% of 23,434 deployments.
    • Extend asset tokens with token_permissions, which names what an issuer can do to a holder: pause, freeze, mint or seize.
  • Chains registry: Extend to six Avalanche L1 chains, each with daily active users at project grain: Kite, TuringChain, ValueX, Titan L1, TomatoChain and TixChain.
  • Chain metrics: Extend to Arc fees and activity, attributed to Circle.
  • Polygon raw: Extend transactions with authorization_list, from July 2025.
Fixed
  • Real-world assets registry:
    • Fix token_extensions to name the live compliance module on 1,217 deployments.
    • Fix token_standard coverage to 97% of deployments, from 76%.
  • Ethereum raw: Fix authorization_list.nonce to NUMERIC on Ethereum, Base and BSC, so the full 64-bit range reads exactly.
​
Breaking
  • DEX registry: Remove deployment_id from the DEX pools registry and the pool metrics tables. Where you filtered on the older deployment_id, filter on protocol_id and chain_id together.
  • Tokens registry: Remove asset_id, bridged and the external price-provider id from the tokens registry. bridged continues as bridged_status on the asset tokens table.
  • Interest rates: Rekey unique_id to include the reserve. Every existing id changes, so re-pull rather than diff on the old ones.
  • Markets: Retire dimensions.vaults ahead of the vault vertical. The registry returns with that vertical, its facts and metrics beside it.
  • Ethereum raw: Remove the pre-Merge columns params, author and sealFields from blocks and publicKey, condition, creates and standardV from transactions. A query that named them drops the name.
  • Base raw: Remove the legacy logs.signature column. A query that named it drops the name.
  • HyperEVM raw: Remove total_difficulty, author, signature, step and params from blocks and source_hash from transactions. A query that named them drops the name.
New
  • Asset metrics: Add app_tvl, daily, per asset token by app, per asset by app and per asset.
  • Geographic intelligence: Add a region of activity per account with a confidence tier, on Ethereum, Base, Solana and Robinhood Chain, with Ethereum history from July 2015.
Expanded
  • DEX trades:
    • Extend to 14 more venues, taking the count from 32 to 49.
    • Restore Thena, Etherex and Pharaoh with frozen history.
  • Perp markets: Extend to MUX on five chains, 31 markets, on the same tables as Hyperliquid.
  • Interest rates: Extend to Morpho Blue beside Aave v2, Aave v3, Spark and HyperLend.
  • App metrics: Extend trading volume to 48 apps and 60 projects, up from 43 and 25.
  • Ethereum raw: Extend with authorization_list, y_parity, receipt_root and requests_hash.
  • Base raw: Extend with authorization_list, withdrawals, withdrawals_root, requests_hash, deposit_receipt_version, receipt_deposit_receipt_version, receipt_blob_gas_used, receipt_operator_fee_constant and receipt_operator_fee_scalar.
  • BSC raw: Extend with authorization_list, withdrawals, withdrawals_root, requests_hash and milli_timestamp.
  • Starknet: Extend transactions with receipt_l1_gas, receipt_l1_data_gas, receipt_l2_gas, tip, nonce_data_availability_mode, fee_data_availability_mode, resource_bounds, paymaster_data, account_deployment_data, receipt_messages_sent and receipt_message_hash, and blocks with l1_da_mode and starknet_version.
  • Geographic intelligence: Backfill facts_accounts.activity_hours to each chain’s first block, Ethereum from July 2015.
Fixed
  • Chain metrics: Fix 63 daily tables to exclude the open UTC day and each chain’s period before its availability cutoff.
  • Ethereum raw: Fix withdrawals on pre-Shanghai blocks to an empty array.