Anonymized Yandex.Metrica Data

The dataset consists of two tables, either of them can be downloaded as a compressed file or as prepared partitions. In addition to that, an extended version of the hits table containing 100 million rows is available as TSV at https://datasets.clickhouse.tech/hits/tsv/hits_100m_obfuscated_v1.tsv.xz and as prepared partitions at .

Download and import visits:

Download and import visits from compressed tsv-file:

Additional examples of queries to these tables can be found among stateful tests of ClickHouse (they are named and test.visits there).