Schema Deprecation & Migration Guide - Allium Documentation Hub

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.

Key clarification: The fungible_* tables (e.g., fungible_token_transfers, fungible_balances) contain both native token (e.g., ETH, MATIC, AVAX) and ERC20 token data. This was also the case with the legacy tables they replace. Use the token_type column to filter: NATIVE for native transfers, ERC20 for ERC20 transfers.

Summary

Chain	Legacy Prefix	New Schema Family
ethereum	eth_, eth_and_erc20_, eth_erc20_*	native_, fungible_
arbitrum	eth_, eth_erc20_	native_, fungible_
base	eth_, eth_erc20_	native_, fungible_
mode	eth_, eth_erc20_	native_, fungible_
optimism	eth_, eth_erc20_	native_, fungible_
polygon	matic_, matic_and_erc20_, pol_*	native_, fungible_
polygon_zkevm	eth_, eth_erc20_	native_, fungible_
scroll	eth_, eth_erc20_	native_, fungible_
zora	eth_, eth_erc20_	native_, fungible_
avalanche	avax_, avax_erc20_	native_, fungible_
bsc	bnb_, bnb_erc20_	native_, fungible_
common.prices	token_prices_hourly_easy	common.prices.hourly
ethereum.prices, arbitrum.prices, base.prices, polygon.prices	dex_token_prices_hourly	.dex.token_prices_hourly

Table Mappings

Arbitrum Assets

Legacy Table	New Table
arbitrum.assets.eth_balances_latest	arbitrum.assets.native_balances_latest
arbitrum.assets.eth_balances	arbitrum.assets.native_balances
arbitrum.assets.eth_credit_debit	arbitrum.assets.native_credit_debit
arbitrum.assets.eth_token_transfers	arbitrum.assets.native_token_transfers
arbitrum.assets.eth_erc20_balances_latest	arbitrum.assets.fungible_balances_latest
arbitrum.assets.eth_erc20_balances	arbitrum.assets.fungible_balances
arbitrum.assets.eth_erc20_token_transfers	arbitrum.assets.fungible_token_transfers
arbitrum.assets.unhydrated_fungible_balances	arbitrum.assets.fungible_balances

Avalanche Assets

Legacy Table	New Table
avalanche.assets.avax_balances	avalanche.assets.native_balances
avalanche.assets.avax_token_transfers	avalanche.assets.native_token_transfers
avalanche.assets.avax_erc20_balances	avalanche.assets.fungible_balances
avalanche.assets.avax_erc20_token_transfers	avalanche.assets.fungible_token_transfers
avalanche.assets.unhydrated_fungible_balances	avalanche.assets.fungible_balances

Base Assets

Legacy Table	New Table
base.assets.eth_balances_latest	base.assets.native_balances_latest
base.assets.eth_balances	base.assets.native_balances
base.assets.eth_credit_debit	base.assets.native_credit_debit
base.assets.eth_token_transfers	base.assets.native_token_transfers
base.assets.eth_erc20_balances_latest	base.assets.fungible_balances_latest
base.assets.eth_erc20_balances	base.assets.fungible_balances
base.assets.eth_erc20_token_transfers	base.assets.fungible_token_transfers
base.assets.unhydrated_fungible_balances	base.assets.fungible_balances

BSC Assets

Legacy Table	New Table
bsc.assets.bnb_balances	bsc.assets.native_balances
bsc.assets.bnb_credit_debit	bsc.assets.native_credit_debit
bsc.assets.bnb_token_transfers	bsc.assets.native_token_transfers
bsc.assets.bnb_erc20_balances	bsc.assets.fungible_balances
bsc.assets.bnb_erc20_token_transfers	bsc.assets.fungible_token_transfers

Ethereum Assets

Legacy Table	New Table
ethereum.assets.eth_balances_latest	ethereum.assets.native_balances_latest
ethereum.assets.eth_balances	ethereum.assets.native_balances
ethereum.assets.eth_credit_debit	ethereum.assets.native_credit_debit
ethereum.assets.eth_token_transfers	ethereum.assets.native_token_transfers
ethereum.assets.eth_and_erc20_balances_latest, ethereum.assets.eth_erc20_balances_latest	ethereum.assets.fungible_balances_latest
ethereum.assets.eth_and_erc20_balances, ethereum.assets.eth_erc20_balances	ethereum.assets.fungible_balances
ethereum.assets.eth_and_erc20_token_transfers	ethereum.assets.fungible_token_transfers
ethereum.assets.unhydrated_fungible_balances	ethereum.assets.fungible_balances

Mode Assets

Legacy Table	New Table
mode.assets.eth_token_transfers	mode.assets.native_token_transfers
mode.assets.eth_erc20_token_transfers	mode.assets.fungible_token_transfers

Optimism Assets

Legacy Table	New Table
optimism.assets.eth_balances	optimism.assets.native_balances
optimism.assets.eth_credit_debit	optimism.assets.native_credit_debit
optimism.assets.eth_token_transfers	optimism.assets.native_token_transfers
optimism.assets.eth_erc20_balances	optimism.assets.fungible_balances
optimism.assets.eth_erc20_token_transfers	optimism.assets.fungible_token_transfers
optimism.assets.unhydrated_fungible_balances	optimism.assets.fungible_balances

Polygon Assets

Legacy Table	New Table
polygon.assets.matic_balances_latest	polygon.assets.native_balances_latest
polygon.assets.matic_balances	polygon.assets.native_balances
polygon.assets.matic_credit_debit	polygon.assets.native_credit_debit
polygon.assets.matic_token_transfers	polygon.assets.native_token_transfers
polygon.assets.pol_balances_latest	polygon.assets.native_balances_latest
polygon.assets.pol_balances	polygon.assets.native_balances
polygon.assets.pol_credit_debit	polygon.assets.native_credit_debit
polygon.assets.pol_token_transfers	polygon.assets.native_token_transfers
polygon.assets.matic_and_erc20_balances_latest	polygon.assets.fungible_balances_latest
polygon.assets.matic_and_erc20_balances	polygon.assets.fungible_balances
polygon.assets.matic_and_erc20_token_transfers	polygon.assets.fungible_token_transfers
polygon.assets.unhydrated_fungible_balances	polygon.assets.fungible_balances

Polygon zkEVM Assets

Legacy Table	New Table
polygon_zkevm.assets.eth_token_transfers	polygon_zkevm.assets.native_token_transfers
polygon_zkevm.assets.eth_erc20_token_transfers	polygon_zkevm.assets.fungible_token_transfers

Scroll Assets

Legacy Table	New Table
scroll.assets.eth_token_transfers	scroll.assets.native_token_transfers
scroll.assets.eth_erc20_token_transfers	scroll.assets.fungible_token_transfers

Zora Assets

Legacy Table	New Table
zora.assets.eth_token_transfers	zora.assets.native_token_transfers
zora.assets.eth_erc20_token_transfers	zora.assets.fungible_token_transfers

Common Prices

Legacy Table	New Table
common.prices.token_prices_hourly_easy	common.prices.hourly

DEX Token Prices

Legacy Table	New Table
ethereum.prices.dex_token_prices_hourly	ethereum.dex.token_prices_hourly
arbitrum.prices.dex_token_prices_hourly	arbitrum.dex.token_prices_hourly
base.prices.dex_token_prices_hourly	base.dex.token_prices_hourly
polygon.prices.dex_token_prices_hourly	polygon.dex.token_prices_hourly

Schema Changes & Column Mappings

Fungible Token Transfers

Important: The ASSETS.FUNGIBLE_TOKEN_TRANSFERS table contains both native and ERC20 token transfers, same as the legacy tables it replaces. Use the token_type column to filter: NATIVE for native transfers, ERC20 for ERC20 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 Column	New Column	Description
`erc20_log_index`	`log_index`	Simplified for consistency
`call_type`	`eth_call_type`	Clarifies EVM call context
`eth_transfer_type`	`transfer_type`	Unified naming

Value Changes

Field	Legacy Value	New Value	Description
`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:

Unified fungible tables - native and ERC20 token data combined into single fungible_* tables, reducing query complexity
Standardized naming across all chains
Consistent chain logic and data structure
Maintenance 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.

​Overview

​Summary

​Table Mappings

​Schema Changes & Column Mappings

​Fungible Token Transfers

​Column Renames

​Value Changes

​Token Prices

​Migration Checklist

​Key Benefits

​Support

Overview

Summary

Table Mappings

Schema Changes & Column Mappings

Fungible Token Transfers

Column Renames

Value Changes

Token Prices

Migration Checklist

Key Benefits

Support