PREVIEW / stock_daily / 2006-01-23

all stock daily files

  file:    by_date/stock_daily/2006/2006-01-23.parquet
  size:    144 KB
  rows:    4,313
  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-23	AAPL	Stock	2.7179	2.8414	2.7143	2.7739	1059730000.0
2006-01-23	MSFT	Stock	26.41	26.53	26.3	26.35	47925600.0
2006-01-23	NVDA	Stock	0.3679	0.3702	0.3629	0.3672	334884000.0
2006-01-23	AMZN	Stock	2.209	2.2375	2.175	2.1865	115056000.0
2006-01-23	CL	Stock	26.95	27.145	26.815	26.96	4680400.0
2006-01-23	A	Stock	24.4635	24.7353	24.4206	24.4993	2203108.0
2006-01-23	AABA-DELISTED	Stock	34.2200012207031	34.4000015258789	33.9799995422363	34.1699981689453	30887600.0
2006-01-23	AACC-DELISTED	Stock	23.6	23.92	23.3	23.3	106015.0
2006-01-23	AACQ-DELISTED	Stock	5.22	5.22	5.22	5.22	1000.0
2006-01-23	AACQU-DELISTED	Stock	6.45	6.5	6.45	6.5	3500.0
2006-01-23	AACQW-DELISTED	Stock	0.64	0.65	0.64	0.64	50000.0
2006-01-23	AAI-DELISTED	Stock	13.82	14.19	13.82	13.95	1493300.0
2006-01-23	AAIC-DELISTED	Stock	215.0	216.8	210.2	216.6	804800.0
2006-01-23	AAME	Stock	2.65	2.69	2.65	2.65	6400.0
2006-01-23	AAON	Stock	2.4507	2.4665	2.4072	2.4586	38728.0
2006-01-23	AAP	Stock	41.8	42.45	41.57	41.62	797900.0
2006-01-23	AATI-DELISTED	Stock	13.87	14.5	13.81	14.1	156415.0
2006-01-23	AAU-DELISTED	Stock	2.67	2.75	2.65	2.72	59400.0
2006-01-23	AAUAF-DELISTED	Stock	2.67	2.75	2.65	2.72	59400.0
2006-01-23	AAV-DELISTED	Stock	19.2	19.2	19.02	19.05	267900.0
2006-01-23	AAWW-DELISTED	Stock	44.25	44.75	43.5	44.2	51400.0
2006-01-23	AAXN-DELISTED	Stock	8.28999996185303	8.30000019073486	7.86999988555908	8.05000019073486	1656600.0
2006-01-23	ABAX-DELISTED	Stock	17.88	18.08	17.82	18.06	94295.0
2006-01-23	ABB-DELISTED	Stock	10.75	10.84	10.73	10.84	1070900.0
2006-01-23	ABC-DELISTED	Stock	20.45	20.58	20.33	20.48	2486000.0
2006-01-23	ABCB	Stock	19.6765	19.8711	19.4529	19.6085	5346.0
2006-01-23	ABCO-DELISTED	Stock	22.97	23.19	22.76	23.01	180110.0
2006-01-23	ABCW-DELISTED	Stock	31.44	31.46	31.12	31.29	28200.0
2006-01-23	ABD-DELISTED	Stock	24.25	24.32	23.99	24.01	130600.0
2006-01-23	ABE-DELISTED	Stock	12.3	12.49	12.25	12.45	24000.0
2006-01-23	ABFS-DELISTED	Stock	44.6	44.6	43.11	43.18	487206.0
2006-01-23	ABG	Stock	16.4	16.94	16.0	16.77	58000.0
2006-01-23	ABK-DELISTED	Stock	74.2	75.11	73.74	74.27	467700.0
2006-01-23	ABM	Stock	19.07	19.4	18.98	19.09	209100.0
2006-01-23	ABMD-DELISTED	Stock	10.2	10.52	10.11	10.29	88450.0
2006-01-23	ABP-DELISTED	Stock	6.38	6.57	6.25	6.44	559500.0
2006-01-23	ABR	Stock	26.13	26.6	26.0	26.33	70100.0
2006-01-23	ABT	Stock	19.4319	19.9357	19.2544	19.4367	7912880.0
2006-01-23	ABTL-DELISTED	Stock	25.18	25.42	24.83	24.97	27393.0
2006-01-23	ABV-DELISTED	Stock	40.09	40.21	39.61	40.11	2237200.0
2006-01-23	ABVA-DELISTED	Stock	16.622	16.79	16.598	16.79	1400.0
2006-01-23	ABVT-DELISTED	Stock	28.35	28.35	28.35	28.35	500.0
2006-01-23	ABX-DELISTED	Stock	30.03	30.34	29.62	29.92	7131930.0
2006-01-23	ACAD	Stock	10.4	10.4	9.9	9.93	46000.0
2006-01-23	ACAP-DELISTED	Stock	47.95	47.95	46.5	47.75	60159.0
2006-01-23	ACAS-DELISTED	Stock	34.65	35.0	34.51	34.75	631797.0
2006-01-23	ACAT-DELISTED	Stock	22.16	22.16	21.4	21.78	142234.0
2006-01-23	ACC-DELISTED	Stock	24.86	24.94	24.84	24.9	65000.0
2006-01-23	ACCL-DELISTED	Stock	6.68	6.7	6.47	6.51	113554.0
2006-01-23	ACCO	Stock	24.25	24.32	23.99	24.01	130600.0

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

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