About this Dataset

Bitcoin Data With Indicators

`V3_Bitcoin_data.csv` is the latest version

Note: RSI(14) is added. Starting and ending date updated.

Columns:

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.

Future Works

July: Will add Exponential Moving Average - 20, 50, 200
August: Will add Bollinger Bands.

Tables

V3 Bitcoin Data

@kaggle.raimondextervinluan_bitcoindatamovingaverages.v3_bitcoin_data

171.02 KB
1826 rows
11 columns


CREATE TABLE v3_bitcoin_data (
  "date" VARCHAR,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" DOUBLE,
  "market_cap" DOUBLE,
  "ma_20" DOUBLE,
  "ma_50" DOUBLE,
  "ma_200" DOUBLE,
  "rsi_14_sma" DOUBLE
);