Token Flow
@_token_flow
Followers
3,121
Following
76
Media
70
Statuses
345
Blockchain history as relational datasets, designed for effortless querying
Joined October 2020
Don't wanna be here?
Send us removal request.
Explore trending content on Musk Viewer
Rebeca
• 778488 Tweets
Imane Khelif
• 742226 Tweets
Simone
• 732080 Tweets
Simone
• 732080 Tweets
Trans
• 726294 Tweets
#EndBadGovernaceInNigeria
• 519528 Tweets
Tinubu
• 299563 Tweets
Starmer
• 292226 Tweets
#IStandWithAngelaCarini
• 288673 Tweets
Flavinha
• 205874 Tweets
Evan Gershkovich
• 199135 Tweets
TZUYU
• 197522 Tweets
JK Rowling
• 193562 Tweets
The IOC
• 181651 Tweets
Paul Whelan
• 177751 Tweets
Algeria
• 155628 Tweets
flavia
• 129330 Tweets
トランスジェンダー
• 100878 Tweets
#GinasticaArtistica
• 98233 Tweets
Argelia
• 79456 Tweets
Cardi
• 61414 Tweets
#كاريزما26
• 49803 Tweets
The IBA
• 39467 Tweets
ROOM EP OUT NOW
• 30132 Tweets
Michael Phelps
• 29116 Tweets
Caster Semenya
• 22705 Tweets
バニーの日
• 21430 Tweets
Andy Murray
• 19981 Tweets
Mike Tyson
• 19869 Tweets
Logan Paul
• 18754 Tweets
Belgium
• 17547 Tweets
Serena Williams
• 16526 Tweets
Pedro Scooby
• 14094 Tweets
Swyer
• 10149 Tweets
Pinned Tweet
Token Flow is committing to Blobs Protection Program 🛡️
1. We will store all Ethereum Blobs ❤️
If you're looking for Blobs from other layers (like Data Availability or similar), DM us to arrange it.
2. Blob data will be stored by Token Flow indefinitely, starting from day 1
10
5
29
Proudly announcing:
All details in the thread 👇
7
33
150
Blockchain analytics today is difficult, slow and limited in scope.
We are here to fix it!
We just completed the first close of our Series A round with $12M committed to accelerate our journey.
Here's what we are building: 🧵
5
30
106
We are proud to announce our strategic partnership with
@StarkWareLtd
to bring data and analytics tools to the
#StarkNet
Layer 2 ecosystem !
0
19
89
In collaboration with
@StarkWareLtd
we have created the
#StarkNet
Data Warehouse which combines historical decoded L1 and L2 data. Check it out on the Snowflake Marketplace 👀 :
2
14
78
Need more data on blockchain transactions? They're crucial for understanding on-chain activities, no doubt! But the level of detail available used to vary... until NOW!
🚀🚀 Introducing AnyTx transaction decoder 🚀🚀
3
13
47
Did you know Token Flow was the first provider of
@Starknet
data back in 2022? Since then, a lot has changed - the network has grown immensely and so has our data. Finally we can share more!
🚀 New version of Starknet Data Warehouse is now live! 🚀
What's possible now?
- We've
2
8
39
Busy day for
@Starknet
community - provisions are live! Check the stats on claims with this dashboard we've built:
Underlying data is provided by Token Flow - enabling developers with a quick and easy way to interact with blockchain data.
Soon available
9
15
42
After months of working in shadows we are happy to announce the 🚀 Ethereum Data Warehouse (EDW) 🚀
It is a full queryable history of the Ethereum blockchain with everything that you can get from a full node and much, much more 👀
2
9
44
🔥 104.7M $STRK tokens already claimed 🔥
It's been only 3 hours since going live - let's take a closer look👇
88k Users that Claimed Tokens
👉 8.39% of all eligible users
👉17.86% of all the allocated value
Split by user category:
👑 15.43% Starknet users
👾 1.01% StarkEx
14
11
32
Seeing all the hype around
@Starknet
Provisions and wondering how to dive into the numbers yourself?
Token Flow to the rescue!
Just for one week, you can access our entire set of Starknet data for free!
What's in there?
- Provisions data: allocations,
4
12
30
Our decoded data makes it easy for anyone to run
#Ethereum
queries. In this guide we show you how to use the
#EthereumDataWarehouse
to run simple
#data
queries about mints and secondary market transactions for an
#NFT
3
5
33
Want to know more about the features we developed for
#StarkNet
? 🔥 Get full source code plus documentation on Github :
0
8
31
We are excited to announce that our first sample of Decoded data has been added to the
#EthereumDataWarehouse
Beta program on
@SnowflakeDB
#Ethereum
#Data
#EthereumDecoded
1
12
30
🚀 Exciting Update 🚀
Optimism is now part of Token Flow’s datasets.
Dive into Optimism's state, connect events to calls, and explore raw & decoded data at .
Discover what’s now possible 🧵👇
1
10
27
Both EthTx and our Data Warehouse will go multichain. We are already building tools for
#StarkNet
by
@StarkWareLtd
and have done preliminary work on other rollup L2s and scaling solutions including
@optimismPBC
,
@0xPolygon
and
@FantomFDN
3
2
23
Calculating the total supply of a token over time is a deceptively tricky and time-consuming problem
BUT
You only need a few lines of SQL and 63 milliseconds to get it right every time IF you use Token Flow.
Let's look at XEN token on
@optimismFND
👀
3
9
23
Ever wondered how many contracts are deployed on
#Ethereum
?
With a little help from
@insightsflow
's
#EthereumDataWarehouse
@n4motto
from
@electriccapital
has the answer for you:
1/ Over 44 MILLION contracts have been deployed to
@Ethereum
since genesis 🤯
I analyzed all 44M using
@InsightsFlow
so you don’t have to.
Turns out, 70% of live contracts (~15M) are copies from one of 15 templates.
🧵 Here’s a breakdown of the dominant contract codes
45
173
774
4
8
18
Ethereum's storage, with memory locations as hashes of variable slots & keys, isn't easily deciphered. To list all the token holders you had to run complex queries, build local databases and reconstruct the state by aggregating historical events.
Or you could use TokenFlow.
1
2
22
But this is just the 🧨beginning🧨. We also collect all state and storage diffs (11.5B rows) and 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.
1
1
23
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 sign up to our mailing list as more details are coming soon ⏰.
1
1
18
GM
@Optimism
fam, we have news for you - our Optimistic Data Warehouse is live with fully decoded storage diffs 🤯 - and it doesn't cost a penny.
But what does it mean when we say we have fully decoded storage diffs?
We index and store fully labelled updates to contract storage
1
4
17
The first lesson in our
#EthereumDecoded
series is online! 🔥
Do you want to know more about storage diff decoding?
Check out this explainer by
@kchojn
👀
2
6
16
In practice it radically changes the approach to 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.
1
1
17
🟣 What awaits us further in Ethereum ? 🟣
Undoubtedly, one of the more significant changes awaiting us in the future (likely in the fall of 2023) is the implementation of EIP-4844.
1
4
11
GM! Ethereum Data Warehouse is OUT OF BETA!
State & storage diffs, calls and events, topped with the decoded data, all live now!
Try it out at and read what’s new below 🧵
4
7
16
EDW is based on the highly performant ♥️
@SnowflakeDB
cloud. 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).
1
0
15
@Uniswap
is synonymous with Defi. It dominates DEX Trading Volume and TVL, and is often considered the only DeFi protocol with true product market fit.
How is it that analysing the most studied web3 product is complicated, with many questions still going unanswered?
2
5
16
The ERC-4626 standard (
@erc4626
) has optimised and unified yield-bearing vaults. From
@yearnfi
to
@fraxfinance
and
@Balancer
, the adoption of this standard is skyrocketing!
But there's a catch:
Accounting & Reporting remains a major challenge! 😠
Let's simplyify it! 🧵
1
5
15
Join us and
@flipsidecrypto
on Wednesday to find out more about our
#EthereumDataWarehouse
. As well as talking about the “Raw” level of data which is currently available we’ll also give a preview of the “Decoded” level of data which is coming soon
What's the story behind Token Flow's cream of the crop
#blockchain
data? And why is it so ground-breaking for on-chain analytics?
Join
@flipsidecrypto
&
@InsightsFlow
this Wednesday to learn more 💫
0
3
25
0
5
14
@eth_tx
was created as a side project but soon became very popular in the community.
Now the time has come for the major upgrade with many exciting new features 👇👇👇
2
2
12
We are so glad to have attended
@ethgathering
a few days ago and proud to have been one of its sponsors! 🔥 A lot of very incredible people and companies and also many interesting talks.
1
3
12
Today we also launch new “Getting Started” documentation to make it easier for users to onboard to our data products, to connect to the analytics / visualization platform of their choice and to see what other community members have created.
1
1
12
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 🤟.
1
0
13
Following our announcement of the
#EthereumDataWarehouse
we are now sharing our wider mission and roadmap for creating a multichain
#BlockchainTimeMachine
. A thread on what we are building:
1
3
12
Use cases 👀: iterating on token holders, showing the history of protocol parameters or implementations of the proxy, checking which contracts store your address, checking which contracts use your address for addressing storage... the potential is mind blowing 🤯
1
1
12
A must read from
@MariaShen
and
@ElectricCapital
- kudos!
Our key takeaway? We're all going multichain - that one is obvious. And for multichain world, you need multichain data sets, like the one from Token Flow ✨
We're stoked to be contributing to amazing initiatives like
0/ We are delighted to release the 5th annual
@ElectricCapital
Developer Report
We analyzed a record 485 million code commits across 818k repositories—20x more code than our first report from 2019!
356+ people across the community contributed to making this report.
Long,
97
432
1K
0
2
12
@BeanstalkFarms
Glad we could help. It was a great test for the decoded layer of the Ethereum Data Warehouse!
0
0
11
Our second lesson in our
#EthereumDecoded
series is online! 🔥 Are you interested in Ethereum storage memory layout ? Check this out this explainer by Piotr Rudnik our Data Engineer : 👀
2
4
10
The
#EthereumDataWarehouse
is Merged 🎉 The detailed Ethereum history including pre-hashed storage diffs is coming in as before. The Grand Shoutout goes to
@karol_choj
and the team. Let the data flow!
0
1
10
The most basic explanation of how a
@Uniswap
pool works is that Liquidity Providers deposit 2 tokens enabling traders to swap their token for the other. Traders pay a small fee to LPs
How many fees did LP A make from trader B's swap?
The answer is not as simple as you think 🧵
2
4
11
Kudos to
@0xaustinb
for this amazing
@lilnounsdao
data visualization powered by
@InsightsFlow
#EthereumDataWarehouse
and
@flipsidecrypto
1
2
11
Great thread 🔥 Using the storage data isn't easy at first, but it changes the way we approach many common problems 👌
If you've been in defi for any amount of time, you should be familiar with two types of price oracles:
> off-chain aggregators like
@chainlink
> on-chain like
@Uniswap
TWAP
It's time to compare them! 🧐
The repo and article on working with storage data are linked at the end.
4
7
53
0
2
11
Do you want to build the future of blockchain data and analytics with us? We are hiring data engineers, ecosystem developers, DevOps and more!
0
1
10
Decoded state and storage are game-changers for on-chain analytics - they give you the unbiased truth.
Querying storage to understand what has happened on-chain is going straight to the source - it doesn’t rely on whether an event was emitted or whether events were excluded by
0
6
11
Announcing the launch of Token Flow Insights SA, created with the goal of being the leading provider of contextualized
#data
and
#analytics
for the
#DeFi
ecosystem;
1
3
10
Thank you to our Alpha testers
@samczsun
,
@Mudit__Gupta
,
@bkiepuszewski
,
@0xren_cf
and
@eherrerosj
for their feedback on a very early version of “new”
@eth_tx
🫂🙏
1
0
10
@haydenzadams
With decoded, queryable storage diffs, you won't miss events at all!
Simpler, faster, more reliable 🙏
1
0
10
@anthonykrose
@bkiepuszewski
@blobscan
@etherscan
@graphprotocol
Blobs will be part of Token Flow data from day 1 for all supported chains - we'll post more extensively on this topic later this week!
1
0
9
Ethereum Data Warehouse is live and available to all now - read more about its capabilities on our blog:
0
1
8
@maurelian_
The easiest way would be to add current balances of all addresses. With our datasets it is just this simple query 👇👇👇
3
1
9
No more cumbersome aggregations of events to recreate values of variables in time. From our datasets you get full history of every storage location in pre-hashed form.
Sounds interesting? Check our free Snowflake listing for raw data : 👀
1
0
8
Great example of what can be done with our new Tokens Dataset ! 🔥 Thanks
@0xren_cf
for sharing 😉
#Token
#EthereumDataWarehouse
why did uniswap buy genie? why are nft platforms being acquired or funded? check the chain
erc721 transfers happen as frequently as erc20 transfers on ethereum. users/devs like non fungibility, they're an important building block for the digital economy
pfps are just the start
11
64
308
1
3
7
Andra will talk about the usefulness of diffs and how to access them - we're looking forward to seeing you there!
👋 We're excited to welcome Andra, Senior Product Manager at
@_token_flow
, as a speaker!
🗓 April 5-7, 2024
⬇️ Grab your ticket!
🎟️
2
0
3
6
0
12
Just last week we launched the full version of Ethereum Data Warehouse. Its breakthrough feature is a comprehensive history of state and storage changes. It enables direct queries using smart contract variables, transforming the data access experience. Just like the one above.
1
0
7
Most of valuable blockchain analytics focuses on smart contract variables. But until now their history was not directly available because common belief was that:
'you cannot iterate over hashmaps' !
Well, now you can :)
1
0
8
Today StarkNet Alpha on Goerli was upgraded to version 0.8.0 which finally provides transaction traces and our does not fall behind 💪:
1
3
8
People are creative - about 0.5M tokens (contracts) were created on Ethereum so far 👀
1
0
8
Currently we provide data for
@Ethereum
and StarkNet by
@StarkWareLtd
, but we will soon extend our coverage to other L2 and scaling solutions including
@optimismFND
,
@arbitrum
,
@zksync
,
@0xPolygon
and
@avalancheavax
.
Stay tuned...
1
0
8
We welcome our new investors
@ElectricCapital
and
@Deltabc_fund
who join our seed investor
@UDHCFinance
.
1
0
7
If you are at the DeFi Security Summit at Stanford and want to talk about
@eth_tx
or our other blockchain data tools and products send us a DM - we are here all day at
@summit_defi
0
0
6
We keep talking about the importance of state and storage diffs all the time - but it's not always obvious what that is and how to use it. Luckily,
@mierzwik
knows this better than anyone. Tune in 👇
2
2
7
#MuchClicked
@InsightsFlow
EDW beta
@moxie
web3 first impressions
@brockjelmore
Foundry debugger
@HenriLieutaud
Cairo 101
@clemlak
Marmite
@benjaminion_xyz
super-majority dangers
@sproulM_
Key manager UI by
@joenrv
@fuellabs_
token model
1
8
25
1
0
7
🤖💾 The Ethereum Virtual Machine (EVM) is the runtime environment for smart contracts on the
#Ethereum
blockchain.
1
2
5
And one more thing 😃 - we also have reverted events and storage diffs, i.e. the cases when a contract emitted an event or changed 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.
1
0
7
We will be opening up the new version of EthTx for Beta testing very soon - join our discord and mailing list to get notifications on when Beta testing is open (linktree in our bio).
1
0
6
We are great fans and power users of
@SnowflakeDB
.
Incredible platform for our incredible data 🫶
0
4
7
It is still early days in our journey into the multichain world, and we are already working on expanding to other scaling solutions in the future.
Reply in a comment below to let us know which L2s and scaling solutions that you'd like to see us cover next ... 💬
0
1
5
🟣 POV 🟣
Exciting update: After completing the onboarding process, the ETL pipeline repository became the first priority. The tasks that caused performance bottlenecks were parallelized, resulting in a noticeable performance improvement.
1
2
5
Need more than one-by-one transaction analysis?
Sign up for private beta access to Token Flow Data Platform - blockchain history as relational datasets with fully decoded data, including state and storage diffs, without any whitelisting requirements.
1
0
6
Unlock the full potential of your transactions with AnyTX - the cutting-edge new tool from the team behind . 👀👇
1
1
5
To show the power of the
#EthereumDataWarehouse
our next blog gives examples of querying State to answer four typical analytical queries which are simplified with EDW - token holders, contract status, calling of user proxies, storing of address:
0
0
6
Using just basic
#SQL
we show you how to see the mints for an
#NFT
over time using
@thekissprecise
as an example:
1
0
4
All info needed for sign-up and providing feedback can be found in the announcement:
1
0
6
Great use case for storage data from the
#EthereumDataWarehouse
👀
know how to work with raw storage slot data, anon? doing so unlocks a lot of new web3 analytics possibilities, such as comparing price oracle data (yes, the values differ from the tokenIn/tokenOut amounts)!
some teaser
@Uniswap
TWAP vs
@chainlink
data feed comparisons below:
4
3
44
0
2
6
Our
#EthereumDataWarehouse
is the ultimate source of every transaction, call, event, state and storage change, available in fully decoded and contextually enriched form.
And yes, we also have every reverted action...
1
0
6
AnyTx covers the basics and much more - full execution trace complete with state and storage diffs in context.
Wondering what that looks like for 0x955af0a1164026e553ddf0f6bb099a23cecd5eb5f5348bcd779a80b489b28f60 ?
Check it out :
1
0
6
Until now
#Ethereum
transactions have performed 14,643,277,964 writes to the chain. But today's analytics tools don't let us understand much of it.
Our unique approach enables what has always been considered impossible - full historical analysis of blockchain state. 🔥
1
0
6
Sample storage diffs panel 🪄 (notice pre-hashed keys, variable names, structure fields, etc):
2
0
6
EIP 4844 is live!
Remember that:
- Token Flow will store blobs indefinitely ♾️
- Transient storage will be available for analytics same as regular storage 🗃️
Happy BLOB Season 🔥
0
3
6
With AnyTX, you can easily obtain and view both decoded state diffs and storage diffs in the Ethereum blockchain. Our pre-hashed processed data allows for secure and efficient analysis of changes made to the network and smart contracts.
1
0
5
Just one day until Dencun and the arrival of Blobs. Looking to access Blobs indefinitely? Here's all you need to know 👇
Token Flow is committing to Blobs Protection Program 🛡️
1. We will store all Ethereum Blobs ❤️
If you're looking for Blobs from other layers (like Data Availability or similar), DM us to arrange it.
2. Blob data will be stored by Token Flow indefinitely, starting from day 1
10
5
29
0
0
5
Working together, we hope to identify products, features and datasets that will be of interest to the wider ecosystem. 🤝
0
0
5
Thanks to the new
@SnowflakeDB
direct links access to our
#EthereumDataWarehuse
has become even easier:
0
2
5
We will also provide tailored training, integration, and technical support. 📘
1
0
5
Beta users can now access all Decoded events and calls for Ethereum that occurred during April 2022. Decoded storage data is coming soon :)
You can access the new Decoded dataset here:
1
0
5
Exciting things are on the horizon! Next week, we've got some cool stuff lined up 🚀 We're keeping it super simple by changing our Twitter handle to
@_token_flow
!
No fuss, no frills – just a quick heads-up. Update your bookmarks, and stay tuned for all the awesome updates 👀
0
0
5
For a deeper dive into these challenges and solutions, check out our blog post: and test out the Ethereum Database Warehouse at TokenFlow!
0
0
3
Our data wizard
@mierzwik
spoke with
@ensdomains
,
@DuneAnalytics
and
@graphprotocol
about the future of blockchain data analytics and about the challenge to attract new people who are not native to this ecosystem.
1
0
4