PREVIEW / stock_1hour / 2005-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-09-14.parquet
  size:    568 KB
  rows:    27,249
  symbols: 2,063

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-09-14 08:00:00	AAPL	Stock	1.8107	1.835	1.8107	1.825	1604400.0
2005-09-14 09:00:00	AAPL	Stock	1.8254	1.8286	1.8089	1.8104	57617532.0
2005-09-14 10:00:00	AAPL	Stock	1.8107	1.825	1.8093	1.82	70298648.0
2005-09-14 11:00:00	AAPL	Stock	1.8204	1.8243	1.8161	1.8161	34139140.0
2005-09-14 12:00:00	AAPL	Stock	1.8157	1.8161	1.8036	1.81	43229676.0
2005-09-14 13:00:00	AAPL	Stock	1.8096	1.8136	1.7996	1.8018	39845848.0
2005-09-14 14:00:00	AAPL	Stock	1.8018	1.8043	1.7732	1.7732	89547332.0
2005-09-14 15:00:00	AAPL	Stock	1.7732	1.7846	1.7665	1.7718	115451840.0
2005-09-14 16:00:00	AAPL	Stock	1.7718	1.8282	1.7718	1.7764	4645564.0
2005-09-14 17:00:00	AAPL	Stock	1.7768	1.7779	1.7714	1.7779	186732.0
2005-09-14 18:00:00	AAPL	Stock	1.7768	1.7786	1.7768	1.7786	85316.0
2005-09-14 08:00:00	MSFT	Stock	26.5	26.51	26.48	26.51	13770.0
2005-09-14 09:00:00	MSFT	Stock	26.52	26.55	26.46	26.5	5667249.0
2005-09-14 10:00:00	MSFT	Stock	26.5	26.64	26.5	26.54	9088855.0
2005-09-14 11:00:00	MSFT	Stock	26.55	26.57	26.48	26.54	4627907.0
2005-09-14 12:00:00	MSFT	Stock	26.54	26.62	26.52	26.59	5107103.0
2005-09-14 13:00:00	MSFT	Stock	26.58	26.59	26.48	26.5	5588294.0
2005-09-14 14:00:00	MSFT	Stock	26.5	26.52	26.39	26.44	6853066.0
2005-09-14 15:00:00	MSFT	Stock	26.43	26.43	26.3	26.3	13992237.0
2005-09-14 16:00:00	MSFT	Stock	26.32	26.57	26.28	26.32	474441.0
2005-09-14 17:00:00	MSFT	Stock	26.32	26.34	26.3	26.33	647560.0
2005-09-14 18:00:00	MSFT	Stock	26.34	26.34	26.3	26.32	2800.0
2005-09-14 08:00:00	NVDA	Stock	0.275	0.275	0.275	0.275	102000.0
2005-09-14 09:00:00	NVDA	Stock	0.2746	0.2763	0.2727	0.2746	52581720.0
2005-09-14 10:00:00	NVDA	Stock	0.2747	0.2758	0.2743	0.2752	61785000.0
2005-09-14 11:00:00	NVDA	Stock	0.2751	0.277	0.2749	0.2759	51264360.0
2005-09-14 12:00:00	NVDA	Stock	0.2759	0.2763	0.275	0.2757	58934400.0
2005-09-14 13:00:00	NVDA	Stock	0.2757	0.2763	0.274	0.2742	39797160.0
2005-09-14 14:00:00	NVDA	Stock	0.2742	0.2747	0.2708	0.2721	105009720.0
2005-09-14 15:00:00	NVDA	Stock	0.2721	0.2722	0.271	0.2722	103854960.0
2005-09-14 16:00:00	NVDA	Stock	0.2744	0.2753	0.2718	0.2718	553680.0
2005-09-14 17:00:00	NVDA	Stock	0.2727	0.2727	0.2721	0.2721	17880000.0
2005-09-14 18:00:00	NVDA	Stock	0.2719	0.2738	0.2719	0.2738	492840.0
2005-09-14 09:00:00	AMZN	Stock	2.2055	2.2205	2.169	2.17	10374360.0
2005-09-14 10:00:00	AMZN	Stock	2.17	2.1825	2.165	2.1705	14271760.0
2005-09-14 11:00:00	AMZN	Stock	2.17	2.2365	2.1695	2.1905	16318860.0
2005-09-14 12:00:00	AMZN	Stock	2.1895	2.1895	2.168	2.1705	6605780.0
2005-09-14 13:00:00	AMZN	Stock	2.1715	2.1805	2.148	2.1545	14724980.0
2005-09-14 14:00:00	AMZN	Stock	2.1545	2.1545	2.141	2.145	18153060.0
2005-09-14 15:00:00	AMZN	Stock	2.1445	2.1665	2.142	2.155	26571980.0
2005-09-14 16:00:00	AMZN	Stock	2.1555	2.1575	2.1543	2.1575	225300.0
2005-09-14 17:00:00	AMZN	Stock	2.152	2.155	2.152	2.155	16376720.0
2005-09-14 09:00:00	CL	Stock	26.285	26.395	26.242	26.36	235600.0
2005-09-14 10:00:00	CL	Stock	26.365	26.435	26.16	26.2	686000.0
2005-09-14 11:00:00	CL	Stock	26.2	26.255	26.185	26.255	310200.0
2005-09-14 12:00:00	CL	Stock	26.255	26.285	26.21	26.25	233400.0
2005-09-14 13:00:00	CL	Stock	26.245	26.3	26.21	26.285	327600.0
2005-09-14 14:00:00	CL	Stock	26.275	26.3	26.205	26.23	366400.0
2005-09-14 15:00:00	CL	Stock	26.23	26.295	26.175	26.265	539000.0

> showing 49 of 27,249 rows — these rows as CSV

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