Dataset: Bitcoin

About this Dataset

Bitcoin

Context

Bitcoin is the longest-running and most well-known cryptocurrency, first released as open-source in 2009 by the anonymous Satoshi Nakamoto. Bitcoin serves as a decentralized medium of digital exchange, with transactions verified and recorded in a public distributed ledger (the blockchain) without the need for a trusted record-keeping authority or central intermediary. Transaction blocks contain an S SHA-256 cryptographic hash of previous transaction blocks and are thus "chained" together, serving as an immutable record of all transactions that have ever occurred.

Data Scraping

Bitcoin Data Scraping using Python link

Tables

Btc Data

@kaggle.taruntiwarihp_bitcoin.btc_data

13.96 MB
3488 rows
737 columns


CREATE TABLE btc_data (
  "date" TIMESTAMP,
  "priceusd" DOUBLE,
  "transactions" BIGINT,
  "size" DOUBLE,
  "sentbyaddress" BIGINT,
  "difficulty" DOUBLE,
  "hashrate" DOUBLE,
  "mining_profitability" DOUBLE,
  "sentinusdusd" DOUBLE,
  "transactionfeesusd" DOUBLE,
  "median_transaction_feeusd" DOUBLE,
  "confirmationtime" DOUBLE,
  "transactionvalueusd" DOUBLE,
  "mediantransactionvalueusd" DOUBLE,
  "activeaddresses" BIGINT,
  "top100cap" DOUBLE,
  "fee_to_rewardusd" DOUBLE,
  "transactions3sma" DOUBLE,
  "transactions7sma" DOUBLE,
  "transactions14sma" DOUBLE,
  "transactions30sma" DOUBLE,
  "transactions90sma" DOUBLE,
  "transactions3ema" DOUBLE,
  "transactions7ema" DOUBLE,
  "transactions14ema" DOUBLE,
  "transactions30ema" DOUBLE,
  "transactions90ema" DOUBLE,
  "transactions3wma" DOUBLE,
  "transactions7wma" DOUBLE,
  "transactions14wma" DOUBLE,
  "transactions30wma" DOUBLE,
  "transactions90wma" DOUBLE,
  "transactions3trx" DOUBLE,
  "transactions7trx" DOUBLE,
  "transactions14trx" DOUBLE,
  "transactions30trx" DOUBLE,
  "transactions90trx" DOUBLE,
  "transactions3mom" BIGINT,
  "transactions7mom" BIGINT,
  "transactions14mom" BIGINT,
  "transactions30mom" BIGINT,
  "transactions90mom" BIGINT,
  "transactions3std" DOUBLE,
  "transactions7std" DOUBLE,
  "transactions14std" DOUBLE,
  "transactions30std" DOUBLE,
  "transactions90std" DOUBLE,
  "transactions3var" DOUBLE,
  "transactions7var" DOUBLE,
  "transactions14var" DOUBLE,
  "transactions30var" BIGINT,
  "transactions90var" BIGINT,
  "transactions3rsi" DOUBLE,
  "transactions7rsi" DOUBLE,
  "transactions14rsi" DOUBLE,
  "transactions30rsi" DOUBLE,
  "transactions90rsi" DOUBLE,
  "transactions3roc" DOUBLE,
  "transactions7roc" DOUBLE,
  "transactions14roc" DOUBLE,
  "transactions30roc" DOUBLE,
  "transactions90roc" DOUBLE,
  "size3sma" DOUBLE,
  "size7sma" DOUBLE,
  "size14sma" DOUBLE,
  "size30sma" DOUBLE,
  "size90sma" DOUBLE,
  "size3ema" DOUBLE,
  "size7ema" DOUBLE,
  "size14ema" DOUBLE,
  "size30ema" DOUBLE,
  "size90ema" DOUBLE,
  "size3wma" DOUBLE,
  "size7wma" DOUBLE,
  "size14wma" DOUBLE,
  "size30wma" DOUBLE,
  "size90wma" DOUBLE,
  "size3trx" DOUBLE,
  "size7trx" DOUBLE,
  "size14trx" DOUBLE,
  "size30trx" DOUBLE,
  "size90trx" DOUBLE,
  "size3mom" DOUBLE,
  "size7mom" DOUBLE,
  "size14mom" DOUBLE,
  "size30mom" DOUBLE,
  "size90mom" DOUBLE,
  "size3std" DOUBLE,
  "size7std" DOUBLE,
  "size14std" DOUBLE,
  "size30std" DOUBLE,
  "size90std" DOUBLE,
  "size3var" DOUBLE,
  "size7var" BIGINT,
  "size14var" BIGINT,
  "size30var" BIGINT,
  "size90var" BIGINT,
  "size3rsi" DOUBLE,
  "size7rsi" DOUBLE,
  "size14rsi" DOUBLE
);