PREVIEW / stock_1hour / 2006-07-05

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-07-05.parquet
  size:    610 KB
  rows:    29,248
  symbols: 2,311

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
2006-07-05 06:00:00	AAPL	Stock	2.0518	2.0696	2.0429	2.0696	12600.0
2006-07-05 08:00:00	AAPL	Stock	2.0664	2.0664	2.05	2.05	802648.0
2006-07-05 09:00:00	AAPL	Stock	2.05	2.0571	2.0321	2.0478	74722032.0
2006-07-05 10:00:00	AAPL	Stock	2.0479	2.05	2.03	2.0307	86733472.0
2006-07-05 11:00:00	AAPL	Stock	2.0304	2.0357	2.0264	2.0296	67126724.0
2006-07-05 12:00:00	AAPL	Stock	2.0296	2.03	2.02	2.0225	43698452.0
2006-07-05 13:00:00	AAPL	Stock	2.0225	2.04	2.0221	2.0307	66458336.0
2006-07-05 14:00:00	AAPL	Stock	2.0304	2.0482	2.0286	2.0461	57235024.0
2006-07-05 15:00:00	AAPL	Stock	2.0461	2.0471	2.0321	2.0357	111254892.0
2006-07-05 16:00:00	AAPL	Stock	2.0354	2.0364	2.0339	2.0357	2122680.0
2006-07-05 17:00:00	AAPL	Stock	2.035	2.0357	2.0268	2.0329	731108.0
2006-07-05 18:00:00	AAPL	Stock	2.0307	2.0361	2.0307	2.0361	626416.0
2006-07-05 08:00:00	MSFT	Stock	23.5	23.66	23.5	23.52	24970.0
2006-07-05 09:00:00	MSFT	Stock	23.52	23.6	23.36	23.43	8789945.0
2006-07-05 10:00:00	MSFT	Stock	23.42	23.51	23.35	23.38	8401282.0
2006-07-05 11:00:00	MSFT	Stock	23.38	23.47	23.35	23.38	7186022.0
2006-07-05 12:00:00	MSFT	Stock	23.39	23.41	23.33	23.39	3400016.0
2006-07-05 13:00:00	MSFT	Stock	23.39	23.51	23.37	23.381	5101982.0
2006-07-05 14:00:00	MSFT	Stock	23.38	23.48	23.37	23.452	7311161.0
2006-07-05 15:00:00	MSFT	Stock	23.45	23.477	23.31	23.31	10693794.0
2006-07-05 16:00:00	MSFT	Stock	23.31	23.425	23.2	23.33	536227.0
2006-07-05 17:00:00	MSFT	Stock	23.34	23.35	23.3	23.35	12473.0
2006-07-05 18:00:00	MSFT	Stock	23.35	23.35	23.3	23.3	27859.0
2006-07-05 08:00:00	NVDA	Stock	0.36	0.36	0.3583	0.3583	14400.0
2006-07-05 09:00:00	NVDA	Stock	0.3567	0.3575	0.3498	0.3507	37310580.0
2006-07-05 10:00:00	NVDA	Stock	0.3505	0.3508	0.3465	0.3472	63588900.0
2006-07-05 11:00:00	NVDA	Stock	0.3473	0.3485	0.3463	0.3472	47686020.0
2006-07-05 12:00:00	NVDA	Stock	0.3473	0.3483	0.3467	0.3483	24860820.0
2006-07-05 13:00:00	NVDA	Stock	0.3483	0.35	0.3475	0.3495	39470100.0
2006-07-05 14:00:00	NVDA	Stock	0.3495	0.352	0.3493	0.3518	69048360.0
2006-07-05 15:00:00	NVDA	Stock	0.3518	0.3523	0.3438	0.3438	154804320.0
2006-07-05 16:00:00	NVDA	Stock	0.3442	0.3445	0.3438	0.3442	3024600.0
2006-07-05 17:00:00	NVDA	Stock	0.3442	0.3442	0.3442	0.3442	54000.0
2006-07-05 18:00:00	NVDA	Stock	0.3438	0.3438	0.3438	0.3438	76140.0
2006-07-05 08:00:00	AMZN	Stock	1.927	1.927	1.8925	1.8975	44360.0
2006-07-05 09:00:00	AMZN	Stock	1.9305	1.9305	1.89	1.896	11275960.0
2006-07-05 10:00:00	AMZN	Stock	1.8965	1.897	1.882	1.883	11015560.0
2006-07-05 11:00:00	AMZN	Stock	1.8825	1.8825	1.8685	1.8745	17785800.0
2006-07-05 12:00:00	AMZN	Stock	1.875	1.875	1.858	1.8585	6748960.0
2006-07-05 13:00:00	AMZN	Stock	1.8585	1.8745	1.858	1.861	14065900.0
2006-07-05 14:00:00	AMZN	Stock	1.861	1.8615	1.849	1.8555	19419300.0
2006-07-05 15:00:00	AMZN	Stock	1.8555	1.8635	1.839	1.8555	29001500.0
2006-07-05 16:00:00	AMZN	Stock	1.853	1.8535	1.8515	1.8515	63060.0
2006-07-05 18:00:00	AMZN	Stock	1.8555	1.8555	1.8555	1.8555	21560.0
2006-07-05 09:00:00	CL	Stock	29.91	29.965	29.805	29.845	423600.0
2006-07-05 10:00:00	CL	Stock	29.845	29.85	29.46	29.47	924600.0
2006-07-05 11:00:00	CL	Stock	29.47	29.74	29.455	29.655	563200.0
2006-07-05 12:00:00	CL	Stock	29.655	29.685	29.58	29.61	205800.0
2006-07-05 13:00:00	CL	Stock	29.61	29.72	29.58	29.675	463400.0
2006-07-05 14:00:00	CL	Stock	29.67	29.86	29.65	29.85	380400.0

> showing 50 of 29,248 rows — these rows as CSV

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