User Behavior
June 20th, 2022. Q11. What are users swapping for? What activities are the most common for users on Flow right now? Create a visualization of what’s causing spikes in swapping behavior.
Introduction
Flow was created by Dapper Labs, the team behind NBA Topshot, but it is actually because of their experience with Crypto Kitties and the problems they faced with Ethereum that the team decided to build a blockchain optimized for NFTs. They built Flow, a proof of stake blockchain designed for security, speed, and performance.
Methods
In this analysis, we take a look at the activity in Flow. The data shown is for the past 30 days. In particular, we look at:
-
The most swapped for tokens, i.e., the tokens that people got most in exchange for other tokens when swapping. This information is easily available in the
flow.core.fact_swaps
table. We then get the token names from theflow.core.dim_contract_labels
table. -
The activities most common for Flow users. We get the activity information from
flow.core.fact_events
. -
Daily swap transactions.
Analysis
The most swapped for token is tUSDT, the version of USDT in Flow. The next is Flow, the native token to the blockchain. In the third place is FUSD, another stablecoin.
The top 3 events happen on every transaction, and refer to the tokens that are sent from the wallet signing the transaction (TokensWithdrawn) to other wallets (TokensDeposited), and the transaction fees (FeesDeducted). The Deposit and Withdraw evens encode the same information for NFT transfers.
We can see a big peak in volume on May 22nd, which is mainly caused by the listing of the FLOW token on Coinbase on May 19th. This event must have brought a lot of new users to the Flow chain, which is the reason for which we also see almost 2M accounts created in the past month.
Contact Data
Thank you for reading!
For any questions or feedback feel free to contact me on Discord at CarlOwOs#4288 or Twitter at @CarlOwOs1