📖 INTRO

From March 1, 2023, the trend of active users in the Flow ecosystem had many ups and downs, on some days, many users were active in this chain, and on some days, the trend of the number of users faced a decline. In this topic, we are going to examine these ups and downs.

As you know, Flow ecosystem has many platforms for blockchain activities. These platforms include NFT trading and Flow token staking, which is based on proof of stake, and swap tokens and bridging assets from the Flow chain to other chains. The activity of the users of this network on each of these platforms increases the trend of the number of daily users in this network.Let's see which of these platforms has the most user activity from March 1st. and what is the reason for the increase and decrease in activity.

🔧 METHOD

The fact_transactions table has been used to call users and transactions executed on the Flow network. The token_transfers,swap, nft_sales, staking_actions, and bridge_transactions tables have been used to call active users on these platforms. And for case-by-case review of each activity, the corresponding table has been used.