PREVIEW / stock_1hour / 2003-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-04-24.parquet
  size:    423 KB
  rows:    21,054
  symbols: 1,559

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-24 08:00:00	AAPL	Stock	0.2423	0.2423	0.2411	0.2411	33600.0
2003-04-24 09:00:00	AAPL	Stock	0.2427	0.243	0.2402	0.2404	31780560.0
2003-04-24 10:00:00	AAPL	Stock	0.2405	0.2409	0.2366	0.2375	48796608.0
2003-04-24 11:00:00	AAPL	Stock	0.2377	0.2389	0.2364	0.2371	25586960.0
2003-04-24 12:00:00	AAPL	Stock	0.2371	0.2384	0.2366	0.2378	11345712.0
2003-04-24 13:00:00	AAPL	Stock	0.2379	0.2388	0.237	0.2388	23840936.0
2003-04-24 14:00:00	AAPL	Stock	0.2388	0.2413	0.2388	0.2409	21514024.0
2003-04-24 15:00:00	AAPL	Stock	0.2409	0.2418	0.2321	0.2402	102280640.0
2003-04-24 16:00:00	AAPL	Stock	0.2402	0.2407	0.2393	0.2402	2525600.0
2003-04-24 17:00:00	AAPL	Stock	0.24	0.24	0.24	0.24	504000.0
2003-04-24 08:00:00	MSFT	Stock	25.58	25.72	25.5	25.529	90860.0
2003-04-24 09:00:00	MSFT	Stock	25.529	25.71	25.32	25.65	8427654.0
2003-04-24 10:00:00	MSFT	Stock	25.64	25.7	25.44	25.51	8408195.0
2003-04-24 11:00:00	MSFT	Stock	25.52	25.54	25.4	25.48	5040636.0
2003-04-24 12:00:00	MSFT	Stock	25.48	25.51	25.41	25.48	2841139.0
2003-04-24 13:00:00	MSFT	Stock	25.49	25.55	25.4	25.489	4508395.0
2003-04-24 14:00:00	MSFT	Stock	25.489	25.66	25.43	25.58	6606283.0
2003-04-24 15:00:00	MSFT	Stock	25.59	25.68	25.47	25.5	6580368.0
2003-04-24 16:00:00	MSFT	Stock	25.5	25.68	25.42	25.569	638793.0
2003-04-24 17:00:00	MSFT	Stock	25.569	25.59	25.49	25.541	36625.0
2003-04-24 18:00:00	MSFT	Stock	25.55	25.55	25.54	25.54	4700.0
2003-04-24 08:00:00	NVDA	Stock	0.1182	0.1182	0.1182	0.1182	60000.0
2003-04-24 09:00:00	NVDA	Stock	0.1195	0.1209	0.1173	0.1181	159168120.0
2003-04-24 10:00:00	NVDA	Stock	0.118	0.1187	0.1175	0.1178	70471800.0
2003-04-24 11:00:00	NVDA	Stock	0.1178	0.1178	0.1157	0.1165	122001960.0
2003-04-24 12:00:00	NVDA	Stock	0.1165	0.1173	0.1165	0.1169	43371360.0
2003-04-24 13:00:00	NVDA	Stock	0.1169	0.1171	0.1168	0.117	35710560.0
2003-04-24 14:00:00	NVDA	Stock	0.117	0.1191	0.117	0.1185	66204960.0
2003-04-24 15:00:00	NVDA	Stock	0.1185	0.1188	0.1172	0.1173	85184400.0
2003-04-24 16:00:00	NVDA	Stock	0.1173	0.1175	0.1169	0.1172	6652200.0
2003-04-24 17:00:00	NVDA	Stock	0.1173	0.1175	0.1172	0.1172	924000.0
2003-04-24 18:00:00	NVDA	Stock	0.1175	0.1175	0.1171	0.1171	160200.0
2003-04-24 08:00:00	AMZN	Stock	1.28	1.28	1.26	1.26	356500.0
2003-04-24 09:00:00	AMZN	Stock	1.2635	1.2765	1.258	1.266	19643620.0
2003-04-24 10:00:00	AMZN	Stock	1.267	1.2815	1.25	1.2515	37585140.0
2003-04-24 11:00:00	AMZN	Stock	1.2515	1.2545	1.2385	1.252	26533360.0
2003-04-24 12:00:00	AMZN	Stock	1.2525	1.2645	1.2475	1.263	13699600.0
2003-04-24 13:00:00	AMZN	Stock	1.2635	1.269	1.251	1.265	12755920.0
2003-04-24 14:00:00	AMZN	Stock	1.2655	1.2677	1.2558	1.2625	10728060.0
2003-04-24 15:00:00	AMZN	Stock	1.262	1.2695	1.2485	1.256	55076520.0
2003-04-24 16:00:00	AMZN	Stock	1.2565	1.4049	1.255	1.4049	106493800.0
2003-04-24 17:00:00	AMZN	Stock	1.4045	1.4365	1.256	1.4275	47641280.0
2003-04-24 18:00:00	AMZN	Stock	1.4275	1.4295	1.415	1.4205	4285100.0
2003-04-24 09:00:00	CL	Stock	28.66	28.66	28.555	28.585	485200.0
2003-04-24 10:00:00	CL	Stock	28.59	28.75	28.565	28.615	555200.0
2003-04-24 11:00:00	CL	Stock	28.615	28.645	28.58	28.58	603200.0
2003-04-24 12:00:00	CL	Stock	28.58	28.64	28.565	28.64	240600.0
2003-04-24 13:00:00	CL	Stock	28.645	28.7	28.59	28.68	226600.0
2003-04-24 14:00:00	CL	Stock	28.685	28.69	28.595	28.635	395400.0
2003-04-24 15:00:00	CL	Stock	28.635	28.69	28.55	28.615	634800.0

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

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