This query calculates daily transaction counts for two different sources (flow.core.fact_transactions
and flow.core_evm.fact_transactions
) and compares these counts across consecutive days. It outputs the total transaction count per day, the difference from the previous day, the percentage change, and a cumulative transaction total.
The output provides a detailed view of daily transaction trends, highlighting fluctuations and offering a clear cumulative summary. It enables analysis of growth patterns and volatility in transactions across days and identifies notable increases or decreases with the percentage difference calculation.
Flow is a layer one blockchain with a next-gen smart contract language (Cadence) and full EVM equivalence (any Solidity, smart contract, or protocol that works on Ethereum or an EVM L2 works on Flow). The network was designed to enable consumer crypto applications that scale to mainstream audiences and seamlessly connect to digital ecosystems. It is based on a unique, multi-role architecture, and designed to scale without sharding, allowing for massive improvements in speed and throughput while preserving a developer-friendly, ACID-compliant environment.
Flow is the only blockchain designed from the ground up for consumer applications, empowering developers to build innovative projects that scale to massive audiences at low cost.
Flow is architected with a clear vision for the future of consumer crypto, and meticulously designed to address the shortcomings of earlier blockchains to ensure scalability, usability, and efficiency are not simply an afterthought. By incorporating critical protocol-level primitives, such as account abstraction and on-chain randomness, as well a powerful transaction model and scalability without sharding, Flow sets itself apart as a blockchain made for those interested in building apps for widespread adoption and developer-friendly innovation. To date, over 45-million consumer accounts have connected to experiences from the NBA, NFL, and Disney on Flow.
Flow is creating an open ecosystem where where software developers, content creators, and consumers alike are appropriately incentivized and rewarded for the value they contribute to the network
Flow encourages developers to innovate and build without facing the challenges of high fees and network congestion experienced on other blockchains. Developers on Flow enjoy both a great user experience and access to liquidity and infrastructure. The Flow ecosystem includes transformative features like user-friendly wallets, wallet-less onboarding, and sponsored transactions — facilitating a smoother user experience and encouraging broader adoption.
For more information on the Flow blockchain check out their Primer.
This dashboard will explore Flow blockchains's recent Crescendo upgrade introducing EVM equivalence, along with Cadence. Below is a list of metrics featured in this dashboard:
• Transactions including EVM and Cadence
• Active wallets including EVM and Cadence
• Accounts created over-time
• Fees over-time
• Token supply including staked, locked, circulating, liquid and total
• Contracts deployed and deployers
-
Website: https://www.flow.com
-
Twitter: https://twitter.com/flow_blockchain
-
Discord: http://chat.onflow.org/
-
Github: https://github.com/onflow
-
Status Page: https://status.onflow.org/
-
Flow Blockchain Roadmap: https://flow.com/flow-roadmap
-
Flow Blockchain Forum: https://forum.flow.com/
-
Flow Blockchain Primer: https://flow.com/primer
-
Flow Blockchain Primer: PDF