Ehdtd - cryptoCurrency Exchange history data to database
Project description
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 columnstatus
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.
- If
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.
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
ehdtd-0.2.8.tar.gz
(26.0 kB
view details)
Built Distribution
ehdtd-0.2.8-py3-none-any.whl
(27.4 kB
view details)
File details
Details for the file ehdtd-0.2.8.tar.gz
.
File metadata
- Download URL: ehdtd-0.2.8.tar.gz
- Upload date:
- Size: 26.0 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/5.1.1 CPython/3.9.2
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 893fe6b331fba7fa6366ece23be011a136ad9f23555df459a656bc775b788595 |
|
MD5 | 98e963694da192c87a28cb7e49864073 |
|
BLAKE2b-256 | d859bcb084f27d5f6874d0d98f4ac62f4d1da6659e8f56518bb68f073cc15090 |
File details
Details for the file ehdtd-0.2.8-py3-none-any.whl
.
File metadata
- Download URL: ehdtd-0.2.8-py3-none-any.whl
- Upload date:
- Size: 27.4 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/5.1.1 CPython/3.9.2
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 87b3e8f470253b2490c34dd9beba64426a1073da38444bbf7b8dd9370c8d9e99 |
|
MD5 | 9dbb4e581c03cfbc2017cc6071ff24e3 |
|
BLAKE2b-256 | bc9b2314ee6b89fae9b6700a887ce6a75995ebaac3aa58f7574461be67a89b4b |