PREVIEW / stock_daily / 2012-01-20

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-20.parquet
  size:    197 KB
  rows:    6,122
  symbols: 3,523

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
2012-01-20	AAPL	Stock	15.2675	15.2679	14.9911	15.0107	413974400.0
2012-01-20	MSFT	Stock	28.82	29.74	28.75	29.71	165902900.0
2012-01-20	NVDA	Stock	0.3582	0.3625	0.3542	0.3555	546272000.0
2012-01-20	AMZN	Stock	9.5355	9.645	9.452	9.5465	112206000.0
2012-01-20	TSLA	Stock	1.7933	1.8	1.76	1.7733	9934500.0
2012-01-20	TLT	Stock	117.71	117.96	116.97	116.98	6548394.0
2012-01-20	ES	Stock	33.55	34.36	33.48	34.36	1771700.0
2012-01-20	CL	Stock	44.805	44.83	44.155	44.5	6467200.0
2012-01-20	A	Stock	29.8784	29.9714	29.0987	29.3276	5461287.0
2012-01-20	AABA-DELISTED	Stock	16.11	16.11	15.85	16.0	20974158.0
2012-01-20	AACC-DELISTED	Stock	4.25	4.569	4.17	4.28	41529.0
2012-01-20	AACG	Stock	6.2	6.21	6.2	6.21	1600.0
2012-01-20	AAIC-DELISTED	Stock	22.19	22.51	22.1	22.46	45059.0
2012-01-20	AAME	Stock	2.0	2.02	1.95	1.99	1400.0
2012-01-20	AAMRQ-DELISTED	Stock	0.426	0.493	0.4063	0.4661	16714323.0
2012-01-20	AAON	Stock	5.9081	5.9496	5.7037	5.9259	110025.0
2012-01-20	AAP	Stock	75.17	75.44	74.28	74.75	1296500.0
2012-01-20	AAT	Stock	21.26	21.46	21.15	21.25	98200.0
2012-01-20	AAU-DELISTED	Stock	2.45	2.56	2.36	2.5	114152.0
2012-01-20	AAUAF-DELISTED	Stock	2.45	2.56	2.36	2.5	114652.0
2012-01-20	AAV-DELISTED	Stock	3.33	3.47	3.33	3.45	696326.0
2012-01-20	AAWW-DELISTED	Stock	43.05	43.49	42.47	43.44	289543.0
2012-01-20	AAXJ	Stock	54.19	54.55	54.13	54.49	293687.0
2012-01-20	AAXN-DELISTED	Stock	5.1	5.11	4.89	4.92	485090.0
2012-01-20	AB	Stock	15.56	15.61	15.08	15.35	474500.0
2012-01-20	ABAC-DELISTED	Stock	1.73	1.77	1.6688	1.72	22765.0
2012-01-20	ABAX-DELISTED	Stock	28.47	28.52	28.0	28.14	66558.0
2012-01-20	ABB-DELISTED	Stock	20.98	21.15	20.91	21.13	1747384.0
2012-01-20	ABBNY-DELISTED	Stock	20.98	21.15	20.91	21.14	1947900.0
2012-01-20	ABC-DELISTED	Stock	39.47	40.12	39.35	40.09	2789027.0
2012-01-20	ABCB	Stock	10.72	10.99	10.72	10.92	34600.0
2012-01-20	ABCD-DELISTED	Stock	3.14	3.24	3.12	3.19	11234.0
2012-01-20	ABCO-DELISTED	Stock	39.08	39.19	38.97	39.01	92366.0
2012-01-20	ABCW-DELISTED	Stock	0.3062	0.3062	0.2811	0.2811	29320.0
2012-01-20	ABD-DELISTED	Stock	9.85	10.0	9.77	9.97	588630.0
2012-01-20	ABE-DELISTED	Stock	18.18	18.36	18.07	18.35	13411.0
2012-01-20	ABEO	Stock	1650.0	1700.0	1650.0	1700.0	3.0
2012-01-20	ABFS-DELISTED	Stock	21.78	22.05	21.52	21.99	205826.0
2012-01-20	ABG	Stock	23.26	23.58	23.13	23.39	208800.0
2012-01-20	ABH-DELISTED	Stock	14.94	15.06	14.87	14.89	499076.0
2012-01-20	ABM	Stock	21.04	21.31	21.03	21.17	142200.0
2012-01-20	ABMD-DELISTED	Stock	18.62	19.0	18.23	18.61	153633.0
2012-01-20	ABR	Stock	4.25	4.37	4.06	4.27	62000.0
2012-01-20	ABT	Stock	26.6913	26.7728	26.4946	26.7536	17691538.0
2012-01-20	ABTL-DELISTED	Stock	3.9485	3.95	3.7987	3.95	3993.0
2012-01-20	ABUS	Stock	2.59	2.66	2.5	2.66	24900.0
2012-01-20	ABV-DELISTED	Stock	37.38	37.38	36.86	36.95	2168701.0
2012-01-20	ABVA-DELISTED	Stock	3.42	3.42	3.4	3.4	1000.0
2012-01-20	ABVT-DELISTED	Stock	66.38	67.0	65.5	65.88	99006.0
2012-01-20	ABX-DELISTED	Stock	46.42	47.03	45.31	45.82	13962949.0

> showing 50 of 6,122 rows — these rows as CSV

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