ClickHouse API

Clickhouse API provides access to data stored in the OLAP database.

ClickHouse® is a high-performance, column-oriented SQL database for online analytical processing (OLAP).

General information

Host: olap.3xpl.net
Ports:
- 70: ClickHouse native TCP interface
- 71: HTTP based interface
Every connection or request requires username and password
Basiс limit per user is 1 SQL request per second and doesn't depend on the connection method

Connection methods

using ClickHouse CLI client
- clickhouse client -h olap.3xpl.net --port 70 --user=... --password=...
using HTTP Interface
- HTTP service is available at http://olap.3xpl.net:71
- Playground is available at http://olap.3xpl.net:71/play
using BI & data visualisation tools
- ClickHouse support connect to the most popular BI and data visualisation tools such as Grafana, Tableau, Metabase and others. Full list provided at https://clickhouse.com/docs/en/integrations/data-visualization
using integrations with third-party services, clouds, programming languages
- https://clickhouse.com/docs/en/integrations

Table structure

Data available in different formats supported by ClickHouse https://clickhouse.com/docs/en/integrations/data-formats

Database contains the table events with following columns:

column	type	description
`blockchain`	string	blockchain where events happened
`module`	string	module that handled the event
`block`	integer	block in which an event transaction was included
`transaction`	string	hash of the transaction containing the event
`sort_key`	integer	sorting within block
`time`	string / date	time when event happened
`address`	string	address affected by event
`currency`	string	currency of the event
`sign`	integer	sign of effect
`effect`	string	transferred amount
`valid`	integer	is event valid (not failed)
`extra`	string	some additional information about the event
`extra_indexed`	string	–

Available blockchains

Every row contains {blockchain} field.
You can get list of available blockchains directly from api main stats endpoint: https://api.3xpl.com/ (API token required)

List of available blockchains

Id	Title
aptos	Aptos
arbitrum-one	Arbitrum One
avalanche	Avalanche
base	Base
beacon-chain	Beacon Chain
bitcoin	Bitcoin
bitcoin-cash	Bitcoin Cash
bnb	BNB
bob	BOB
botanix	Botanix
cardano	Cardano
dash	Dash
digibyte	DigiByte
dogecoin	Dogecoin
ecash	eCash
ethereum	Ethereum
ethereum-classic	Ethereum Classic
fantom	Fantom
gnosis-chain	Gnosis Chain
groestlcoin	Groestlcoin
handshake	Handshake
kusama	Kusama
linea	Linea
liquid-network	Liquid Network
litecoin	Litecoin
monero	Monero
moonbeam	Moonbeam
opbnb	opBNB
optimism	Optimism
peercoin	Peercoin
polkadot	Polkadot
polygon	Polygon
polygon-zkevm	Polygon zkEVM
rootstock	Rootstock
sei-evm	Sei EVM
solana	Solana
stellar	Stellar
ton	TON
tron	TRON
xrp-ledger	XRP Ledger
zcash	Zcash
zksync-era	zkSync Era

How to get access to data services

Join our Discord server and go to the #faq section, where you can find authorization credentials and keys. We provide free access to data services for students and academics.