Here are what the fields mean first_activity_date
:
The date when a user first interacted with the Flow blockchain.
Used to identify user cohorts and calculate retention.
activity_date
:The date of the recorded activity.
Used to track daily metrics and trends over time.
days_since_first_activity
:The number of days between a user's first activity and the current activity.
Crucial for analyzing user retention and engagement patterns over time.
active_users
:The count of unique users who performed any activity on a given day.
Helps track daily active user (DAU) metrics.
total_transactions
:The total number of transactions performed on a given day.
Indicates overall blockchain activity and usage.
total_gas_limit
:The sum of gas limits set for all transactions on a given day.
Useful for understanding network capacity utilization.
avg_active_addresses
:The average number of unique addresses that were active in a given day.
Provides a measure of network participation.
avg_transactions
:The average number of transactions per active address on a given day.
Indicates user engagement levels.
avg_fees_native
:The average transaction fee in the native blockchain currency.
Useful for tracking network costs in the native token.
avg_fees_usd
:The average transaction fee converted to USD.
Provides a standardized measure of transaction costs
Flow user retention is decreasing and activities as a whole are stagnating.
But overall the daily transaction is picking up slowly and steadily with the average fee remaining the lowest since last month.
I didn't had enough time to add all of the graphs I wanted so below will explain the fields and what to do if you decide to fork this yourself
Adjust the time range to suit your analysis needs if you want.
Once again I have a particular preference and only did it monthly
I wanted only successful transactions so I did some filtering for them using the (tx_succeeded = TRUE