PREVIEW / stock_daily / 2012-03-28

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-28.parquet
  size:    200 KB
  rows:    6,168
  symbols: 3,539

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-03-28	AAPL	Stock	22.085	22.1946	21.7968	22.0579	655460400.0
2012-03-28	MSFT	Stock	32.52	32.7	32.04	32.19	41344800.0
2012-03-28	NVDA	Stock	0.3753	0.384	0.3725	0.379	892448000.0
2012-03-28	AMZN	Stock	10.307	10.35	10.0155	10.058	124900000.0
2012-03-28	TSLA	Stock	2.5187	2.5627	2.474	2.5233	14325000.0
2012-03-28	TLT	Stock	112.92	113.94	112.85	113.28	7885996.0
2012-03-28	ES	Stock	37.07	37.19	36.71	36.89	2220400.0
2012-03-28	CL	Stock	48.225	48.27	47.925	48.025	4100000.0
2012-03-28	A	Stock	32.4893	32.525	31.5379	31.8956	4318841.0
2012-03-28	AABA-DELISTED	Stock	15.45	15.48	15.14	15.32	18242758.0
2012-03-28	AACC-DELISTED	Stock	4.9	5.0	4.78	4.85	105705.0
2012-03-28	AACG	Stock	6.3	6.39	6.3	6.35	800.0
2012-03-28	AAIC-DELISTED	Stock	22.55	22.72	22.46	22.56	118842.0
2012-03-28	AAME	Stock	2.16	2.79	2.16	2.79	5000.0
2012-03-28	AAMRQ-DELISTED	Stock	0.481	0.4915	0.471	0.488	1510744.0
2012-03-28	AAON	Stock	6.2696	6.3111	6.1215	6.163	267300.0
2012-03-28	AAP	Stock	90.71	90.79	88.65	88.79	838000.0
2012-03-28	AAT	Stock	22.8	22.89	22.43	22.59	75800.0
2012-03-28	AAU-DELISTED	Stock	2.67	2.67	2.47	2.53	231306.0
2012-03-28	AAUAF-DELISTED	Stock	2.67	2.67	2.47	2.53	232106.0
2012-03-28	AAV-DELISTED	Stock	3.32	3.35	3.28	3.35	640700.0
2012-03-28	AAWW-DELISTED	Stock	48.72	48.99	46.86	48.4	301383.0
2012-03-28	AAXJ	Stock	56.75	56.87	56.07	56.36	338154.0
2012-03-28	AAXN-DELISTED	Stock	4.6	4.65	4.34	4.41	629480.0
2012-03-28	AB	Stock	15.76	15.8	15.37	15.58	138200.0
2012-03-28	ABAC-DELISTED	Stock	1.71	1.71	1.63	1.64	4550.0
2012-03-28	ABAX-DELISTED	Stock	29.86	29.96	29.37	29.59	54747.0
2012-03-28	ABB-DELISTED	Stock	20.4	20.405	20.032	20.2	1713643.0
2012-03-28	ABBNY-DELISTED	Stock	20.4	20.405	20.032	20.2	1775649.0
2012-03-28	ABC-DELISTED	Stock	39.47	39.67	38.95	39.08	1802179.0
2012-03-28	ABCB	Stock	13.22	13.35	13.1	13.31	130200.0
2012-03-28	ABCD-DELISTED	Stock	2.7	2.73	2.65	2.66	9103.0
2012-03-28	ABCO-DELISTED	Stock	44.91	44.95	44.25	44.61	192291.0
2012-03-28	ABCW-DELISTED	Stock	0.8032	0.8032	0.7631	0.8032	46920.0
2012-03-28	ABD-DELISTED	Stock	12.72	12.76	12.42	12.68	331640.0
2012-03-28	ABE-DELISTED	Stock	19.15	19.24	19.1	19.1	7968.0
2012-03-28	ABEO	Stock	1412.5	1412.5	1325.0	1400.0	14.0
2012-03-28	ABFS-DELISTED	Stock	18.96	19.12	18.77	19.02	239419.0
2012-03-28	ABG	Stock	27.45	27.55	26.8	27.22	140400.0
2012-03-28	ABH-DELISTED	Stock	14.71	14.73	14.48	14.51	142300.0
2012-03-28	ABM	Stock	24.23	24.33	24.06	24.32	268800.0
2012-03-28	ABMD-DELISTED	Stock	22.7	23.06	21.997	22.4	270747.0
2012-03-28	ABR	Stock	5.72	5.92	5.72	5.82	47400.0
2012-03-28	ABT	Stock	29.4501	29.4981	29.1766	29.3254	14784494.0
2012-03-28	ABTL-DELISTED	Stock	4.7591	4.9506	4.7247	4.75	8218.0
2012-03-28	ABUS	Stock	2.75	2.75	2.51	2.51	30900.0
2012-03-28	ABV-DELISTED	Stock	43.43	43.49	41.15	41.36	6181938.0
2012-03-28	ABVA-DELISTED	Stock	3.94	4.09	3.94	4.05	6300.0
2012-03-28	ABVT-DELISTED	Stock	82.85	83.24	82.85	83.23	366241.0
2012-03-28	ABX-DELISTED	Stock	43.69	43.77	42.77	43.16	7675618.0

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

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