PREVIEW / stock_1hour / 2003-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-04-23.parquet
  size:    432 KB
  rows:    21,541
  symbols: 1,568

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
2003-04-23 08:00:00	AAPL	Stock	0.2414	0.2414	0.2414	0.2414	1338400.0
2003-04-23 09:00:00	AAPL	Stock	0.2414	0.2421	0.2388	0.2411	32540760.0
2003-04-23 10:00:00	AAPL	Stock	0.2411	0.2421	0.2388	0.242	28301056.0
2003-04-23 11:00:00	AAPL	Stock	0.242	0.2429	0.24	0.2411	32945528.0
2003-04-23 12:00:00	AAPL	Stock	0.2411	0.2432	0.2411	0.243	25736928.0
2003-04-23 13:00:00	AAPL	Stock	0.243	0.2432	0.2416	0.242	24446240.0
2003-04-23 14:00:00	AAPL	Stock	0.242	0.2429	0.2413	0.2427	16268000.0
2003-04-23 15:00:00	AAPL	Stock	0.2427	0.2434	0.2414	0.2427	21264320.0
2003-04-23 16:00:00	AAPL	Stock	0.2425	0.2445	0.2414	0.2425	1058400.0
2003-04-23 17:00:00	AAPL	Stock	0.2425	0.2425	0.2425	0.2425	39200.0
2003-04-23 08:00:00	MSFT	Stock	25.755	25.9	25.75	25.79	123292.0
2003-04-23 09:00:00	MSFT	Stock	25.79	25.82	25.53	25.7	8014637.0
2003-04-23 10:00:00	MSFT	Stock	25.69	25.77	25.47	25.71	8123521.0
2003-04-23 11:00:00	MSFT	Stock	25.72	25.8	25.62	25.8	5688178.0
2003-04-23 12:00:00	MSFT	Stock	25.8	25.99	25.79	25.901	6570347.0
2003-04-23 13:00:00	MSFT	Stock	25.901	25.925	25.61	25.67	4892519.0
2003-04-23 14:00:00	MSFT	Stock	25.67	25.78	25.59	25.74	5371219.0
2003-04-23 15:00:00	MSFT	Stock	25.75	25.79	25.54	25.73	8812658.0
2003-04-23 16:00:00	MSFT	Stock	25.71	25.74	25.65	25.72	1007983.0
2003-04-23 17:00:00	MSFT	Stock	25.72	25.73	25.57	25.57	134780.0
2003-04-23 18:00:00	MSFT	Stock	25.65	25.65	25.63	25.63	7000.0
2003-04-23 08:00:00	NVDA	Stock	0.1187	0.1187	0.1187	0.1187	60000.0
2003-04-23 09:00:00	NVDA	Stock	0.1179	0.119	0.1171	0.1189	79711800.0
2003-04-23 10:00:00	NVDA	Stock	0.1189	0.1193	0.1175	0.1192	110037000.0
2003-04-23 11:00:00	NVDA	Stock	0.1192	0.1202	0.1187	0.1202	58144680.0
2003-04-23 12:00:00	NVDA	Stock	0.1202	0.1212	0.1199	0.1208	94906920.0
2003-04-23 13:00:00	NVDA	Stock	0.1209	0.121	0.1191	0.1195	67728120.0
2003-04-23 14:00:00	NVDA	Stock	0.1195	0.1212	0.1192	0.1208	42498120.0
2003-04-23 15:00:00	NVDA	Stock	0.1207	0.1216	0.1202	0.1212	95257560.0
2003-04-23 16:00:00	NVDA	Stock	0.1211	0.1217	0.1203	0.1212	2919120.0
2003-04-23 17:00:00	NVDA	Stock	0.1207	0.1208	0.1203	0.1204	624000.0
2003-04-23 18:00:00	NVDA	Stock	0.1204	0.1204	0.1203	0.1203	144000.0
2003-04-23 08:00:00	AMZN	Stock	1.31	1.325	1.2795	1.3	1435400.0
2003-04-23 09:00:00	AMZN	Stock	1.304	1.3275	1.29	1.3095	26971300.0
2003-04-23 10:00:00	AMZN	Stock	1.3095	1.31	1.285	1.2935	26888700.0
2003-04-23 11:00:00	AMZN	Stock	1.293	1.2935	1.273	1.2835	24141320.0
2003-04-23 12:00:00	AMZN	Stock	1.284	1.2925	1.275	1.29	17061620.0
2003-04-23 13:00:00	AMZN	Stock	1.2895	1.2905	1.2705	1.2775	17205460.0
2003-04-23 14:00:00	AMZN	Stock	1.279	1.28	1.2745	1.278	11139080.0
2003-04-23 15:00:00	AMZN	Stock	1.2775	1.278	1.268	1.2695	25395940.0
2003-04-23 16:00:00	AMZN	Stock	1.2695	1.3035	1.267	1.267	2780620.0
2003-04-23 17:00:00	AMZN	Stock	1.2675	1.2715	1.2672	1.268	408000.0
2003-04-23 18:00:00	AMZN	Stock	1.271	1.271	1.271	1.271	66000.0
2003-04-23 09:00:00	CL	Stock	28.535	28.54	28.38	28.415	440400.0
2003-04-23 10:00:00	CL	Stock	28.41	28.425	28.3	28.335	653400.0
2003-04-23 11:00:00	CL	Stock	28.335	28.555	28.325	28.51	628400.0
2003-04-23 12:00:00	CL	Stock	28.51	28.62	28.5	28.55	389200.0
2003-04-23 13:00:00	CL	Stock	28.55	28.62	28.54	28.585	249000.0
2003-04-23 14:00:00	CL	Stock	28.585	28.66	28.575	28.65	386200.0
2003-04-23 15:00:00	CL	Stock	28.645	28.725	28.62	28.695	631800.0

> showing 50 of 21,541 rows — these rows as CSV

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