PREVIEW / stock_daily / 2012-04-25

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-25.parquet
  size:    199 KB
  rows:    6,181
  symbols: 3,559

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-25	AAPL	Stock	21.9871	22.0714	21.6429	21.7857	905777600.0
2012-04-25	MSFT	Stock	31.92	32.32	31.87	32.2	62495500.0
2012-04-25	NVDA	Stock	0.3253	0.3295	0.3193	0.327	727112000.0
2012-04-25	AMZN	Stock	9.5835	9.74	9.58	9.721	79102000.0
2012-04-25	TSLA	Stock	2.138	2.1993	2.138	2.194	10683000.0
2012-04-25	TLT	Stock	116.41	117.32	115.69	116.49	8859429.0
2012-04-25	ES	Stock	36.58	36.74	36.35	36.57	1836400.0
2012-04-25	CL	Stock	49.325	49.87	49.21	49.79	4974200.0
2012-04-25	A	Stock	28.8269	29.671	28.8269	29.4564	5110808.0
2012-04-25	AABA-DELISTED	Stock	15.39	15.51	15.38	15.495	12885538.0
2012-04-25	AACC-DELISTED	Stock	5.17	5.17	4.941	5.0	43742.0
2012-04-25	AACG	Stock	6.58	6.6	6.51	6.51	1400.0
2012-04-25	AAIC-DELISTED	Stock	23.71	23.93	23.37	23.49	62663.0
2012-04-25	AAME	Stock	2.86	2.94	2.85	2.93	4000.0
2012-04-25	AAMRQ-DELISTED	Stock	0.575	0.594	0.575	0.58	1923308.0
2012-04-25	AAON	Stock	5.8489	5.923	5.76	5.84	116775.0
2012-04-25	AAP	Stock	89.29	89.74	88.14	89.64	606300.0
2012-04-25	AAT	Stock	23.41	23.55	23.17	23.35	108000.0
2012-04-25	AAU-DELISTED	Stock	2.2	2.24	2.14	2.23	156112.0
2012-04-25	AAUAF-DELISTED	Stock	2.2	2.24	2.14	2.23	156212.0
2012-04-25	AAV-DELISTED	Stock	2.96	3.13	2.9	3.12	352092.0
2012-04-25	AAWW-DELISTED	Stock	46.01	46.01	44.48	45.3	203410.0
2012-04-25	AAXJ	Stock	55.7	55.94	55.58	55.92	113008.0
2012-04-25	AAXN-DELISTED	Stock	4.12	4.2	4.11	4.2	289912.0
2012-04-25	AB	Stock	14.39	14.45	14.2	14.33	134300.0
2012-04-25	ABAC-DELISTED	Stock	1.8475	2.0	1.84	1.98	16534.0
2012-04-25	ABAX-DELISTED	Stock	29.0	29.65	28.88	29.57	166309.0
2012-04-25	ABB-DELISTED	Stock	19.48	19.56	19.25	19.35	5253391.0
2012-04-25	ABBNY-DELISTED	Stock	19.51	19.56	19.25	19.35	5275437.0
2012-04-25	ABC-DELISTED	Stock	37.7	38.17	37.51	37.858	2938770.0
2012-04-25	ABCB	Stock	12.17	12.87	12.17	12.69	152100.0
2012-04-25	ABCD-DELISTED	Stock	2.6	2.75	2.49	2.59	20812.0
2012-04-25	ABCO-DELISTED	Stock	44.42	44.88	43.84	44.23	192544.0
2012-04-25	ABCW-DELISTED	Stock	0.6828	0.8534	0.6828	0.7129	13820.0
2012-04-25	ABD-DELISTED	Stock	10.79	11.01	10.41	10.52	907820.0
2012-04-25	ABE-DELISTED	Stock	19.28	19.4	19.24	19.31	7805.0
2012-04-25	ABEO	Stock	1412.5	1412.5	1275.0	1362.5	18.0
2012-04-25	ABFS-DELISTED	Stock	18.05	18.18	17.76	17.84	144555.0
2012-04-25	ABG	Stock	26.26	27.44	26.12	27.23	777100.0
2012-04-25	ABH-DELISTED	Stock	13.16	13.52	13.09	13.5	247074.0
2012-04-25	ABM	Stock	23.31	23.62	23.15	23.29	146300.0
2012-04-25	ABMD-DELISTED	Stock	23.14	23.64	22.99	23.63	650485.0
2012-04-25	ABR	Stock	5.6	5.72	5.44	5.69	46600.0
2012-04-25	ABT	Stock	29.191	29.642	29.1047	29.5557	19044393.0
2012-04-25	ABTL-DELISTED	Stock	4.6	4.6	4.35	4.6	12653.0
2012-04-25	ABUS	Stock	2.35	2.44	2.28	2.44	4000.0
2012-04-25	ABV-DELISTED	Stock	43.78	43.96	43.55	43.66	2225045.0
2012-04-25	ABVA-DELISTED	Stock	4.03	4.16	4.03	4.1	3817.0
2012-04-25	ABVT-DELISTED	Stock	83.23	83.23	83.09	83.1	257611.0
2012-04-25	ABX-DELISTED	Stock	39.96	40.09	39.36	39.96	9074800.0

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

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