PREVIEW / stock_daily / 2006-12-20

all stock daily files

  file:    by_date/stock_daily/2006/2006-12-20.parquet
  size:    156 KB
  rows:    4,671
  symbols: 2,960

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-20	AAPL	Stock	3.0882	3.0954	3.0264	3.0271	567691600.0
2006-12-20	MSFT	Stock	29.99	30.24	29.97	30.09	31202100.0
2006-12-20	NVDA	Stock	0.6417	0.6493	0.6372	0.6377	306594000.0
2006-12-20	AMZN	Stock	1.9715	2.015	1.9695	2.0005	155686000.0
2006-12-20	CL	Stock	32.595	32.72	32.53	32.585	3989800.0
2006-12-20	A	Stock	24.4278	25.0	24.3491	24.3562	5934510.0
2006-12-20	AABA-DELISTED	Stock	26.2399997711182	26.3099994659424	25.5400009155273	25.5900001525879	24905600.0
2006-12-20	AACC-DELISTED	Stock	16.11	16.13	15.89	15.98	85612.0
2006-12-20	AACQ-DELISTED	Stock	5.4	5.42	5.4	5.42	20500.0
2006-12-20	AACQW-DELISTED	Stock	0.56	0.56	0.56	0.56	104000.0
2006-12-20	AAI-DELISTED	Stock	12.3	12.39	12.06	12.09	1299000.0
2006-12-20	AAIC-DELISTED	Stock	149.0	157.2	149.0	157.2	4504600.0
2006-12-20	AAME	Stock	2.9	2.9	2.9	2.9	300.0
2006-12-20	AAON	Stock	3.2277	3.25	3.1842	3.1947	167062.0
2006-12-20	AAP	Stock	35.61	36.44	35.52	36.02	1359200.0
2006-12-20	AATI-DELISTED	Stock	5.25	5.3	5.16	5.21	353834.0
2006-12-20	AAU-DELISTED	Stock	2.31	2.36	2.25	2.35	75800.0
2006-12-20	AAUAF-DELISTED	Stock	2.31	2.36	2.25	2.35	75800.0
2006-12-20	AAV-DELISTED	Stock	11.54	11.57	11.41	11.48	694200.0
2006-12-20	AAWW-DELISTED	Stock	45.88	46.43	45.28	45.8	97607.0
2006-12-20	AAXN-DELISTED	Stock	7.67999982833862	7.80999994277954	7.65999984741211	7.69000005722046	930100.0
2006-12-20	AB	Stock	78.84	79.27	78.68	78.96	142900.0
2006-12-20	ABAX-DELISTED	Stock	18.66	19.25	18.66	18.96	125375.0
2006-12-20	ABB-DELISTED	Stock	17.83	17.9	17.76	17.81	1503000.0
2006-12-20	ABBC-DELISTED	Stock	19.05	19.14	18.97	19.02	9564.0
2006-12-20	ABC-DELISTED	Stock	22.77	22.88	22.68	22.7	4001400.0
2006-12-20	ABCB	Stock	27.3896	27.5744	27.1951	27.5453	7608.0
2006-12-20	ABCO-DELISTED	Stock	26.28	26.46	26.19	26.31	158932.0
2006-12-20	ABCW-DELISTED	Stock	28.66	28.88	28.54	28.74	69590.0
2006-12-20	ABD-DELISTED	Stock	26.69	27.09	26.3	26.98	278000.0
2006-12-20	ABE-DELISTED	Stock	19.08	19.11	17.5	18.45	72200.0
2006-12-20	ABFS-DELISTED	Stock	36.71	36.85	36.39	36.56	128252.0
2006-12-20	ABG	Stock	24.0	24.16	23.82	23.91	198300.0
2006-12-20	ABK-DELISTED	Stock	88.71	88.89	88.4	88.77	282300.0
2006-12-20	ABM	Stock	23.5	23.95	23.33	23.49	250300.0
2006-12-20	ABMD-DELISTED	Stock	13.5	13.61	13.42	13.52	80758.0
2006-12-20	ABP-DELISTED	Stock	3.55	3.62	3.42	3.52	143400.0
2006-12-20	ABR	Stock	29.29	29.35	29.0	29.25	71200.0
2006-12-20	ABT	Stock	23.088	23.2079	22.7569	23.0064	8064402.0
2006-12-20	ABTL-DELISTED	Stock	18.726	18.726	17.074	17.274	134905.0
2006-12-20	ABV-DELISTED	Stock	48.48	48.82	48.41	48.64	399400.0
2006-12-20	ABVA-DELISTED	Stock	15.69	15.83	15.6	15.7865	8326.0
2006-12-20	ABVT-DELISTED	Stock	58.0	58.0	58.0	58.0	100.0
2006-12-20	ABX-DELISTED	Stock	30.69	30.74	30.17	30.25	3545542.0
2006-12-20	ACAD	Stock	8.98	9.06	8.9	8.98	86400.0
2006-12-20	ACAP-DELISTED	Stock	39.04	40.01	38.75	39.99	38629.0
2006-12-20	ACAS-DELISTED	Stock	45.48	45.53	44.93	44.9615	660894.0
2006-12-20	ACAT-DELISTED	Stock	17.52	18.05	17.52	17.84	86092.0
2006-12-20	ACC-DELISTED	Stock	28.38	28.64	28.31	28.39	114506.0
2006-12-20	ACCL-DELISTED	Stock	5.65	5.72	5.53	5.66	113823.0

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

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