PREVIEW / stock_daily / 2006-07-20

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-20.parquet
  size:    147 KB
  rows:    4,424
  symbols: 2,787

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-07-20	AAPL	Stock	2.1771	2.1996	2.1329	2.1607	1972146400.0
2006-07-20	MSFT	Stock	23.44	23.45	22.78	22.85	76605200.0
2006-07-20	NVDA	Stock	0.3325	0.3383	0.3197	0.3202	505602000.0
2006-07-20	AMZN	Stock	1.7195	1.7405	1.6915	1.709	116724000.0
2006-07-20	CL	Stock	31.04	31.355	30.805	31.225	3134200.0
2006-07-20	A	Stock	21.1016	21.4306	20.5436	20.5794	3421046.0
2006-07-20	AABA-DELISTED	Stock	25.5499992370605	26.2099990844727	24.9099998474121	25.2700004577637	54659700.0
2006-07-20	AACC-DELISTED	Stock	17.92	18.07	17.68	17.82	140575.0
2006-07-20	AACQ-DELISTED	Stock	5.35	5.35	5.35	5.35	500.0
2006-07-20	AACQW-DELISTED	Stock	0.38	0.38	0.38	0.38	24500.0
2006-07-20	AAI-DELISTED	Stock	13.74	13.9	13.09	13.14	1033800.0
2006-07-20	AAIC-DELISTED	Stock	201.4	204.0	193.4	194.0	990200.0
2006-07-20	AAON	Stock	3.3317	3.3554	3.0249	3.0328	373612.0
2006-07-20	AAP	Stock	29.3	29.4	29.02	29.23	1865000.0
2006-07-20	AATI-DELISTED	Stock	9.6	9.75	9.33	9.33	88043.0
2006-07-20	AAU-DELISTED	Stock	2.45	2.4944	2.36	2.37	49200.0
2006-07-20	AAUAF-DELISTED	Stock	2.45	2.4944	2.36	2.37	49200.0
2006-07-20	AAV-DELISTED	Stock	15.95	16.08	15.85	15.88	303100.0
2006-07-20	AAWW-DELISTED	Stock	44.74	44.74	43.06	43.45	72524.0
2006-07-20	AAXN-DELISTED	Stock	7.63000011444092	7.76999998092651	7.32000017166138	7.3899998664856	651700.0
2006-07-20	AB	Stock	61.07	61.38	60.19	60.33	189900.0
2006-07-20	ABAX-DELISTED	Stock	19.94	19.96	19.44	19.66	253187.0
2006-07-20	ABB-DELISTED	Stock	12.19	12.25	11.94	11.95	1402900.0
2006-07-20	ABBC-DELISTED	Stock	14.5	14.59	14.46	14.46	8111.0
2006-07-20	ABC-DELISTED	Stock	21.24	21.3	20.92	20.94	1287800.0
2006-07-20	ABCB	Stock	22.3708	22.3708	21.6608	21.7969	11104.0
2006-07-20	ABCO-DELISTED	Stock	24.1	24.49	23.78	23.78	135314.0
2006-07-20	ABCW-DELISTED	Stock	30.34	30.59	29.24	29.24	28210.0
2006-07-20	ABD-DELISTED	Stock	20.84	21.08	19.5	19.51	142400.0
2006-07-20	ABE-DELISTED	Stock	12.29	12.34	12.04	12.3	14400.0
2006-07-20	ABFS-DELISTED	Stock	47.51	47.76	44.16	44.3	375166.0
2006-07-20	ABG	Stock	20.11	20.4	20.0	20.03	170000.0
2006-07-20	ABK-DELISTED	Stock	82.0	82.34	81.62	81.95	778100.0
2006-07-20	ABM	Stock	17.1	17.15	16.53	16.62	167700.0
2006-07-20	ABMD-DELISTED	Stock	13.63	13.63	12.92	12.97	90799.0
2006-07-20	ABP-DELISTED	Stock	4.35	4.36	4.14	4.19	120700.0
2006-07-20	ABR	Stock	25.95	25.95	25.51	25.77	63400.0
2006-07-20	ABT	Stock	22.0516	22.4067	22.0324	22.1716	10007086.0
2006-07-20	ABTL-DELISTED	Stock	16.825	17.026	16.274	16.475	52331.0
2006-07-20	ABV-DELISTED	Stock	40.7	40.71	39.65	39.85	366300.0
2006-07-20	ABVA-DELISTED	Stock	16.35	16.35	16.1	16.1	1036.0
2006-07-20	ABVT-DELISTED	Stock	48.5	48.5	48.5	48.5	19200.0
2006-07-20	ABX-DELISTED	Stock	29.75	29.88	28.67	28.7	3965300.0
2006-07-20	ACAD	Stock	6.59	6.69	6.18	6.33	288700.0
2006-07-20	ACAP-DELISTED	Stock	48.32	48.38	47.09	47.11	25794.0
2006-07-20	ACAS-DELISTED	Stock	34.71	34.92	34.6	34.76	725316.0
2006-07-20	ACAT-DELISTED	Stock	17.7	17.85	16.7043	16.71	40863.0
2006-07-20	ACC-DELISTED	Stock	25.75	25.84	24.71	24.74	60700.0
2006-07-20	ACCL-DELISTED	Stock	6.76	6.8	6.58	6.58	19235.0
2006-07-20	ACCO	Stock	20.84	21.08	19.5	19.51	160500.0

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

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