PREVIEW / stock_daily / 2012-03-27

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-27.parquet
  size:    200 KB
  rows:    6,171
  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-03-27	AAPL	Stock	21.6493	22.01	21.645	21.9457	607129600.0
2012-03-27	MSFT	Stock	32.65	32.7	32.4	32.52	36274900.0
2012-03-27	NVDA	Stock	0.3695	0.375	0.3688	0.3705	419968000.0
2012-03-27	AMZN	Stock	10.1795	10.4925	10.144	10.272	192016000.0
2012-03-27	TSLA	Stock	2.4773	2.6633	2.4687	2.5293	38088000.0
2012-03-27	TLT	Stock	112.78	113.7	112.7	113.44	6972602.0
2012-03-27	ES	Stock	37.26	37.31	37.05	37.18	1858100.0
2012-03-27	CL	Stock	48.5	48.645	48.32	48.355	2962800.0
2012-03-27	A	Stock	32.2246	33.1044	32.1817	32.6681	5318132.0
2012-03-27	AABA-DELISTED	Stock	15.53	15.55	15.41	15.43	11742886.0
2012-03-27	AACC-DELISTED	Stock	4.79	5.0	4.78	4.9	210641.0
2012-03-27	AACG	Stock	6.58	6.58	6.48	6.51	17200.0
2012-03-27	AAIC-DELISTED	Stock	22.78	22.85	22.4	22.53	151521.0
2012-03-27	AAME	Stock	2.64	2.7	2.61	2.66	6400.0
2012-03-27	AAMRQ-DELISTED	Stock	0.483	0.495	0.4806	0.49	2650605.0
2012-03-27	AAON	Stock	6.3259	6.3733	6.2519	6.2667	145125.0
2012-03-27	AAP	Stock	90.7	91.05	90.27	90.51	853800.0
2012-03-27	AAT	Stock	23.04	23.07	22.76	22.83	107200.0
2012-03-27	AAU-DELISTED	Stock	2.7	2.75	2.64	2.65	73636.0
2012-03-27	AAUAF-DELISTED	Stock	2.7	2.75	2.64	2.65	74036.0
2012-03-27	AAV-DELISTED	Stock	3.38	3.4	3.32	3.33	469879.0
2012-03-27	AAWW-DELISTED	Stock	50.16	50.16	48.64	48.79	431568.0
2012-03-27	AAXJ	Stock	57.15	57.2	56.86	56.91	139140.0
2012-03-27	AAXN-DELISTED	Stock	4.43	4.65	4.4205	4.61	851522.0
2012-03-27	AB	Stock	15.75	15.84	15.65	15.65	156800.0
2012-03-27	ABAC-DELISTED	Stock	1.64	1.77	1.63	1.73	19455.0
2012-03-27	ABAX-DELISTED	Stock	29.56	29.98	29.22	29.79	114878.0
2012-03-27	ABB-DELISTED	Stock	20.54	20.57	20.28	20.3	2026855.0
2012-03-27	ABBNY-DELISTED	Stock	20.54	20.57	20.28	20.29	2031718.0
2012-03-27	ABC-DELISTED	Stock	39.68	39.7	39.39	39.49	2265002.0
2012-03-27	ABCB	Stock	13.35	13.49	13.2	13.24	33200.0
2012-03-27	ABCD-DELISTED	Stock	2.8	2.8	2.66	2.69	25498.0
2012-03-27	ABCO-DELISTED	Stock	44.58	45.04	44.25	44.8	199773.0
2012-03-27	ABCW-DELISTED	Stock	0.753	0.8032	0.7279	0.8032	75400.0
2012-03-27	ABD-DELISTED	Stock	12.67	13.05	12.67	12.73	398760.0
2012-03-27	ABE-DELISTED	Stock	19.21	19.42	19.21	19.25	18186.0
2012-03-27	ABEO	Stock	1425.0	1450.0	1312.5	1412.5	21.0
2012-03-27	ABFS-DELISTED	Stock	19.05	19.23	18.93	18.95	274957.0
2012-03-27	ABG	Stock	28.31	28.39	27.39	27.41	388000.0
2012-03-27	ABH-DELISTED	Stock	14.95	15.07	14.65	14.67	138245.0
2012-03-27	ABM	Stock	24.45	24.55	24.18	24.26	295300.0
2012-03-27	ABMD-DELISTED	Stock	23.49	23.49	22.7	22.71	422225.0
2012-03-27	ABR	Stock	5.89	5.94	5.72	5.72	36600.0
2012-03-27	ABT	Stock	29.2342	29.5029	29.2342	29.4261	13449354.0
2012-03-27	ABTL-DELISTED	Stock	5.0043	5.1059	4.7745	4.8	20748.0
2012-03-27	ABUS	Stock	2.5	2.58	2.49	2.58	23100.0
2012-03-27	ABV-DELISTED	Stock	44.4	44.48	43.16	43.32	2862807.0
2012-03-27	ABVA-DELISTED	Stock	3.9	3.9	3.9	3.9	100.0
2012-03-27	ABVT-DELISTED	Stock	83.17	83.35	82.84	82.85	782965.0
2012-03-27	ABX-DELISTED	Stock	44.79	44.87	43.78	43.8	6491558.0

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

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