PREVIEW / stock_daily / 2009-01-09

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-09.parquet
  size:    176 KB
  rows:    5,714
  symbols: 3,428

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-09	AAPL	Stock	3.3289	3.335	3.2193	3.235	546845600.0
2009-01-09	MSFT	Stock	20.17	20.3	19.41	19.52	49815300.0
2009-01-09	NVDA	Stock	0.21	0.21	0.1978	0.1982	761352000.0
2009-01-09	AMZN	Stock	2.846	2.85	2.735	2.7755	133682000.0
2009-01-09	TLT	Stock	111.46	113.35	111.27	112.73	2727805.0
2009-01-09	CL	Stock	32.69	32.99	32.375	32.45	6939800.0
2009-01-09	A	Stock	13.0973	13.5408	12.8898	13.2475	6917024.0
2009-01-09	AABA-DELISTED	Stock	13.42	13.56	12.9	13.11	19170066.0
2009-01-09	AACC-DELISTED	Stock	5.41	5.41	4.98	4.98	54883.0
2009-01-09	AACG	Stock	4.6	4.6	4.45	4.6	17000.0
2009-01-09	AAI-DELISTED	Stock	4.62	4.75	4.42	4.45	2639501.0
2009-01-09	AAIC-DELISTED	Stock	6.0	6.2	5.0	5.2	612708.0
2009-01-09	AAME	Stock	0.89	0.89	0.8	0.85	1700.0
2009-01-09	AAON	Stock	4.0593	4.0869	3.8519	3.9704	1016044.0
2009-01-09	AAP	Stock	32.39	32.39	31.55	31.78	991500.0
2009-01-09	AATI-DELISTED	Stock	3.3	3.3	2.91	3.0	235040.0
2009-01-09	AAU-DELISTED	Stock	0.75	0.75	0.69	0.69	104426.0
2009-01-09	AAUAF-DELISTED	Stock	0.75	0.75	0.69	0.69	104926.0
2009-01-09	AAV-DELISTED	Stock	4.71	4.74	4.61	4.61	524161.0
2009-01-09	AAWW-DELISTED	Stock	24.05	24.83	23.04	23.21	342580.0
2009-01-09	AAXJ	Stock	33.37	33.37	32.42	32.608	93715.0
2009-01-09	AAXN-DELISTED	Stock	5.63	5.73	5.46	5.47	630480.0
2009-01-09	AB	Stock	21.81	21.81	20.4	20.92	295100.0
2009-01-09	ABAX-DELISTED	Stock	15.05	15.33	14.46	14.74	140497.0
2009-01-09	ABB-DELISTED	Stock	14.39	14.48	14.08	14.11	3395563.0
2009-01-09	ABBC-DELISTED	Stock	9.03	9.09	8.65	8.67	115986.0
2009-01-09	ABBNY-DELISTED	Stock	14.39	14.48	14.08	14.11	3396324.0
2009-01-09	ABC-DELISTED	Stock	18.35	18.45	17.77	17.98	3677146.0
2009-01-09	ABCB	Stock	11.0005	11.0881	10.2322	10.4268	41228.0
2009-01-09	ABCO-DELISTED	Stock	11.035	11.035	10.61	10.61	135606.0
2009-01-09	ABCW-DELISTED	Stock	2.6	2.6	2.3999	2.54	115810.0
2009-01-09	ABD-DELISTED	Stock	4.6	4.63	3.94	3.94	327110.0
2009-01-09	ABE-DELISTED	Stock	13.2	13.35	12.78	13.0	9888.0
2009-01-09	ABEO	Stock	1025.0	1037.5	1025.0	1037.5	3.0
2009-01-09	ABFS-DELISTED	Stock	27.15	27.15	25.85	26.4	1023629.0
2009-01-09	ABG	Stock	5.2	5.2	4.8	4.99	268000.0
2009-01-09	ABII-DELISTED	Stock	68.15	68.22	67.22	67.83	19744.0
2009-01-09	ABK-DELISTED	Stock	1.6	1.63	1.47	1.48	15303910.0
2009-01-09	ABM	Stock	19.11	19.11	17.99	18.05	380700.0
2009-01-09	ABMD-DELISTED	Stock	14.3	14.3	13.73	13.79	209637.0
2009-01-09	ABR	Stock	3.02	3.16	2.84	2.87	113300.0
2009-01-09	ABT	Stock	24.5562	25.0072	24.4266	24.5514	14017716.0
2009-01-09	ABTL-DELISTED	Stock	2.45	2.5	2.45	2.5	3260.0
2009-01-09	ABV-DELISTED	Stock	44.98	44.99	43.62	44.33	707159.0
2009-01-09	ABVA-DELISTED	Stock	1.38	1.53	1.38	1.46	740.0
2009-01-09	ABX-DELISTED	Stock	32.75	33.94	31.83	32.9	14016937.0
2009-01-09	ACAD	Stock	1.22	1.22	1.12	1.12	67800.0
2009-01-09	ACAP-DELISTED	Stock	45.86	45.86	43.85	44.13	47912.0
2009-01-09	ACAS-DELISTED	Stock	6.19	6.39	5.77	5.81	3722055.0
2009-01-09	ACAT-DELISTED	Stock	5.46	5.5	5.31	5.38	24875.0

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

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