PREVIEW / stock_daily / 2016-04-12

all stock daily files

  file:    by_date/stock_daily/2016/2016-04-12.parquet
  size:    219 KB
  rows:    6,576
  symbols: 3,325

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-12	AAPL	Stock	27.335	27.625	27.165	27.61	108929200.0
2016-04-12	MSFT	Stock	54.37	54.78	53.76	54.65	24944300.0
2016-04-12	NVDA	Stock	0.9	0.9012	0.8785	0.896	292764000.0
2016-04-12	AMZN	Stock	29.92	30.203	29.6155	30.1585	52822000.0
2016-04-12	GOOGL	Stock	37.9215	38.246	37.5783	38.216	27387160.0
2016-04-12	META	Stock	109.34	111.16	108.99	110.61	26248100.0
2016-04-12	TSLA	Stock	16.6333	16.7867	16.242	16.5213	86448000.0
2016-04-12	TLT	Stock	131.08	131.55	130.525	130.93	4276037.0
2016-04-12	ES	Stock	56.67	56.8	56.43	56.67	1764300.0
2016-04-12	CL	Stock	70.83	71.37	70.77	71.23	2549000.0
2016-04-12	A	Stock	39.47	39.83	39.34	39.75	992500.0
2016-04-12	AA.B-DELISTED	Stock	32.84	33.11	32.1301	33.04	86821.0
2016-04-12	AAAP-DELISTED	Stock	35.97	36.3	35.4	36.25	53078.0
2016-04-12	AABA-DELISTED	Stock	36.65	36.83	36.28	36.66	9543742.0
2016-04-12	AAC-DELISTED	Stock	18.25	18.642	17.695	18.44	132121.0
2016-04-12	AACG	Stock	5.7	5.7	5.23	5.34	2600.0
2016-04-12	AAIC-DELISTED	Stock	12.2	12.53	12.136	12.49	358386.0
2016-04-12	AAL	Stock	38.82	39.43	38.76	39.19	6426000.0
2016-04-12	AAMC-DELISTED	Stock	6.0441	6.0441	5.3294	5.95	108820.0
2016-04-12	AAME	Stock	4.71	4.71	4.7	4.71	400.0
2016-04-12	AAMI	Stock	12.8	13.1	12.58	13.05	344700.0
2016-04-12	AAOI	Stock	16.0	16.018	15.23	15.42	254700.0
2016-04-12	AAON	Stock	17.7	18.04	17.7	17.7533	276150.0
2016-04-12	AAP	Stock	154.66	156.6	153.5	156.5	674600.0
2016-04-12	AAT	Stock	38.6	38.74	38.4	38.55	214900.0
2016-04-12	AAU-DELISTED	Stock	1.21	1.27	1.1	1.22	1362523.0
2016-04-12	AAUAF-DELISTED	Stock	1.21	1.27	1.1	1.21	1367661.0
2016-04-12	AAV-DELISTED	Stock	5.35	5.59	5.23	5.58	121184.0
2016-04-12	AAVL-DELISTED	Stock	5.12	5.22	5.0	5.1	202566.0
2016-04-12	AAWW-DELISTED	Stock	38.99	39.55	38.7	39.05	134565.0
2016-04-12	AAXJ	Stock	53.99	54.6325	53.83	54.46	473172.0
2016-04-12	AAXN-DELISTED	Stock	18.52	19.0	18.39	18.84	551645.0
2016-04-12	AB	Stock	23.89	23.95	23.52	23.68	347300.0
2016-04-12	ABAC-DELISTED	Stock	0.55	0.6815	0.5022	0.64	41096.0
2016-04-12	ABAX-DELISTED	Stock	44.56	45.64	43.41	45.46	302629.0
2016-04-12	ABB-DELISTED	Stock	19.54	19.76	19.47	19.71	1082071.0
2016-04-12	ABBNY-DELISTED	Stock	19.54	19.76	19.47	19.71	1523486.0
2016-04-12	ABBV	Stock	58.98	60.05	58.69	59.89	7243700.0
2016-04-12	ABC-DELISTED	Stock	84.61	85.15	84.0499	84.9	1556880.0
2016-04-12	ABCB	Stock	28.59	28.96	28.33	28.84	118200.0
2016-04-12	ABCD-DELISTED	Stock	4.11	4.18	3.96	3.96	52488.0
2016-04-12	ABCO-DELISTED	Stock	31.43	31.6554	30.96	31.26	443772.0
2016-04-12	ABCW-DELISTED	Stock	44.62	45.03	44.555	44.94	20864.0
2016-04-12	ABDC-DELISTED	Stock	11.6	11.81	11.59	11.81	37749.0
2016-04-12	ABE-DELISTED	Stock	11.73	11.95	11.72	11.86	16855.0
2016-04-12	ABEO	Stock	65.0	67.0	62.5	64.25	2284.0
2016-04-12	ABEOW-DELISTED	Stock	0.65	0.65	0.65	0.65	150.0
2016-04-12	ABEV	Stock	5.14	5.21	5.07	5.2	12146800.0
2016-04-12	ABG	Stock	54.29	56.16	54.01	55.93	306900.0
2016-04-12	ABGB-DELISTED	Stock	1.5	1.52	1.43	1.5195	42294.0

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

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