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
| Chain | Legacy Prefix | New Schema Family |
|---|
| ethereum | eth_, eth_and_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_ | 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_ |
| common.prices | token_prices_hourly_easy | common.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 |
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.fungible_balances_latest |
| ethereum.assets.eth_and_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.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 |
| 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 |
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 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:
- 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.
