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
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.
The Exploration page shows the reader how to explore the contents of the database, what are the available tables and what is their structure.
The Writing SQL queries page guides the reader through writing their first SQL query.