PREVIEW / stock_daily / 2006-07-19

all stock daily files

  file:    by_date/stock_daily/2006/2006-07-19.parquet
  size:    148 KB
  rows:    4,455
  symbols: 2,810

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-19	AAPL	Stock	1.8914	1.9671	1.87	1.9321	1390743200.0
2006-07-19	MSFT	Stock	22.82	23.46	22.72	23.4	82188200.0
2006-07-19	NVDA	Stock	0.3117	0.3307	0.3093	0.3267	1055550000.0
2006-07-19	AMZN	Stock	1.675	1.7385	1.6695	1.724	177326000.0
2006-07-19	CL	Stock	30.55	31.255	30.48	31.135	3489200.0
2006-07-19	A	Stock	20.3004	21.1016	20.3004	21.03	3133058.0
2006-07-19	AABA-DELISTED	Stock	26.4099998474121	26.7000007629395	25.0400009155273	25.2000007629395	204339000.0
2006-07-19	AACC-DELISTED	Stock	17.81	18.11	17.81	17.95	226443.0
2006-07-19	AACQU-DELISTED	Stock	6.13	6.13	6.13	6.13	500.0
2006-07-19	AACQW-DELISTED	Stock	0.38	0.38	0.38	0.38	16000.0
2006-07-19	AAI-DELISTED	Stock	13.33	14.21	13.33	13.91	1352000.0
2006-07-19	AAIC-DELISTED	Stock	197.4	204.4	196.8	200.4	1383400.0
2006-07-19	AAME	Stock	2.87	2.87	2.8	2.8	6200.0
2006-07-19	AAON	Stock	3.0802	3.3699	3.0736	3.3356	391837.0
2006-07-19	AAP	Stock	28.7	29.4	28.61	29.36	1770200.0
2006-07-19	AATI-DELISTED	Stock	8.64	9.65	8.5	9.58	148329.0
2006-07-19	AAU-DELISTED	Stock	2.35	2.38	2.26	2.36	45300.0
2006-07-19	AAUAF-DELISTED	Stock	2.35	2.38	2.26	2.36	45300.0
2006-07-19	AAV-DELISTED	Stock	15.84	15.98	15.7781	15.9252	371400.0
2006-07-19	AAWW-DELISTED	Stock	41.29	45.05	41.28	44.5	72412.0
2006-07-19	AAXN-DELISTED	Stock	7.51999998092651	7.71000003814697	7.46999979019165	7.63000011444092	982100.0
2006-07-19	AB	Stock	59.27	61.25	59.15	60.82	300300.0
2006-07-19	ABAX-DELISTED	Stock	19.05	19.93	19.05	19.83	156965.0
2006-07-19	ABB-DELISTED	Stock	11.68	12.18	11.68	12.16	2040300.0
2006-07-19	ABBC-DELISTED	Stock	14.48	14.52	14.16	14.46	8916.0
2006-07-19	ABC-DELISTED	Stock	20.64	21.31	20.64	21.3	1948885.0
2006-07-19	ABCB	Stock	21.0674	22.3999	21.0674	22.2735	26937.0
2006-07-19	ABCO-DELISTED	Stock	23.95	24.31	23.51	24.11	162700.0
2006-07-19	ABCW-DELISTED	Stock	29.28	30.43	28.89	30.25	51100.0
2006-07-19	ABD-DELISTED	Stock	19.63	20.96	19.61	20.81	266200.0
2006-07-19	ABE-DELISTED	Stock	11.71	12.3	11.71	12.28	17100.0
2006-07-19	ABFS-DELISTED	Stock	46.75	48.16	46.67	47.6	359954.0
2006-07-19	ABG	Stock	19.76	20.11	19.75	20.1	141600.0
2006-07-19	ABK-DELISTED	Stock	81.2	82.56	80.98	82.23	764400.0
2006-07-19	ABM	Stock	16.6	17.13	16.6	17.06	126400.0
2006-07-19	ABMD-DELISTED	Stock	13.02	13.75	12.91	13.58	107366.0
2006-07-19	ABP-DELISTED	Stock	4.22	4.44	4.21	4.29	121700.0
2006-07-19	ABR	Stock	25.5	26.0	25.3	25.95	80800.0
2006-07-19	ABT	Stock	21.4471	22.4306	21.4471	22.2051	28630888.0
2006-07-19	ABTL-DELISTED	Stock	17.562	17.562	16.648	16.75	46839.0
2006-07-19	ABV-DELISTED	Stock	39.2	40.63	38.78	40.52	700300.0
2006-07-19	ABVA-DELISTED	Stock	16.1725	16.2999	16.1725	16.2999	1900.0
2006-07-19	ABX-DELISTED	Stock	29.05	29.94	28.97	29.89	2887900.0
2006-07-19	ACAD	Stock	6.47	6.77	6.47	6.55	298300.0
2006-07-19	ACAP-DELISTED	Stock	47.65	48.29	47.63	48.0	25124.0
2006-07-19	ACAS-DELISTED	Stock	33.98	34.93	33.8	34.48	1616916.0
2006-07-19	ACAT-DELISTED	Stock	16.605	17.805	16.525	17.805	70102.0
2006-07-19	ACC-DELISTED	Stock	25.05	26.05	25.0	25.7	49500.0
2006-07-19	ACCL-DELISTED	Stock	6.56	6.97	6.54	6.83	52167.0
2006-07-19	ACCO	Stock	19.63	20.96	19.61	20.81	312300.0

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

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