PREVIEW / stock_daily / 2012-07-19

all stock daily files

  file:    by_date/stock_daily/2012/2012-07-19.parquet
  size:    199 KB
  rows:    6,145
  symbols: 3,500

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-07-19	AAPL	Stock	21.8314	21.9768	21.6429	21.94	436861600.0
2012-07-19	MSFT	Stock	30.51	30.8	30.38	30.67	46663200.0
2012-07-19	NVDA	Stock	0.3288	0.334	0.3265	0.3298	403036000.0
2012-07-19	AMZN	Stock	11.0365	11.375	11.0345	11.3085	108988000.0
2012-07-19	META	Stock	29.41	29.5	28.63	29.0	13685100.0
2012-07-19	TSLA	Stock	2.1813	2.21	2.136	2.1513	21538500.0
2012-07-19	TLT	Stock	128.46	129.1	128.11	128.49	5246268.0
2012-07-19	ES	Stock	40.23	40.64	40.11	40.48	1520800.0
2012-07-19	CL	Stock	52.64	52.93	52.27	52.81	3061000.0
2012-07-19	A	Stock	27.2961	27.6109	27.1531	27.5107	2968513.0
2012-07-19	AABA-DELISTED	Stock	15.71	15.855	15.635	15.74	15860861.0
2012-07-19	AACC-DELISTED	Stock	7.06	7.06	6.85	6.91	27115.0
2012-07-19	AACG	Stock	4.34	4.69	4.02	4.06	57200.0
2012-07-19	AAIC-DELISTED	Stock	22.8	22.88	22.24	22.33	78814.0
2012-07-19	AAME	Stock	2.78	2.8	2.66	2.79	3900.0
2012-07-19	AAMRQ-DELISTED	Stock	0.521	0.55	0.5105	0.5395	1754572.0
2012-07-19	AAON	Stock	6.1422	6.163	5.9852	5.9911	95175.0
2012-07-19	AAP	Stock	73.95	74.39	73.08	73.37	1091300.0
2012-07-19	AAT	Stock	25.28	25.28	24.95	24.95	104400.0
2012-07-19	AAU-DELISTED	Stock	1.91	2.04	1.9	1.95	86110.0
2012-07-19	AAUAF-DELISTED	Stock	1.91	2.04	1.9	1.97	86760.0
2012-07-19	AAV-DELISTED	Stock	3.22	3.36	3.22	3.34	189384.0
2012-07-19	AAWW-DELISTED	Stock	46.76	47.65	46.54	46.85	187481.0
2012-07-19	AAXJ	Stock	52.38	52.67	52.27	52.54	275931.0
2012-07-19	AAXN-DELISTED	Stock	5.02	5.06	4.85	4.865	248412.0
2012-07-19	AB	Stock	12.57	13.06	12.51	12.62	259800.0
2012-07-19	ABAC-DELISTED	Stock	1.13	1.17	1.08	1.08	24801.0
2012-07-19	ABAX-DELISTED	Stock	40.12	40.24	39.2	39.37	139566.0
2012-07-19	ABB-DELISTED	Stock	16.2	16.23	16.0	16.06	5881106.0
2012-07-19	ABBNY-DELISTED	Stock	16.2	16.23	16.0	16.05	15006158.0
2012-07-19	ABC-DELISTED	Stock	39.73	39.98	39.57	39.72	1409629.0
2012-07-19	ABCB	Stock	12.66	12.66	12.06	12.07	21000.0
2012-07-19	ABCD-DELISTED	Stock	1.0899	1.125	1.02	1.12	21833.0
2012-07-19	ABCO-DELISTED	Stock	49.52	49.88	48.88	48.89	136129.0
2012-07-19	ABCW-DELISTED	Stock	0.43	0.43	0.4	0.42	49294.0
2012-07-19	ABE-DELISTED	Stock	19.11	19.2395	19.11	19.2395	7974.0
2012-07-19	ABEO	Stock	600.0	612.5	537.5	575.0	51.0
2012-07-19	ABFS-DELISTED	Stock	11.92	12.41	11.7	11.83	206393.0
2012-07-19	ABG	Stock	27.53	27.82	27.21	27.47	418300.0
2012-07-19	ABM	Stock	19.49	19.61	19.22	19.3	611700.0
2012-07-19	ABMD-DELISTED	Stock	24.03	24.2198	23.51	23.7	411628.0
2012-07-19	ABR	Stock	5.33	5.35	5.28	5.32	54600.0
2012-07-19	ABT	Stock	31.734	31.758	31.4653	31.5708	11503752.0
2012-07-19	ABTL-DELISTED	Stock	3.56	3.73	3.56	3.69	1310.0
2012-07-19	ABUS	Stock	2.46	2.77	2.46	2.56	77200.0
2012-07-19	ABV-DELISTED	Stock	37.5	37.8	37.05	37.5	1986361.0
2012-07-19	ABVA-DELISTED	Stock	4.29	4.34	4.29	4.34	4283.0
2012-07-19	ABX-DELISTED	Stock	34.73	35.22	34.42	34.78	8428192.0
2012-07-19	ACAD	Stock	1.59	1.61	1.52	1.59	297700.0
2012-07-19	ACAS-DELISTED	Stock	9.86	9.96	9.81	9.86	1633362.0

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

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