Announcing the Ethereum Data Warehouse Beta Program
Token Flow
Token Flow

EDW is based on the Snowflake cloud and as a result is highly performant. It has the full history since Genesis and is constantly updated with the head of the chain (~15 blocks lag is enforced to minimize the impact of reorgs).
It contains everything that other providers have: full blocks data, transactions, events and internal calls. What others do not have is the relation between an event and the call that emitted it, so you can actually see where it resides in the processing tree.
But this is just the beginning. We also collect all state and storage diffs (11.5B rows) and all storage reads (15.6B rows). And what’s more important is that they are all pre-hashed which means that you see all mapping keys and finally you can iterate through hashmaps.
In practice it radically changes the approach to reporting and analyzing contract history, because you no longer have to aggregate events to get the state (e.g. token holders and balances) but you can just query the state directly. It is much faster and infinitely more reliable.
And one more thing – we also have reverted events and storage diffs, i.e. the cases when a contract emitted an event or changed its storage but it was reverted and thus not permanently stored. So you can also see when somebody ‘tried’ to do something and did not succeed.
Simple use cases include: iterating on any token holders, showing the history of protocol parameters, seeing all previous implementations of the upgradeable proxy, checking which contracts store your address, checking which contracts use your address for addressing storage .. the potential is mind blowing.
We are now preparing the limited beta program for users to test the data and provide us feedback. If you are interested in getting early access or to request a demo drop us a line drop us a line as more details are coming soon.
More articles

Discover AnyTx – Token Flow’s advanced transaction decoder
AnyTx transaction decoder reveals the full spectrum of blockchain interactions to get better understanding of what’s going on chain.

Token Flow and Argent announce data partnership for StarkNet and Ethereum
Argent will use Token Flow’s fully queryable blockchain history for its own analysis of on-chain activities.

Token Flow raises $12m in Series A funding to expand its blockchain data platform
First close of Series A with $12m committed to expand Token Flow’s unique state processing technology which takes blockchain data analytics to a whole new level.