PREVIEW / stock_daily / 2006-12-21

all stock daily files

  file:    by_date/stock_daily/2006/2006-12-21.parquet
  size:    155 KB
  rows:    4,664
  symbols: 2,956

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-21	AAPL	Stock	3.025	3.0529	2.9357	2.9607	903599200.0
2006-12-21	MSFT	Stock	30.13	30.14	29.89	29.98	32270500.0
2006-12-21	NVDA	Stock	0.6412	0.643	0.625	0.6322	367920000.0
2006-12-21	AMZN	Stock	1.9935	2.017	1.9825	1.9945	131004000.0
2006-12-21	CL	Stock	32.575	32.685	32.205	32.345	3882400.0
2006-12-21	A	Stock	24.299	24.5994	24.1845	24.4993	2922799.0
2006-12-21	AABA-DELISTED	Stock	25.7099990844727	25.75	25.1299991607666	25.4799995422363	27050600.0
2006-12-21	AACC-DELISTED	Stock	16.04	16.25	16.02	16.07	122344.0
2006-12-21	AACQ-DELISTED	Stock	5.42	5.42	5.34	5.42	33100.0
2006-12-21	AAI-DELISTED	Stock	12.18	12.22	11.65	11.75	2155900.0
2006-12-21	AAIC-DELISTED	Stock	158.0	166.2	158.0	162.4	3692200.0
2006-12-21	AAME	Stock	2.9	2.9	2.9	2.9	200.0
2006-12-21	AAON	Stock	3.2277	3.3396	3.2277	3.3396	216422.0
2006-12-21	AAP	Stock	36.02	36.16	35.51	35.6	358600.0
2006-12-21	AATI-DELISTED	Stock	5.2	5.28	5.15	5.25	274535.0
2006-12-21	AAU-DELISTED	Stock	2.32	2.53	2.25	2.37	195600.0
2006-12-21	AAUAF-DELISTED	Stock	2.32	2.53	2.25	2.37	195600.0
2006-12-21	AAV-DELISTED	Stock	11.45	11.46	11.22	11.27	728800.0
2006-12-21	AAWW-DELISTED	Stock	45.72	46.32	44.69	44.94	118657.0
2006-12-21	AAXN-DELISTED	Stock	7.65999984741211	7.76999998092651	7.55000019073486	7.59999990463257	622000.0
2006-12-21	AB	Stock	79.27	80.29	78.87	79.75	312600.0
2006-12-21	ABAX-DELISTED	Stock	19.02	19.34	18.78	18.9	105720.0
2006-12-21	ABB-DELISTED	Stock	17.71	17.7188	17.51	17.58	1721200.0
2006-12-21	ABBC-DELISTED	Stock	19.09	19.09	18.9	19.03	13968.0
2006-12-21	ABC-DELISTED	Stock	22.76	23.08	22.52	22.6	3337600.0
2006-12-21	ABCB	Stock	27.5161	27.8662	27.0103	27.234	11926.0
2006-12-21	ABCO-DELISTED	Stock	26.45	26.61	26.36	26.59	294998.0
2006-12-21	ABCW-DELISTED	Stock	28.89	29.03	28.76	28.79	44160.0
2006-12-21	ABD-DELISTED	Stock	26.98	27.45	26.98	27.32	374500.0
2006-12-21	ABE-DELISTED	Stock	17.9	18.8	17.62	18.58	33000.0
2006-12-21	ABFS-DELISTED	Stock	36.48	36.79	36.29	36.51	195570.0
2006-12-21	ABG	Stock	23.85	24.0	23.75	23.88	111700.0
2006-12-21	ABK-DELISTED	Stock	88.57	89.43	88.39	89.03	606800.0
2006-12-21	ABM	Stock	23.47	23.8	22.99	23.26	286200.0
2006-12-21	ABMD-DELISTED	Stock	14.15	15.09	14.0	14.05	292006.0
2006-12-21	ABP-DELISTED	Stock	3.43	3.47	3.2	3.21	417600.0
2006-12-21	ABR	Stock	29.35	29.57	29.0	29.05	42400.0
2006-12-21	ABT	Stock	22.9632	23.0304	22.7713	23.0304	7997916.0
2006-12-21	ABTL-DELISTED	Stock	16.998	17.097	16.651	16.8	42814.0
2006-12-21	ABV-DELISTED	Stock	48.58	48.7	48.18	48.59	511400.0
2006-12-21	ABVA-DELISTED	Stock	15.84	15.84	15.84	15.84	475.0
2006-12-21	ABX-DELISTED	Stock	30.3	30.3	29.82	30.02	4359400.0
2006-12-21	ACAD	Stock	9.01	9.04	8.79	9.0	88300.0
2006-12-21	ACAP-DELISTED	Stock	39.88	40.22	39.64	39.75	35601.0
2006-12-21	ACAS-DELISTED	Stock	45.19	45.32	44.68	44.7	814105.0
2006-12-21	ACAT-DELISTED	Stock	17.89	18.02	17.65	17.97	68895.0
2006-12-21	ACC-DELISTED	Stock	28.36	28.66	28.35	28.4	348400.0
2006-12-21	ACCL-DELISTED	Stock	5.66	5.75	5.66	5.73	51913.0
2006-12-21	ACCO	Stock	26.98	27.45	26.98	27.32	403900.0
2006-12-21	ACCP-DELISTED	Stock	2.8	2.88	2.8	2.87	7485.0

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

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