Bitcoin Data With Indicators
Indicators available for now: Moving Averages are 20, 50, and 200. RSI - 14
@kaggle.raimondextervinluan_bitcoindatamovingaverages
Indicators available for now: Moving Averages are 20, 50, and 200. RSI - 14
@kaggle.raimondextervinluan_bitcoindatamovingaverages
V3_Bitcoin_data.csv is the latest versionNote: RSI(14) is added. Starting and ending date updated.
Date: Date when the data is applicable
Open: The opening price of Bitcoin at the start of the day
High: The highest price of Bitcoin within the day
Low: The lowest price of Bitcoin within the day
*Close:*The closing price of Bitcoin at the end of the day. Sometimes the closing price is the opening price of the next day.
Volume: The total amount of Bitcoin traded on that day
Market Cap: The current supply of coins multiplied by the current market price of one coin yields the market capitalization of an asset (Additional resources: Coinbase, ByBit, CoinMarketCap)
MA(20) - The average of all closing prices from 20 days ago
MA(50) - The average of all closing prices from 50 days ago
MA(200) - The average of all closing prices from 200 days ago
RSI(14) - The rate of change in price changes (Additional Resources: Investopedia, CFI, Fidelity
Suggestions are highly appreciated. Put them on the Discussion tab.
CREATE TABLE v3_bitcoin_data (
"date" VARCHAR,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"volume" DOUBLE,
"market_cap" DOUBLE,
"ma_20" DOUBLE -- MA(20),
"ma_50" DOUBLE -- MA(50),
"ma_200" DOUBLE -- MA(200),
"rsi_14_sma" DOUBLE -- RSI(14)(SMA)
);Anyone who has the link will be able to view this.