PREVIEW / stock_daily / 2006-03-20

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-20.parquet
  size:    147 KB
  rows:    4,381
  symbols: 2,770

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-03-20	AAPL	Stock	2.3293	2.3379	2.2811	2.2854	605441200.0
2006-03-20	MSFT	Stock	27.7	27.99	27.67	27.89	67094100.0
2006-03-20	NVDA	Stock	0.41	0.4101	0.4029	0.4033	293772000.0
2006-03-20	AMZN	Stock	1.796	1.8635	1.79	1.8115	123416000.0
2006-03-20	CL	Stock	28.47	28.545	28.405	28.5	3082400.0
2006-03-20	A	Stock	27.0887	27.1102	26.731	26.9814	2414905.0
2006-03-20	AABA-DELISTED	Stock	30.3799991607666	30.9300003051758	30.2000007629395	30.4400005340576	21455200.0
2006-03-20	AACC-DELISTED	Stock	19.57	19.79	19.4	19.75	186271.0
2006-03-20	AACQU-DELISTED	Stock	7.05	7.05	7.05	7.05	1000.0
2006-03-20	AACQW-DELISTED	Stock	0.76	0.78	0.75	0.78	213765.0
2006-03-20	AAI-DELISTED	Stock	17.14	18.24	17.09	18.2	1832700.0
2006-03-20	AAIC-DELISTED	Stock	190.8	190.8	185.402	186.2	584000.0
2006-03-20	AAME	Stock	2.9	2.9	2.88	2.88	2300.0
2006-03-20	AAON	Stock	2.9274	2.9709	2.8668	2.9419	94922.0
2006-03-20	AAP	Stock	41.37	41.51	40.9	41.28	690100.0
2006-03-20	AATI-DELISTED	Stock	11.6	11.73	11.45	11.63	629293.0
2006-03-20	AAU-DELISTED	Stock	2.75	2.76	2.66	2.69	109800.0
2006-03-20	AAUAF-DELISTED	Stock	2.75	2.76	2.66	2.69	109800.0
2006-03-20	AAV-DELISTED	Stock	19.98	19.98	19.1	19.16	560100.0
2006-03-20	AAWW-DELISTED	Stock	48.0	48.0	45.0	48.0	50900.0
2006-03-20	AAXN-DELISTED	Stock	10.0500001907349	10.3400001525879	10.0	10.2299995422363	1813800.0
2006-03-20	AB	Stock	64.3	64.83	64.24	64.59	113000.0
2006-03-20	ABAX-DELISTED	Stock	24.2	24.99	23.8	24.65	1599835.0
2006-03-20	ABB-DELISTED	Stock	12.41	12.42	12.25	12.31	821900.0
2006-03-20	ABBC-DELISTED	Stock	13.34	13.34	13.25	13.25	58000.0
2006-03-20	ABC-DELISTED	Stock	23.84	23.96	23.58	23.68	1925400.0
2006-03-20	ABCB	Stock	21.9817	22.2735	21.9526	22.2638	18198.0
2006-03-20	ABCO-DELISTED	Stock	27.28	28.19	27.05	28.17	291872.0
2006-03-20	ABCW-DELISTED	Stock	30.26	30.37	29.85	30.21	45200.0
2006-03-20	ABD-DELISTED	Stock	21.91	22.71	21.9	22.59	187800.0
2006-03-20	ABE-DELISTED	Stock	12.78	12.84	12.72	12.75	43600.0
2006-03-20	ABFS-DELISTED	Stock	41.36	42.35	41.35	42.26	226014.0
2006-03-20	ABG	Stock	20.0	20.48	19.82	20.24	85800.0
2006-03-20	ABK-DELISTED	Stock	80.46	82.0	80.35	81.79	777100.0
2006-03-20	ABM	Stock	17.2	17.3	17.06	17.26	185300.0
2006-03-20	ABMD-DELISTED	Stock	11.26	12.23	11.26	12.06	182203.0
2006-03-20	ABP-DELISTED	Stock	5.97	5.97	5.72	5.73	273100.0
2006-03-20	ABR	Stock	26.71	26.94	26.5	26.81	57700.0
2006-03-20	ABT	Stock	21.543	21.5718	21.188	21.2312	11607128.0
2006-03-20	ABTL-DELISTED	Stock	22.83	23.47	22.78	23.42	39247.0
2006-03-20	ABV-DELISTED	Stock	43.6	44.26	42.84	42.99	403900.0
2006-03-20	ABX-DELISTED	Stock	26.69	27.14	26.57	26.57	3429900.0
2006-03-20	ACAD	Stock	16.27	16.45	14.54	14.96	1381100.0
2006-03-20	ACAP-DELISTED	Stock	49.58	50.67	49.25	50.25	42546.0
2006-03-20	ACAS-DELISTED	Stock	35.07	35.54	34.88	35.46	920014.0
2006-03-20	ACAT-DELISTED	Stock	23.86	24.43	23.86	24.29	34236.0
2006-03-20	ACC-DELISTED	Stock	27.6	27.6	26.51	26.67	216600.0
2006-03-20	ACCL-DELISTED	Stock	7.2	7.45	7.2	7.42	89516.0
2006-03-20	ACCO	Stock	21.91	22.71	21.9	22.59	188300.0
2006-03-20	ACCP-DELISTED	Stock	1.45	1.5	1.45	1.45	10410.0

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

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