Spaces:
Sleeping
Sleeping
import requests | |
import pandas as pd | |
# Your API Key (you need to replace 'YOUR_API_KEY' with your actual CryptoCompare API key) | |
api_key = '1606c591d78cde143733502669d97c3707d94637e2c32c3184bef54a2a1653d2' | |
# The base URL for the CryptoCompare API | |
base_url = 'https://min-api.cryptocompare.com/data/v2/histohour' | |
# Parameters for the API call | |
# In this example, we are getting hourly data for Bitcoin (BTC) priced in USD | |
parameters = { | |
'fsym': 'BTC', | |
'tsym': 'USD', | |
'limit': 2000, # The maximum number of data points you can get in one call is 2000 | |
'api_key': api_key | |
} | |
# Make the API call | |
response = requests.get(base_url, params=parameters) | |
# Check if the request was successful | |
if response.status_code == 200: | |
# Parse the received JSON data | |
data = response.json() | |
# Extract the data points | |
data_points = data['Data']['Data'] | |
# Create a DataFrame from the data points | |
df = pd.DataFrame(data_points) | |
# Convert timestamps to human-readable dates | |
df['time'] = pd.to_datetime(df['time'], unit='s') | |
# Save the DataFrame to a CSV file | |
df.to_csv('crypto_hourly_data.csv', index=False) | |
print(df) | |
#print("Data extraction successful, saved to crypto_hourly_data.csv") | |
else: | |
print(f"Failed to fetch data: {response.status_code}") | |
# Make sure to install pandas and requests modules if you haven't already | |
# pip install pandas requests |