PREVIEW / stock_1hour / 2004-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-14.parquet
  size:    499 KB
  rows:    23,651
  symbols: 1,818

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
2004-09-14 08:00:00	AAPL	Stock	0.6395	0.6429	0.6355	0.6355	149072.0
2004-09-14 09:00:00	AAPL	Stock	0.6338	0.6338	0.6211	0.6273	71127056.0
2004-09-14 10:00:00	AAPL	Stock	0.6271	0.6296	0.6261	0.6261	35948304.0
2004-09-14 11:00:00	AAPL	Stock	0.6261	0.6313	0.6259	0.6309	24574144.0
2004-09-14 12:00:00	AAPL	Stock	0.6309	0.6338	0.6304	0.6336	34625752.0
2004-09-14 13:00:00	AAPL	Stock	0.6338	0.6343	0.6305	0.6314	17469424.0
2004-09-14 14:00:00	AAPL	Stock	0.6313	0.6332	0.6307	0.6325	14710024.0
2004-09-14 15:00:00	AAPL	Stock	0.6325	0.6348	0.6305	0.6332	40955264.0
2004-09-14 16:00:00	AAPL	Stock	0.6332	0.6341	0.6321	0.6338	3966872.0
2004-09-14 17:00:00	AAPL	Stock	0.6321	0.6321	0.6318	0.6318	16800.0
2004-09-14 18:00:00	AAPL	Stock	0.634	0.634	0.634	0.634	2991408.0
2004-09-14 08:00:00	MSFT	Stock	27.33	27.4047	27.28	27.31	88200.0
2004-09-14 09:00:00	MSFT	Stock	27.33	27.41	27.27	27.35	7254874.0
2004-09-14 10:00:00	MSFT	Stock	27.35	27.39	27.31	27.34	5950521.0
2004-09-14 11:00:00	MSFT	Stock	27.34	27.46	27.34	27.45	6760924.0
2004-09-14 12:00:00	MSFT	Stock	27.45	27.51	27.429	27.47	6663878.0
2004-09-14 13:00:00	MSFT	Stock	27.47	27.49	27.369	27.38	6826125.0
2004-09-14 14:00:00	MSFT	Stock	27.38	27.43	27.34	27.42	5732455.0
2004-09-14 15:00:00	MSFT	Stock	27.41	27.51	27.39	27.42	9212761.0
2004-09-14 16:00:00	MSFT	Stock	27.42	27.51	27.4	27.47	5040352.0
2004-09-14 17:00:00	MSFT	Stock	27.47	27.47	27.4	27.45	19432.0
2004-09-14 18:00:00	MSFT	Stock	27.4257	27.4543	27.42	27.42	135158.0
2004-09-14 08:00:00	NVDA	Stock	0.1158	0.1195	0.1158	0.1195	13701000.0
2004-09-14 09:00:00	NVDA	Stock	0.1195	0.12	0.1175	0.1178	80526840.0
2004-09-14 10:00:00	NVDA	Stock	0.1178	0.1188	0.1176	0.1183	119865960.0
2004-09-14 11:00:00	NVDA	Stock	0.1182	0.1195	0.1177	0.1191	86697000.0
2004-09-14 12:00:00	NVDA	Stock	0.1192	0.1198	0.1183	0.1193	61590600.0
2004-09-14 13:00:00	NVDA	Stock	0.1193	0.1196	0.1183	0.1189	60700200.0
2004-09-14 14:00:00	NVDA	Stock	0.1189	0.1196	0.1188	0.1193	66361560.0
2004-09-14 15:00:00	NVDA	Stock	0.1193	0.1208	0.119	0.1201	156716040.0
2004-09-14 16:00:00	NVDA	Stock	0.1201	0.1201	0.1193	0.1196	3863520.0
2004-09-14 17:00:00	NVDA	Stock	0.1189	0.1193	0.1189	0.1193	183600.0
2004-09-14 18:00:00	NVDA	Stock	0.1201	0.1201	0.1193	0.1193	1484040.0
2004-09-14 08:00:00	AMZN	Stock	2.0055	2.01	2.0	2.007	87000.0
2004-09-14 09:00:00	AMZN	Stock	2.0075	2.047	1.995	2.04	38491480.0
2004-09-14 10:00:00	AMZN	Stock	2.039	2.07	2.0325	2.0679	63228840.0
2004-09-14 11:00:00	AMZN	Stock	2.067	2.086	2.056	2.068	41137040.0
2004-09-14 12:00:00	AMZN	Stock	2.068	2.097	2.0635	2.0965	26213400.0
2004-09-14 13:00:00	AMZN	Stock	2.0965	2.1	2.072	2.088	34433220.0
2004-09-14 14:00:00	AMZN	Stock	2.088	2.1005	2.0825	2.097	23221800.0
2004-09-14 15:00:00	AMZN	Stock	2.096	2.1375	2.0945	2.1305	71730060.0
2004-09-14 16:00:00	AMZN	Stock	2.1305	2.1445	2.0952	2.1445	8819660.0
2004-09-14 17:00:00	AMZN	Stock	2.1335	2.139	2.13	2.132	278800.0
2004-09-14 18:00:00	AMZN	Stock	2.1328	2.1328	2.131	2.131	10081700.0
2004-09-14 09:00:00	CL	Stock	27.25	27.315	27.21	27.27	234200.0
2004-09-14 10:00:00	CL	Stock	27.27	27.275	26.98	26.985	369000.0
2004-09-14 11:00:00	CL	Stock	26.98	27.11	26.95	27.105	390000.0
2004-09-14 12:00:00	CL	Stock	27.11	27.225	27.105	27.21	204400.0
2004-09-14 13:00:00	CL	Stock	27.22	27.275	27.19	27.195	322800.0
2004-09-14 14:00:00	CL	Stock	27.19	27.27	27.175	27.26	413800.0

> showing 50 of 23,651 rows — these rows as CSV

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