PREVIEW / stock_daily / 2006-12-27

all stock daily files

  file:    by_date/stock_daily/2006/2006-12-27.parquet
  size:    156 KB
  rows:    4,666
  symbols: 2,963

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2006-12-27	AAPL	Stock	2.7911	2.9286	2.7418	2.9114	1935754800.0
2006-12-27	MSFT	Stock	29.99	30.13	29.91	30.02	31248400.0
2006-12-27	NVDA	Stock	0.6197	0.6273	0.6197	0.6252	264954000.0
2006-12-27	AMZN	Stock	1.993	2.0235	1.99	2.0145	70730000.0
2006-12-27	CL	Stock	32.625	32.66	32.375	32.52	2289200.0
2006-12-27	A	Stock	24.5994	24.8927	24.5565	24.8212	2027659.0
2006-12-27	AABA-DELISTED	Stock	25.4699993133545	25.8799991607666	25.4500007629395	25.75	12421800.0
2006-12-27	AACC-DELISTED	Stock	16.92	17.09	16.66	17.0	109474.0
2006-12-27	AACQ-DELISTED	Stock	5.42	5.44	5.42	5.44	7200.0
2006-12-27	AACQW-DELISTED	Stock	0.51	0.51	0.51	0.51	5000.0
2006-12-27	AAI-DELISTED	Stock	12.02	12.14	11.93	12.03	1241300.0
2006-12-27	AAIC-DELISTED	Stock	161.2	163.0	160.2	162.6	1284700.0
2006-12-27	AAME	Stock	3.05	3.05	2.96	3.05	3000.0
2006-12-27	AAON	Stock	3.4147	3.5635	3.4147	3.5371	101756.0
2006-12-27	AAP	Stock	35.89	36.06	35.62	35.97	397500.0
2006-12-27	AATI-DELISTED	Stock	5.38	5.4699	5.29	5.37	246920.0
2006-12-27	AAU-DELISTED	Stock	2.48	2.5	2.36	2.37	67500.0
2006-12-27	AAUAF-DELISTED	Stock	2.48	2.5	2.36	2.37	67500.0
2006-12-27	AAV-DELISTED	Stock	11.03	11.15	10.81	10.89	1250700.0
2006-12-27	AAWW-DELISTED	Stock	45.17	45.75	45.17	45.25	49722.0
2006-12-27	AAXN-DELISTED	Stock	7.40000009536743	7.80000019073486	7.3899998664856	7.5	1541400.0
2006-12-27	AB	Stock	79.6	80.48	79.45	80.3	123900.0
2006-12-27	ABAX-DELISTED	Stock	19.34	19.95	19.34	19.53	128381.0
2006-12-27	ABB-DELISTED	Stock	17.72	17.9	17.72	17.8901	674500.0
2006-12-27	ABBC-DELISTED	Stock	19.07	19.26	19.07	19.25	14840.0
2006-12-27	ABC-DELISTED	Stock	22.39	22.6	22.34	22.56	2111200.0
2006-12-27	ABCB	Stock	27.2535	27.4674	27.1367	27.1951	34545.0
2006-12-27	ABCO-DELISTED	Stock	26.83	27.15	26.75	27.08	123466.0
2006-12-27	ABCW-DELISTED	Stock	28.9	29.5	28.77	29.36	103810.0
2006-12-27	ABD-DELISTED	Stock	26.92	27.0	26.81	26.95	193000.0
2006-12-27	ABE-DELISTED	Stock	18.01	18.3	17.89	18.1	39100.0
2006-12-27	ABFS-DELISTED	Stock	37.44	37.87	37.04	37.14	267293.0
2006-12-27	ABG	Stock	23.86	24.0	23.8	23.9	142100.0
2006-12-27	ABK-DELISTED	Stock	89.51	90.25	89.5	89.84	288200.0
2006-12-27	ABM	Stock	23.09	23.77	23.06	23.32	340400.0
2006-12-27	ABMD-DELISTED	Stock	13.85	14.3	13.85	14.28	90300.0
2006-12-27	ABP-DELISTED	Stock	3.24	3.24	3.08	3.17	326800.0
2006-12-27	ABR	Stock	29.58	29.73	29.44	29.73	191800.0
2006-12-27	ABT	Stock	23.2703	23.5102	23.2175	23.5102	13415590.0
2006-12-27	ABTL-DELISTED	Stock	17.0	17.3	16.05	17.3	170036.0
2006-12-27	ABV-DELISTED	Stock	48.7	49.0	48.64	48.94	486600.0
2006-12-27	ABVA-DELISTED	Stock	15.83	15.8301	15.8299	15.8299	660.0
2006-12-27	ABVT-DELISTED	Stock	40.0	55.0	40.0	55.0	564.0
2006-12-27	ABX-DELISTED	Stock	30.18	30.61	30.01	30.57	2834635.0
2006-12-27	ACAD	Stock	9.1	9.23	8.98	9.08	149000.0
2006-12-27	ACAP-DELISTED	Stock	40.61	41.7	40.61	41.39	42648.0
2006-12-27	ACAS-DELISTED	Stock	45.55	46.0	45.49	45.95	376242.0
2006-12-27	ACAT-DELISTED	Stock	17.66	17.85	17.37	17.74	70251.0
2006-12-27	ACC-DELISTED	Stock	28.46	28.69	28.03	28.15	96873.0
2006-12-27	ACCL-DELISTED	Stock	5.87	5.96	5.84	5.96	69317.0

> showing 50 of 4,666 rows — these rows as CSV

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