PREVIEW / stock_daily / 2012-01-19

all stock daily files

  file:    by_date/stock_daily/2012/2012-01-19.parquet
  size:    196 KB
  rows:    6,103
  symbols: 3,519

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-19	AAPL	Stock	15.3625	15.4061	15.2325	15.2768	261738400.0
2012-01-19	MSFT	Stock	28.16	28.44	28.03	28.12	74053500.0
2012-01-19	NVDA	Stock	0.3525	0.3592	0.3488	0.3588	608312000.0
2012-01-19	AMZN	Stock	9.544	9.797	9.518	9.7225	141920000.0
2012-01-19	TSLA	Stock	1.8127	1.8493	1.774	1.784	18694500.0
2012-01-19	TLT	Stock	119.33	119.559	117.92	118.32	8626694.0
2012-01-19	ES	Stock	34.08	34.15	33.48	33.53	1520800.0
2012-01-19	CL	Stock	44.99	45.24	44.795	44.985	5160600.0
2012-01-19	A	Stock	29.5923	30.2647	29.4063	29.9356	4322336.0
2012-01-19	AABA-DELISTED	Stock	15.9	16.15	15.89	16.13	22350331.0
2012-01-19	AACC-DELISTED	Stock	4.2	4.25	4.11	4.25	8600.0
2012-01-19	AACG	Stock	6.59	6.59	6.25	6.29	3600.0
2012-01-19	AAIC-DELISTED	Stock	21.8	22.25	21.63	22.13	62570.0
2012-01-19	AAME	Stock	1.98	2.03	1.96	2.01	1600.0
2012-01-19	AAMRQ-DELISTED	Stock	0.4155	0.439	0.4112	0.43	10417482.0
2012-01-19	AAON	Stock	5.9852	5.9852	5.8785	5.9141	133650.0
2012-01-19	AAP	Stock	75.17	76.33	74.49	75.15	935200.0
2012-01-19	AAT	Stock	21.24	21.5	21.05	21.23	93500.0
2012-01-19	AAU-DELISTED	Stock	2.57	2.58	2.41	2.44	76441.0
2012-01-19	AAUAF-DELISTED	Stock	2.57	2.58	2.41	2.44	77241.0
2012-01-19	AAV-DELISTED	Stock	3.5	3.54	3.312	3.35	1138398.0
2012-01-19	AAWW-DELISTED	Stock	42.11	43.72	41.99	43.25	272926.0
2012-01-19	AAXJ	Stock	54.21	54.37	53.96	54.28	416350.0
2012-01-19	AAXN-DELISTED	Stock	5.27	5.31	5.07	5.11	297717.0
2012-01-19	AB	Stock	14.65	15.58	14.63	15.4	924400.0
2012-01-19	ABAC-DELISTED	Stock	1.59	1.74	1.59	1.68	61180.0
2012-01-19	ABAX-DELISTED	Stock	28.1	28.58	27.68	28.41	90633.0
2012-01-19	ABB-DELISTED	Stock	21.2	21.39	21.09	21.38	2933269.0
2012-01-19	ABBNY-DELISTED	Stock	21.2	21.4	21.09	21.4	2977444.0
2012-01-19	ABC-DELISTED	Stock	38.94	39.46	38.73	39.41	1656126.0
2012-01-19	ABCB	Stock	10.47	10.78	10.44	10.74	16400.0
2012-01-19	ABCD-DELISTED	Stock	3.21	3.21	3.09	3.16	15446.0
2012-01-19	ABCO-DELISTED	Stock	38.91	39.6	38.87	39.19	254598.0
2012-01-19	ABCW-DELISTED	Stock	0.3012	0.3113	0.3012	0.3113	8820.0
2012-01-19	ABD-DELISTED	Stock	9.71	9.91	9.71	9.88	200790.0
2012-01-19	ABE-DELISTED	Stock	17.96	18.159	17.77	18.11	49235.0
2012-01-19	ABEO	Stock	1725.0	1725.0	1650.0	1712.5	10.0
2012-01-19	ABFS-DELISTED	Stock	21.52	21.93	21.26	21.85	195919.0
2012-01-19	ABG	Stock	23.62	23.69	23.16	23.27	342200.0
2012-01-19	ABH-DELISTED	Stock	15.02	15.17	14.96	14.97	353514.0
2012-01-19	ABM	Stock	20.77	21.16	20.77	21.06	136300.0
2012-01-19	ABMD-DELISTED	Stock	18.27	18.97	18.24	18.62	257194.0
2012-01-19	ABR	Stock	4.14	4.3	4.14	4.25	30000.0
2012-01-19	ABT	Stock	26.5233	26.5953	26.413	26.5953	13263652.0
2012-01-19	ABTL-DELISTED	Stock	3.9	3.9021	3.9	3.9	37279.0
2012-01-19	ABUS	Stock	2.23	2.53	2.23	2.5	14100.0
2012-01-19	ABV-DELISTED	Stock	37.31	37.5	37.17	37.33	2454922.0
2012-01-19	ABVA-DELISTED	Stock	3.43	3.54	3.43	3.45	10065.0
2012-01-19	ABVT-DELISTED	Stock	66.87	67.0	65.73	66.35	83348.0
2012-01-19	ABX-DELISTED	Stock	47.6	48.01	45.97	46.49	9242817.0

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

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