Introducing Santiment Queries

Overview

At Santiment we make heavy use of Clickhouse, a blazing fast column-oriented database, where we store on-chain, financial, social and development activity data. Apart from storing data, Clickhouse is capable of doing complex calculations and aggregations on millions of rows of data. This makes it a perfect tool to power your research.

Santiment Queries is an online web tool giving access to a Clickhouse cluster, containing our datasets.

Basic SQL knowledge is required to use the tool. In case you have no experience, you can follow the very short Clickhouse Tutorial

Access

Santiment Queries can be found at https://app.santiment.net/queries. Anonymous users can browse the public dashboards. Logged in users can create public and private dashboards.

Exploration

The Exploration page shows the reader how to explore the contents of the database, what are the available tables and what is their structure.

Writing your first SQL Query

The Writing SQL queries page guides the reader through writing their first SQL query.