PREVIEW / stock_1hour / 2003-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-04-25.parquet
  size:    410 KB
  rows:    20,787
  symbols: 1,562

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-25 08:00:00	AAPL	Stock	0.2393	0.2393	0.2393	0.2393	1624000.0
2003-04-25 09:00:00	AAPL	Stock	0.2384	0.242	0.2384	0.2415	25892608.0
2003-04-25 10:00:00	AAPL	Stock	0.2416	0.2425	0.2384	0.2392	46180232.0
2003-04-25 11:00:00	AAPL	Stock	0.2393	0.2393	0.2363	0.2391	29201592.0
2003-04-25 12:00:00	AAPL	Stock	0.2391	0.2402	0.2386	0.2392	21091840.0
2003-04-25 13:00:00	AAPL	Stock	0.2393	0.2398	0.2386	0.2393	12917184.0
2003-04-25 14:00:00	AAPL	Stock	0.2393	0.2396	0.238	0.2389	17733632.0
2003-04-25 15:00:00	AAPL	Stock	0.2391	0.2396	0.2375	0.2377	33613664.0
2003-04-25 16:00:00	AAPL	Stock	0.2384	0.2388	0.2375	0.2384	912800.0
2003-04-25 17:00:00	AAPL	Stock	0.2384	0.2384	0.2384	0.2384	50400.0
2003-04-25 08:00:00	MSFT	Stock	25.23	25.495	25.18	25.28	354792.0
2003-04-25 09:00:00	MSFT	Stock	25.27	25.56	25.241	25.5	6934032.0
2003-04-25 10:00:00	MSFT	Stock	25.49	25.644	25.37	25.411	9730270.0
2003-04-25 11:00:00	MSFT	Stock	25.41	25.44	25.34	25.38	5514339.0
2003-04-25 12:00:00	MSFT	Stock	25.38	25.45	25.347	25.41	4433401.0
2003-04-25 13:00:00	MSFT	Stock	25.41	25.46	25.31	25.32	4397760.0
2003-04-25 14:00:00	MSFT	Stock	25.33	25.378	25.2599	25.33	6463282.0
2003-04-25 15:00:00	MSFT	Stock	25.33	25.37	25.17	25.22	8690589.0
2003-04-25 16:00:00	MSFT	Stock	25.22	25.24	25.15	25.2	680278.0
2003-04-25 17:00:00	MSFT	Stock	25.18	25.3726	25.18	25.18	40400.0
2003-04-25 18:00:00	MSFT	Stock	25.19	25.2	25.19	25.2	1006.0
2003-04-25 08:00:00	NVDA	Stock	0.1162	0.1162	0.1152	0.1152	492000.0
2003-04-25 09:00:00	NVDA	Stock	0.1162	0.1186	0.1147	0.1152	77819040.0
2003-04-25 10:00:00	NVDA	Stock	0.1153	0.1157	0.1127	0.1127	131680680.0
2003-04-25 11:00:00	NVDA	Stock	0.1128	0.1157	0.112	0.1121	184172880.0
2003-04-25 12:00:00	NVDA	Stock	0.1122	0.1127	0.1118	0.1123	93738840.0
2003-04-25 13:00:00	NVDA	Stock	0.1123	0.1137	0.1121	0.1124	124717920.0
2003-04-25 14:00:00	NVDA	Stock	0.1124	0.1127	0.1122	0.1122	45512760.0
2003-04-25 15:00:00	NVDA	Stock	0.1122	0.1129	0.1122	0.1127	118656840.0
2003-04-25 16:00:00	NVDA	Stock	0.1129	0.1132	0.1126	0.1129	13299000.0
2003-04-25 17:00:00	NVDA	Stock	0.113	0.113	0.1123	0.1123	584400.0
2003-04-25 08:00:00	AMZN	Stock	1.4025	1.415	1.382	1.3895	20827300.0
2003-04-25 09:00:00	AMZN	Stock	1.3895	1.434	1.3865	1.421	199901780.0
2003-04-25 10:00:00	AMZN	Stock	1.4215	1.431	1.4098	1.4215	133386860.0
2003-04-25 11:00:00	AMZN	Stock	1.4215	1.425	1.416	1.42	68555960.0
2003-04-25 12:00:00	AMZN	Stock	1.42	1.4375	1.4185	1.4375	70327240.0
2003-04-25 13:00:00	AMZN	Stock	1.4375	1.4495	1.4355	1.4415	83251200.0
2003-04-25 14:00:00	AMZN	Stock	1.4411	1.445	1.4355	1.444	40898200.0
2003-04-25 15:00:00	AMZN	Stock	1.444	1.45	1.4385	1.4485	99795420.0
2003-04-25 16:00:00	AMZN	Stock	1.4485	1.45	1.444	1.449	6351200.0
2003-04-25 17:00:00	AMZN	Stock	1.448	1.4495	1.4281	1.4495	793240.0
2003-04-25 18:00:00	AMZN	Stock	1.4485	1.4525	1.4485	1.45	266000.0
2003-04-25 09:00:00	CL	Stock	28.575	28.615	28.515	28.575	202000.0
2003-04-25 10:00:00	CL	Stock	28.555	28.575	28.385	28.445	457000.0
2003-04-25 11:00:00	CL	Stock	28.43	28.43	28.325	28.41	282200.0
2003-04-25 12:00:00	CL	Stock	28.4	28.475	28.29	28.365	230200.0
2003-04-25 13:00:00	CL	Stock	28.36	28.375	28.285	28.335	228800.0
2003-04-25 14:00:00	CL	Stock	28.33	28.4	28.24	28.36	409000.0
2003-04-25 15:00:00	CL	Stock	28.355	28.47	28.305	28.34	526000.0
2003-04-25 16:00:00	CL	Stock	28.34	28.34	28.34	28.34	31600.0

> showing 50 of 20,787 rows — these rows as CSV

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