PREVIEW / stock_daily / 2012-08-03

all stock daily files

  file:    by_date/stock_daily/2012/2012-08-03.parquet
  size:    199 KB
  rows:    6,175
  symbols: 3,516

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-08-03	AAPL	Stock	21.9154	22.0707	21.8414	21.9893	344920800.0
2012-08-03	MSFT	Stock	29.53	29.94	29.48	29.75	35859400.0
2012-08-03	NVDA	Stock	0.3413	0.3465	0.3333	0.343	326548000.0
2012-08-03	AMZN	Stock	11.7015	11.8245	11.6515	11.7485	56506000.0
2012-08-03	META	Stock	20.36	22.16	19.9	21.09	80647000.0
2012-08-03	TSLA	Stock	1.7933	1.8367	1.7827	1.818	18142500.0
2012-08-03	TLT	Stock	127.84	128.03	126.77	127.42	9084768.0
2012-08-03	ES	Stock	39.8	39.99	39.45	39.57	1375200.0
2012-08-03	CL	Stock	53.27	53.745	53.08	53.23	3599400.0
2012-08-03	A	Stock	27.568	28.2403	27.5465	27.9757	2551210.0
2012-08-03	AABA-DELISTED	Stock	15.89	16.03	15.82	15.96	8807631.0
2012-08-03	AACC-DELISTED	Stock	5.79	5.9001	5.775	5.89	36886.0
2012-08-03	AACG	Stock	4.1	4.33	4.1	4.22	7600.0
2012-08-03	AAIC-DELISTED	Stock	22.15	22.81	22.15	22.32	74714.0
2012-08-03	AAME	Stock	2.55	2.69	2.55	2.69	3500.0
2012-08-03	AAMRQ-DELISTED	Stock	0.513	0.5195	0.502	0.507	400421.0
2012-08-03	AAON	Stock	5.4874	5.6089	5.44	5.5407	145800.0
2012-08-03	AAP	Stock	68.26	68.5	66.31	68.01	2080900.0
2012-08-03	AAT	Stock	25.62	26.33	25.45	26.16	113500.0
2012-08-03	AAU-DELISTED	Stock	1.91	1.95	1.88	1.94	232841.0
2012-08-03	AAUAF-DELISTED	Stock	1.91	1.94	1.88	1.94	233749.0
2012-08-03	AAV-DELISTED	Stock	3.87	3.9	3.8	3.86	117440.0
2012-08-03	AAWW-DELISTED	Stock	47.62	52.13	47.18	51.26	660509.0
2012-08-03	AAXJ	Stock	53.4	53.74	53.22	53.63	264830.0
2012-08-03	AAXN-DELISTED	Stock	5.6	5.63	5.48	5.4902	652771.0
2012-08-03	AB	Stock	12.33	13.1	12.2	12.3	328100.0
2012-08-03	ABAC-DELISTED	Stock	0.85	0.92	0.84	0.92	54267.0
2012-08-03	ABAX-DELISTED	Stock	36.35	37.6	36.35	37.31	74278.0
2012-08-03	ABB-DELISTED	Stock	17.8	18.04	17.78	17.92	4300492.0
2012-08-03	ABBNY-DELISTED	Stock	17.8	18.04	17.78	17.91	5776258.0
2012-08-03	ABC-DELISTED	Stock	39.3	39.76	39.29	39.4	3968912.0
2012-08-03	ABCB	Stock	11.46	12.0	11.39	11.89	52700.0
2012-08-03	ABCD-DELISTED	Stock	1.08	1.13	1.02	1.09	24439.0
2012-08-03	ABCO-DELISTED	Stock	43.92	44.27	43.18	43.5	407047.0
2012-08-03	ABCW-DELISTED	Stock	0.39	0.42	0.37	0.37	6426.0
2012-08-03	ABE-DELISTED	Stock	19.24	19.39	19.24	19.28	34883.0
2012-08-03	ABEO	Stock	687.5	875.0	687.5	875.0	1.0
2012-08-03	ABFS-DELISTED	Stock	10.23	10.37	9.87	9.91	573708.0
2012-08-03	ABG	Stock	26.23	27.08	26.07	26.86	437300.0
2012-08-03	ABM	Stock	18.42	19.05	18.39	18.9	257300.0
2012-08-03	ABMD-DELISTED	Stock	23.3	23.37	22.86	23.19	616571.0
2012-08-03	ABR	Stock	5.43	5.63	5.43	5.48	152200.0
2012-08-03	ABT	Stock	32.089	32.3625	31.9163	31.9499	12233014.0
2012-08-03	ABTL-DELISTED	Stock	3.64	3.64	3.35	3.43	63170.0
2012-08-03	ABUS	Stock	3.29	3.29	3.06	3.28	28200.0
2012-08-03	ABV-DELISTED	Stock	38.8	39.13	38.26	38.46	2562597.0
2012-08-03	ABVA-DELISTED	Stock	4.34	4.34	4.34	4.34	300.0
2012-08-03	ABX-DELISTED	Stock	32.72	33.02	32.46	32.77	8008368.0
2012-08-03	ACAD	Stock	1.56	1.6	1.51	1.51	288700.0
2012-08-03	ACAS-DELISTED	Stock	10.49	10.77	10.44	10.62	5045027.0

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

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