PREVIEW / stock_daily / 2012-04-27

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-27.parquet
  size:    199 KB
  rows:    6,169
  symbols: 3,545

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-04-27	AAPL	Stock	21.6096	21.6493	21.4464	21.5357	406722400.0
2012-04-27	MSFT	Stock	32.12	32.22	31.88	31.98	41419100.0
2012-04-27	NVDA	Stock	0.3268	0.3288	0.321	0.3245	475356000.0
2012-04-27	AMZN	Stock	11.2415	11.4345	11.011	11.3425	442338000.0
2012-04-27	TSLA	Stock	2.24	2.242	2.194	2.2227	8865000.0
2012-04-27	TLT	Stock	117.02	117.36	116.79	117.29	2814528.0
2012-04-27	ES	Stock	36.8	36.94	36.65	36.82	1438900.0
2012-04-27	CL	Stock	49.38	49.45	49.03	49.19	5788200.0
2012-04-27	A	Stock	30.186	30.5222	29.7282	30.4435	4121164.0
2012-04-27	AABA-DELISTED	Stock	15.51	15.62	15.49	15.57	9478336.0
2012-04-27	AACC-DELISTED	Stock	5.25	5.48	5.14	5.32	47781.0
2012-04-27	AACG	Stock	6.53	6.96	6.52	6.96	1200.0
2012-04-27	AAIC-DELISTED	Stock	23.57	23.708	23.43	23.64	34072.0
2012-04-27	AAME	Stock	2.89	2.9	2.86	2.89	2300.0
2012-04-27	AAMRQ-DELISTED	Stock	0.581	0.599	0.57	0.575	4031326.0
2012-04-27	AAON	Stock	5.9111	6.0504	5.8074	6.0237	105300.0
2012-04-27	AAP	Stock	91.93	93.08	91.5	92.37	998100.0
2012-04-27	AAT	Stock	23.63	23.75	23.34	23.61	105300.0
2012-04-27	AAU-DELISTED	Stock	2.3	2.32	2.22	2.26	125819.0
2012-04-27	AAUAF-DELISTED	Stock	2.3	2.32	2.22	2.26	126517.0
2012-04-27	AAV-DELISTED	Stock	3.18	3.21	3.05	3.14	280072.0
2012-04-27	AAWW-DELISTED	Stock	44.98	45.74	44.75	45.47	165458.0
2012-04-27	AAXJ	Stock	56.19	56.34	55.94	56.21	66788.0
2012-04-27	AAXN-DELISTED	Stock	4.54	4.55	4.43	4.44	720319.0
2012-04-27	AB	Stock	14.32	14.34	14.08	14.13	129900.0
2012-04-27	ABAC-DELISTED	Stock	1.91	1.91	1.77	1.86	12648.0
2012-04-27	ABAX-DELISTED	Stock	30.82	36.29	30.82	36.09	514718.0
2012-04-27	ABB-DELISTED	Stock	18.94	18.98	18.8	18.81	5811528.0
2012-04-27	ABBNY-DELISTED	Stock	18.96	18.98	18.8	18.81	5814328.0
2012-04-27	ABC-DELISTED	Stock	37.1501	37.2	36.6	36.91	2914787.0
2012-04-27	ABCB	Stock	12.5	12.8	12.3	12.73	67400.0
2012-04-27	ABCD-DELISTED	Stock	2.46	2.61	2.39	2.46	24707.0
2012-04-27	ABCO-DELISTED	Stock	44.2	46.14	44.2	45.75	353998.0
2012-04-27	ABCW-DELISTED	Stock	0.8032	0.8032	0.6828	0.6878	8710.0
2012-04-27	ABD-DELISTED	Stock	10.77	11.02	10.61	10.97	907050.0
2012-04-27	ABE-DELISTED	Stock	19.47	19.55	19.4	19.47	6374.0
2012-04-27	ABEO	Stock	1275.0	1450.0	1225.0	1425.0	35.0
2012-04-27	ABFS-DELISTED	Stock	15.51	16.45	15.5	16.26	1472320.0
2012-04-27	ABG	Stock	27.85	28.82	27.7	28.68	483300.0
2012-04-27	ABH-DELISTED	Stock	13.55	13.55	13.18	13.27	235557.0
2012-04-27	ABM	Stock	23.33	23.63	23.13	23.47	230300.0
2012-04-27	ABMD-DELISTED	Stock	24.41	24.75	24.18	24.6	551735.0
2012-04-27	ABR	Stock	5.84	5.85	5.75	5.75	18900.0
2012-04-27	ABT	Stock	29.786	29.8676	29.7188	29.7428	11533764.0
2012-04-27	ABTL-DELISTED	Stock	4.6869	4.7022	4.5489	4.6	2291.0
2012-04-27	ABUS	Stock	2.5	2.5	2.49	2.5	8900.0
2012-04-27	ABV-DELISTED	Stock	43.37	43.815	43.34	43.39	2546655.0
2012-04-27	ABVT-DELISTED	Stock	83.18	83.18	83.11	83.12	576918.0
2012-04-27	ABX-DELISTED	Stock	40.4	40.69	40.13	40.66	5441192.0
2012-04-27	ACAD	Stock	1.44	1.55	1.43	1.51	159000.0

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

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