Crypto-Pandas
CCXT DATA → PANDAS DATAFRAME IN JUST 1 LINE OF CODE
Crypto-Pandas fuses the power of Pandas with the market-connectivity of CCXT. It turns CCXT’s nested JSON into clean, typed DataFrames for analysis, backtests, or real-time dashboards — and lets you place/cancel live orders using the same DataFrame-centric API.
Why Crypto-Pandas?
1-liners, everywhere. Fetch OHLCV, tickers, trades, order books, balances, orders → all as DataFrames.
- Consistent columns & dtypes. Timestamps as UTC datetime64[ns, UTC], numeric columns as proper numerics.
- Zero boilerplate. Stop writing JSON-to-DataFrame glue for every exchange.
- CCXT-compatible. Keep your favorite CCXT params; just get DataFrames back.
Installation
Crypto-Pandas can be installed on Python 3.11~3.14:
pip install crypto-pandas
Examples
Find all examples in the Crypto-Pandas-Example Repository
Getting Started
Crypto-Pandas works near identically to CCXT. Just add exchange = CCXTPandasExchange(exchange=exchange)
and the exchange methods provided by CCXT will be exposed to Crypto-Pandas.
More examples can be found on Binder:
import ccxt
from crypto_pandas import CCXTPandasExchange
# Initialize a CCXTPandasExchange object
exchange = ccxt.binance(dict(apiKey="your_api_key_here", secret="your_secret_here"))
exchange = CCXTPandasExchange(exchange=exchange)
# OHLCV
ohlcv = exchange.fetch_ohlcv("BTC/USDT", timeframe="1m", limit=100) # -> DataFrame
# Trades
trades = exchange.fetch_trades("BTC/USDT", limit=1000) # -> DataFrame
# Orderbook
ob = exchange.fetch_order_book("BTC/USDT", limit=50) # -> DataFrame
# Tickers
tick = exchange.fetch_tickers() # -> DataFrame
# Fetch open orders from an exchange
open_orders = exchange.fetch_open_orders(symbol="BTC/USDT")
# Halve the amount and edit orders
open_orders["amount"] /= 2
response = exchange.edit_orders(open_orders)
# Display the transformed orders dataframe
print(response)
Documentation
For detailed documentation, visit the ReadTheDocs or read the API reference for advanced features.
About Sigma Quantiphi
Sigma Quantiphi is a quantitative-engineering firm that builds end-to-end algorithmic-trading systems for the cryptocurrency markets. We create open-source, Python-first tools—like crypto-pandas—and deliver turnkey execution, data, and research pipelines that emphasize simplicity, transparency, and rapid deployment.
License
This project is licensed under the Apache License. See the LICENSE file for more details.
Contributing
Contributions are welcome! If you'd like to contribute, please fork the repository, create a new branch for your feature or fix, and send a pull request.
- Fork the repository.
- Create your feature/fix branch:
git checkout -b my-new-feature. - Commit your changes:
git commit -am 'Add some feature'. - Push to the branch:
git push origin my-new-feature. - Submit a pull request.
Support
If you encounter any issues or have questions, feel free to open an issue on the GitHub repository or contact us via email at contact@sqphi.com. Happy trading! 🚀
Metadata
Release files for crypto-pandas 0.12.7
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| crypto_pandas-0.12.7.tar.gz | 21.4 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| crypto_pandas-0.12.7-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 49.6 kB
Release files / crypto_pandas-0.12.7.tar.gz
| Download URL | crypto_pandas-0.12.7.tar.gz |
|---|---|
| Size | 21.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
680a6c8b4801eb4bb4a331cba1242ff8c7f42f6f581cbce12192d24d984b84a8
|
|
BLAKE2b-256 checksum How to use checksums |
550964b6b4a22353ee3f60ace187d0abc1ba3101f7d2cadaddc476164f508f32
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/2.2.1 CPython/3.12.9 Windows/11
|
Release files / crypto_pandas-0.12.7-py3-none-any.whl
| Download URL | crypto_pandas-0.12.7-py3-none-any.whl |
|---|---|
| Size | 28.2 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
8ce82bb6a12712b239103de6ca433a0423380b98f2a458f616e7cf8d113c9f81
|
|
BLAKE2b-256 checksum How to use checksums |
52d90a977b45abdb599f5af31cde720b1d78994a252f3b7741bcf3e389dbceeb
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/2.2.1 CPython/3.12.9 Windows/11
|