PREVIEW / stock_daily / 2012-03-15

all stock daily files

  file:    by_date/stock_daily/2012/2012-03-15.parquet
  size:    199 KB
  rows:    6,164
  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-15	AAPL	Stock	21.4146	21.4289	20.6625	20.9129	1159718000.0
2012-03-15	MSFT	Stock	32.79	32.94	32.58	32.85	49068300.0
2012-03-15	NVDA	Stock	0.3602	0.3665	0.359	0.3645	382380000.0
2012-03-15	AMZN	Stock	9.101	9.2215	9.015	9.2215	83202000.0
2012-03-15	TSLA	Stock	2.352	2.3653	2.3187	2.3333	8574000.0
2012-03-15	TLT	Stock	110.9	111.74	110.88	111.21	14155006.0
2012-03-15	ES	Stock	36.72	36.92	36.42	36.71	1215000.0
2012-03-15	CL	Stock	47.42	47.835	47.42	47.71	3156000.0
2012-03-15	A	Stock	32.2604	32.8469	32.0815	32.804	2972148.0
2012-03-15	AABA-DELISTED	Stock	14.65	14.98	14.57	14.88	19021484.0
2012-03-15	AACC-DELISTED	Stock	4.8	4.84	4.68	4.78	15548.0
2012-03-15	AACG	Stock	6.35	6.89	6.31	6.31	14800.0
2012-03-15	AAIC-DELISTED	Stock	24.58	24.58	23.9231	24.22	87154.0
2012-03-15	AAME	Stock	2.88	3.01	2.88	2.98	2600.0
2012-03-15	AAMRQ-DELISTED	Stock	0.5098	0.5098	0.49	0.501	2008032.0
2012-03-15	AAON	Stock	5.8637	5.9911	5.8133	5.9704	248738.0
2012-03-15	AAP	Stock	89.07	89.46	88.57	89.25	1022400.0
2012-03-15	AAT	Stock	22.17	22.59	22.03	22.57	219900.0
2012-03-15	AAU-DELISTED	Stock	2.65	2.65	2.52	2.55	346076.0
2012-03-15	AAUAF-DELISTED	Stock	2.65	2.65	2.52	2.55	346676.0
2012-03-15	AAV-DELISTED	Stock	3.66	3.69	3.57	3.6	433643.0
2012-03-15	AAWW-DELISTED	Stock	45.26	48.27	45.26	47.67	416597.0
2012-03-15	AAXJ	Stock	57.53	57.9	57.45	57.82	168573.0
2012-03-15	AAXN-DELISTED	Stock	4.03	4.08	4.0	4.07	193946.0
2012-03-15	AB	Stock	15.08	15.28	14.98	15.03	428100.0
2012-03-15	ABAC-DELISTED	Stock	1.7	1.74	1.66	1.66	34619.0
2012-03-15	ABAX-DELISTED	Stock	27.35	27.67	27.11	27.55	60891.0
2012-03-15	ABB-DELISTED	Stock	20.83	21.06	20.74	21.0	2446614.0
2012-03-15	ABBNY-DELISTED	Stock	20.83	21.06	20.74	21.0	2447814.0
2012-03-15	ABC-DELISTED	Stock	38.24	38.25	37.805	37.9	2470176.0
2012-03-15	ABCB	Stock	12.45	12.72	12.3	12.69	67800.0
2012-03-15	ABCD-DELISTED	Stock	2.94	2.98	2.87	2.97	11519.0
2012-03-15	ABCO-DELISTED	Stock	42.76	43.25	42.36	43.15	168882.0
2012-03-15	ABCW-DELISTED	Stock	0.5121	0.5522	0.4719	0.4719	12910.0
2012-03-15	ABD-DELISTED	Stock	12.8	13.25	12.64	12.99	1457080.0
2012-03-15	ABE-DELISTED	Stock	19.34	19.4	19.2	19.4	39098.0
2012-03-15	ABEO	Stock	1375.0	1425.0	1375.0	1425.0	9.0
2012-03-15	ABFS-DELISTED	Stock	18.55	19.15	18.41	19.01	125670.0
2012-03-15	ABG	Stock	27.2	27.81	27.02	27.81	330000.0
2012-03-15	ABH-DELISTED	Stock	15.31	15.58	15.21	15.43	120364.0
2012-03-15	ABM	Stock	23.36	23.74	22.94	23.61	301400.0
2012-03-15	ABMD-DELISTED	Stock	22.26	22.26	21.64	21.95	549132.0
2012-03-15	ABR	Stock	5.35	5.44	5.3	5.37	118600.0
2012-03-15	ABT	Stock	28.2506	28.4905	28.193	28.361	16573364.0
2012-03-15	ABTL-DELISTED	Stock	4.65	5.1	4.65	4.75	34649.0
2012-03-15	ABUS	Stock	2.25	2.29	2.11	2.28	8800.0
2012-03-15	ABV-DELISTED	Stock	41.25	41.34	40.85	40.99	2013428.0
2012-03-15	ABVA-DELISTED	Stock	4.2	4.22	4.2	4.22	500.0
2012-03-15	ABVT-DELISTED	Stock	72.11	72.73	71.71	72.72	86910.0
2012-03-15	ABX-DELISTED	Stock	43.35	44.48	43.05	43.87	12055802.0

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

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