PREVIEW / stock_1hour / 2004-09-24

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-09-24.parquet
  size:    488 KB
  rows:    23,484
  symbols: 1,828

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-24 08:00:00	AAPL	Stock	0.6656	0.6656	0.6656	0.6656	280000.0
2004-09-24 09:00:00	AAPL	Stock	0.6666	0.6743	0.6652	0.6716	31553312.0
2004-09-24 10:00:00	AAPL	Stock	0.6716	0.675	0.6689	0.675	51060408.0
2004-09-24 11:00:00	AAPL	Stock	0.6752	0.6786	0.6713	0.6713	52808616.0
2004-09-24 12:00:00	AAPL	Stock	0.6714	0.6725	0.6659	0.6714	66869880.0
2004-09-24 13:00:00	AAPL	Stock	0.6714	0.6768	0.6695	0.6725	43493744.0
2004-09-24 14:00:00	AAPL	Stock	0.6725	0.6743	0.6634	0.6661	51548448.0
2004-09-24 15:00:00	AAPL	Stock	0.6657	0.6688	0.6638	0.6654	46035472.0
2004-09-24 16:00:00	AAPL	Stock	0.6654	0.6675	0.665	0.6661	2037112.0
2004-09-24 08:00:00	MSFT	Stock	27.34	27.38	27.34	27.35	7860.0
2004-09-24 09:00:00	MSFT	Stock	27.35	27.45	27.33	27.4	6368173.0
2004-09-24 10:00:00	MSFT	Stock	27.4	27.4	27.29	27.34	9340746.0
2004-09-24 11:00:00	MSFT	Stock	27.35	27.46	27.34	27.411	6596243.0
2004-09-24 12:00:00	MSFT	Stock	27.4	27.41	27.31	27.34	4712284.0
2004-09-24 13:00:00	MSFT	Stock	27.34	27.45	27.33	27.4	4828535.0
2004-09-24 14:00:00	MSFT	Stock	27.4	27.44	27.31	27.32	4234516.0
2004-09-24 15:00:00	MSFT	Stock	27.321	27.34	27.19	27.3	8877986.0
2004-09-24 16:00:00	MSFT	Stock	27.3	27.32	27.25	27.27	3005522.0
2004-09-24 17:00:00	MSFT	Stock	27.27	27.3713	27.27	27.3713	18174.0
2004-09-24 18:00:00	MSFT	Stock	27.32	27.32	27.3	27.3	2200.0
2004-09-24 08:00:00	NVDA	Stock	0.121	0.121	0.1208	0.1208	120000.0
2004-09-24 09:00:00	NVDA	Stock	0.121	0.1215	0.1192	0.1202	45993000.0
2004-09-24 10:00:00	NVDA	Stock	0.1201	0.1206	0.1192	0.1195	39411840.0
2004-09-24 11:00:00	NVDA	Stock	0.1195	0.1201	0.117	0.1172	60860760.0
2004-09-24 12:00:00	NVDA	Stock	0.1172	0.1173	0.1153	0.1162	119923560.0
2004-09-24 13:00:00	NVDA	Stock	0.1161	0.1183	0.1158	0.117	63121320.0
2004-09-24 14:00:00	NVDA	Stock	0.1171	0.1177	0.116	0.1168	60395640.0
2004-09-24 15:00:00	NVDA	Stock	0.1169	0.1173	0.1163	0.117	73206240.0
2004-09-24 16:00:00	NVDA	Stock	0.117	0.1171	0.1162	0.1162	3780960.0
2004-09-24 17:00:00	NVDA	Stock	0.1171	0.1171	0.117	0.1171	180000.0
2004-09-24 08:00:00	AMZN	Stock	2.0915	2.0975	2.0915	2.0975	26000.0
2004-09-24 09:00:00	AMZN	Stock	2.0915	2.097	2.069	2.0765	15101420.0
2004-09-24 10:00:00	AMZN	Stock	2.075	2.079	2.059	2.078	25199060.0
2004-09-24 11:00:00	AMZN	Stock	2.0775	2.087	2.0675	2.07	15698400.0
2004-09-24 12:00:00	AMZN	Stock	2.0705	2.0755	2.0435	2.055	21413060.0
2004-09-24 13:00:00	AMZN	Stock	2.055	2.07	2.05	2.066	9757480.0
2004-09-24 14:00:00	AMZN	Stock	2.0655	2.0655	2.05	2.0505	6694520.0
2004-09-24 15:00:00	AMZN	Stock	2.05	2.057	2.0425	2.0465	26130080.0
2004-09-24 16:00:00	AMZN	Stock	2.0475	2.048	2.0425	2.047	3566600.0
2004-09-24 17:00:00	AMZN	Stock	2.05	2.054	2.047	2.0505	222860.0
2004-09-24 18:00:00	AMZN	Stock	2.048	2.0515	2.048	2.0515	56000.0
2004-09-24 09:00:00	CL	Stock	22.915	22.96	22.82	22.855	1067800.0
2004-09-24 10:00:00	CL	Stock	22.84	22.945	22.795	22.825	1636000.0
2004-09-24 11:00:00	CL	Stock	22.825	22.865	22.655	22.73	2619400.0
2004-09-24 12:00:00	CL	Stock	22.73	22.765	22.575	22.605	1446200.0
2004-09-24 13:00:00	CL	Stock	22.615	22.675	22.525	22.645	1858000.0
2004-09-24 14:00:00	CL	Stock	22.64	22.67	22.565	22.575	2070400.0
2004-09-24 15:00:00	CL	Stock	22.575	22.61	22.535	22.555	2689200.0
2004-09-24 16:00:00	CL	Stock	22.55	22.68	22.55	22.55	296200.0

> showing 49 of 23,484 rows — these rows as CSV

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