Skip to main content
Important: The schemas listed below are deprecated and will be removed by December 18, 2025. Please migrate to the recommended alternatives as soon as possible.

​
Overview

Allium is deprecating legacy asset schemas across all major chains to simplify and standardize asset data tables. The new schema family introduces consistent naming conventions across blockchains. Starting December 18, 2025, the legacy schemas listed below will be deprecated and removed from allium catalog and respective shares. Please migrate to the new standardized schemas before this date.

​
Summary

ChainLegacy PrefixNew Schema Family
ethereumeth_, eth_and_erc20_, eth_erc20_*native_, fungible_
arbitrumeth_, eth_erc20_native_, fungible_
baseeth_, eth_erc20_native_, fungible_
modeeth_, eth_erc20_native_, fungible_
optimismeth_, eth_erc20_native_, fungible_
polygonmatic_, matic_and_erc20_, pol_*native_, fungible_
polygon_zkevmeth_, eth_erc20_native_, fungible_
scrolleth_, eth_erc20_native_, fungible_
zoraeth_, eth_erc20_native_, fungible_
avalancheavax_, avax_erc20_native_, fungible_
bscbnb_, bnb_erc20_native_, fungible_
common.pricestoken_prices_hourly_easycommon.prices.hourly
ethereum.prices, arbitrum.prices, base.prices, polygon.pricesdex_token_prices_hourly.dex.token_prices_hourly

​
Table Mappings

Legacy TableNew Table
arbitrum.assets.eth_balances_latestarbitrum.assets.native_balances_latest
arbitrum.assets.eth_balancesarbitrum.assets.native_balances
arbitrum.assets.eth_credit_debitarbitrum.assets.native_credit_debit
arbitrum.assets.eth_token_transfersarbitrum.assets.native_token_transfers
arbitrum.assets.eth_erc20_balances_latestarbitrum.assets.fungible_balances_latest
arbitrum.assets.eth_erc20_balancesarbitrum.assets.fungible_balances
arbitrum.assets.eth_erc20_token_transfersarbitrum.assets.fungible_token_transfers
arbitrum.assets.unhydrated_fungible_balancesarbitrum.assets.fungible_balances
Legacy TableNew Table
avalanche.assets.avax_balancesavalanche.assets.native_balances
avalanche.assets.avax_token_transfersavalanche.assets.native_token_transfers
avalanche.assets.avax_erc20_balancesavalanche.assets.fungible_balances
avalanche.assets.avax_erc20_token_transfersavalanche.assets.fungible_token_transfers
avalanche.assets.unhydrated_fungible_balancesavalanche.assets.fungible_balances
Legacy TableNew Table
base.assets.eth_balances_latestbase.assets.native_balances_latest
base.assets.eth_balancesbase.assets.native_balances
base.assets.eth_credit_debitbase.assets.native_credit_debit
base.assets.eth_token_transfersbase.assets.native_token_transfers
base.assets.eth_erc20_balances_latestbase.assets.fungible_balances_latest
base.assets.eth_erc20_balancesbase.assets.fungible_balances
base.assets.eth_erc20_token_transfersbase.assets.fungible_token_transfers
base.assets.unhydrated_fungible_balancesbase.assets.fungible_balances
Legacy TableNew Table
bsc.assets.bnb_balancesbsc.assets.native_balances
bsc.assets.bnb_credit_debitbsc.assets.native_credit_debit
bsc.assets.bnb_token_transfersbsc.assets.native_token_transfers
bsc.assets.bnb_erc20_balancesbsc.assets.fungible_balances
bsc.assets.bnb_erc20_token_transfersbsc.assets.fungible_token_transfers
Legacy TableNew Table
ethereum.assets.eth_balances_latestethereum.assets.native_balances_latest
ethereum.assets.eth_balancesethereum.assets.native_balances
ethereum.assets.eth_credit_debitethereum.assets.native_credit_debit
ethereum.assets.eth_token_transfersethereum.assets.native_token_transfers
ethereum.assets.eth_and_erc20_balances_latest, ethereum.assets.eth_erc20_balances_latestethereum.assets.fungible_balances_latest
ethereum.assets.eth_and_erc20_balances, ethereum.assets.eth_erc20_balancesethereum.assets.fungible_balances
ethereum.assets.eth_and_erc20_token_transfersethereum.assets.fungible_token_transfers
ethereum.assets.unhydrated_fungible_balancesethereum.assets.fungible_balances
Legacy TableNew Table
mode.assets.eth_token_transfersmode.assets.native_token_transfers
mode.assets.eth_erc20_token_transfersmode.assets.fungible_token_transfers
Legacy TableNew Table
optimism.assets.eth_balancesoptimism.assets.native_balances
optimism.assets.eth_credit_debitoptimism.assets.native_credit_debit
optimism.assets.eth_token_transfersoptimism.assets.native_token_transfers
optimism.assets.eth_erc20_balancesoptimism.assets.fungible_balances
optimism.assets.eth_erc20_token_transfersoptimism.assets.fungible_token_transfers
optimism.assets.unhydrated_fungible_balancesoptimism.assets.fungible_balances
Legacy TableNew Table
polygon.assets.matic_balances_latestpolygon.assets.native_balances_latest
polygon.assets.matic_balancespolygon.assets.native_balances
polygon.assets.matic_credit_debitpolygon.assets.native_credit_debit
polygon.assets.matic_token_transferspolygon.assets.native_token_transfers
polygon.assets.pol_balances_latestpolygon.assets.native_balances_latest
polygon.assets.pol_balancespolygon.assets.native_balances
polygon.assets.pol_credit_debitpolygon.assets.native_credit_debit
polygon.assets.pol_token_transferspolygon.assets.native_token_transfers
polygon.assets.matic_and_erc20_balances_latestpolygon.assets.fungible_balances_latest
polygon.assets.matic_and_erc20_balancespolygon.assets.fungible_balances
polygon.assets.matic_and_erc20_token_transferspolygon.assets.fungible_token_transfers
polygon.assets.unhydrated_fungible_balancespolygon.assets.fungible_balances
Legacy TableNew Table
polygon_zkevm.assets.eth_token_transferspolygon_zkevm.assets.native_token_transfers
polygon_zkevm.assets.eth_erc20_token_transferspolygon_zkevm.assets.fungible_token_transfers
Legacy TableNew Table
scroll.assets.eth_token_transfersscroll.assets.native_token_transfers
scroll.assets.eth_erc20_token_transfersscroll.assets.fungible_token_transfers
Legacy TableNew Table
zora.assets.eth_token_transferszora.assets.native_token_transfers
zora.assets.eth_erc20_token_transferszora.assets.fungible_token_transfers
Legacy TableNew Table
common.prices.token_prices_hourly_easycommon.prices.hourly
Legacy TableNew Table
ethereum.prices.dex_token_prices_hourlyethereum.dex.token_prices_hourly
arbitrum.prices.dex_token_prices_hourlyarbitrum.dex.token_prices_hourly
base.prices.dex_token_prices_hourlybase.dex.token_prices_hourly
polygon.prices.dex_token_prices_hourlypolygon.dex.token_prices_hourly

​
Schema Changes & Column Mappings

​
Fungible Token Transfers

When migrating from legacy ERC20 token transfer tables (e.g., ASSETS.ETH_ERC20_TOKEN_TRANSFERS) to the new ASSETS.FUNGIBLE_TOKEN_TRANSFERS schema, the following changes apply:

​
Column Renames

Legacy ColumnNew ColumnDescription
erc20_log_indexlog_indexSimplified for consistency
call_typeeth_call_typeClarifies EVM call context
eth_transfer_typetransfer_typeUnified naming

​
Value Changes

FieldLegacy ValueNew ValueDescription
token_type'ETH''NATIVE'Standardized native token label
All other columns maintain the same names and types between the legacy and new schemas.

​
Token Prices

The token_prices_hourly_easy table is being deprecated in favor of common.prices.hourly.
The new hourly table does not provide the same abstraction of token prices across chains. This cross-chain abstraction feature is no longer supported. All other column names and types remain the same.

​
Migration Checklist

  • Review the new schema structure - Review available columns
  • Update your queries - Replace all references to legacy tables using the mappings above
  • Test your applications - Run existing queries against new schemas to ensure compatibility
  • Deploy changes - Update your workflows to use the new schema
  • Validate results - Verify data accuracy and performance
  • Complete migration by December 18, 2025 - Legacy schemas will be removed after this date

​
Key Benefits

The new schemas maintain full coverage with:
  • Standardized naming across all chains
  • Consistent chain logic and data structure
  • Maintainence and support of the new schemas

​
Support

If you need help with migration or have questions about deprecated schemas:
  • Review the recommended alternative schema documentation.
  • Reach out to our support team for migration assistance.