PREVIEW / stock_daily / 2006-05-31

all stock daily files

  file:    by_date/stock_daily/2006/2006-05-31.parquet
  size:    149 KB
  rows:    4,445
  symbols: 2,803

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-05-31	AAPL	Stock	2.2057	2.2068	2.0961	2.1346	1280977600.0
2006-05-31	MSFT	Stock	23.26	23.35	22.65	22.65	120202000.0
2006-05-31	NVDA	Stock	0.388	0.3917	0.3807	0.383	598422000.0
2006-05-31	AMZN	Stock	1.737	1.747	1.6865	1.7305	103932000.0
2006-05-31	CL	Stock	30.115	30.245	30.01	30.17	3581200.0
2006-05-31	A	Stock	24.3705	25.0	24.3705	24.9571	5449684.0
2006-05-31	AABA-DELISTED	Stock	32.189998626709	32.3199996948242	31.1100006103516	31.5900001525879	21306700.0
2006-05-31	AACC-DELISTED	Stock	17.59	17.72	17.15	17.31	290968.0
2006-05-31	AACQW-DELISTED	Stock	0.59	0.63	0.56	0.62	155500.0
2006-05-31	AAI-DELISTED	Stock	12.09	12.53	12.01	12.32	1304400.0
2006-05-31	AAIC-DELISTED	Stock	214.4	215.0	209.8	210.2	1062300.0
2006-05-31	AAME	Stock	2.93	3.01	2.89	2.98	1500.0
2006-05-31	AAON	Stock	3.063	3.0907	3.0275	3.0709	66066.0
2006-05-31	AAP	Stock	37.58	38.25	37.58	38.12	1004000.0
2006-05-31	AATI-DELISTED	Stock	10.8	11.58	10.69	11.58	320951.0
2006-05-31	AAU-DELISTED	Stock	2.5	2.56	2.45	2.46	32400.0
2006-05-31	AAUAF-DELISTED	Stock	2.5	2.56	2.45	2.46	32400.0
2006-05-31	AAV-DELISTED	Stock	18.5	18.76	18.46	18.66	225900.0
2006-05-31	AAWW-DELISTED	Stock	51.0	51.0	49.5	50.95	17400.0
2006-05-31	AAXN-DELISTED	Stock	9.32999992370605	9.42000007629395	9.19999980926514	9.31999969482422	1057700.0
2006-05-31	AB	Stock	65.42	65.75	64.35	65.28	137500.0
2006-05-31	ABAX-DELISTED	Stock	16.98	17.44	16.84	17.07	356894.0
2006-05-31	ABB-DELISTED	Stock	12.49	12.66	12.45	12.6	1328300.0
2006-05-31	ABBC-DELISTED	Stock	13.98	14.14	13.75	14.05	30170.0
2006-05-31	ABC-DELISTED	Stock	21.7	21.89	21.64	21.82	2328200.0
2006-05-31	ABCB	Stock	21.1258	21.155	20.6491	20.7173	12543.0
2006-05-31	ABCO-DELISTED	Stock	25.51	25.87	25.48	25.84	240921.0
2006-05-31	ABCW-DELISTED	Stock	28.85	29.33	28.83	29.15	70570.0
2006-05-31	ABD-DELISTED	Stock	22.52	23.07	22.36	22.76	304790.0
2006-05-31	ABE-DELISTED	Stock	12.45	12.54	12.37	12.4	49400.0
2006-05-31	ABFS-DELISTED	Stock	40.82	41.49	40.43	41.21	587074.0
2006-05-31	ABG	Stock	20.55	20.9	20.54	20.86	240500.0
2006-05-31	ABK-DELISTED	Stock	79.28	80.23	78.95	80.15	866700.0
2006-05-31	ABM	Stock	17.16	17.4	17.16	17.35	236000.0
2006-05-31	ABMD-DELISTED	Stock	12.87	13.5	12.71	13.38	105489.0
2006-05-31	ABP-DELISTED	Stock	4.65	4.75	4.57	4.71	234700.0
2006-05-31	ABR	Stock	23.95	24.7	23.95	24.46	171600.0
2006-05-31	ABT	Stock	20.4203	20.5162	20.3099	20.4875	10966653.0
2006-05-31	ABTL-DELISTED	Stock	16.05	16.25	15.7	16.15	37421.0
2006-05-31	ABV-DELISTED	Stock	40.6	41.55	40.38	41.03	544400.0
2006-05-31	ABVA-DELISTED	Stock	18.9	18.97	18.8	18.8	6489.0
2006-05-31	ABX-DELISTED	Stock	30.86	31.11	30.21	30.61	4172000.0
2006-05-31	ACAD	Stock	10.28	10.54	10.25	10.36	432900.0
2006-05-31	ACAP-DELISTED	Stock	46.44	46.99	45.87	46.3	27334.0
2006-05-31	ACAS-DELISTED	Stock	33.67	34.26	33.6	34.25	2755922.0
2006-05-31	ACAT-DELISTED	Stock	18.77	19.0	17.98	18.3	182685.0
2006-05-31	ACC-DELISTED	Stock	23.54	23.96	23.54	23.86	58800.0
2006-05-31	ACCL-DELISTED	Stock	7.05	7.21	7.02	7.2	53322.0
2006-05-31	ACCO	Stock	22.52	23.07	22.36	22.76	311700.0
2006-05-31	ACE-DELISTED	Stock	51.5	51.93	51.3	51.75	1297600.0

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

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