Tokens OHLC price

Description

This dataset contains each 4 days historical price data for various cryptocurrencies, sourced from the CoinGecko API. It includes data fields such as Open, High, Low, Close, and token The dataset is structured with date and token as its primary key, enabling chronological analysis of cryptocurrency price movements. This dataset can be merged with the Top pools APY per protocol dataset for combined financial analysis.

Collection method

Data is retrieved each 4 days from the CoinGecko API, which provides historical and current price data for a range of cryptocurrencies. The API is utilized to gather opening, highest, lowest, and closing prices.

Schema

• date: The date for the price data.

• Open: Opening price of the cryptocurrency on the given date.

• High: Highest price of the cryptocurrency on the given date.

• Low: Lowest price of the cryptocurrency on the given date.

• Close: Closing price of the cryptocurrency on the given date.

• token: Identifier of the cryptocurrency.

The dataset uses date and token as the primary key.

Potential Use Cases

• Price Trend Analysis: Analyzing the historical price trends of cryptocurrencies.

• Combining with Yield Data: Merging this price data with the "APY top pools per project" dataset for a comprehensive financial analysis of cryptocurrency market trends and DeFi yields.

• Investment Analysis: Utilizing historical price data to inform cryptocurrency investment and trading strategies.

• Cryptocurrency Market Research: Providing a dataset for researchers to examine market behaviors and price fluctuations in cryptocurrencies.

Use example

from giza.datasets import DatasetsLoader

# Usage example:
loader = DatasetsLoader()
df = loader.load('tokens-ohcl')

df.head()

date	Open	High	Low	Close	token
2019-02-03	3438.3604	3472.2433	3438.3604	3461.0583	"WBTC"
2019-02-07	3468.16	3486.4073	3425.8603	3425.8603	"WBTC"
2019-02-11	3387.7629	3770.3402	3387.7629	3770.3402	"WBTC"
2019-02-15	3605.9233	3652.9015	3605.5237	3605.5237	"WBTC"
2019-02-19	3613.8624	3831.385	3613.8624	3831.385	"WBTC"