PREVIEW / stock_daily / 2006-09-15

all stock daily files

  file:    by_date/stock_daily/2006/2006-09-15.parquet
  size:    150 KB
  rows:    4,469
  symbols: 2,815

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-09-15	AAPL	Stock	2.6643	2.6779	2.6175	2.6464	981853600.0
2006-09-15	MSFT	Stock	26.58	26.94	26.49	26.85	126057700.0
2006-09-15	NVDA	Stock	0.4848	0.495	0.4825	0.4927	649764000.0
2006-09-15	AMZN	Stock	1.595	1.637	1.579	1.626	205474000.0
2006-09-15	CL	Stock	30.95	31.14	30.84	31.07	4689000.0
2006-09-15	A	Stock	22.1888	22.2103	21.8169	22.1173	6559556.0
2006-09-15	AABA-DELISTED	Stock	29.2999992370605	29.5699996948242	29.2199993133545	29.3199996948242	19550300.0
2006-09-15	AACC-DELISTED	Stock	14.93	14.97	14.52	14.92	123687.0
2006-09-15	AACQ-DELISTED	Stock	5.35	5.35	5.35	5.35	3845.0
2006-09-15	AACQU-DELISTED	Stock	6.1	6.1	6.1	6.1	500.0
2006-09-15	AACQW-DELISTED	Stock	0.39	0.4	0.39	0.4	20000.0
2006-09-15	AAI-DELISTED	Stock	10.0	10.26	9.72	9.74	1991500.0
2006-09-15	AAIC-DELISTED	Stock	172.6	176.0	171.0	176.0	1696800.0
2006-09-15	AAON	Stock	3.1473	3.1486	2.8866	2.9946	650784.0
2006-09-15	AAP	Stock	32.74	32.94	32.31	32.47	1402700.0
2006-09-15	AATI-DELISTED	Stock	8.62	8.62	8.36	8.39	337852.0
2006-09-15	AAU-DELISTED	Stock	2.36	2.39	2.29	2.38	41100.0
2006-09-15	AAUAF-DELISTED	Stock	2.36	2.39	2.29	2.38	41100.0
2006-09-15	AAV-DELISTED	Stock	14.15	14.49	13.81	14.37	703900.0
2006-09-15	AAWW-DELISTED	Stock	44.05	44.05	43.5	43.75	320316.0
2006-09-15	AAXN-DELISTED	Stock	7.71000003814697	7.73999977111816	7.5	7.59000015258789	982300.0
2006-09-15	AB	Stock	70.0	71.03	70.0	70.86	481400.0
2006-09-15	ABAX-DELISTED	Stock	22.96	23.04	22.27	22.49	151428.0
2006-09-15	ABB-DELISTED	Stock	13.3	13.36	13.27	13.34	3195300.0
2006-09-15	ABBC-DELISTED	Stock	15.3	15.3	15.2	15.22	29099.0
2006-09-15	ABC-DELISTED	Stock	22.94	23.26	22.88	23.24	2472000.0
2006-09-15	ABCB	Stock	25.9111	26.3197	25.8236	26.1154	70735.0
2006-09-15	ABCO-DELISTED	Stock	25.48	25.72	25.27	25.51	258943.0
2006-09-15	ABCW-DELISTED	Stock	28.79	28.98	28.55	28.72	147770.0
2006-09-15	ABD-DELISTED	Stock	20.6	20.7	19.72	20.39	437220.0
2006-09-15	ABE-DELISTED	Stock	13.65	13.8	13.65	13.8	24100.0
2006-09-15	ABFS-DELISTED	Stock	46.06	46.42	43.68	43.83	674113.0
2006-09-15	ABG	Stock	20.35	20.5	20.0	20.13	453700.0
2006-09-15	ABK-DELISTED	Stock	85.0	85.1	84.42	84.45	499100.0
2006-09-15	ABM	Stock	18.7	18.9	18.58	18.75	567800.0
2006-09-15	ABMD-DELISTED	Stock	15.15	15.25	14.75	14.81	158754.0
2006-09-15	ABP-DELISTED	Stock	3.72	3.79	3.51	3.7	282100.0
2006-09-15	ABR	Stock	25.7	25.86	25.5	25.86	123700.0
2006-09-15	ABT	Stock	23.6541	23.9276	23.6302	23.7405	14546895.0
2006-09-15	ABTL-DELISTED	Stock	16.551	16.952	15.749	16.2	10791.0
2006-09-15	ABV-DELISTED	Stock	44.88	45.12	44.82	44.96	234400.0
2006-09-15	ABVA-DELISTED	Stock	16.65	16.65	16.65	16.65	500.0
2006-09-15	ABX-DELISTED	Stock	28.31	29.1443	27.88	29.1244	7507948.0
2006-09-15	ACAD	Stock	8.58	8.79	8.35	8.63	309900.0
2006-09-15	ACAP-DELISTED	Stock	48.7	50.67	48.29	50.54	40499.0
2006-09-15	ACAS-DELISTED	Stock	38.5	38.84	38.45	38.79	734279.0
2006-09-15	ACAT-DELISTED	Stock	16.64	16.64	16.25	16.35	137559.0
2006-09-15	ACC-DELISTED	Stock	25.5	25.88	25.4	25.68	381800.0
2006-09-15	ACCL-DELISTED	Stock	5.45	5.55	5.44	5.54	36149.0
2006-09-15	ACCO	Stock	20.6	20.7	19.72	20.39	526100.0

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

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