This document provides introductory research about Substreams and The Graph. It discusses the concept of Substreams, the potential ways to export data from the blockchain, and the tools and resources available for developers. It also mentions the collaboration between Pinax Network, StreamingFast, and other teams in developing data sinks and loaders. The document includes links to additional resources and videos for further exploration.
Welcome
This article provides introductory research about Substreams and The Graph. Please note that this article is an early work in progress and will be updated soon. Enjoy!
Table of Contents
- Welcome
- Resources
- How to get the on-chain data to notion
- Firehose and Substreams
- Pinax, StreamingFast, and The Graph
- Google Sheets + Antelope Substreams + Notion API
- dFuse
- Watch Videos about Substreams and the Graph Protocol
- Research into Pinax Network
- CSV file export from bloks and JSON Conversion
- Related Posts
Resources
How to get the on-chain data to notion
It seems like it should be very simple to get the data as its not much, though blockchains can be complex. It can be done manually easily and confirmed by weekly review and agreement (ie like each delegate or signatory agrees during weekly msig proposal or meeting in a minute). So it might not be necessary to automate this anytime soon and it’s better to focus more on getting it set up in notion than the blockchain integration
There are interesting ways to export the data from the blockchain which might be easy to do. These are good to explore and learn about in general and will be increasingly necessary to scale up the cignals app to many people in the long term.
Some options that may help include:
- Pinax / The Graph
- Wharfkit
- Could see blue papers
- Other SDKs and APIs?
Firehose and Substreams
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fee121a72-f825-4b74-b594-ce907d1bd377%2FUntitled.png?id=33ce72e1-9fe7-48a1-a587-08a4b5475f40&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F86c6f9bb-ead4-4f64-ac70-7bafc508baf4%2FUntitled.png?id=f15c3e2f-93a6-4ea0-8526-dcb3da864d4e&table=block)
telegram chatbot
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F53cdf3e5-901e-4d4e-86fb-ea9a949e9633%2FUntitled.png?id=cb19a801-b903-482e-b5cc-34efe659cab8&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fd9e3fdf8-f5b8-415f-a907-023789a9b96e%2FUntitled.png?id=3b8070bc-3548-4e5c-937d-e077b3e71ba6&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F5127b505-f909-402c-bb20-8bb43f3826c8%2FUntitled.png?id=30a00881-c8ca-4cf6-a412-1d4c4e86eb2b&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F74ed9872-fcd8-459a-bd22-7bd45e723a7e%2FUntitled.png?id=3541b9c6-8f40-4cae-8518-ceff4da534e3&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F1a408994-b535-4c4b-a2b2-6e31938f33cf%2FUntitled.png?id=4da77f31-b4ed-4539-b273-789b5eead747&table=block)
Pinax, StreamingFast, and The Graph
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F41756c08-e20a-4ad9-96c3-ee91c0864a5b%2FUntitled.png?id=821f16da-0232-4de7-8fc0-919939deea18&table=block)
Most notably, the number of data sinks (or data loaders) have increased, thanks for the efforts of multiple teams:
- Pinax Network released: Prometheus, Winston, CSV file and a Google Sheets sink!
- Messari is about to release a Parquet files sink, and together with the other files options made available now provides ingestion into BigQuery, Clickhouse, Redshift and other large scale MPP engines
- Edge & Node is about to release: graph-node integration for Substreams-based Subgraphs
- We, StreamingFast, released: Postgres, Key/value store, MongoDB, CSV & JSON Files
Many thanks to those who have contributed to the ecosystem of tools, provided feedback or beta-tested the software this year:
- Pinax Networks, along with their contribution of multiple sinks, being the first to host the Substreams runtime, and their ownership and maintenance of a full blown Firehose integration for Antelope.
Google Sheets + Antelope Substreams + Notion API
This can work now.
dFuse
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fd9227668-1484-40c0-982c-4e74c995c39b%2FUntitled.png?id=dc850629-9b51-46fd-a65d-b873f94f7020&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F909a290a-f397-4d0a-9b49-346e50acf13e%2FUntitled.png?id=14d1cd07-d82e-428a-9813-9501e1ef5bfe&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F9b68b4c3-e3a1-4197-bdea-25c60cee76aa%2FUntitled.png?id=b86b6a5a-73c4-47b2-830b-812b635f0ae8&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F1512b1a8-0a08-46b8-9368-fcf5e6ca9f7c%2FUntitled.png?id=4de62a70-4b9c-435d-8828-3b2c2089d9a4&table=block)
https://docs.dfuse.eosnation.io/
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F4e9cf827-80e1-45a1-8aa9-aeed472e65c7%2FUntitled.png?id=a0b8469e-5c93-4ea0-8d56-39d80bd92229&table=block)
Watch this:
https://substreams.streamingfast.io/
https://substreams.streamingfast.io/concepts-and-fundamentals/benefits
Watch this:
https://github.com/pinax-network/substreams-antelope
https://docs.rs/substreams-antelope/latest/substreams_antelope/
https://github.com/pinax-network/firehose-antelope
https://github.com/pinax-network/awesome-substreams
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F0462f03e-3742-4b4b-a9cc-e9e0dba1dbbd%2FUntitled.png?id=bcb6bb8d-697f-44a0-9cef-3a891b60caaa&table=block)
🔥Get ready to learn about Firehose and Substreams, two powerful tools for developers working with blockchain technology! In this workshop, Matthew Darwin of Pinax introduces these tools and explains why they are essential for processing and managing the massive amount of data that will come with the future of blockchain technology. 🚀Firehose provides a scalable and stable interface for developers and indexers to handle this data more efficiently. It's currently available for several blockchains, including Ethereum, Solana, Near, Cosmos, and more. 🎨Matthew also dives into the architecture of Firehose and introduces Substreams, a feature that allows developers to extract and transform specific data from blockchains in a more efficient and customizable manner. Substreams are composable, parameterizable, transformable, and parallelizable, and can be built on top of each other like Lego blocks. 👨💻Overall, this workshop provides a comprehensive introduction to Firehose and Substreams and highlights their potential for revolutionizing the way developers work with blockchain technology. At Pinax, we're passionate about building tools and technologies that empower developers and accelerate innovation. Download all slides of the presentation as a PDF here:
https://drive.google.com/file/d/1F5h1...
Originally this presentation was held for the Learning Series of The Graph Advocates. If you're passionate about The Graph Protocol we highly recommend to get in touch with them and sign upop to join. -
https://www.graphadvocates.com/
🐦Connect with us on Twitter at
https://twitter.com/PinaxNetwork
to stay up-to-date on our latest developments and get involved in the conversation. Don't miss out on this exciting opportunity to learn about the future of blockchain technology! 🔮
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F7778e61a-57e1-4bc9-8327-e6ff8d57c4d2%2FUntitled.png?id=3f585a58-bcce-4298-9484-9fc8bf9420d0&table=block)
Pinax is EOS Nation
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Faf76c5c1-c51f-48ea-a645-98380e92ceb9%2FUntitled.png?id=2c5882bb-00cc-45b9-9307-e52f4dfbe9a5&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fd30ab52e-0230-4320-ab75-22e3655db839%2FUntitled.png?id=b3df0c44-78e0-496c-8009-ec9a357f6ff9&table=block)
EOS Canada built firehose and substreams
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F0983db65-275f-425d-a30e-4d35df32d05e%2FUntitled.png?id=9243ea30-9907-453e-b380-07a02f34feda&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F924b7d35-e174-4a48-943a-1c9134ecc46b%2FUntitled.png?id=9a3d3d4c-0b79-4017-a4bc-fa195495da25&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F51016696-cc78-40e0-89a9-a55f5f47c3d5%2FUntitled.png?id=e0463079-02d7-432a-8596-af3453acaa69&table=block)
non-developers can access substreams easily if it’s been built already
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fb0aac70b-832c-44b5-a31f-cbe1c541dd27%2FUntitled.png?id=59892fa8-6dfe-4921-9fab-c32e9467f9e9&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fc9f1c4b2-9df7-4891-aab1-c9e26b72393d%2FUntitled.png?id=3f32b850-4d49-4a81-8bf6-ced637bae494&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fdd8b784e-fea0-46dd-9d8c-7aa12175c70d%2FUntitled.png?id=f3f736e5-71f4-4b34-8fe9-e38ef9f438d8&table=block)
different colors of boxes are different authors. boxes are substreams
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F289b7996-cc28-48a8-9e02-0e26af8cb3e9%2FUntitled.png?id=d98f4a86-761d-4f5a-8985-60b08d5d27a3&table=block)
substreams can export data in any format
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F4a7c6b23-6ff3-4d3f-ba53-4bce25a137c2%2FUntitled.png?id=6ccd5da8-06f1-4bf3-ac60-18c936f02df2&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F049d9b39-12fd-453a-b1ee-007eb765db44%2FUntitled.png?id=ae4be6ca-c2a7-483a-ba57-a3fa5f18836b&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F2859cd23-e0b8-4359-8192-e49c0e0d5060%2FUntitled.png?id=4788df64-5b1c-49d8-bf63-a0e2a35abf11&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F86c6f9bb-ead4-4f64-ac70-7bafc508baf4%2FUntitled.png?id=413236d9-9dc5-49e2-aae7-90c6c0a78d6b&table=block)
telegram chatbot
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F53cdf3e5-901e-4d4e-86fb-ea9a949e9633%2FUntitled.png?id=dd5b26eb-1862-4909-b45f-f3e91e3df217&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fd9e3fdf8-f5b8-415f-a907-023789a9b96e%2FUntitled.png?id=a809b63f-e89d-43a5-8ed8-0f24e8b0295a&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F5127b505-f909-402c-bb20-8bb43f3826c8%2FUntitled.png?id=fe030a98-f013-432d-b05f-340efa59ec52&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F74ed9872-fcd8-459a-bd22-7bd45e723a7e%2FUntitled.png?id=fa8aaca4-1096-45ee-baa1-be965a5abe40&table=block)
![image](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F90673938-7cfe-4658-bf25-01f9522d54a1%2FUntitled.png?id=584692e2-d49e-4fb4-a617-9172e7ed9fa0&table=block)
Watch Videos about Substreams and the Graph Protocol
https://www.youtube.com/@dfuse4326/featured
It seems like Pinax is using the Substreams tech created by streaming fast to export filterable data to google spreadsheets. They built a plugin and it seems like it works well.
Discover the amazing potential of Substreams for Google Sheets in this detailed tutorial and demo. Learn how to access and analyze blockchain data such as token prices, transaction volumes, and on-chain activity, all within your favorite spreadsheet editor! This powerful tool offers customization, flexibility, and speed for a seamless experience. Stay tuned for future updates and developments, and join us in revolutionizing blockchain data analysis!
0:00- Introduction
0:29- Blockchain Data Use-Cases
2:40- Advantages
2:56- Demo
6:41- Google Data Studio
9:05- Project Next Steps
10:07- Conclusion & Resources
Research into Pinax Network
Martin B is the CMO of Pinax, so it might make sense to reach out to him about this. Daniel Keyes is the CEO. Can see their twitter accounts and see its often what they post about
Yaniv is co-founder of The Graph, big deal:
CSV file export from bloks and JSON Conversion
Bloks has can export csv files
perhaps vlad or other antelope devs can build JSON reciever software similar to how james mart built it