# CryptoHouse

**Repository Path**: mirrors_ClickHouse/CryptoHouse

## Basic Information

- **Project Name**: CryptoHouse
- **Description**: Artifacts including queries and materialized views used for CryptoHouse
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-08-01
- **Last Updated**: 2026-01-31

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# CryptoHouse

![Crypto UI](./cryptohouse.png)

This repository contains the example queries and materialized views used for [CryptoHouse](https://crypto.clickhouse.com). Users can raise UI issues in this repository, request Materialized views, and suggest example queries.

**The process to deploy example queries and materialized views is currently manual. We intend to automate this process.**

## Contributing example queries

Fork this repository and raise a PR on the [queries.json](./queries.json) file. Once the PR is approved, this query will be deployed to the ClickHouse instance (currently manually).

## Reporting UI or Performance issues with CryptoHouse

Raise an issue in this repository using the relevant template.

## Requesting a Materialized View

Materialized views can be used to accelerate specific queries. We will consider adding materialized views if they are generic and can be used across a number of queries. Please raise a "Request Materialized View" issue in this repository.

## Direct connections

Users can connect directly to the ClickHouse instance using the [ClickHouse Client](https://clickhouse.com/docs/en/interfaces/cli).

```bash
clickhouse client --host crypto-clickhouse.clickhouse.com --secure --user crypto --password ''
```

## Load queries

```bash
export CLICKHOUSE_URL=https://crypto-clickhouse.clickhouse.com
export CLICKHOUSE_PASSWORD=<password>

npm run load_queries
```