Open Analytics Bounty: ETH (November 6)
Introduction
What is Hashflow?
Hashflow is a decentralized exchange designed for interoperability, zero slippage, and MEV-protected trades. It allows you to trade any asset on any chain in seconds simply by connecting your wallet. All trades are commission-free, and all price quotes are executed at their displayed price, giving you the most value for your buck on every trade[1].
Zero Slippage
All Hashflow quotes are executed at the displayed price.
MEV-Resistance
Cryptographic signatures make front-running impossible. Traders can keep what they earn.
HFT Token
HFT is the governance token for the Hashflow protocol as well as the Hashverse, Hashflow’s gamified DAO and governance platform. It is an ERC-20 token deployed on Ethereum mainnet.
Circulating Supply
The circulating supply is the current number of coins that circulate on the blockchain.
Total Supply
The total supply is the maximum amount of coins and represents a limit that cannot be exceeded.
Method
The current dashboard has built to clarification of the HFT Token launch and claiming drop in the early minutes of token releasing.
For this purpose I used ethereum.core.fact_event_logs table by following filters:
WHERE ORIGIN_FUNCTION_SIGNATURE = '0xeb4d6138'
and ORIGIN_TO_ADDRESS = '0x1a9a4d919943340b7e855e310489e16155f4ed29'
and CONTRACT_ADDRESS = '0xb3999f658c0391d94a37f7ff328f3fec942bcadc'
and BLOCK_TIMESTAMP BETWEEN '2022-11-07 12:31:00.000' and '2022-11-07 23:59:00.000'
Also ethereum.core.dim_labels and crosschain.core.address_labels tables to find where transferred HFT tokens after claim.
I used the NFTs allocation to categorize drop claimers count as Open Alpha and Open Beta tables here.
NFT | Minted | HFT Value per NFT |
---|---|---|
Hashbot Poster #1 | 17,124 | 584 |
Hashbot Poster #2 | 3,741 | 1,871 |
The Hashbot #1 Page 1 | 561 | 4,456 |
Hashbot Poster #3 | 676 | 2,959 |
Hashbot Poster #4 | 832 | 2,404 |
The Hashbot #1 Page 3 | 600 | 3,333 |
The Hashbot #1 Page 4 | 220 | 13,636 |
Hashbot: Domination | 25 | 100,000 |
Community Rewards (NFTs + Rake the Rewards + Exchange Distribution)
- NFT holders will be able to claim up to
30,000 HFT
upon TGE for each wallet holding NFTs as of their respective snapshot dates. See the breakdown here. - Thereafter, all wallets holding NFTs with remaining aggregate value in excess of
30,000 HFT
will be able to claim the balance according to the following schedule: Linear, daily vesting with a vesting floor of1,000 HFT
per day, beginning 1 month after TGE. For example, if you held Hashflow NFTs with a total value of200,000 HFT
in one wallet, you will be able to claim30,000 HFT
at TGE. After 1 month, you will start vesting 1,000 HFT per day over the next 170 days. - For Rake the Rewards rewards: HFT that were earned before July 2022 will be fully distributed and claimable by eligible wallets upon TGE. HFT that were earned on or after July 2022 will be subject to linear, daily vesting for a period of 30 days after TGE. Read More…
The separate part I deals with the Hashflow Platform overall view by assessing of swaps metrics on supported chains over past months.
I was wired when found the Flipsidecrypto database doesn’t have all Hashflow transactions, for example like this transactions hash:
0xca9c1b5434041003877bb87fdd739b4447f20d51e8c165450cbe915ff68b499a
✍🏻 Conclusion
As of Findings Above:
- At genesis, HFT supply is 1 billion (one billion tokens).
- 157.9M HFT are in circulation, and according to the project paper, wallets containing more than 30,000 HFT can claim the balance. Linear, daily vesting with a vesting floor of 1,000 HFT each day, starting 1 month after TGE [Link], but they altered their mind and are releasing the floor a day after launch.
- More than 61% of claimer was eligible to less than 584 HFTs that allocated to Hashbot Poster #1.
- Arbitrum have had the most share of New users percentage and count with over one-third of all new users, followed by Avalanche with 16.7%.
- As anticipated, Ethereum has generated the highest proportion of fees, totaling $22.6k.
- With one-fourth of all transactions going to Polygon, it received the largest share.
- When comparing the percentages of active users, 30.7% belongs to Arbitrum.
About:
-
Author: HaM☰d
\
-
Discord: 0xHaM☰d#8391
\
-
Twitter: @arjmandi_hamed
\
-
Email: h_arjmandi2012@yahoo.com
HFT Token Launch
In Nov 7th, at 13:00 UTC, the HFT Token been launched, but it couldn't be claimed in the early minutes, so I was curouse to know what happened and built the current dashboard to trace the Claimers behaving.
What’s will be assessed:
> * HFT Total Supply > * HFT Circulating Supply > * HFT Holders > * HFT Claiming Metrics in Claim Date > * HFT Claimed Destinations > * & Platform’s Overall View
Hey there 👋!
Firstly, I appreciate you sticking with it until the conclusion.
I'm Hamed, a civil engineering Ph.D.
student interested in data analysis.
I've made many similar dashboards and visualizations since I started at Flipside in January.
Please take a look at my various contact details and let me know what you think.
:telescope: Findings:
At genesis, the total HFT supply will be 1,000,000,000
(one billion tokens).
157.9M HFT are in the circulate to date, while in aforementioned in the project document: all wallets holding NFTs with remaining aggregate value in excess of 30,000 HFT
will be able to claim the balance according to the following schedule: Linear, daily vesting with a vesting floor of 1,000 HFT
per day, beginning 1 month after TGE [Link], but they changed their decide and are releasing vesting floor of 1,000 HFT
per day, since a day after launch.
:telescope: Findings:
As can be observed in the current section’s graphs, the most volume of claimed HFT tokens transferred to binance, as excepted.
Wait a minute, what happened? :eyes:
About 125M HFT transferred before 13:00, while 100M of it transferred to unknown wallets and the most volume of rest transferred to binance.
Ok, we knew 75M of circulating supply allocated to Market Makers [Link], but what about the rest 50M HFT tokens?! Who Know? Maybe it took by Market Maker to regular the price volatility after launch.
As of PIE charts below, binance was the destination of 62.5% of transferred volume followed by unknown addresses with 23.4%.
:telescope: Findings:
The PIE chart right shows the distributions of eligible drop token addresses based on held NFTs as aforementioned in methodology and here.
As can be seen more than 61% of claimer was eligible to less than 584 HFTs that allocated to Hashbot Poster #1.
Although, this classification might not be exactly matched with Open Alpha & Open Beta Users tables, because of, might be some users transferred their NFTs or held other NFTs that couldn’t put its to this category, but it give us an overall view of distribution of eligible drop token.
:telescope: Findings:
The charts above show the number of new users since last May.
as can be seen the new users count peaked at nearly 30K in last week of Oct.
Arbitrum have had the most share of New users percentage and count with over one-third of all new users, followed by Avalanche with 16.7%.
The animated chart right shows the growth of new users count over time.
:telescope: Findings:
The current section’s graphs present the overall view of weekly transactions count, active users and generated fees volume over time.
Ethereum has had the most percentage of generated fees with $22.6K, as excepted.
Polygon allocated to itself the most percentage of transactions count with one-fourth of all transactions.
Arbitrum has had the highest percentage of active users with 30.7%

:telescope: Findings:
The charts above show the minutely claim transactions and HFT volume in dropping date (Nov 7th) since 13:00 UTC till 23:59.
As can be seen 6 minute before the formal claiming time, more than 177.5K HFT has been claimed, but the claiming was disable till 28 minute after 13:00, that 619.85K has claimed, then four minute later claiming was disabled again.
The claimed HFT volume peaked at 4.45M in 14:02, just one hour after announcement claiming time. trend on claim transactions count followed volume pattern, too.