PREVIEW / stock_daily / 2009-01-16

all stock daily files

  file:    by_date/stock_daily/2009/2009-01-16.parquet
  size:    176 KB
  rows:    5,695
  symbols: 3,417

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-16	AAPL	Stock	3.0107	3.0136	2.8714	2.9404	1047625600.0
2009-01-16	MSFT	Stock	19.63	19.91	19.15	19.71	79634100.0
2009-01-16	NVDA	Stock	0.1945	0.2015	0.1883	0.1998	831324000.0
2009-01-16	AMZN	Stock	2.59	2.6165	2.4765	2.5795	165164000.0
2009-01-16	TLT	Stock	113.42	116.09	113.3601	114.3	2994707.0
2009-01-16	CL	Stock	31.86	31.94	31.22	31.77	8621800.0
2009-01-16	A	Stock	13.927	14.2918	13.505	13.9557	7181945.0
2009-01-16	AABA-DELISTED	Stock	11.87	11.97	11.44	11.57	24233216.0
2009-01-16	AACC-DELISTED	Stock	5.02	5.03	4.75	4.8501	56097.0
2009-01-16	AACG	Stock	3.66	3.94	3.4	3.56	23100.0
2009-01-16	AAI-DELISTED	Stock	4.41	4.54	4.2899	4.5	2264765.0
2009-01-16	AAIC-DELISTED	Stock	3.4	4.0	3.2	4.0	983123.0
2009-01-16	AAON	Stock	3.6484	3.7472	3.5714	3.7452	557381.0
2009-01-16	AAP	Stock	31.03	31.85	30.56	31.72	930300.0
2009-01-16	AATI-DELISTED	Stock	2.82	2.98	2.76	2.97	129759.0
2009-01-16	AAU-DELISTED	Stock	0.65	0.65	0.62	0.65	18700.0
2009-01-16	AAUAF-DELISTED	Stock	0.65	0.65	0.62	0.65	19200.0
2009-01-16	AAV-DELISTED	Stock	4.45	4.52	4.33	4.5	475068.0
2009-01-16	AAWW-DELISTED	Stock	19.27	19.7599	17.49	18.06	211209.0
2009-01-16	AAXJ	Stock	31.5	31.7399	31.06	31.31	10303.0
2009-01-16	AAXN-DELISTED	Stock	5.06	5.35	5.03	5.35	1466585.0
2009-01-16	AB	Stock	19.33	19.33	17.95	18.78	406600.0
2009-01-16	ABAX-DELISTED	Stock	14.66	15.21	14.44	15.02	342843.0
2009-01-16	ABB-DELISTED	Stock	12.67	12.74	12.07	12.44	4039208.0
2009-01-16	ABBC-DELISTED	Stock	8.05	8.05	7.36	7.45	144140.0
2009-01-16	ABBNY-DELISTED	Stock	12.67	12.74	12.07	12.47	4090574.0
2009-01-16	ABC-DELISTED	Stock	18.53	18.9	18.4	18.68	3565886.0
2009-01-16	ABCB	Stock	9.6194	9.6194	9.1039	9.4054	30227.0
2009-01-16	ABCO-DELISTED	Stock	10.375	10.485	10.12	10.46	136364.0
2009-01-16	ABCW-DELISTED	Stock	2.53	2.56	2.26	2.45	118960.0
2009-01-16	ABD-DELISTED	Stock	3.29	3.35	2.84	2.94	419580.0
2009-01-16	ABE-DELISTED	Stock	12.77	12.88	12.45	12.69	29120.0
2009-01-16	ABEO	Stock	1250.0	1250.0	1037.5	1250.0	2.0
2009-01-16	ABFS-DELISTED	Stock	24.39	24.49	22.75	24.04	595562.0
2009-01-16	ABG	Stock	4.23	4.23	3.4	3.54	437900.0
2009-01-16	ABII-DELISTED	Stock	70.33	71.63	69.88	69.88	11445.0
2009-01-16	ABK-DELISTED	Stock	1.25	1.3204	1.15	1.19	14164822.0
2009-01-16	ABM	Stock	18.12	18.15	17.17	17.85	379000.0
2009-01-16	ABMD-DELISTED	Stock	13.39	13.47	12.56	12.94	206322.0
2009-01-16	ABR	Stock	3.07	3.09	2.62	2.66	144100.0
2009-01-16	ABT	Stock	23.7789	24.1579	23.6733	23.9516	26773239.0
2009-01-16	ABTL-DELISTED	Stock	2.6465	2.9461	1.6478	1.8535	50625.0
2009-01-16	ABV-DELISTED	Stock	42.59	42.75	41.14	42.53	532575.0
2009-01-16	ABVA-DELISTED	Stock	1.69	1.7	1.5004	1.5004	3033.0
2009-01-16	ABVT-DELISTED	Stock	31.5	31.5	31.5	31.5	26450.0
2009-01-16	ABX-DELISTED	Stock	34.88	35.1	32.7	34.29	18582108.0
2009-01-16	ACAD	Stock	1.17	1.2	1.11	1.19	33300.0
2009-01-16	ACAP-DELISTED	Stock	42.52	42.75	41.52	42.75	57916.0
2009-01-16	ACAS-DELISTED	Stock	4.7	4.99	4.33	4.54	3082050.0
2009-01-16	ACAT-DELISTED	Stock	5.16	5.39	4.8	4.96	33748.0

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

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