Ethereum balances tables: Deprecation and new standardized tables
We’re introducing new standardized balances tables for Ethereum and deprecating legacy balance tables to improve performance and consistency across all EVM chains.Table deprecations
The following tables will be removed from the platform on December 11, 2025 (4 weeks from today):ethereum.core.fact_eth_balancesethereum.core.fact_token_balancesethereum.core.ez_balance_deltasethereum.core.ez_current_balances
New tables
Two new tables are now available in theethereum.balances schema:ethereum.balances.ez_balances_native_daily- Daily native ETH balance snapshotsethereum.balances.ez_balances_erc20_daily- Daily ERC20 token balance snapshots
Key changes
Granularity
Daily snapshots based on max block per day (vs calls at every block)Historical data
One-time historical snapshot as of June 10, 2025 to include balances for all address/contract pairs and native asset holders from genesisVerified tokens
ERC20 table includes only verified tokens, selected based on custom business logic. Tokens can be added upon requestMain column differences
USER_ADDRESS→ADDRESSBLOCK_TIMESTAMP→BLOCK_DATE
Key benefits
- Standardized: New tables are standardized and deployed across all EVMs
- Performance: More efficient, faster queries
- Pre-aggregated: Balances aggregated to daily level
- USD pricing: Includes USD pricing for all balances
Migration timeline
You have 4 weeks to migrate your queries to the new tables. The legacy tables will be removed on December 11, 2025.Need help?
If you have questions about migrating to the new tables or need assistance with custom token additions, please contact [email protected].Introducing FlipAI Agents: Data Science in Your Pocket
We’re excited to introduce FlipAI Agents—expert AI-assistants trained by data scientists to solve specific problems for you. Each agent is tailor-made to provide answers to specific insights or questions you have about your business in minutes. No coding. No analytics expertise.What are FlipAI Agents?
Think of them as having a team of expert data scientists on call, 24/7, each specialized in solving a particular problem you face. Each agent combines:- Highly curated, cross-chain data normalized to understand behavior at scale across 30+ blockchain networks
- Proprietary methodologies developed by Flipside’s data science team, including frameworks like Flipside User Scores
- Blockchain-native AI trained to surface the toughest crypto-related insights
- Purpose-built interfaces that guide you through complex analyses with simple, natural language questions
Available Agents
Spindl Agent
Build precision-targeted wallet audiences for Spindl campaigns. The Spindl Agent streamlines wallet segmentation into a simple three-step workflow: select blockchains, set targeting criteria, and export your address list.Learn more about the Spindl Agent →Targeting Agent
Target blockchain addresses with custom criteria for growth campaigns. Use flexible wallet targeting across 30+ blockchain networks, exportable for use in any campaign platform.Learn more about the Targeting Agent →Coming Soon
We’ll be launching more agents in the coming days and weeks:- Airdrop Agent: Evaluate whether your incentive programs are attracting genuine users or airdrop farmers
- Competitive Intelligence Agent: Track your protocol’s position in the market and benchmark against competitors
- Dashboard Analyzer: Talk to your dashboards with natural language queries
- Offchain Data Agent: Integrate external data with onchain intelligence
Get Started
Ready to start using FlipAI Agents? Check out our Agents overview to learn more about all available agents and how they can help you make faster, more informed decisions about where to focus your growth efforts.Introducing Mentions: Reference datasets and workflows with @
We’re excited to launch Mentions, a powerful new feature that makes it easier to work with specific datasets and workflows in FlipsideAI.What are mentions?
Type@ in any FlipsideAI conversation to search and reference:- Datasets: Specific Flipside’s data tables across 30+ blockchain networks
- Workflows: Pre-built analysis agents trained on specialized methodologies
Why use mentions?
- Precision: Tell FlipsideAI exactly which data sources to use
- Discovery: Browse available datasets and workflows as you type
- Efficiency: Reduce ambiguity and get better results faster
How to use mentions
- Type
@in the chat - Search by blockchain (
@ethereum), category (@defi,@nft), or specific tokens (@usdc) - Select from the dropdown menu
- Continue your question with context
@ethereum dex swaps, show me the top 10 trading pairs by volume this week”Learn more
Check out the full documentation to master mentions and discover advanced techniques:Explore the Mentions guide →Removal of unsuccessful transactions from Solana tables
We’ve updated our Solana tables to exclude unsuccessful transactions, improving query performance and reducing storage overhead.What changed
Most of our Solana tables previously included only successful transactions. With this update, all remaining tables now follow the same pattern, excluding unsuccessful transactions.Why this matters
- Improved Performance: Queries will process less data, resulting in faster execution times
- Reduced Storage: Smaller tables mean more efficient data management
- Better Analytics: Unsuccessful transactions provide limited analytical value for most use cases
Data availability
- Failed transactions are still accessible in
solana.core.fact_transactionsfor failure counts and general metrics - Fee deductions remain tracked in
sol_balancestables, as fees are deducted even for failed transactions
Impact
This change affects historical data. While it’s unlikely this impacts existing reports, please review any queries that specifically analyze unsuccessful transactions outside offact_transactions.Documentation improvements
We’ve completely overhauled our documentation structure to provide a more intuitive and powerful experience for users exploring Flipside’s products and data.🗂️ Enhanced Navigation Structure
Our documentation now features a comprehensive three-tab organization:- FlipsideAI Tab: Complete guide to our AI-powered blockchain intelligence platform - Get started
- Snowflake Data Shares Tab: Everything you need to access and use our data shares - Overview
- Blockchain Data Tab: Detailed schemas and table references for 30+ blockchain networks - Schema overview
🤖 AI-Powered Search & Discovery
The documentation now includes powerful AI search capabilities:- Contextual Actions: Every page includes options to copy content, view in AI tools (Claude, ChatGPT), or open in editors (Cursor, VSCode)
- Intelligent Navigation: AI-powered suggestions help you find relevant content across the entire documentation
📊 Comprehensive Blockchain Data Coverage
We’ve expanded our blockchain data documentation to include:- 30+ Networks: Complete coverage from Ethereum and Bitcoin to emerging chains like Aleo and Eclipse - Browse all networks
- Organized Schemas: Each blockchain is structured with Core, DeFi, NFT, Price, and Stats categories
- Detailed Table References: Over 100+ individual table pages with column descriptions and data types
- Consistent Structure: Standardized navigation patterns make it easy to find data across any network
🎯 Improved User Experience
- Better Visual Hierarchy: Clear headings, consistent formatting, and improved readability
- Progressive Disclosure: Information is organized from basic concepts to advanced features
- Interactive Elements: Cards, steps, tips, and callouts guide users through complex topics
🔧 Analyst-Friendly Features
- Code Examples: Tested, runnable examples with proper error handling
- Troubleshooting Guides: Common issues and solutions for each product - FlipsideAI troubleshooting