PREVIEW / stock_1hour / 2008-03-17

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-17.parquet
  size:    807 KB
  rows:    40,644
  symbols: 3,282

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
2008-03-17 05:00:00	AAPL	Stock	4.3975	4.3975	4.3975	4.3975	2800.0
2008-03-17 06:00:00	AAPL	Stock	4.4014	4.4014	4.4014	4.4014	28000.0
2008-03-17 07:00:00	AAPL	Stock	4.4036	4.4243	4.3929	4.4243	116200.0
2008-03-17 08:00:00	AAPL	Stock	4.4107	4.4264	4.3493	4.3711	5289928.0
2008-03-17 09:00:00	AAPL	Stock	4.3714	4.4811	4.3643	4.4564	118017760.0
2008-03-17 10:00:00	AAPL	Stock	4.4571	4.5143	4.4296	4.4954	155554476.0
2008-03-17 11:00:00	AAPL	Stock	4.495	4.5054	4.4511	4.4529	110335960.0
2008-03-17 12:00:00	AAPL	Stock	4.4532	4.465	4.3961	4.4145	106466808.0
2008-03-17 13:00:00	AAPL	Stock	4.4145	4.4643	4.3825	4.4525	123084416.0
2008-03-17 14:00:00	AAPL	Stock	4.4532	4.5246	4.4411	4.515	164007032.0
2008-03-17 15:00:00	AAPL	Stock	4.515	4.5925	4.5075	4.5264	254643704.0
2008-03-17 16:00:00	AAPL	Stock	4.5264	4.55	4.4789	4.5479	14359996.0
2008-03-17 17:00:00	AAPL	Stock	4.5507	4.5529	4.5261	4.5461	2916060.0
2008-03-17 18:00:00	AAPL	Stock	4.5446	4.5493	4.54	4.5457	276864.0
2008-03-17 19:00:00	AAPL	Stock	4.5404	4.5571	4.5404	4.555	379680.0
2008-03-17 05:00:00	MSFT	Stock	27.58	27.58	27.56	27.56	400.0
2008-03-17 07:00:00	MSFT	Stock	27.5	27.5	27.39	27.4	8163.0
2008-03-17 08:00:00	MSFT	Stock	27.35	27.4	27.2	27.22	143554.0
2008-03-17 09:00:00	MSFT	Stock	27.22	28.01	27.16	27.91	8435770.0
2008-03-17 10:00:00	MSFT	Stock	27.91	28.05	27.79	27.97	9903568.0
2008-03-17 11:00:00	MSFT	Stock	27.97	28.4	27.95	28.21	13239989.0
2008-03-17 12:00:00	MSFT	Stock	28.21	28.211	27.78	28.03	10063426.0
2008-03-17 13:00:00	MSFT	Stock	28.03	28.05	27.73	28.03	7486860.0
2008-03-17 14:00:00	MSFT	Stock	28.04	28.4	27.97	28.32	9401492.0
2008-03-17 15:00:00	MSFT	Stock	28.32	28.73	28.25	28.315	19259099.0
2008-03-17 16:00:00	MSFT	Stock	28.3	28.495	28.129	28.4	2747969.0
2008-03-17 17:00:00	MSFT	Stock	28.45	28.6	28.3	28.3	1922749.0
2008-03-17 18:00:00	MSFT	Stock	28.48	28.48	28.42	28.42	3829.0
2008-03-17 19:00:00	MSFT	Stock	28.42	28.42	28.4	28.42	3500.0
2008-03-17 07:00:00	NVDA	Stock	0.4532	0.4532	0.4532	0.4532	4000.0
2008-03-17 08:00:00	NVDA	Stock	0.4475	0.4575	0.432	0.4335	1377720.0
2008-03-17 09:00:00	NVDA	Stock	0.435	0.454	0.4328	0.449	90288800.0
2008-03-17 10:00:00	NVDA	Stock	0.4492	0.462	0.449	0.4582	140424280.0
2008-03-17 11:00:00	NVDA	Stock	0.4585	0.4593	0.444	0.4445	93322320.0
2008-03-17 12:00:00	NVDA	Stock	0.4442	0.4472	0.4408	0.445	70982520.0
2008-03-17 13:00:00	NVDA	Stock	0.4452	0.448	0.44	0.4478	65586840.0
2008-03-17 14:00:00	NVDA	Stock	0.4478	0.4528	0.445	0.45	86543080.0
2008-03-17 15:00:00	NVDA	Stock	0.45	0.4548	0.4465	0.4465	163133360.0
2008-03-17 16:00:00	NVDA	Stock	0.447	0.4522	0.4465	0.45	68281720.0
2008-03-17 17:00:00	NVDA	Stock	0.4465	0.452	0.4465	0.4465	2303360.0
2008-03-17 19:00:00	NVDA	Stock	0.4518	0.4518	0.4518	0.4518	12000.0
2008-03-17 08:00:00	AMZN	Stock	3.2855	3.304	3.2735	3.283	98660.0
2008-03-17 09:00:00	AMZN	Stock	3.2885	3.347	3.246	3.3035	34980140.0
2008-03-17 10:00:00	AMZN	Stock	3.304	3.35	3.2695	3.3075	26242800.0
2008-03-17 11:00:00	AMZN	Stock	3.308	3.3375	3.27	3.27	15267240.0
2008-03-17 12:00:00	AMZN	Stock	3.2695	3.3264	3.258	3.304	24032840.0
2008-03-17 13:00:00	AMZN	Stock	3.304	3.3075	3.2525	3.3015	20123760.0
2008-03-17 14:00:00	AMZN	Stock	3.3035	3.359	3.291	3.337	19905440.0
2008-03-17 15:00:00	AMZN	Stock	3.3375	3.3895	3.3205	3.3265	44305720.0
2008-03-17 16:00:00	AMZN	Stock	3.3265	3.3512	3.3102	3.3181	6990540.0

> showing 50 of 40,644 rows — these rows as CSV

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