The Calm Before Onchain Summertime with Base

This Dashboard provides data pertaining to Base Mainnet which launched for builders on July 13th, 2023. Included are total transactions, new and daily users, wallet and collection information.

Credits & Resources

Diamond

Twitter: https://twitter.com/DiamondNFL
Warpcast: https://warpcast.com/diam-nd
Discord: diam.nd or diam0nd#2971

Base

Main Website: https://base.org/
Twitter: https://twitter.com/buildonbase
Bridge Assets: https://bridge.base.org/
Base Docs: https://docs.base.org/
Base Explorer (Etherscan Backend): https://basescan.org/
Base Explorer (Alternative): https://base.blockscout.com/

Base: An Introduction

Base is a secure, low-cost, builder-friendly Ethereum L2 built using the OP Stack set to bring the next billion users onchain.

Base, an innovative initiative incubated within Coinbase, is strategically positioned to pave the way for a gradual and systematic decentralization strategy in the forthcoming years. This pioneering effort not only acts as a conduit for decentralized applications to harness the full spectrum of Coinbase's cutting-edge products and expansive distribution network, but also offers a seamless integration into the Coinbase ecosystem. With the added benefits of effortless Coinbase integrations, user-friendly fiat onramps, and the invaluable privilege of tapping into the extensive user base of millions of verified users within the Coinbase ecosystem, Base emerges as a transformative platform at the intersection of decentralization and mainstream accessibility.

Base is built on the Bedrock release of the OP Stack, which is designed from the ground up to be as close to Ethereum as possible. Because of this, there are very little differences when it comes to building on Base and Ethereum.

"We believe that decentralization is critical to creating an open, global cryptoeconomy that is accessible to everyone."

Set to launch August 9th, Coinbase announced their Onchain Summer that kicks off their public launch with a multi-week festival of onchain art, music, gaming, & more. Before this, on July13th Base opened up their mainnet for builders; including introducing the mint for “Base is for builders,” a commemorative NFT you can earn to celebrate the moment. I provide a look into the mint transactions and unique wallets in the "Base Transactions, Users & Collections" tab in this dashboard. The mint is open from July 13 - August 13th, and you can find the contract here.

Note: I am currently in the process of learning the foundational concepts of SQL. For me, this involves gaining proficiency in efficiently managing and manipulating data within the available tables. Additionally, I am focusing on refining the essential elements that contribute to the creation of informative and effective dashboards. Adding an extra layer of complexity to this challenge was the fact that I was working with a blockchain that I am not yet fully familiar with. I set a personal challenge for myself with this dashboard: to construct and create all relevant queries within it all in under a single day. I had the benefit of spending the previous day crash-coursing on every ounce of material I could find on Base.

Methodology

Data on transactions and users on Base Mainnet came from the following table:

base.core.fact_transactions

Data on Base <-> Eth Bridging comes from the following tables, and monitoring the Base Main contract at: 0x49048044d57e1c92a77f79988d21fa8faf74e97e

ethereum.core.ez_token_transfers
ethereum.core.fact_transactions