Name: Daily Crypto & Stocks Market Data
Creator: Kaggle
License: https://opendatacommons.org/licenses/by/1-0/index.html

About this Dataset

Daily Crypto & Stocks Market Data

This dataset contains hourly cryptocurrency and stock market data collected from coingecko
starting in mid-March 2025. The collection pipeline was designed to demonstrate practical data management and automation skills:

Data Ingestion: A Google AppScript automatically scrapes fresh hourly data from coingecko and writes it into Google Sheets.
Data Offloading: To avoid Google Sheets’ row limitations, Python scripts periodically export data from Sheets into Google BigQuery for cloud storage.
Data Publishing: The data is shared to Kaggle via a scheduled notebook, ensuring the dataset is updated hourly with the latest available records.

This setup provides a reliable, reproducible data stream that can be used for:

Practicing SQL queries for data extraction, filtering, and preparation before analysis.
Exploratory data analysis of crypto and stock price movements.
Building time-series forecasting models.
Studying correlations between global assets.
Demonstrating real-world ETL (Extract, Transform, Load) and data pipeline engineering.

The dataset is continuously updated daily, making it suitable both for live monitoring and historical trend analysis.

Need data at the intraday/hourly level? I’ve got you covered with a related dataset👉 Hourly Crypto & Stocks Market Data

Tables

Cryptocurrency

@kaggle.adrianjuliusaluoch_crypto_and_stock_market_for_financi_e39f95b2.cryptocurrency

2.24 MB
109,896 rows
9 columns

CREATE TABLE cryptocurrency (
  "timestamp" TIMESTAMP,
  "name" VARCHAR,
  "symbol" VARCHAR,
  "price_usd" VARCHAR,
  "vol_24h" VARCHAR,
  "total_vol" VARCHAR,
  "chg_24h" VARCHAR,
  "chg_7d" VARCHAR,
  "market_cap" VARCHAR
);

Stocks

@kaggle.adrianjuliusaluoch_crypto_and_stock_market_for_financi_e39f95b2.stocks

1.2 MB
165,038 rows
9 columns

CREATE TABLE stocks (
  "timestamp" TIMESTAMP,
  "name" VARCHAR,
  "last" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "chg" DOUBLE,
  "chg_1b51e2" VARCHAR  -- Chg %,
  "vol" VARCHAR,
  "time" VARCHAR
);