Bybit Trades Data Saver ClickHouse

Python script - Bybit Trades Data Saver using ClickHouse (ultra-fast solution for generating analytics)

Script will take the Trades data from Bybit REST API, save it to ClickHouse and then take it back from ClickHouse in JSON format.

Install

First install ClickHoouse:

sudo apt-get install apt-transport-https ca-certificates dirmngr

sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv E0C56BD4

echo "deb https://repo.clickhouse.tech/deb/stable/ main/" | sudo tee
/etc/apt/sources.list.d/clickhouse.list

sudo apt-get update

sudo apt-get install -y clickhouse-server clickhouse-client

And run it:

sudo service clickhouse-server start

clickhouse-client

Next create python virtual environment and activate it:

python3 -m venv .pb-ch && source .pb-ch/bin/activate

And then install necessary libraries:

pip install clickhouse-driver

pip install pandas

pip install pybit==2.4.1

---

📄 License

MIT License - Feel free to modify and distribute.

🤝 Contributing

Contributions, issues, and feature requests are welcome! Feel free to check issues page.

⚠️ Disclaimer

This project is for informational and educational purposes only. You should not use this information or any other material as legal, tax, investment, financial, or other advice. Nothing contained here is a recommendation, endorsement, or offer by me to buy or sell any securities or other financial instruments.

If you intend to use real money, use it at your own risk.

Under no circumstances will I be responsible or liable for any claims, damages, losses, expenses, costs, or liabilities of any kind, including but not limited to direct or indirect damages for loss of profits.

---

📞 Contact Me

I develop trading bots of any complexity, dashboards, and indicators for crypto exchanges, forex, and stocks. 🚀

To contact me, please send a message:

• Telegram: https://t.me/ryu8777 ✈️
• Discord: https://discord.gg/zSw58e9Uvf 🤝

---

🤝 Become My Crypto Partner

Start your trading journey on Bybit! Join using my referral link below:

Join Bybit: https://www.bybit.com/invite?ref=P11NJW

---

🖥️ VPS for Your Bots and Scripts

Keep your bots running 24/7! I prefer and recommend using DigitalOcean.

Get $200 in credit over 60 days by using my referral link:

👉 https://m.do.co/c/3d7f6e57bc04