PREVIEW / stock_daily / 2012-04-09

all stock daily files

  file:    by_date/stock_daily/2012/2012-04-09.parquet
  size:    199 KB
  rows:    6,173
  symbols: 3,540

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-09	AAPL	Stock	22.3618	22.8514	22.3321	22.7225	597536800.0
2012-04-09	MSFT	Stock	31.22	31.4	30.97	31.1	31056400.0
2012-04-09	NVDA	Stock	0.36	0.3622	0.354	0.361	365504000.0
2012-04-09	AMZN	Stock	9.601	9.71	9.525	9.5935	62718000.0
2012-04-09	TSLA	Stock	2.2733	2.286	2.2067	2.21	24835500.0
2012-04-09	TLT	Stock	115.54	115.77	115.24	115.55	14379611.0
2012-04-09	ES	Stock	36.55	36.9	36.47	36.79	23617100.0
2012-04-09	CL	Stock	48.83	48.83	48.435	48.52	3772800.0
2012-04-09	A	Stock	31.5665	31.5665	31.1445	31.1516	5182805.0
2012-04-09	AABA-DELISTED	Stock	15.0	15.25	14.96	15.1	11319739.0
2012-04-09	AACC-DELISTED	Stock	4.84	4.99	4.8	4.86	19997.0
2012-04-09	AACG	Stock	6.8	6.82	6.3	6.36	7900.0
2012-04-09	AAIC-DELISTED	Stock	22.56	22.66	22.34	22.38	89014.0
2012-04-09	AAME	Stock	2.89	2.91	2.88	2.88	1100.0
2012-04-09	AAMRQ-DELISTED	Stock	0.495	0.499	0.4856	0.493	1894226.0
2012-04-09	AAON	Stock	5.7037	5.7719	5.5763	5.6178	287213.0
2012-04-09	AAP	Stock	89.61	89.85	88.9	89.82	713100.0
2012-04-09	AAT	Stock	22.8	22.93	22.55	22.56	119700.0
2012-04-09	AAU-DELISTED	Stock	2.35	2.39	2.31	2.31	118733.0
2012-04-09	AAUAF-DELISTED	Stock	2.35	2.39	2.31	2.31	119033.0
2012-04-09	AAV-DELISTED	Stock	3.0	3.03	2.94	3.01	712909.0
2012-04-09	AAWW-DELISTED	Stock	48.28	49.01	47.72	48.2	329600.0
2012-04-09	AAXJ	Stock	55.67	55.9	55.59	55.66	127395.0
2012-04-09	AAXN-DELISTED	Stock	4.03	4.1	3.96	3.96	514854.0
2012-04-09	AB	Stock	14.82	14.97	14.68	14.74	180100.0
2012-04-09	ABAC-DELISTED	Stock	1.67	1.67	1.6	1.66	4850.0
2012-04-09	ABAX-DELISTED	Stock	27.7	28.06	27.33	27.43	91449.0
2012-04-09	ABB-DELISTED	Stock	19.69	19.79	19.5	19.769	1077637.0
2012-04-09	ABBNY-DELISTED	Stock	19.69	19.79	19.5	19.77	1082302.0
2012-04-09	ABC-DELISTED	Stock	38.1	38.7	37.65	38.43	2441734.0
2012-04-09	ABCB	Stock	12.8	13.01	12.77	12.79	62600.0
2012-04-09	ABCD-DELISTED	Stock	2.48	2.55	2.41	2.51	15023.0
2012-04-09	ABCO-DELISTED	Stock	41.78	43.58	41.76	43.41	243062.0
2012-04-09	ABCW-DELISTED	Stock	0.8936	0.9639	0.8836	0.9539	12800.0
2012-04-09	ABD-DELISTED	Stock	11.8	11.98	11.53	11.77	407030.0
2012-04-09	ABE-DELISTED	Stock	19.19	19.21	19.18	19.18	6386.0
2012-04-09	ABEO	Stock	1462.5	1550.0	1400.0	1537.5	66.0
2012-04-09	ABFS-DELISTED	Stock	18.85	19.25	18.71	18.78	297918.0
2012-04-09	ABG	Stock	27.24	27.32	26.65	27.08	388000.0
2012-04-09	ABH-DELISTED	Stock	13.7	13.73	13.53	13.59	190865.0
2012-04-09	ABM	Stock	23.63	23.76	23.22	23.28	240400.0
2012-04-09	ABMD-DELISTED	Stock	21.27	21.43	21.0	21.18	198897.0
2012-04-09	ABR	Stock	5.03	5.12	5.02	5.11	21100.0
2012-04-09	ABT	Stock	29.1766	29.4357	29.0375	29.2534	12945394.0
2012-04-09	ABTL-DELISTED	Stock	4.7	4.75	4.6505	4.7	16300.0
2012-04-09	ABUS	Stock	2.53	2.62	2.28	2.46	36800.0
2012-04-09	ABV-DELISTED	Stock	40.04	41.1	40.04	40.83	2148269.0
2012-04-09	ABVA-DELISTED	Stock	4.08	4.08	4.08	4.08	200.0
2012-04-09	ABVT-DELISTED	Stock	82.87	82.98	82.87	82.89	392267.0
2012-04-09	ABX-DELISTED	Stock	41.0	41.62	40.83	40.96	8056384.0

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

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