PREVIEW / stock_1hour / 2005-11-11

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-11.parquet
  size:    558 KB
  rows:    26,383
  symbols: 2,098

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2005-11-11 07:00:00	AAPL	Stock	2.1854	2.1854	2.1854	2.1854	43540.0
2005-11-11 08:00:00	AAPL	Stock	2.1857	2.1929	2.1782	2.1911	1274308.0
2005-11-11 09:00:00	AAPL	Stock	2.1911	2.2168	2.1875	2.2089	106750840.0
2005-11-11 10:00:00	AAPL	Stock	2.2089	2.2182	2.2	2.2061	102759776.0
2005-11-11 11:00:00	AAPL	Stock	2.2057	2.2179	2.1996	2.2011	69886740.0
2005-11-11 12:00:00	AAPL	Stock	2.2007	2.2082	2.1936	2.2	35820932.0
2005-11-11 13:00:00	AAPL	Stock	2.2	2.2011	2.1932	2.2011	29035804.0
2005-11-11 14:00:00	AAPL	Stock	2.2011	2.2054	2.1961	2.1986	26450676.0
2005-11-11 15:00:00	AAPL	Stock	2.1986	2.2018	2.1907	2.1989	43976660.0
2005-11-11 16:00:00	AAPL	Stock	2.1961	2.1993	2.1914	2.1975	2495780.0
2005-11-11 17:00:00	AAPL	Stock	2.1921	2.2048	2.1921	2.1954	252000.0
2005-11-11 18:00:00	AAPL	Stock	2.1954	2.1954	2.1914	2.1921	167636.0
2005-11-11 06:00:00	MSFT	Stock	27.22	27.22	27.12	27.12	3000.0
2005-11-11 08:00:00	MSFT	Stock	27.12	27.19	27.12	27.16	1688136.0
2005-11-11 09:00:00	MSFT	Stock	27.16	27.25	27.12	27.22	5913628.0
2005-11-11 10:00:00	MSFT	Stock	27.23	27.35	27.21	27.34	10038172.0
2005-11-11 11:00:00	MSFT	Stock	27.34	27.39	27.2	27.35	9470610.0
2005-11-11 12:00:00	MSFT	Stock	27.35	27.36	27.29	27.29	4843830.0
2005-11-11 13:00:00	MSFT	Stock	27.3	27.33	27.28	27.31	4157393.0
2005-11-11 14:00:00	MSFT	Stock	27.31	27.32	27.26	27.31	5546824.0
2005-11-11 15:00:00	MSFT	Stock	27.31	27.35	27.25	27.28	8660957.0
2005-11-11 16:00:00	MSFT	Stock	27.28	27.43	27.25	27.35	818917.0
2005-11-11 17:00:00	MSFT	Stock	27.33	27.39	27.31	27.34	29400.0
2005-11-11 18:00:00	MSFT	Stock	27.34	27.34	27.33	27.34	3000.0
2005-11-11 08:00:00	NVDA	Stock	0.2801	0.2814	0.28	0.2814	210000.0
2005-11-11 09:00:00	NVDA	Stock	0.2814	0.2859	0.2807	0.2839	101206800.0
2005-11-11 10:00:00	NVDA	Stock	0.2839	0.2857	0.2802	0.2852	121516080.0
2005-11-11 11:00:00	NVDA	Stock	0.2852	0.287	0.2827	0.2835	89715480.0
2005-11-11 12:00:00	NVDA	Stock	0.2837	0.2857	0.2827	0.283	67438800.0
2005-11-11 13:00:00	NVDA	Stock	0.283	0.2847	0.2807	0.2818	46090440.0
2005-11-11 14:00:00	NVDA	Stock	0.2817	0.2838	0.2812	0.2835	35873640.0
2005-11-11 15:00:00	NVDA	Stock	0.2834	0.2845	0.2832	0.2835	70478520.0
2005-11-11 16:00:00	NVDA	Stock	0.2834	0.2837	0.2812	0.2837	2224320.0
2005-11-11 17:00:00	NVDA	Stock	0.2833	0.2833	0.2833	0.2833	184560.0
2005-11-11 09:00:00	AMZN	Stock	2.1115	2.152	2.1115	2.1395	17935000.0
2005-11-11 10:00:00	AMZN	Stock	2.139	2.1465	2.127	2.1385	12458820.0
2005-11-11 11:00:00	AMZN	Stock	2.139	2.15	2.1325	2.14	15833140.0
2005-11-11 12:00:00	AMZN	Stock	2.14	2.1415	2.1305	2.138	5717300.0
2005-11-11 13:00:00	AMZN	Stock	2.1385	2.143	2.136	2.1425	5119160.0
2005-11-11 14:00:00	AMZN	Stock	2.1425	2.1475	2.134	2.1385	6223160.0
2005-11-11 15:00:00	AMZN	Stock	2.1381	2.1445	2.131	2.1355	14292700.0
2005-11-11 16:00:00	AMZN	Stock	2.134	2.1395	2.134	2.1395	136480.0
2005-11-11 17:00:00	AMZN	Stock	2.134	2.134	2.134	2.134	36000.0
2005-11-11 08:00:00	CL	Stock	26.825	26.825	26.825	26.825	1400.0
2005-11-11 09:00:00	CL	Stock	26.815	26.83	26.735	26.77	311200.0
2005-11-11 10:00:00	CL	Stock	26.78	26.8	26.655	26.7	383200.0
2005-11-11 11:00:00	CL	Stock	26.7	26.805	26.6755	26.79	389400.0
2005-11-11 12:00:00	CL	Stock	26.805	26.86	26.78	26.79	193400.0
2005-11-11 13:00:00	CL	Stock	26.795	26.83	26.755	26.8	201200.0
2005-11-11 14:00:00	CL	Stock	26.805	26.85	26.792	26.82	295800.0

> showing 50 of 26,383 rows — these rows as CSV

> unlock the full archive -- $79 one-time