ClickHouse / ClickHouse/CryptoHouse
Enhance CryptoHouse with Multi-Blockchain Queries Using Blockchair Datasets
- Dominant language
- TypeScript
- Stars
- 68
- Forks
- 9
- PR merge metrics
- No merged PRs in 30d
Description
We at Blockchair use ClickHouse since our foundation in 2016. It is an absolute unit for web3 analytics which made our API functionally superior on the market. It would be great to see more blockchains in CryptoHouse.
**Describe the solution you'd like**
Integrating Blockchair and 3xpl datasets, which represent all events that have happened across 43 blockchains, could be beneficial for web3 analytics who use CryptoHouse. This integration would involve:
Adding new queries to the queries.json file for these new datasets. For instance, queries could be designed to analyze transaction volumes, average fees, mining stats and patterns across different blockchains, or to track token movements across chains (bridging/rollups), providing users with insights into cross-chain liquidity flows.
Developing new materialized views that pre-process and aggregate Blockchair data for high-demand queries, enhancing performance and user experience by speeding up data retrieval processes.
**Describe alternatives you've considered**
As an alternative to a full integration, we could implement a phased approach where only a subset of Blockchair's datasets for major blockchains is initially integrated to assess user engagement and technical stability. Or we can provide data for, let's say, last month, last 90 days or 1 year.
СС @alexey-milovidov @Har01d
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.