PREVIEW / stock_1hour / 2005-10-18

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-10-18.parquet
  size:    570 KB
  rows:    27,344
  symbols: 2,088

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-10-18 08:00:00	AAPL	Stock	1.9107	1.9107	1.8707	1.9061	1316756.0
2005-10-18 09:00:00	AAPL	Stock	1.9032	1.9211	1.8957	1.9154	79898504.0
2005-10-18 10:00:00	AAPL	Stock	1.9146	1.9268	1.9007	1.9054	132311760.0
2005-10-18 11:00:00	AAPL	Stock	1.9057	1.9121	1.8907	1.8946	72853452.0
2005-10-18 12:00:00	AAPL	Stock	1.895	1.8971	1.8896	1.8896	42038780.0
2005-10-18 13:00:00	AAPL	Stock	1.8896	1.8907	1.8693	1.8843	87451364.0
2005-10-18 14:00:00	AAPL	Stock	1.8843	1.8911	1.87	1.8746	68326972.0
2005-10-18 15:00:00	AAPL	Stock	1.8743	1.9168	1.8643	1.8654	106423968.0
2005-10-18 16:00:00	AAPL	Stock	1.865	1.8766	1.8614	1.8639	6881252.0
2005-10-18 17:00:00	AAPL	Stock	1.8675	1.8952	1.8589	1.8696	794584.0
2005-10-18 18:00:00	AAPL	Stock	1.8661	1.8661	1.8661	1.8661	16800.0
2005-10-18 08:00:00	MSFT	Stock	24.56	24.56	24.5	24.54	36846.0
2005-10-18 09:00:00	MSFT	Stock	24.55	24.63	24.45	24.58	6858797.0
2005-10-18 10:00:00	MSFT	Stock	24.59	24.69	24.56	24.68	12951880.0
2005-10-18 11:00:00	MSFT	Stock	24.68	24.83	24.64	24.68	11217557.0
2005-10-18 12:00:00	MSFT	Stock	24.672	24.74	24.67	24.7	3610056.0
2005-10-18 13:00:00	MSFT	Stock	24.7	24.72	24.64	24.69	7601984.0
2005-10-18 14:00:00	MSFT	Stock	24.69	24.77	24.65	24.65	6656813.0
2005-10-18 15:00:00	MSFT	Stock	24.66	24.69	24.56	24.57	18518629.0
2005-10-18 16:00:00	MSFT	Stock	24.57	24.63	24.45	24.46	363938.0
2005-10-18 17:00:00	MSFT	Stock	24.45	24.52	24.45	24.52	3790.0
2005-10-18 18:00:00	MSFT	Stock	24.56	24.56	24.5	24.5	316400.0
2005-10-18 09:00:00	NVDA	Stock	0.2698	0.271	0.2647	0.2648	28071960.0
2005-10-18 10:00:00	NVDA	Stock	0.2648	0.2678	0.2647	0.2664	65198400.0
2005-10-18 11:00:00	NVDA	Stock	0.2666	0.2675	0.2652	0.2654	30037200.0
2005-10-18 12:00:00	NVDA	Stock	0.2654	0.2669	0.2654	0.2666	16553400.0
2005-10-18 13:00:00	NVDA	Stock	0.2666	0.2666	0.2633	0.2646	39508680.0
2005-10-18 14:00:00	NVDA	Stock	0.2645	0.265	0.2637	0.2639	26223000.0
2005-10-18 15:00:00	NVDA	Stock	0.2639	0.2662	0.2637	0.2651	88131120.0
2005-10-18 16:00:00	NVDA	Stock	0.2651	0.2654	0.2633	0.2634	1179840.0
2005-10-18 17:00:00	NVDA	Stock	0.2633	0.2659	0.2613	0.2613	1116000.0
2005-10-18 08:00:00	AMZN	Stock	2.251	2.2575	2.248	2.248	36000.0
2005-10-18 09:00:00	AMZN	Stock	2.2425	2.2525	2.231	2.236	13702800.0
2005-10-18 10:00:00	AMZN	Stock	2.236	2.2425	2.221	2.231	15432420.0
2005-10-18 11:00:00	AMZN	Stock	2.231	2.25	2.231	2.238	11447060.0
2005-10-18 12:00:00	AMZN	Stock	2.239	2.245	2.23	2.243	7181560.0
2005-10-18 13:00:00	AMZN	Stock	2.2425	2.243	2.226	2.239	9899780.0
2005-10-18 14:00:00	AMZN	Stock	2.238	2.241	2.2235	2.23	8897180.0
2005-10-18 15:00:00	AMZN	Stock	2.2295	2.241	2.215	2.2325	19954620.0
2005-10-18 16:00:00	AMZN	Stock	2.231	2.2445	2.2185	2.2325	352100.0
2005-10-18 17:00:00	AMZN	Stock	2.2295	2.2354	2.225	2.225	366000.0
2005-10-18 18:00:00	AMZN	Stock	2.223	2.223	2.223	2.223	2000.0
2005-10-18 09:00:00	CL	Stock	26.0	26.03	25.875	25.925	306800.0
2005-10-18 10:00:00	CL	Stock	25.94	26.04	25.9	25.955	275800.0
2005-10-18 11:00:00	CL	Stock	25.965	26.11	25.954	26.07	295400.0
2005-10-18 12:00:00	CL	Stock	26.065	26.135	26.06	26.115	239400.0
2005-10-18 13:00:00	CL	Stock	26.12	26.155	26.01	26.12	393000.0
2005-10-18 14:00:00	CL	Stock	26.13	26.2	26.09	26.145	271800.0
2005-10-18 15:00:00	CL	Stock	26.15	26.2	26.085	26.085	758200.0
2005-10-18 18:00:00	CL	Stock	26.055	26.055	26.055	26.055	56600.0

> showing 50 of 27,344 rows — these rows as CSV

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