We are excited to announce that we have added support for querying Uniswap data on Ethereum. This means that users can now ask any questions they have about general Defi analytics like Total Value Locked (TVL), liquidity, volume, and fees for Uniswap pools.
Here are some examples of the types of questions users can ask:
- “What is the total value locked in the WETH/DAI Uniswap pool?”
- “What is the 7-day moving average volume for the UNI/USDC pool?”
- “What is the 24-hour change in liquidity for the UNI/USDT pool?”
- “What is the total fee collected by the WBTC/WETH pool in the last month?”
By providing a simple, user-friendly interface and natural language processing, our platform makes it easy for you to analyze Uniswap data and make sense of the complex DeFi ecosystem. This can help you to gain a deeper understanding of the DeFi ecosystem, track the performance of your favorite pools, and stay on top of the latest trends in the rapidly evolving world of decentralized finance. So why wait? Start exploring Uniswap data now and see what insights you can uncover!
As part of our commitment to constantly improving and innovating for our users, we’re excited to announce the release of a new feature that allows you to track the live state of your smart contracts on Ethereum and Celo.
Querying the live state of your contracts directly from SQL is much easier and more efficient than using traditional APIs. It allows you to access real-time data without having to worry about API limitations or the overhead of making multiple API calls. Plus, with this feature, you’ll have a clear, concise view of your contract data, making it easier to track and manage your contracts.
But the power of this feature doesn’t stop there. By using sub-queries, you can even call smart contracts directly from within your SQL queries. This allows you to join existing data with the live state of your contracts, unlocking even more insights and use cases. For example, you can use this feature to find all wallets meeting certain conditions and check those wallet balances by reading the live state from the smart contract.
Whether you’re a developer looking to stay on top of your contract data, or a user interested in keeping an eye on your contracts, this feature is sure to be a game-changer. For more information on how to use this feature, check out our documentation at https://docs.makerdojo.io/reference/read-contract-state. Then, visit https://makerdojo.io to give it a try and let us know what you think.
We’re always looking for ways to improve and make your experience with web3 even better. We hope this new feature helps you manage your smart contracts with ease. Happy contract tracking!
We are excited to announce the launch of a new AI engine for Celo on MakerDojo that unlocks a faster and more powerful engine to help our users get Web3 insights. Here are some highlights:
- Ask any question: You can ask questions about almost anything on Celo – ranging from NFTs, and Defi, to custom questions about smart contracts data.
- Fast: New engine will be blazing fast.
- Real-time: Anything published on blockchain will be available on MakerDojo within a second.
- Enriched Data: We have added many second-level tables to the data set to make it easier to query. Read more about the data set here in docs.
- Embedded Docs: You can see in-place documentation for tables and columns by clicking on the question mark icon.
We invite you all to try out the engine and get as many insights as quickly as possible. And we wish you happy holidays while you explore the data.
Blockchains support a lot of diverse use cases like NFTs, DeFi, DAOs etc., through DAPPs and smart contracts. Most smart contracts store an immutable state on the blockchain in a blockchain-specific data format.
These datasets on blockchains are in the order of several terabytes growing by several gigabytes daily. From a data analytics perspective, these datasets offer valuable insights into smart contracts. These insights help with several things. To name a few:
- Make DeFi / NFT trading decisions
- Track the performance of the smart contracts for data-driven development
- Share critical info stored by smart contracts in a transparent and verifiable way with the community
Accessing the data is technically challenging as it takes specialized skills to handle large amounts of data. And it’s complex as it takes a deep understanding of the implementation details of a smart contract to translate blockchain-specific data format to relevant high-level concepts. Because of the challenges, it often takes a team of data engineers within a Web3 company to build custom data pipelines for them to draw insights.
MakerDojo solves this problem by offering a conversational analytics platform where interested users can draw insights without needing technical skills. Users can ask for insights in spoken English on the platform and get relevant plots back as an answer. After which, users can add those plots to dashboards that can be private, public, or embedded. MakerDojo also offers advanced use cases like setting alerts on data trends, joining the on-chain data with off-chain private datasets, etc.
At MakerDojo, we believe that data is critical to building great products. As Web3 sees wider adoption, we would like to help the ecosystem by enabling anyone to draw insights from blockchain data through our platform.
PS: 0th block on any blockchain is called the Genesis Block, and this post is the genesis post of several to come.