PREVIEW / stock_1hour / 2006-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-27.parquet
  size:    622 KB
  rows:    29,531
  symbols: 2,395

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-10-27 08:00:00	AAPL	Stock	2.9286	2.9354	2.9196	2.925	650552.0
2006-10-27 09:00:00	AAPL	Stock	2.925	2.9429	2.9182	2.9339	61222028.0
2006-10-27 10:00:00	AAPL	Stock	2.9325	2.9446	2.9279	2.9411	65058980.0
2006-10-27 11:00:00	AAPL	Stock	2.9414	2.9439	2.9307	2.9343	51575664.0
2006-10-27 12:00:00	AAPL	Stock	2.9346	2.9368	2.9179	2.9229	45922072.0
2006-10-27 13:00:00	AAPL	Stock	2.9225	2.9243	2.8829	2.8864	106378972.0
2006-10-27 14:00:00	AAPL	Stock	2.8868	2.8929	2.8575	2.8746	147477316.0
2006-10-27 15:00:00	AAPL	Stock	2.8743	2.9286	2.8657	2.8721	107336796.0
2006-10-27 16:00:00	AAPL	Stock	2.8732	2.8746	2.8682	2.8721	1158276.0
2006-10-27 17:00:00	AAPL	Stock	2.8714	2.8729	2.8679	2.8696	534408.0
2006-10-27 18:00:00	AAPL	Stock	2.8696	2.8732	2.8696	2.8725	42812.0
2006-10-27 19:00:00	AAPL	Stock	2.8711	2.8729	2.8675	2.8714	135128.0
2006-10-27 07:00:00	MSFT	Stock	28.38	28.38	28.24	28.24	3600.0
2006-10-27 08:00:00	MSFT	Stock	28.25	28.4	28.13	28.37	385097.0
2006-10-27 09:00:00	MSFT	Stock	28.35	28.76	28.35	28.67	18344321.0
2006-10-27 10:00:00	MSFT	Stock	28.67	28.79	28.53	28.58	17556842.0
2006-10-27 11:00:00	MSFT	Stock	28.578	28.67	28.48	28.662	8436324.0
2006-10-27 12:00:00	MSFT	Stock	28.66	28.72	28.61	28.68	6491899.0
2006-10-27 13:00:00	MSFT	Stock	28.69	28.7	28.41	28.45	10560962.0
2006-10-27 14:00:00	MSFT	Stock	28.45	28.46	28.25	28.3	12021324.0
2006-10-27 15:00:00	MSFT	Stock	28.291	28.36	28.25	28.36	11932009.0
2006-10-27 16:00:00	MSFT	Stock	28.36	28.4	28.29	28.35	844914.0
2006-10-27 17:00:00	MSFT	Stock	28.36	28.36	28.31	28.35	16091.0
2006-10-27 18:00:00	MSFT	Stock	28.35	28.35	28.35	28.35	200.0
2006-10-27 19:00:00	MSFT	Stock	28.34	28.34	28.34	28.34	500.0
2006-10-27 08:00:00	NVDA	Stock	0.5633	0.5663	0.5625	0.5625	738000.0
2006-10-27 09:00:00	NVDA	Stock	0.5625	0.5765	0.559	0.5692	85805160.0
2006-10-27 10:00:00	NVDA	Stock	0.5692	0.5693	0.5588	0.5607	72869700.0
2006-10-27 11:00:00	NVDA	Stock	0.5606	0.5638	0.5545	0.556	47155620.0
2006-10-27 12:00:00	NVDA	Stock	0.5562	0.5593	0.5542	0.5552	29569140.0
2006-10-27 13:00:00	NVDA	Stock	0.555	0.5563	0.5438	0.5473	74630880.0
2006-10-27 14:00:00	NVDA	Stock	0.5472	0.5502	0.535	0.5397	106659900.0
2006-10-27 15:00:00	NVDA	Stock	0.5395	0.541	0.5333	0.5398	124742400.0
2006-10-27 16:00:00	NVDA	Stock	0.5398	0.5408	0.5385	0.5408	1328940.0
2006-10-27 17:00:00	NVDA	Stock	0.54	0.54	0.5377	0.5387	156060.0
2006-10-27 18:00:00	NVDA	Stock	0.5397	0.5407	0.5387	0.5387	166560.0
2006-10-27 19:00:00	NVDA	Stock	0.54	0.54	0.54	0.54	9000.0
2006-10-27 08:00:00	AMZN	Stock	1.8945	1.9075	1.894	1.896	1039240.0
2006-10-27 09:00:00	AMZN	Stock	1.8955	1.9135	1.8832	1.889	32257320.0
2006-10-27 10:00:00	AMZN	Stock	1.8895	1.9065	1.8885	1.9045	30090060.0
2006-10-27 11:00:00	AMZN	Stock	1.9045	1.917	1.9025	1.9125	19686460.0
2006-10-27 12:00:00	AMZN	Stock	1.9125	1.919	1.91	1.9105	13910320.0
2006-10-27 13:00:00	AMZN	Stock	1.9105	1.914	1.8935	1.8986	22378820.0
2006-10-27 14:00:00	AMZN	Stock	1.8985	1.9085	1.89	1.8965	30716940.0
2006-10-27 15:00:00	AMZN	Stock	1.8965	1.912	1.893	1.909	36466620.0
2006-10-27 16:00:00	AMZN	Stock	1.912	1.9155	1.9003	1.91	524280.0
2006-10-27 17:00:00	AMZN	Stock	1.913	1.9185	1.911	1.9175	103500.0
2006-10-27 09:00:00	CL	Stock	31.39	31.495	31.365	31.49	497400.0
2006-10-27 10:00:00	CL	Stock	31.495	31.675	31.475	31.645	1246200.0
2006-10-27 11:00:00	CL	Stock	31.64	31.78	31.605	31.765	811400.0

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

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