PREVIEW / stock_daily / 2006-03-17

all stock daily files

  file:    by_date/stock_daily/2006/2006-03-17.parquet
  size:    147 KB
  rows:    4,360
  symbols: 2,752

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-03-17	AAPL	Stock	2.3125	2.3407	2.2896	2.3093	812042000.0
2006-03-17	MSFT	Stock	27.35	27.66	27.27	27.5	120615000.0
2006-03-17	NVDA	Stock	0.4012	0.4075	0.3952	0.4064	618588000.0
2006-03-17	AMZN	Stock	1.844	1.849	1.7925	1.7995	137724000.0
2006-03-17	CL	Stock	28.44	28.445	28.185	28.345	3994200.0
2006-03-17	A	Stock	27.0029	27.2818	26.9099	27.1245	7066051.0
2006-03-17	AABA-DELISTED	Stock	30.3500003814697	30.3600006103516	29.8299999237061	30.0699996948242	23629700.0
2006-03-17	AACC-DELISTED	Stock	19.97	19.98	19.58	19.62	182129.0
2006-03-17	AACQ-DELISTED	Stock	5.45	5.48	5.45	5.48	4500.0
2006-03-17	AACQU-DELISTED	Stock	7.0	7.06	7.0	7.06	4800.0
2006-03-17	AACQW-DELISTED	Stock	0.75	0.75	0.75	0.75	2900.0
2006-03-17	AAI-DELISTED	Stock	17.41	17.4299	16.92	17.06	2358900.0
2006-03-17	AAIC-DELISTED	Stock	190.2	193.0	188.0	190.8	708800.0
2006-03-17	AAME	Stock	2.88	2.88	2.87	2.87	700.0
2006-03-17	AAON	Stock	2.8945	2.9116	2.8523	2.9077	525487.0
2006-03-17	AAP	Stock	41.4	41.86	40.95	41.54	866100.0
2006-03-17	AATI-DELISTED	Stock	11.6	11.65	11.45	11.61	343286.0
2006-03-17	AAU-DELISTED	Stock	2.59	2.79	2.53	2.73	114000.0
2006-03-17	AAUAF-DELISTED	Stock	2.59	2.79	2.53	2.73	114000.0
2006-03-17	AAV-DELISTED	Stock	19.91	19.91	19.41	19.83	296000.0
2006-03-17	AAWW-DELISTED	Stock	48.0	48.0	35.0	48.0	2900.0
2006-03-17	AAXN-DELISTED	Stock	10.0600004196167	10.2200002670288	10.0	10.0	1804800.0
2006-03-17	AB	Stock	65.55	65.81	64.6	64.6	109600.0
2006-03-17	ABAX-DELISTED	Stock	21.84	22.79	21.82	22.75	515537.0
2006-03-17	ABB-DELISTED	Stock	12.25	12.42	12.2201	12.4	1194000.0
2006-03-17	ABBC-DELISTED	Stock	13.2	13.34	13.2	13.34	6653.0
2006-03-17	ABC-DELISTED	Stock	23.68	23.92	23.61	23.86	2454800.0
2006-03-17	ABCB	Stock	22.2054	22.5263	22.0401	22.1956	83278.0
2006-03-17	ABCO-DELISTED	Stock	27.58	27.59	26.8	27.36	276599.0
2006-03-17	ABCW-DELISTED	Stock	30.35	30.37	30.0	30.18	119520.0
2006-03-17	ABD-DELISTED	Stock	21.9	22.15	21.59	21.97	109800.0
2006-03-17	ABE-DELISTED	Stock	12.68	12.74	12.66	12.68	27700.0
2006-03-17	ABFS-DELISTED	Stock	41.5	41.6	40.56	41.57	411122.0
2006-03-17	ABG	Stock	20.3	20.32	19.92	20.1	145200.0
2006-03-17	ABK-DELISTED	Stock	81.2	81.2	79.98	80.42	755500.0
2006-03-17	ABM	Stock	17.05	17.3	16.98	17.2	515500.0
2006-03-17	ABMD-DELISTED	Stock	11.07	11.5	10.92	11.43	237054.0
2006-03-17	ABP-DELISTED	Stock	6.0	6.0	5.8	5.8	255200.0
2006-03-17	ABR	Stock	26.93	27.1	26.51	26.75	131700.0
2006-03-17	ABT	Stock	21.687	21.8165	21.5526	21.6774	10475615.0
2006-03-17	ABTL-DELISTED	Stock	21.25	23.25	21.25	23.0	271866.0
2006-03-17	ABV-DELISTED	Stock	44.25	44.37	43.0	43.6	337500.0
2006-03-17	ABVT-DELISTED	Stock	31.0	39.0	31.0	39.0	700.0
2006-03-17	ABX-DELISTED	Stock	26.67	27.08	26.54	26.63	5085100.0
2006-03-17	ACAD	Stock	17.93	17.94	16.04	16.34	1154500.0
2006-03-17	ACAP-DELISTED	Stock	50.08	50.14	49.43	49.43	43991.0
2006-03-17	ACAS-DELISTED	Stock	36.05	36.09	35.53	35.53	908369.0
2006-03-17	ACAT-DELISTED	Stock	23.4	23.856	23.18	23.72	151730.0
2006-03-17	ACC-DELISTED	Stock	27.89	28.58	27.35	27.81	168400.0
2006-03-17	ACCL-DELISTED	Stock	7.17	7.19	7.07	7.19	64514.0

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

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