PREVIEW / stock_daily / 2006-08-07

all stock daily files

  file:    by_date/stock_daily/2006/2006-08-07.parquet
  size:    148 KB
  rows:    4,453
  symbols: 2,802

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-07	AAPL	Stock	2.4186	2.4857	2.3682	2.4004	1245512800.0
2006-08-07	MSFT	Stock	24.28	24.48	24.19	24.22	36862400.0
2006-08-07	NVDA	Stock	0.3928	0.4002	0.3875	0.3952	436146000.0
2006-08-07	AMZN	Stock	1.3595	1.3645	1.3295	1.339	109528000.0
2006-08-07	CL	Stock	29.345	29.53	29.25	29.5	4233000.0
2006-08-07	A	Stock	19.9857	20.0286	19.6781	19.8498	2060093.0
2006-08-07	AABA-DELISTED	Stock	26.9200000762939	27.1100006103516	26.5799999237061	27.0799999237061	12847200.0
2006-08-07	AACC-DELISTED	Stock	18.61	18.73	18.37	18.73	84860.0
2006-08-07	AACQU-DELISTED	Stock	6.0	6.0	6.0	6.0	1400.0
2006-08-07	AACQW-DELISTED	Stock	0.39	0.39	0.39	0.39	100.0
2006-08-07	AAI-DELISTED	Stock	12.71	12.79	12.5	12.73	701500.0
2006-08-07	AAIC-DELISTED	Stock	184.0	184.6	180.0	180.8	856800.0
2006-08-07	AAME	Stock	2.82	2.87	2.75	2.79	3500.0
2006-08-07	AAON	Stock	3.1486	3.1895	3.0288	3.1895	224016.0
2006-08-07	AAP	Stock	30.33	30.5	29.92	30.14	606200.0
2006-08-07	AATI-DELISTED	Stock	8.47	8.75	8.45	8.73	316951.0
2006-08-07	AAU-DELISTED	Stock	2.63	2.6499	2.62	2.64	27000.0
2006-08-07	AAUAF-DELISTED	Stock	2.63	2.6499	2.62	2.64	27000.0
2006-08-07	AAV-DELISTED	Stock	16.5	16.5676	16.45	16.5	266900.0
2006-08-07	AAWW-DELISTED	Stock	39.74	39.98	39.25	39.41	57108.0
2006-08-07	AAXN-DELISTED	Stock	7.03000020980835	7.19000005722046	7.0	7.05999994277954	417800.0
2006-08-07	AB	Stock	66.2	67.05	66.03	66.08	136000.0
2006-08-07	ABAX-DELISTED	Stock	22.97	23.28	22.61	22.65	171173.0
2006-08-07	ABB-DELISTED	Stock	12.86	12.99	12.8	12.97	3024100.0
2006-08-07	ABBC-DELISTED	Stock	14.99	14.99	14.7	14.85	6702.0
2006-08-07	ABC-DELISTED	Stock	21.72	21.72	21.45	21.6	2524200.0
2006-08-07	ABCB	Stock	25.6291	25.8236	25.4152	25.5902	66520.0
2006-08-07	ABCO-DELISTED	Stock	25.11	25.16	24.95	25.08	120865.0
2006-08-07	ABCW-DELISTED	Stock	30.1	30.29	29.77	29.96	15730.0
2006-08-07	ABD-DELISTED	Stock	19.25	19.38	19.04	19.36	127500.0
2006-08-07	ABE-DELISTED	Stock	12.9	12.92	12.74	12.84	5600.0
2006-08-07	ABFS-DELISTED	Stock	44.84	45.18	44.22	44.85	306770.0
2006-08-07	ABG	Stock	20.5	20.61	20.35	20.49	612700.0
2006-08-07	ABK-DELISTED	Stock	82.48	82.92	82.11	82.52	500500.0
2006-08-07	ABM	Stock	16.56	16.63	16.31	16.46	79400.0
2006-08-07	ABMD-DELISTED	Stock	13.27	13.5	12.98	13.34	107058.0
2006-08-07	ABP-DELISTED	Stock	4.3	4.43	4.25	4.37	133800.0
2006-08-07	ABR	Stock	25.65	25.65	25.31	25.59	70600.0
2006-08-07	ABT	Stock	22.6658	22.7569	22.4594	22.7137	9525427.0
2006-08-07	ABTL-DELISTED	Stock	16.0	16.15	15.2	16.0	58842.0
2006-08-07	ABV-DELISTED	Stock	41.15	41.41	40.29	40.36	316900.0
2006-08-07	ABVA-DELISTED	Stock	16.65	16.65	15.53	16.03	14101.0
2006-08-07	ABX-DELISTED	Stock	32.39	32.39	31.95	32.15	2086500.0
2006-08-07	ACAD	Stock	5.75	5.97	5.67	5.92	186800.0
2006-08-07	ACAP-DELISTED	Stock	45.13	46.95	45.13	46.79	80599.0
2006-08-07	ACAS-DELISTED	Stock	36.24	36.62	36.24	36.37	934273.0
2006-08-07	ACAT-DELISTED	Stock	17.49	17.83	17.39	17.63	39074.0
2006-08-07	ACC-DELISTED	Stock	25.64	25.67	25.25	25.67	39200.0
2006-08-07	ACCL-DELISTED	Stock	6.34	6.34	6.06	6.19	33989.0
2006-08-07	ACCO	Stock	19.25	19.38	19.04	19.36	130400.0

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

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