PREVIEW / stock_daily / 2006-08-22

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-22.parquet
  size:    148 KB
  rows:    4,468
  symbols: 2,820

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-08-22	AAPL	Stock	2.3814	2.44	2.375	2.415	576968000.0
2006-08-22	MSFT	Stock	26.01	26.25	25.62	25.62	89312400.0
2006-08-22	NVDA	Stock	0.4378	0.4507	0.4375	0.4385	473928000.0
2006-08-22	AMZN	Stock	1.407	1.4445	1.4025	1.4185	91742000.0
2006-08-22	CL	Stock	29.7	29.77	29.37	29.445	3068800.0
2006-08-22	A	Stock	22.3033	22.5179	22.0672	22.0959	3217357.0
2006-08-22	AABA-DELISTED	Stock	28.8400001525879	29.6499996185303	28.7999992370605	29.2600002288818	10891800.0
2006-08-22	AACC-DELISTED	Stock	15.31	15.6	15.31	15.44	341620.0
2006-08-22	AACQ-DELISTED	Stock	5.29	5.3	5.29	5.3	389000.0
2006-08-22	AAI-DELISTED	Stock	11.52	11.68	11.44	11.58	822500.0
2006-08-22	AAIC-DELISTED	Stock	179.8	180.2	176.2	177.0	1059600.0
2006-08-22	AAME	Stock	2.71	2.75	2.67	2.67	1300.0
2006-08-22	AAON	Stock	3.0301	3.1236	3.0288	3.0828	216422.0
2006-08-22	AAP	Stock	30.09	30.15	29.71	29.8	590400.0
2006-08-22	AATI-DELISTED	Stock	9.24	9.41	9.01	9.4	108763.0
2006-08-22	AAU-DELISTED	Stock	2.74	2.78	2.7	2.74	75900.0
2006-08-22	AAUAF-DELISTED	Stock	2.74	2.78	2.7	2.74	75900.0
2006-08-22	AAV-DELISTED	Stock	16.24	16.26	16.07	16.1	338400.0
2006-08-22	AAWW-DELISTED	Stock	41.12	42.21	40.75	41.97	106869.0
2006-08-22	AAXN-DELISTED	Stock	7.88000011444092	7.90000009536743	7.73999977111816	7.84000015258789	571100.0
2006-08-22	AB	Stock	68.68	68.68	67.36	67.37	161600.0
2006-08-22	ABAX-DELISTED	Stock	23.06	23.31	22.64	23.06	119057.0
2006-08-22	ABB-DELISTED	Stock	13.33	13.4	13.21	13.3	1531800.0
2006-08-22	ABBC-DELISTED	Stock	14.41	14.55	14.41	14.49	7413.0
2006-08-22	ABC-DELISTED	Stock	21.88	22.2	21.84	22.16	1620000.0
2006-08-22	ABCB	Stock	25.2303	25.2789	24.7927	24.9871	12338.0
2006-08-22	ABCO-DELISTED	Stock	24.68	24.78	24.36	24.57	101974.0
2006-08-22	ABCW-DELISTED	Stock	28.74	28.93	28.66	28.92	23980.0
2006-08-22	ABD-DELISTED	Stock	21.07	21.65	21.07	21.46	298970.0
2006-08-22	ABE-DELISTED	Stock	13.28	13.45	13.0	13.21	10500.0
2006-08-22	ABFS-DELISTED	Stock	43.59	44.28	43.22	43.25	292517.0
2006-08-22	ABG	Stock	20.07	20.2	19.89	19.99	48900.0
2006-08-22	ABK-DELISTED	Stock	84.95	85.61	84.93	85.4	821800.0
2006-08-22	ABM	Stock	17.7	17.88	17.57	17.72	46100.0
2006-08-22	ABMD-DELISTED	Stock	13.52	13.57	13.32	13.39	50886.0
2006-08-22	ABP-DELISTED	Stock	4.21	4.24	4.17	4.24	139400.0
2006-08-22	ABR	Stock	24.9	25.3	24.9	25.27	71500.0
2006-08-22	ABT	Stock	23.2703	23.5438	23.1647	23.4814	13245102.0
2006-08-22	ABTL-DELISTED	Stock	14.907	15.007	14.756	14.893	17376.0
2006-08-22	ABV-DELISTED	Stock	43.7	43.91	43.4	43.44	249300.0
2006-08-22	ABVA-DELISTED	Stock	16.9	16.95	16.9	16.95	5250.0
2006-08-22	ABX-DELISTED	Stock	32.8	33.45	32.62	33.4	4588500.0
2006-08-22	ACAD	Stock	7.26	7.56	7.2	7.4	228500.0
2006-08-22	ACAP-DELISTED	Stock	48.44	49.74	48.4	49.4	23254.0
2006-08-22	ACAS-DELISTED	Stock	37.94	38.29	37.81	38.06	844179.0
2006-08-22	ACAT-DELISTED	Stock	17.89	18.41	17.89	18.16	29242.0
2006-08-22	ACC-DELISTED	Stock	25.26	25.66	25.19	25.66	30209.0
2006-08-22	ACCL-DELISTED	Stock	6.26	6.37	6.15	6.217	37074.0
2006-08-22	ACCO	Stock	21.07	21.65	21.07	21.46	305600.0
2006-08-22	ACCP-DELISTED	Stock	0.67	0.67	0.45	0.52	78925.0

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

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