crypto_candles is giving data of wrong length and dates

[AndrewBworth]

crypto_candles is giving data of wrong length and dates

[canstralian]

import finnhub # Import the Finnhub API client
import pandas as pd
import datetime
import time

def get_valid_crypto_symbols(file_path):
"""Reads cryptocurrency symbols from a file and returns a list of valid symbols."""
valid_symbols = []
with open(file_path, 'r') as file:
for line in file:
symbol = line.strip() # Remove leading/trailing whitespaces
if symbol:
valid_symbols.append(symbol)
return valid_symbols

def fetch_crypto_data(client, symbol, start_timestamp, end_timestamp):
"""
Fetches cryptocurrency data for the given symbol within the specified time range.
Returns a pandas DataFrame containing the fetched data.
"""
try:
# Call Finnhub API to get cryptocurrency candles data
res = client.crypto_candles(symbol, 'D', start_timestamp, end_timestamp)
if 's' in res:
return pd.DataFrame(res['s']) # Convert the response to a DataFrame
else:
print(f"No data found for symbol {symbol}")
return None
except Exception as e:
print(f"Error fetching data for symbol {symbol}: {e}")
return None

def main():
# Define time range
start_time = datetime.datetime.now() - datetime.timedelta(days=200)
end_time = datetime.datetime.now()
start_timestamp = int(start_time.timestamp())
end_timestamp = int(end_time.timestamp())

# Initialize Finnhub client
api_key = "YOUR_API_KEY"  # Replace "YOUR_API_KEY" with your actual API key
client = finnhub.Client(api_key=api_key)

# Get valid cryptocurrency symbols from the file
crypto_symbols = get_valid_crypto_symbols("CryptoList.txt")

# Fetch data for each cryptocurrency symbol
for symbol in crypto_symbols:
    # Fetch data for the symbol
    crypto_data = fetch_crypto_data(client, symbol, start_timestamp, end_timestamp)
    if crypto_data is not None:
        # Process the fetched data or call other functions here
        print(f"Fetched data for {symbol}:")
        print(crypto_data.head())  # Just printing the first few rows for demonstration
        print()

    time.sleep(1)  # Add a delay to avoid hitting API rate limits

if name == "main":
main()