Data types

Decimals

All decimal data is represented as 256 bits decimals with 76 digits precision and 20 decimal digits. Because this precision is higher than most tokens this allows us to transmit to user the exact numbers as received from the exchange without any rounding.

Depending on the users need ( speed vs precision ) they can convert them to float either on the server side in the query on directly in their code once the data was received.

More information about the clickhouse decimal types : https://clickhouse.com/docs/sql-reference/data-types/decimal