PREVIEW / stock_daily / 2006-06-20

all stock daily files

  file:    by_date/stock_daily/2006/2006-06-20.parquet
  size:    146 KB
  rows:    4,410
  symbols: 2,771

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-06-20	AAPL	Stock	2.0575	2.0839	2.0461	2.0525	672974400.0
2006-06-20	MSFT	Stock	22.54	22.76	22.5	22.56	90598500.0
2006-06-20	NVDA	Stock	0.3405	0.3525	0.3392	0.3447	535818000.0
2006-06-20	AMZN	Stock	1.7505	1.7825	1.744	1.774	89310000.0
2006-06-20	CL	Stock	30.165	30.325	30.045	30.085	4821400.0
2006-06-20	A	Stock	23.1402	23.3619	22.9399	23.0186	2086375.0
2006-06-20	AABA-DELISTED	Stock	30.4200000762939	30.6499996185303	30.1000003814697	30.6000003814697	12613200.0
2006-06-20	AACC-DELISTED	Stock	19.1	19.1	18.87	18.87	167154.0
2006-06-20	AACQW-DELISTED	Stock	0.45	0.45	0.43	0.44	25500.0
2006-06-20	AAI-DELISTED	Stock	14.12	14.4	13.95	14.04	1638600.0
2006-06-20	AAIC-DELISTED	Stock	202.2	204.2	197.4	202.8	1206700.0
2006-06-20	AAME	Stock	3.13	3.13	3.12	3.12	200.0
2006-06-20	AAON	Stock	2.851	2.8813	2.7957	2.7984	220219.0
2006-06-20	AAP	Stock	37.35	37.78	36.82	36.99	819200.0
2006-06-20	AATI-DELISTED	Stock	10.0	10.11	9.85	9.89	165447.0
2006-06-20	AAU-DELISTED	Stock	2.31	2.4	2.3	2.32	11500.0
2006-06-20	AAUAF-DELISTED	Stock	2.31	2.4	2.3	2.32	11500.0
2006-06-20	AAV-DELISTED	Stock	18.4	18.4	18.12	18.19	180700.0
2006-06-20	AAWW-DELISTED	Stock	50.03	50.03	49.85	50.0	208605.0
2006-06-20	AAXN-DELISTED	Stock	8.0	8.19999980926514	8.0	8.14000034332275	547600.0
2006-06-20	AB	Stock	58.87	59.25	58.29	58.8	138900.0
2006-06-20	ABAX-DELISTED	Stock	19.41	19.94	19.29	19.55	207402.0
2006-06-20	ABB-DELISTED	Stock	11.81	11.97	11.69	11.92	2063600.0
2006-06-20	ABBC-DELISTED	Stock	14.88	15.04	14.84	14.89	26900.0
2006-06-20	ABC-DELISTED	Stock	20.6	20.6	20.19	20.36	1820200.0
2006-06-20	ABCB	Stock	20.0559	20.5714	20.0461	20.1823	17684.0
2006-06-20	ABCO-DELISTED	Stock	23.49	23.76	23.16	23.24	58327.0
2006-06-20	ABCW-DELISTED	Stock	28.57	28.88	28.38	28.5	67710.0
2006-06-20	ABD-DELISTED	Stock	21.93	22.33	21.93	22.05	174000.0
2006-06-20	ABE-DELISTED	Stock	12.05	12.2	11.95	11.95	8400.0
2006-06-20	ABFS-DELISTED	Stock	41.83	42.47	41.56	41.79	325632.0
2006-06-20	ABG	Stock	20.74	21.04	20.51	20.88	43700.0
2006-06-20	ABK-DELISTED	Stock	79.6	80.42	79.39	79.55	591200.0
2006-06-20	ABM	Stock	17.5	17.78	17.5	17.55	129800.0
2006-06-20	ABMD-DELISTED	Stock	12.37	12.37	12.0	12.02	91054.0
2006-06-20	ABP-DELISTED	Stock	4.6	4.66	4.38	4.41	165200.0
2006-06-20	ABR	Stock	23.65	23.85	23.6	23.62	107000.0
2006-06-20	ABT	Stock	20.2476	20.3723	20.238	20.2572	5813464.0
2006-06-20	ABTL-DELISTED	Stock	14.85	15.25	14.7	15.0	65178.0
2006-06-20	ABV-DELISTED	Stock	37.3	38.1	37.17	37.81	625200.0
2006-06-20	ABVA-DELISTED	Stock	16.5	16.9	16.5	16.9	1242.0
2006-06-20	ABX-DELISTED	Stock	27.5	28.1	27.3	27.62	3098600.0
2006-06-20	ACAD	Stock	8.57	8.72	8.34	8.39	172800.0
2006-06-20	ACAP-DELISTED	Stock	45.07	46.38	44.85	45.77	47096.0
2006-06-20	ACAS-DELISTED	Stock	32.9	32.92	32.64	32.78	694169.0
2006-06-20	ACAT-DELISTED	Stock	16.72	17.42	16.71	17.34	47051.0
2006-06-20	ACC-DELISTED	Stock	23.8	24.2	23.6	23.98	52600.0
2006-06-20	ACCL-DELISTED	Stock	7.09	7.17	7.06	7.09	81119.0
2006-06-20	ACCO	Stock	21.93	22.33	21.93	22.05	177800.0
2006-06-20	ACCP-DELISTED	Stock	0.9	0.9	0.55	0.55	1700.0

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

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