PREVIEW / stock_1hour / 2004-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-07-14.parquet
  size:    511 KB
  rows:    24,069
  symbols: 1,797

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-07-14 08:00:00	AAPL	Stock	0.521	0.521	0.5164	0.517	761600.0
2004-07-14 09:00:00	AAPL	Stock	0.517	0.522	0.5132	0.5202	61740336.0
2004-07-14 10:00:00	AAPL	Stock	0.5204	0.5311	0.5196	0.5268	82304656.0
2004-07-14 11:00:00	AAPL	Stock	0.5271	0.5291	0.525	0.5263	57697528.0
2004-07-14 12:00:00	AAPL	Stock	0.5263	0.5334	0.5232	0.5257	116287976.0
2004-07-14 13:00:00	AAPL	Stock	0.5257	0.5307	0.5246	0.5291	50105832.0
2004-07-14 14:00:00	AAPL	Stock	0.5289	0.5352	0.5288	0.5321	99782760.0
2004-07-14 15:00:00	AAPL	Stock	0.5318	0.5346	0.5279	0.5279	157607912.0
2004-07-14 16:00:00	AAPL	Stock	0.5291	0.55	0.5084	0.5404	121804088.0
2004-07-14 17:00:00	AAPL	Stock	0.5396	0.563	0.5282	0.5625	42088872.0
2004-07-14 18:00:00	AAPL	Stock	0.5627	0.5661	0.5623	0.5634	8330560.0
2004-07-14 08:00:00	MSFT	Stock	27.4	27.45	25.01	27.38	58803.0
2004-07-14 09:00:00	MSFT	Stock	27.38	27.65	27.34	27.63	11356897.0
2004-07-14 10:00:00	MSFT	Stock	27.62	28.08	27.6	28.06	17527535.0
2004-07-14 11:00:00	MSFT	Stock	28.06	28.33	28.0	28.23	14738952.0
2004-07-14 12:00:00	MSFT	Stock	28.23	28.32	28.12	28.21	9094370.0
2004-07-14 13:00:00	MSFT	Stock	28.22	28.25	28.0	28.18	9180090.0
2004-07-14 14:00:00	MSFT	Stock	28.17	28.27	27.95	28.05	8128344.0
2004-07-14 15:00:00	MSFT	Stock	28.04	28.23	28.01	28.15	13810518.0
2004-07-14 16:00:00	MSFT	Stock	28.15	28.23	27.964	28.13	1325771.0
2004-07-14 17:00:00	MSFT	Stock	28.2	28.22	28.13	28.2	49969.0
2004-07-14 18:00:00	MSFT	Stock	28.2	28.24	28.18	28.24	5549.0
2004-07-14 08:00:00	NVDA	Stock	0.1342	0.1342	0.1331	0.1331	1298400.0
2004-07-14 09:00:00	NVDA	Stock	0.1333	0.1374	0.1286	0.1297	253550280.0
2004-07-14 10:00:00	NVDA	Stock	0.1297	0.1355	0.1287	0.1355	198794760.0
2004-07-14 11:00:00	NVDA	Stock	0.1356	0.1362	0.1342	0.1343	123489480.0
2004-07-14 12:00:00	NVDA	Stock	0.1343	0.1349	0.1331	0.1338	94185960.0
2004-07-14 13:00:00	NVDA	Stock	0.1337	0.134	0.1325	0.1331	46307280.0
2004-07-14 14:00:00	NVDA	Stock	0.1331	0.1333	0.1318	0.1322	64488600.0
2004-07-14 15:00:00	NVDA	Stock	0.1321	0.1322	0.1297	0.1312	95811240.0
2004-07-14 16:00:00	NVDA	Stock	0.1314	0.1322	0.1311	0.1322	3229920.0
2004-07-14 17:00:00	NVDA	Stock	0.1314	0.1322	0.1314	0.1322	221760.0
2004-07-14 18:00:00	NVDA	Stock	0.1322	0.1322	0.1322	0.1322	24000.0
2004-07-14 08:00:00	AMZN	Stock	2.476	2.476	2.4575	2.459	96040.0
2004-07-14 09:00:00	AMZN	Stock	2.45	2.4765	2.4445	2.4715	15294900.0
2004-07-14 10:00:00	AMZN	Stock	2.47	2.52	2.464	2.5015	25998180.0
2004-07-14 11:00:00	AMZN	Stock	2.5015	2.5095	2.4945	2.5005	11332540.0
2004-07-14 12:00:00	AMZN	Stock	2.5005	2.505	2.49	2.5025	8780480.0
2004-07-14 13:00:00	AMZN	Stock	2.503	2.503	2.4875	2.49	7973160.0
2004-07-14 14:00:00	AMZN	Stock	2.49	2.498	2.475	2.4795	9434140.0
2004-07-14 15:00:00	AMZN	Stock	2.48	2.48	2.458	2.4755	19183820.0
2004-07-14 16:00:00	AMZN	Stock	2.475	2.4785	2.473	2.4785	1195920.0
2004-07-14 17:00:00	AMZN	Stock	2.483	2.4925	2.475	2.478	537580.0
2004-07-14 18:00:00	AMZN	Stock	2.4785	2.48	2.4785	2.48	17960.0
2004-07-14 09:00:00	CL	Stock	28.65	28.685	28.585	28.635	164800.0
2004-07-14 10:00:00	CL	Stock	28.635	28.755	28.605	28.72	418400.0
2004-07-14 11:00:00	CL	Stock	28.725	28.75	28.655	28.685	177600.0
2004-07-14 12:00:00	CL	Stock	28.68	28.69	28.6	28.625	194600.0
2004-07-14 13:00:00	CL	Stock	28.62	28.625	28.475	28.5	383200.0
2004-07-14 14:00:00	CL	Stock	28.495	28.51	28.45	28.46	319800.0

> showing 50 of 24,069 rows — these rows as CSV

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