PREVIEW / stock_1hour / 2006-10-13

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-13.parquet
  size:    619 KB
  rows:    29,556
  symbols: 2,392

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-13 07:00:00	AAPL	Stock	2.6843	2.6914	2.6843	2.6896	40040.0
2006-10-13 08:00:00	AAPL	Stock	2.6914	2.7025	2.6864	2.7	2586864.0
2006-10-13 09:00:00	AAPL	Stock	2.6982	2.7232	2.6932	2.7211	105915684.0
2006-10-13 10:00:00	AAPL	Stock	2.7204	2.7457	2.7204	2.7282	143004960.0
2006-10-13 11:00:00	AAPL	Stock	2.73	2.73	2.7064	2.7114	81676196.0
2006-10-13 12:00:00	AAPL	Stock	2.7111	2.7143	2.7004	2.705	55166076.0
2006-10-13 13:00:00	AAPL	Stock	2.7046	2.7071	2.6804	2.6854	94736936.0
2006-10-13 14:00:00	AAPL	Stock	2.6854	2.69	2.6693	2.6707	94342332.0
2006-10-13 15:00:00	AAPL	Stock	2.6704	2.6854	2.6696	2.6786	92417444.0
2006-10-13 16:00:00	AAPL	Stock	2.6786	2.6821	2.6714	2.6739	3115084.0
2006-10-13 17:00:00	AAPL	Stock	2.675	2.6821	2.6714	2.6739	516348.0
2006-10-13 18:00:00	AAPL	Stock	2.6768	2.6768	2.6739	2.6746	38920.0
2006-10-13 05:00:00	MSFT	Stock	28.16	28.16	28.16	28.16	100.0
2006-10-13 06:00:00	MSFT	Stock	28.2	28.2	28.2	28.2	700.0
2006-10-13 07:00:00	MSFT	Stock	28.14	28.33	28.14	28.33	23333.0
2006-10-13 08:00:00	MSFT	Stock	28.35	28.4	27.91	28.33	201020.0
2006-10-13 09:00:00	MSFT	Stock	28.35	28.5	28.29	28.46	18494192.0
2006-10-13 10:00:00	MSFT	Stock	28.45	28.69	28.45	28.64	37429653.0
2006-10-13 11:00:00	MSFT	Stock	28.65	28.67	28.53	28.61	18533954.0
2006-10-13 12:00:00	MSFT	Stock	28.61	28.64	28.57	28.62	10843332.0
2006-10-13 13:00:00	MSFT	Stock	28.62	28.66	28.56	28.58	16777398.0
2006-10-13 14:00:00	MSFT	Stock	28.57	28.59	28.4	28.42	12267716.0
2006-10-13 15:00:00	MSFT	Stock	28.42	28.47	28.31	28.38	12138110.0
2006-10-13 16:00:00	MSFT	Stock	28.37	28.38	28.34	28.36	156876.0
2006-10-13 17:00:00	MSFT	Stock	28.38	28.38	28.36	28.37	13046.0
2006-10-13 18:00:00	MSFT	Stock	28.37	28.37	28.37	28.37	2150.0
2006-10-13 19:00:00	MSFT	Stock	28.39	28.39	28.39	28.39	100.0
2006-10-13 08:00:00	NVDA	Stock	0.5408	0.542	0.54	0.5408	702000.0
2006-10-13 09:00:00	NVDA	Stock	0.5397	0.5417	0.5307	0.5403	77295360.0
2006-10-13 10:00:00	NVDA	Stock	0.5405	0.5542	0.5405	0.5516	124546260.0
2006-10-13 11:00:00	NVDA	Stock	0.5517	0.5542	0.549	0.5528	57300060.0
2006-10-13 12:00:00	NVDA	Stock	0.5528	0.5548	0.5493	0.5547	45345720.0
2006-10-13 13:00:00	NVDA	Stock	0.5547	0.5615	0.5542	0.5587	78329220.0
2006-10-13 14:00:00	NVDA	Stock	0.5585	0.5612	0.5548	0.558	57913680.0
2006-10-13 15:00:00	NVDA	Stock	0.5581	0.566	0.5572	0.5628	128858220.0
2006-10-13 16:00:00	NVDA	Stock	0.5628	0.5642	0.5628	0.5642	498120.0
2006-10-13 17:00:00	NVDA	Stock	0.5628	0.5637	0.5628	0.5632	138300.0
2006-10-13 18:00:00	NVDA	Stock	0.5642	0.5642	0.5632	0.5632	114360.0
2006-10-13 08:00:00	AMZN	Stock	1.6835	1.6835	1.675	1.675	22000.0
2006-10-13 09:00:00	AMZN	Stock	1.671	1.6745	1.6645	1.6655	11263100.0
2006-10-13 10:00:00	AMZN	Stock	1.6655	1.674	1.6605	1.667	10997840.0
2006-10-13 11:00:00	AMZN	Stock	1.667	1.6695	1.654	1.661	12290580.0
2006-10-13 12:00:00	AMZN	Stock	1.661	1.679	1.661	1.678	11496400.0
2006-10-13 13:00:00	AMZN	Stock	1.678	1.6785	1.666	1.669	6675000.0
2006-10-13 14:00:00	AMZN	Stock	1.669	1.6705	1.6605	1.6615	8938960.0
2006-10-13 15:00:00	AMZN	Stock	1.662	1.669	1.6615	1.6655	15515080.0
2006-10-13 16:00:00	AMZN	Stock	1.6655	1.666	1.663	1.666	78000.0
2006-10-13 17:00:00	AMZN	Stock	1.666	1.666	1.666	1.666	3100.0
2006-10-13 18:00:00	AMZN	Stock	1.668	1.668	1.668	1.668	20000.0
2006-10-13 09:00:00	CL	Stock	30.655	30.685	30.51	30.585	393400.0

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

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