PREVIEW / stock_daily / 2016-04-14

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-14.parquet
  size:    219 KB
  rows:    6,568
  symbols: 3,306

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-04-14	AAPL	Stock	27.905	28.0975	27.8325	28.025	101895600.0
2016-04-14	MSFT	Stock	55.22	55.58	55.07	55.36	20877100.0
2016-04-14	NVDA	Stock	0.916	0.925	0.9123	0.921	416564000.0
2016-04-14	AMZN	Stock	30.7535	31.219	30.7535	31.0375	70242000.0
2016-04-14	GOOGL	Stock	38.768	38.9805	38.661	38.7695	26992200.0
2016-04-14	META	Stock	110.62	112.04	110.26	110.84	28473300.0
2016-04-14	TSLA	Stock	16.8667	17.1227	16.7367	16.7907	61983000.0
2016-04-14	TLT	Stock	130.91	131.31	130.4901	130.76	6966979.0
2016-04-14	ES	Stock	55.98	56.22	55.84	56.1	1695000.0
2016-04-14	CL	Stock	70.81	71.19	70.71	70.8	2744900.0
2016-04-14	A	Stock	40.86	41.08	40.53	40.78	1347800.0
2016-04-14	AA.B-DELISTED	Stock	34.5	35.0	33.92	34.96	38777.0
2016-04-14	AAAP-DELISTED	Stock	35.0001	35.45	33.51	35.2899	12557.0
2016-04-14	AABA-DELISTED	Stock	37.47	37.5	36.85	37.16	15814416.0
2016-04-14	AAC-DELISTED	Stock	19.15	20.01	18.85	19.88	200467.0
2016-04-14	AACG	Stock	5.42	5.7	5.25	5.31	11200.0
2016-04-14	AAIC-DELISTED	Stock	12.85	12.92	12.68	12.72	180242.0
2016-04-14	AAL	Stock	40.34	41.66	40.25	41.17	10133400.0
2016-04-14	AAMC-DELISTED	Stock	5.8118	5.9794	5.7088	5.8426	66280.0
2016-04-14	AAME	Stock	4.75	4.75	4.71	4.72	3600.0
2016-04-14	AAMI	Stock	13.78	13.84	13.58	13.72	146800.0
2016-04-14	AAOI	Stock	16.1	16.48	15.92	16.25	126600.0
2016-04-14	AAON	Stock	18.2133	18.5467	17.8067	18.3933	294450.0
2016-04-14	AAP	Stock	160.23	161.51	159.75	160.94	507500.0
2016-04-14	AAT	Stock	38.52	38.52	38.07	38.38	137800.0
2016-04-14	AAU-DELISTED	Stock	1.14	1.15	1.1099	1.15	407281.0
2016-04-14	AAUAF-DELISTED	Stock	1.14	1.17	1.1099	1.17	412022.0
2016-04-14	AAV-DELISTED	Stock	5.46	5.49	5.1749	5.27	73384.0
2016-04-14	AAVL-DELISTED	Stock	5.36	5.46	5.26	5.295	229714.0
2016-04-14	AAWW-DELISTED	Stock	40.81	41.104	40.14	40.3	105778.0
2016-04-14	AAXJ	Stock	55.5	55.5	55.29	55.41	1755420.0
2016-04-14	AAXN-DELISTED	Stock	19.57	19.73	19.28	19.3103	477745.0
2016-04-14	AB	Stock	23.82	24.0	23.65	23.73	218200.0
2016-04-14	ABAC-DELISTED	Stock	0.6122	0.62	0.59	0.61	5772.0
2016-04-14	ABAX-DELISTED	Stock	45.83	46.07	45.15	45.87	138364.0
2016-04-14	ABB-DELISTED	Stock	19.87	19.91	19.8	19.86	875096.0
2016-04-14	ABBNY-DELISTED	Stock	19.87	19.91	19.8	19.85	905997.0
2016-04-14	ABBV	Stock	59.15	59.49	59.0	59.28	5185600.0
2016-04-14	ABC-DELISTED	Stock	84.7	87.14	84.63	86.705	1813764.0
2016-04-14	ABCB	Stock	29.81	30.81	29.71	30.57	565200.0
2016-04-14	ABCD-DELISTED	Stock	4.0	4.48	4.0	4.39	58226.0
2016-04-14	ABCO-DELISTED	Stock	31.91	32.31	31.33	31.85	324042.0
2016-04-14	ABCW-DELISTED	Stock	45.97	46.3618	45.76	46.1	23329.0
2016-04-14	ABDC-DELISTED	Stock	11.91	11.97	11.67	11.8	27060.0
2016-04-14	ABE-DELISTED	Stock	12.08	12.24	12.07	12.24	11152.0
2016-04-14	ABEO	Stock	67.0	70.5	66.75	68.75	2328.0
2016-04-14	ABEOW-DELISTED	Stock	0.79	0.79	0.79	0.79	100.0
2016-04-14	ABEV	Stock	5.22	5.35	5.18	5.33	13864600.0
2016-04-14	ABG	Stock	59.0	61.14	58.57	59.26	624400.0
2016-04-14	ABGB-DELISTED	Stock	1.42	1.45	1.42	1.45	29575.0

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

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