PREVIEW / stock_daily / 2006-12-19

all stock daily files

  file:    by_date/stock_daily/2006/2006-12-19.parquet
  size:    156 KB
  rows:    4,669
  symbols: 2,965

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-19	AAPL	Stock	3.0261	3.0957	2.9864	3.0825	911405600.0
2006-12-19	MSFT	Stock	29.71	30.17	29.53	29.99	53822100.0
2006-12-19	NVDA	Stock	0.6277	0.6483	0.6268	0.645	545622000.0
2006-12-19	AMZN	Stock	1.939	1.986	1.9115	1.971	150400000.0
2006-12-19	CL	Stock	32.55	32.64	32.415	32.545	4122000.0
2006-12-19	A	Stock	24.1059	24.5351	24.0773	24.4063	1963631.0
2006-12-19	AABA-DELISTED	Stock	26.0499992370605	26.5	25.9099998474121	26.4099998474121	18973800.0
2006-12-19	AACC-DELISTED	Stock	16.01	16.15	15.89	16.12	64835.0
2006-12-19	AACQ-DELISTED	Stock	5.41	5.41	5.37	5.37	6500.0
2006-12-19	AACQU-DELISTED	Stock	6.52	6.52	6.5	6.5	2900.0
2006-12-19	AACQW-DELISTED	Stock	0.56	0.56	0.52	0.52	9000.0
2006-12-19	AAI-DELISTED	Stock	12.37	12.46	12.18	12.29	2163600.0
2006-12-19	AAIC-DELISTED	Stock	147.8	150.2	146.0	149.0	1563400.0
2006-12-19	AAME	Stock	2.96	2.96	2.92	2.92	1000.0
2006-12-19	AAON	Stock	3.2145	3.2737	3.175	3.2303	271097.0
2006-12-19	AAP	Stock	35.32	35.81	34.97	35.65	1850800.0
2006-12-19	AATI-DELISTED	Stock	5.21	5.39	5.2	5.23	331400.0
2006-12-19	AAU-DELISTED	Stock	2.3	2.38	2.3	2.36	53200.0
2006-12-19	AAUAF-DELISTED	Stock	2.3	2.38	2.3	2.36	53200.0
2006-12-19	AAV-DELISTED	Stock	11.45	11.57	11.38	11.49	647500.0
2006-12-19	AAWW-DELISTED	Stock	45.7	46.05	44.55	45.76	122489.0
2006-12-19	AAXN-DELISTED	Stock	7.71000003814697	7.76999998092651	7.57999992370605	7.59999990463257	1382700.0
2006-12-19	AB	Stock	79.27	79.27	78.72	79.02	113600.0
2006-12-19	ABAX-DELISTED	Stock	18.74	19.0	18.65	18.73	101684.0
2006-12-19	ABB-DELISTED	Stock	17.38	17.53	17.35	17.52	999300.0
2006-12-19	ABBC-DELISTED	Stock	19.04	19.07	18.92	19.07	8548.0
2006-12-19	ABC-DELISTED	Stock	22.8	23.06	22.53	22.7	4915400.0
2006-12-19	ABCB	Stock	26.6699	27.3507	26.6699	27.1659	21077.0
2006-12-19	ABCO-DELISTED	Stock	26.27	26.36	26.06	26.3	141856.0
2006-12-19	ABCW-DELISTED	Stock	28.43	28.75	28.4	28.63	56800.0
2006-12-19	ABD-DELISTED	Stock	26.36	26.78	26.25	26.71	333590.0
2006-12-19	ABE-DELISTED	Stock	19.3	19.5	18.4	18.68	112100.0
2006-12-19	ABFS-DELISTED	Stock	36.17	36.88	36.14	36.67	319623.0
2006-12-19	ABG	Stock	23.73	23.96	23.34	23.96	258900.0
2006-12-19	ABK-DELISTED	Stock	88.3	88.61	87.56	88.58	518800.0
2006-12-19	ABM	Stock	23.55	23.69	23.35	23.45	358200.0
2006-12-19	ABMD-DELISTED	Stock	13.5	13.66	13.22	13.52	102063.0
2006-12-19	ABP-DELISTED	Stock	3.34	3.54	3.23	3.53	304000.0
2006-12-19	ABR	Stock	28.69	29.27	28.43	29.18	77400.0
2006-12-19	ABT	Stock	23.1216	23.1839	22.968	23.1551	7355982.0
2006-12-19	ABTL-DELISTED	Stock	17.25	17.45	16.8	17.4	40998.0
2006-12-19	ABV-DELISTED	Stock	48.68	48.83	48.35	48.75	296900.0
2006-12-19	ABVA-DELISTED	Stock	15.78	15.88	15.46	15.49	7150.0
2006-12-19	ABVT-DELISTED	Stock	58.0	58.0	58.0	58.0	1312.0
2006-12-19	ABX-DELISTED	Stock	30.27	30.75	30.23	30.68	4176158.0
2006-12-19	ACAD	Stock	9.18	9.23	8.89	8.92	125700.0
2006-12-19	ACAP-DELISTED	Stock	38.71	39.36	38.66	39.13	48082.0
2006-12-19	ACAS-DELISTED	Stock	45.12	45.73	45.0	45.51	742744.0
2006-12-19	ACAT-DELISTED	Stock	17.27	17.47	17.16	17.46	671295.0
2006-12-19	ACC-DELISTED	Stock	28.81	28.89	28.2	28.34	117600.0

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

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