Ehdtd - cryptoCurrency Exchange history data to database

This class retrieves historical data from exchanges and stores it in a database.

Example:

Install

```bash
pip install ehdtd
```

Use

```python
import time
from ehdtd import Ehdtd

exchange = 'binance'
symbol = 'BTC/USDT'
interval = '1m'
limit = 10

db_data = {
    'db_type': 'postgresql',  # postgresql, mysql
    'db_name': 'ehdtd',
    'db_user': 'ehdtd',
    'db_pass': 'xxxxxxxxx',
    'db_host': '127.0.0.1',
    'db_port': '5432'
}

fetch_data = [
    {
        'symbol': symbol,
        'interval': interval
    }
]

ehd = Ehdtd(exchange, fetch_data, db_data)  # Create an instance
ehd.start()  # Start fetching data

time.sleep(900)  # First time Wait for available data, for the data to be updated,
                 # you must wait between 90 minutes and 2.5 hours depending on the interval

for v in fetch_data:
    symbol = v['symbol']
    interval = v['interval']
    start_from = 0
    until_to = None
    return_type = 'pandas'
    data_db = ehd.get_data_from_db(symbol, interval, start_from, until_to, return_type)
    print(data_db)
    print('=========================================================================')
    print('')
    time.sleep(1)

ehd.stop()  # Stop fetching data
```

How It Works:

For Binance:

Try to retrieve data from a file. Check this link:
Binance Public Data
If the file is not available, try to retrieve data from the API.
Then get data from the WebSocket API using the Ccxw class.

Database Columns:

open_time, open_date, open_price, close_time, close_date, close_price, low, high, volume, exchange, symbol, interval, status, data
Column data is not used,
and column status can have three values: '__NON_CHECK__', '__OK__', '__ERROR__'.
- If status == '__OK__', the file has consistent data.
- If status == '__ERROR__', the file has inconsistent data.
- If status == '__NON_CHECK__', the file is not analyzed.

Retrieving Data from Database:

Use the function ehd.get_data_from_db(symbol, interval, start_from, until_to, return_type):

If return_type == 'pandas', it returns a Pandas DataFrame.
If return_type == 'list', it returns a list of dictionaries.

View License

Metadata

Release files for ehdtd 0.2.42

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for ehdtd 0.2.42
File	Size	Uploaded
ehdtd-0.2.42.tar.gz	43.0 kB	Sep 28, 2026	Details

Built distribution (wheel)

Table of built distributions (wheels) for ehdtd 0.2.42
File	Interpreter	ABI	Platform	Reset
ehdtd-0.2.42-py3-none-any.whl 53.2 kB Sep 28, 2026	Python 3	none	any	Details

Total release size: 96.3 kB

Release files / ehdtd-0.2.42.tar.gz

Download URL	ehdtd-0.2.42.tar.gz
Size	43.0 kB
Tags	Source
SHA-256 checksum How to use checksums	`b18cfedadf00c09a9129e3d968fba6ed809d64a818368762797ae35f4605a283`
BLAKE2b-256 checksum How to use checksums	`a83f5f0e6e35c91fd207907fc6db5a1f6758daabcb28e290ac00ae287888831e`
Upload date	Sep 28, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/7.0.0 CPython/3.13.5`

Release files / ehdtd-0.2.42-py3-none-any.whl

Download URL	ehdtd-0.2.42-py3-none-any.whl
Size	53.2 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`2f4b3e86c654535a47ee7645d504b042eaec2f78b92f3e9917833d3a990dfeb9`
BLAKE2b-256 checksum How to use checksums	`0d508284dae980045df0aed4ac8662b84d1c3c8a8061c0d96791b8d15196e56e`
Upload date	Sep 28, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/7.0.0 CPython/3.13.5`