PREVIEW / stock_daily / 2009-01-08

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-08.parquet
  size:    176 KB
  rows:    5,703
  symbols: 3,411

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
2009-01-08	AAPL	Stock	3.2296	3.3268	3.2157	3.3107	673500800.0
2009-01-08	MSFT	Stock	19.63	20.19	19.55	20.12	70255400.0
2009-01-08	NVDA	Stock	0.2128	0.2128	0.197	0.21	1014496000.0
2009-01-08	AMZN	Stock	2.7495	2.866	2.729	2.858	131558000.0
2009-01-08	TLT	Stock	112.64	112.92	111.99	112.56	2603599.0
2009-01-08	CL	Stock	32.885	33.105	32.4	32.77	7237800.0
2009-01-08	A	Stock	12.99	13.2189	12.7325	13.1259	6242909.0
2009-01-08	AABA-DELISTED	Stock	12.36	13.07	12.31	13.07	13703844.0
2009-01-08	AACC-DELISTED	Stock	5.45	5.46	5.35	5.4	40486.0
2009-01-08	AACG	Stock	4.59	4.8	4.5	4.55	7800.0
2009-01-08	AAI-DELISTED	Stock	4.64	4.79	4.59	4.74	1498876.0
2009-01-08	AAIC-DELISTED	Stock	5.4	6.598	5.4	6.0	476813.0
2009-01-08	AAON	Stock	4.0237	4.0612	3.9526	4.0316	581681.0
2009-01-08	AAP	Stock	32.38	32.6	31.25	32.5	1165200.0
2009-01-08	AATI-DELISTED	Stock	3.19	3.39	3.17	3.3	511359.0
2009-01-08	AAU-DELISTED	Stock	0.71	0.74	0.71	0.73	48542.0
2009-01-08	AAUAF-DELISTED	Stock	0.71	0.74	0.71	0.73	49442.0
2009-01-08	AAV-DELISTED	Stock	4.72	4.82	4.69	4.71	530802.0
2009-01-08	AAWW-DELISTED	Stock	23.03	24.2	22.25	24.03	206397.0
2009-01-08	AAXJ	Stock	33.61	34.03	33.28	34.03	11988.0
2009-01-08	AAXN-DELISTED	Stock	5.47	5.65	5.32	5.65	860685.0
2009-01-08	AB	Stock	20.56	21.56	20.2	21.43	315500.0
2009-01-08	ABAX-DELISTED	Stock	15.45	15.74	14.83	14.999	548950.0
2009-01-08	ABB-DELISTED	Stock	14.45	14.72	14.29	14.72	3075695.0
2009-01-08	ABBC-DELISTED	Stock	8.97	9.03	8.75	9.03	65712.0
2009-01-08	ABBNY-DELISTED	Stock	14.45	14.72	14.29	14.72	3076383.0
2009-01-08	ABC-DELISTED	Stock	17.73	18.52	17.28	18.38	5017902.0
2009-01-08	ABCB	Stock	10.738	11.0784	10.6893	10.9422	17787.0
2009-01-08	ABCO-DELISTED	Stock	10.898	11.052	10.798	11.007	151948.0
2009-01-08	ABCW-DELISTED	Stock	2.54	2.7	2.44	2.61	91460.0
2009-01-08	ABD-DELISTED	Stock	4.0349	4.6905	3.591	4.63	554750.0
2009-01-08	ABE-DELISTED	Stock	13.52	13.57	13.15	13.33	25961.0
2009-01-08	ABEO	Stock	1012.5	1112.5	1012.5	1112.5	1.0
2009-01-08	ABFS-DELISTED	Stock	28.5	29.04	27.34	27.81	490830.0
2009-01-08	ABG	Stock	4.73	5.29	4.52	5.23	334700.0
2009-01-08	ABII-DELISTED	Stock	69.0	69.6	68.75	69.46	10488.0
2009-01-08	ABK-DELISTED	Stock	1.35	1.75	1.35	1.51	39445636.0
2009-01-08	ABM	Stock	18.39	19.13	18.19	19.1	455400.0
2009-01-08	ABMD-DELISTED	Stock	14.28	14.36	13.805	14.24	361710.0
2009-01-08	ABR	Stock	2.98	3.02	2.8	3.01	148500.0
2009-01-08	ABT	Stock	24.3259	24.8632	24.3259	24.5658	18202168.0
2009-01-08	ABTL-DELISTED	Stock	2.5998	2.5998	2.4252	2.4502	3660.0
2009-01-08	ABV-DELISTED	Stock	44.51	44.79	43.43	44.21	870309.0
2009-01-08	ABVA-DELISTED	Stock	1.39	1.51	1.38	1.38	1300.0
2009-01-08	ABVT-DELISTED	Stock	30.0	30.0	30.0	30.0	20000.0
2009-01-08	ABX-DELISTED	Stock	32.23	33.36	31.94	33.28	14874357.0
2009-01-08	ACAD	Stock	1.15	1.21	1.14	1.2	35600.0
2009-01-08	ACAP-DELISTED	Stock	44.78	45.81	44.29	45.77	44726.0
2009-01-08	ACAS-DELISTED	Stock	6.03	6.47	5.81	6.14	5636070.0
2009-01-08	ACAT-DELISTED	Stock	5.32	5.52	5.32	5.5	28820.0

> showing 50 of 5,703 rows — these rows as CSV

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