PREVIEW / stock_daily / 2016-02-25

all stock daily files

  file:    by_date/stock_daily/2016/2016-02-25.parquet
  size:    217 KB
  rows:    6,532
  symbols: 3,316

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
2016-02-25	AAPL	Stock	24.0125	24.19	23.8125	24.19	110330800.0
2016-02-25	MSFT	Stock	51.73	52.1	50.61	52.1	26939500.0
2016-02-25	NVDA	Stock	0.7985	0.8012	0.783	0.7972	349616000.0
2016-02-25	AMZN	Stock	27.776	27.9695	27.2645	27.7575	90510000.0
2016-02-25	GOOGL	Stock	36.1465	36.4755	35.6615	36.456	36145160.0
2016-02-25	META	Stock	107.11	108.07	105.61	108.07	29906300.0
2016-02-25	TSLA	Stock	11.91	12.568	11.68	12.4953	86260500.0
2016-02-25	TLT	Stock	131.48	132.555	131.32	131.68	6097222.0
2016-02-25	ES	Stock	56.45	56.92	56.25	56.66	1060500.0
2016-02-25	CL	Stock	66.61	67.45	66.33	67.42	3008400.0
2016-02-25	A	Stock	37.62	37.71	36.96	37.63	1453500.0
2016-02-25	AA.B-DELISTED	Stock	30.21	30.7499	29.85	30.64	27933.0
2016-02-25	AAAP-DELISTED	Stock	32.8	33.9999	29.31	33.0	37209.0
2016-02-25	AABA-DELISTED	Stock	30.74	31.36	30.24	31.35	18820394.0
2016-02-25	AAC-DELISTED	Stock	22.75	23.03	21.34	22.71	523662.0
2016-02-25	AACG	Stock	4.61	4.78	4.27	4.27	6700.0
2016-02-25	AAIC-DELISTED	Stock	11.29	11.5	11.1	11.42	303993.0
2016-02-25	AAL	Stock	40.76	41.38	40.41	41.36	6936400.0
2016-02-25	AAMC-DELISTED	Stock	5.1382	5.3824	5.0294	5.1882	24463.0
2016-02-25	AAME	Stock	4.34	4.34	4.21	4.3	1800.0
2016-02-25	AAMI	Stock	11.37	11.5	11.08	11.47	80300.0
2016-02-25	AAOI	Stock	16.0	17.0	15.01	16.89	1009700.0
2016-02-25	AAON	Stock	15.2133	16.5067	15.2	16.28	514950.0
2016-02-25	AAP	Stock	150.8	151.49	147.05	150.08	639900.0
2016-02-25	AAT	Stock	37.02	38.09	36.98	37.76	372500.0
2016-02-25	AAU-DELISTED	Stock	0.7795	0.78	0.75	0.77	61076.0
2016-02-25	AAUAF-DELISTED	Stock	0.7795	0.78	0.75	0.77	62151.0
2016-02-25	AAV-DELISTED	Stock	5.1	5.15	4.99	5.08	65538.0
2016-02-25	AAVL-DELISTED	Stock	5.3	5.51	5.15	5.29	191555.0
2016-02-25	AAWW-DELISTED	Stock	36.54	36.996	36.115	36.42	376551.0
2016-02-25	AAXJ	Stock	48.89	49.3	48.67	49.28	521186.0
2016-02-25	AAXN-DELISTED	Stock	17.2	17.37	16.84	17.21	922678.0
2016-02-25	AB	Stock	19.0	19.5	18.95	19.19	255700.0
2016-02-25	ABAC-DELISTED	Stock	0.6166	0.6166	0.6	0.6	1797.0
2016-02-25	ABAX-DELISTED	Stock	39.84	39.84	38.73	39.2701	279438.0
2016-02-25	ABB-DELISTED	Stock	17.65	17.82	17.61	17.81	1468117.0
2016-02-25	ABBNY-DELISTED	Stock	17.65	17.82	17.61	17.81	1502341.0
2016-02-25	ABBV	Stock	55.17	56.23	54.43	56.2	7076300.0
2016-02-25	ABC-DELISTED	Stock	87.55	88.03	86.88	87.59	1102980.0
2016-02-25	ABCB	Stock	26.38	26.64	26.22	26.57	63800.0
2016-02-25	ABCD-DELISTED	Stock	4.24	4.31	4.1499	4.31	17112.0
2016-02-25	ABCO-DELISTED	Stock	27.3	29.19	27.15	27.83	2445941.0
2016-02-25	ABCW-DELISTED	Stock	41.1	41.59	41.02	41.54	98048.0
2016-02-25	ABDC-DELISTED	Stock	9.5501	10.18	9.55	9.89	29138.0
2016-02-25	ABE-DELISTED	Stock	10.886	10.886	10.46	10.46	344.0
2016-02-25	ABEO	Stock	61.0	61.5	56.5	57.5	1684.0
2016-02-25	ABEV	Stock	4.48	4.51	4.4	4.46	8771400.0
2016-02-25	ABG	Stock	58.46	59.43	57.96	59.3	385400.0
2016-02-25	ABGB-DELISTED	Stock	0.79	0.79	0.7	0.7	7802.0
2016-02-25	ABIL-DELISTED	Stock	7.1	7.18	7.1	7.165	1786.0

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

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