PREVIEW / stock_daily / 2006-01-20

all stock daily files

  file:    by_date/stock_daily/2006/2006-01-20.parquet
  size:    145 KB
  rows:    4,319
  symbols: 2,729

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-01-20	AAPL	Stock	2.8314	2.8586	2.7082	2.7175	1134758800.0
2006-01-20	MSFT	Stock	27.01	27.01	26.26	26.41	79165900.0
2006-01-20	NVDA	Stock	0.3762	0.3805	0.365	0.3651	461604000.0
2006-01-20	AMZN	Stock	2.2115	2.218	2.16	2.196	166148000.0
2006-01-20	CL	Stock	27.425	27.47	26.76	26.85	8190400.0
2006-01-20	A	Stock	24.9285	25.0358	24.3205	24.4993	5196646.0
2006-01-20	AABA-DELISTED	Stock	34.439998626709	34.6599998474121	33.2099990844727	33.7400016784668	57644600.0
2006-01-20	AACC-DELISTED	Stock	23.58	23.8	23.5	23.55	118881.0
2006-01-20	AACQW-DELISTED	Stock	0.62	0.62	0.62	0.62	35000.0
2006-01-20	AAI-DELISTED	Stock	14.13	14.28	13.64	13.8	1361900.0
2006-01-20	AAIC-DELISTED	Stock	221.4	222.0	215.8	216.0	507600.0
2006-01-20	AAME	Stock	2.66	2.66	2.65	2.66	1700.0
2006-01-20	AAON	Stock	2.4691	2.4691	2.3743	2.4033	137447.0
2006-01-20	AAP	Stock	42.18	42.78	41.75	41.92	732000.0
2006-01-20	AATI-DELISTED	Stock	14.41	14.41	13.56	14.01	201546.0
2006-01-20	AAU-DELISTED	Stock	2.65	2.69	2.6	2.65	75300.0
2006-01-20	AAUAF-DELISTED	Stock	2.65	2.69	2.6	2.65	75300.0
2006-01-20	AAV-DELISTED	Stock	19.05	19.25	19.04	19.18	269200.0
2006-01-20	AAWW-DELISTED	Stock	44.7	44.85	44.25	44.25	25000.0
2006-01-20	AAXN-DELISTED	Stock	8.46000003814697	8.51000022888184	8.11999988555908	8.18000030517578	1451300.0
2006-01-20	ABAX-DELISTED	Stock	18.05	18.18	17.76	17.79	122738.0
2006-01-20	ABB-DELISTED	Stock	10.92	10.93	10.6401	10.69	955200.0
2006-01-20	ABBC-DELISTED	Stock	13.01	13.2	13.01	13.2	2115.0
2006-01-20	ABC-DELISTED	Stock	20.48	20.56	20.34	20.5	2932000.0
2006-01-20	ABCB	Stock	19.8322	19.8322	19.2291	19.3847	11104.0
2006-01-20	ABCO-DELISTED	Stock	23.09	23.15	22.91	22.95	140458.0
2006-01-20	ABCW-DELISTED	Stock	32.01	32.01	31.17	31.19	60380.0
2006-01-20	ABD-DELISTED	Stock	24.5	24.5	24.1	24.32	146700.0
2006-01-20	ABE-DELISTED	Stock	12.75	12.78	12.3	12.3	31100.0
2006-01-20	ABFS-DELISTED	Stock	45.21	45.6	44.03	44.52	282500.0
2006-01-20	ABG	Stock	16.72	16.72	16.3	16.5	72300.0
2006-01-20	ABK-DELISTED	Stock	75.54	76.0	74.08	74.12	624000.0
2006-01-20	ABM	Stock	19.45	19.45	18.97	19.03	160700.0
2006-01-20	ABMD-DELISTED	Stock	10.34	10.37	10.1	10.16	57540.0
2006-01-20	ABP-DELISTED	Stock	6.74	6.8	6.36	6.45	879900.0
2006-01-20	ABR	Stock	26.62	26.62	26.1	26.14	109800.0
2006-01-20	ABT	Stock	19.9597	19.9597	19.3407	19.3599	9828262.0
2006-01-20	ABTL-DELISTED	Stock	25.5	25.5	25.05	25.25	20576.0
2006-01-20	ABV-DELISTED	Stock	40.9	41.0	39.81	39.83	519800.0
2006-01-20	ABVA-DELISTED	Stock	16.59	16.632	16.58	16.632	1560.0
2006-01-20	ABX-DELISTED	Stock	30.4	30.57	29.94	29.99	12311600.0
2006-01-20	ACAD	Stock	10.93	10.93	10.37	10.39	65700.0
2006-01-20	ACAP-DELISTED	Stock	49.16	49.16	47.59	47.71	14305.0
2006-01-20	ACAS-DELISTED	Stock	34.51	34.74	34.42	34.51	983386.0
2006-01-20	ACAT-DELISTED	Stock	22.6	22.6	21.84	21.97	63811.0
2006-01-20	ACC-DELISTED	Stock	24.91	25.01	24.76	24.87	55292.0
2006-01-20	ACCL-DELISTED	Stock	6.75	6.87	6.62	6.71	67817.0
2006-01-20	ACCO	Stock	24.5	24.5	24.1	24.32	147400.0
2006-01-20	ACE-DELISTED	Stock	54.48	54.71	52.85	52.92	1526358.0
2006-01-20	ACF-DELISTED	Stock	27.32	27.39	27.0	27.3	2022500.0

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

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