PREVIEW / stock_daily / 2006-05-23

all stock daily files

  file:    by_date/stock_daily/2006/2006-05-23.parquet
  size:    148 KB
  rows:    4,428
  symbols: 2,792

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-23	AAPL	Stock	2.3164	2.3282	2.25	2.2554	694414000.0
2006-05-23	MSFT	Stock	23.11	23.38	22.77	22.79	79986300.0
2006-05-23	NVDA	Stock	0.4083	0.4178	0.394	0.3957	532314000.0
2006-05-23	AMZN	Stock	1.75	1.8	1.688	1.688	176454000.0
2006-05-23	CL	Stock	30.01	30.195	29.695	29.715	4212200.0
2006-05-23	A	Stock	24.6996	25.1216	24.6066	24.671	3992129.0
2006-05-23	AABA-DELISTED	Stock	31.0400009155273	31.6299991607666	30.7600002288818	30.7600002288818	28583400.0
2006-05-23	AACC-DELISTED	Stock	17.59	17.88	17.32	17.41	459524.0
2006-05-23	AACQ-DELISTED	Stock	5.34	5.34	5.34	5.34	500.0
2006-05-23	AACQU-DELISTED	Stock	6.46	6.46	6.46	6.46	1300.0
2006-05-23	AACQW-DELISTED	Stock	0.57	0.6	0.57	0.6	19000.0
2006-05-23	AAI-DELISTED	Stock	12.82	13.13	12.51	12.6	2372700.0
2006-05-23	AAIC-DELISTED	Stock	194.6	199.2	192.0	192.8	857200.0
2006-05-23	AAME	Stock	3.06	3.06	2.84	2.84	1100.0
2006-05-23	AAON	Stock	3.1144	3.2803	3.0867	3.0894	228572.0
2006-05-23	AAP	Stock	38.7	39.26	38.05	38.05	1159200.0
2006-05-23	AATI-DELISTED	Stock	10.48	11.0	10.46	10.62	287887.0
2006-05-23	AAU-DELISTED	Stock	2.52	2.67	2.36	2.48	137100.0
2006-05-23	AAUAF-DELISTED	Stock	2.52	2.67	2.36	2.48	137100.0
2006-05-23	AAV-DELISTED	Stock	18.75	19.03	18.51	18.75	324700.0
2006-05-23	AAWW-DELISTED	Stock	46.5	49.0	46.5	49.0	6000.0
2006-05-23	AAXN-DELISTED	Stock	9.30000019073486	9.48999977111816	9.25	9.39999961853027	853900.0
2006-05-23	AB	Stock	64.51	65.42	63.33	63.33	101600.0
2006-05-23	ABAX-DELISTED	Stock	17.5	18.44	17.0	17.0	1058631.0
2006-05-23	ABB-DELISTED	Stock	12.35	12.93	12.35	12.54	5512100.0
2006-05-23	ABBC-DELISTED	Stock	13.75	13.8199	13.75	13.78	1950.0
2006-05-23	ABC-DELISTED	Stock	21.84	22.06	21.76	21.85	2427600.0
2006-05-23	ABCB	Stock	21.0091	21.1938	20.7173	20.8048	16347.0
2006-05-23	ABCO-DELISTED	Stock	24.67	25.28	24.53	25.1	353842.0
2006-05-23	ABCW-DELISTED	Stock	28.9	29.67	28.86	29.44	97550.0
2006-05-23	ABD-DELISTED	Stock	22.06	23.0	22.04	22.56	589440.0
2006-05-23	ABE-DELISTED	Stock	12.32	12.55	12.32	12.4899	16100.0
2006-05-23	ABFS-DELISTED	Stock	43.59	44.39	42.62	42.72	370837.0
2006-05-23	ABG	Stock	19.73	19.95	19.68	19.93	123500.0
2006-05-23	ABK-DELISTED	Stock	80.65	81.15	80.38	80.75	528900.0
2006-05-23	ABM	Stock	17.21	17.59	17.21	17.39	305500.0
2006-05-23	ABMD-DELISTED	Stock	12.21	12.22	11.65	12.01	118817.0
2006-05-23	ABP-DELISTED	Stock	4.47	4.63	4.3	4.37	444900.0
2006-05-23	ABR	Stock	23.9	24.12	23.75	23.94	213400.0
2006-05-23	ABT	Stock	20.0556	20.142	19.9741	20.0269	7987286.0
2006-05-23	ABTL-DELISTED	Stock	15.8	16.25	15.6	15.65	38371.0
2006-05-23	ABV-DELISTED	Stock	41.16	42.92	41.06	41.11	1370200.0
2006-05-23	ABVA-DELISTED	Stock	18.9	18.9	18.65	18.65	752.0
2006-05-23	ABX-DELISTED	Stock	31.06	31.97	31.0	31.1	6546300.0
2006-05-23	ACAD	Stock	10.41	10.62	9.86	9.88	206400.0
2006-05-23	ACAP-DELISTED	Stock	45.17	45.65	44.24	44.29	55283.0
2006-05-23	ACAS-DELISTED	Stock	34.35	34.41	33.88	33.95	1712931.0
2006-05-23	ACAT-DELISTED	Stock	19.69	19.79	19.1	19.23	100105.0
2006-05-23	ACC-DELISTED	Stock	23.55	23.93	23.44	23.61	134300.0
2006-05-23	ACCL-DELISTED	Stock	6.52	6.69	6.52	6.61	77533.0

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

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