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
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 |
|
blast |
Blast |
|
bnb |
BNB |
|
bob |
BOB |
|
botanix |
Botanix |
|
cardano |
Cardano |
|
dash |
Dash |
|
digibyte |
DigiByte |
|
dogecoin |
Dogecoin |
|
ecash |
eCash |
|
ethereum |
Ethereum |
|
ethereum-classic |
Ethereum Classic |
|
fantom |
Fantom |
|
galactica-evm |
Galactica EVM |
|
gnosis-chain |
Gnosis Chain |
|
groestlcoin |
Groestlcoin |
|
handshake |
Handshake |
|
kusama |
Kusama |
|
linea |
Linea |
|
liquid-network |
Liquid Network |
|
litecoin |
Litecoin |
|
mantle |
Mantle |
|
merlin |
Merlin |
|
monero |
Monero |
|
moonbeam |
Moonbeam |
|
opbnb |
opBNB |
|
optimism |
Optimism |
|
peercoin |
Peercoin |
|
polkadot |
Polkadot |
|
polygon |
Polygon |
|
polygon-zkevm |
Polygon zkEVM |
|
rootstock |
Rootstock |
|
scroll |
Scroll |
|
sei-evm |
Sei EVM |
|
solana |
Solana |
|
stacks |
Stacks |
|
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.
