PREVIEW / stock_daily / 2006-07-21

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-21.parquet
  size:    147 KB
  rows:    4,433
  symbols: 2,785

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-07-21	AAPL	Stock	2.1364	2.1839	2.13	2.1686	891892400.0
2006-07-21	MSFT	Stock	24.08	24.15	23.0	23.87	175483800.0
2006-07-21	NVDA	Stock	0.3093	0.3107	0.2938	0.2962	633918000.0
2006-07-21	AMZN	Stock	1.6925	1.6985	1.646	1.6595	142732000.0
2006-07-21	CL	Stock	31.475	31.58	30.96	31.035	4261600.0
2006-07-21	A	Stock	20.6724	20.6795	19.6567	19.9285	4913271.0
2006-07-21	AABA-DELISTED	Stock	24.9899997711182	26.0599994659424	24.9099998474121	25.8899993896484	36187100.0
2006-07-21	AACC-DELISTED	Stock	17.68	17.97	17.5	17.81	246163.0
2006-07-21	AACQ-DELISTED	Stock	5.32	5.33	5.32	5.32	213800.0
2006-07-21	AACQU-DELISTED	Stock	6.03	6.03	6.03	6.03	1000.0
2006-07-21	AACQW-DELISTED	Stock	0.38	0.38	0.38	0.38	2500.0
2006-07-21	AAI-DELISTED	Stock	12.82	12.91	12.51	12.62	1231700.0
2006-07-21	AAIC-DELISTED	Stock	194.0	195.0	187.0	190.6	1489000.0
2006-07-21	AAME	Stock	2.82	2.82	2.82	2.82	700.0
2006-07-21	AAON	Stock	3.017	3.1131	2.9564	3.1065	211106.0
2006-07-21	AAP	Stock	29.22	29.25	28.77	29.24	1362400.0
2006-07-21	AATI-DELISTED	Stock	9.29	9.32	8.98	8.99	152709.0
2006-07-21	AAU-DELISTED	Stock	2.42	2.42	2.34	2.36	22300.0
2006-07-21	AAUAF-DELISTED	Stock	2.42	2.42	2.34	2.36	22300.0
2006-07-21	AAV-DELISTED	Stock	15.9	15.9	15.68	15.68	270300.0
2006-07-21	AAWW-DELISTED	Stock	43.04	44.02	39.54	41.23	107121.0
2006-07-21	AAXN-DELISTED	Stock	7.38000011444092	7.51999998092651	7.34999990463257	7.40000009536743	802200.0
2006-07-21	AB	Stock	60.5	60.56	59.85	60.22	188100.0
2006-07-21	ABAX-DELISTED	Stock	19.55	19.68	19.4	19.48	303819.0
2006-07-21	ABB-DELISTED	Stock	11.78	11.78	11.63	11.68	1392100.0
2006-07-21	ABBC-DELISTED	Stock	14.34	14.34	14.1	14.22	15066.0
2006-07-21	ABC-DELISTED	Stock	21.0	21.2	20.88	21.0	1895600.0
2006-07-21	ABCB	Stock	21.5829	21.8261	20.8048	21.7094	21282.0
2006-07-21	ABCO-DELISTED	Stock	23.8	23.8	23.1	23.38	234819.0
2006-07-21	ABCW-DELISTED	Stock	29.03	29.4	28.68	29.1	45300.0
2006-07-21	ABD-DELISTED	Stock	19.49	19.65	18.93	19.6	169100.0
2006-07-21	ABE-DELISTED	Stock	12.08	12.3299	11.72	11.9299	5900.0
2006-07-21	ABFS-DELISTED	Stock	44.13	44.71	42.51	44.54	624865.0
2006-07-21	ABG	Stock	20.03	20.4	19.48	20.33	115100.0
2006-07-21	ABK-DELISTED	Stock	82.2	82.2	80.96	81.13	464900.0
2006-07-21	ABM	Stock	16.62	16.62	16.2	16.46	118900.0
2006-07-21	ABMD-DELISTED	Stock	12.89	12.89	12.41	12.74	63362.0
2006-07-21	ABP-DELISTED	Stock	4.15	4.17	3.97	4.05	201200.0
2006-07-21	ABR	Stock	25.81	25.81	25.06	25.35	92300.0
2006-07-21	ABT	Stock	22.2387	22.5458	22.0612	22.4738	13630263.0
2006-07-21	ABTL-DELISTED	Stock	16.6	16.65	16.1	16.35	43356.0
2006-07-21	ABV-DELISTED	Stock	40.05	40.1099	39.29	39.56	168400.0
2006-07-21	ABVA-DELISTED	Stock	15.99	15.99	15.99	15.99	320.0
2006-07-21	ABX-DELISTED	Stock	28.98	28.99	28.18	28.26	4843000.0
2006-07-21	ACAD	Stock	6.32	6.54	6.18	6.49	233700.0
2006-07-21	ACAP-DELISTED	Stock	47.02	47.08	46.39	46.39	12890.0
2006-07-21	ACAS-DELISTED	Stock	34.88	34.915	34.4	34.46	590189.0
2006-07-21	ACAT-DELISTED	Stock	16.62	17.19	16.37	16.98	36527.0
2006-07-21	ACC-DELISTED	Stock	24.77	24.79	24.2	24.52	51600.0
2006-07-21	ACCL-DELISTED	Stock	6.56	6.56	5.81	5.94	104816.0

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

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