PREVIEW / stock_daily / 2016-11-15

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-15.parquet
  size:    216 KB
  rows:    6,553
  symbols: 3,182

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-11-15	AAPL	Stock	26.6425	26.92	26.54	26.7775	129058000.0
2016-11-15	MSFT	Stock	58.33	59.49	58.32	58.87	35904100.0
2016-11-15	NVDA	Stock	2.1072	2.1863	2.0982	2.1548	626092000.0
2016-11-15	AMZN	Stock	36.5	37.339	36.2995	37.162	135116000.0
2016-11-15	GOOGL	Stock	38.2735	39.0119	38.261	38.758	58877780.0
2016-11-15	META	Stock	116.73	118.49	115.83	117.2	34681400.0
2016-11-15	TSLA	Stock	12.1853	12.4287	12.1367	12.2513	58530000.0
2016-11-15	TLT	Stock	122.22	122.81	121.78	121.91	11963704.0
2016-11-15	ES	Stock	51.88	52.67	51.88	52.43	1437800.0
2016-11-15	CL	Stock	66.67	67.0	66.22	66.59	5253200.0
2016-11-15	A	Stock	45.33	46.0	44.95	45.4	4710200.0
2016-11-15	AA	Stock	28.94	30.23	28.83	30.21	3668900.0
2016-11-15	AAAP-DELISTED	Stock	36.14	36.94	36.09	36.605	65693.0
2016-11-15	AABA-DELISTED	Stock	39.64	40.45	39.58	40.2	10013550.0
2016-11-15	AAC-DELISTED	Stock	9.2	9.25	9.0	9.1	282324.0
2016-11-15	AACG	Stock	4.2	4.2	4.19	4.19	900.0
2016-11-15	AAIC-DELISTED	Stock	15.55	15.95	15.5157	15.91	236632.0
2016-11-15	AAL	Stock	45.0	45.28	43.59	44.76	13166600.0
2016-11-15	AAMC-DELISTED	Stock	9.6765	10.0	9.4118	9.5588	54179.0
2016-11-15	AAMI	Stock	14.34	14.43	13.91	14.3	1079500.0
2016-11-15	AAOI	Stock	24.14	25.27	24.03	24.7	443200.0
2016-11-15	AAON	Stock	22.3333	22.3333	21.4667	21.5333	244650.0
2016-11-15	AAP	Stock	164.0	166.9	161.53	164.33	7352900.0
2016-11-15	AAT	Stock	41.25	41.45	40.31	40.49	255300.0
2016-11-15	AAU-DELISTED	Stock	1.21	1.2492	1.18	1.2328	290592.0
2016-11-15	AAUAF-DELISTED	Stock	1.21	1.2492	1.18	1.24	292817.0
2016-11-15	AAV-DELISTED	Stock	6.75	6.9	6.75	6.8	76811.0
2016-11-15	AAWW-DELISTED	Stock	50.65	51.2	48.95	50.25	171929.0
2016-11-15	AAXJ	Stock	55.6	56.15	55.56	56.15	2057722.0
2016-11-15	AAXN-DELISTED	Stock	27.59	28.3	27.32	27.77	1615057.0
2016-11-15	AB	Stock	23.7	23.75	23.0	23.3	247600.0
2016-11-15	ABAC-DELISTED	Stock	2.85	2.8999	2.85	2.86	10297.0
2016-11-15	ABAX-DELISTED	Stock	52.48	53.42	52.27	52.99	138805.0
2016-11-15	ABB-DELISTED	Stock	20.92	21.22	20.9138	21.21	1656720.0
2016-11-15	ABBNY-DELISTED	Stock	20.92	21.22	20.9138	21.22	2534390.0
2016-11-15	ABBV	Stock	63.39	63.39	61.98	62.87	5610300.0
2016-11-15	ABC-DELISTED	Stock	81.5	81.66	78.84	79.53	3850415.0
2016-11-15	ABCB	Stock	42.6	42.7	41.4	42.5	229100.0
2016-11-15	ABCD-DELISTED	Stock	5.07	5.22	4.73	5.0	32804.0
2016-11-15	ABCO-DELISTED	Stock	32.85	33.3	32.55	33.2	503561.0
2016-11-15	ABDC-DELISTED	Stock	11.86	11.9245	11.32	11.32	57304.0
2016-11-15	ABE-DELISTED	Stock	11.25	11.45	11.25	11.45	3555.0
2016-11-15	ABEO	Stock	187.5	191.25	167.5	180.0	26692.0
2016-11-15	ABEOW-DELISTED	Stock	3.68	3.72	3.4	3.71	5303.0
2016-11-15	ABEV	Stock	5.11	5.18	5.07	5.16	12061200.0
2016-11-15	ABG	Stock	57.95	59.6	56.9	58.8	245300.0
2016-11-15	ABIL-DELISTED	Stock	3.25	3.34	3.13	3.15	47263.0
2016-11-15	ABM	Stock	42.9	43.71	42.66	43.59	234600.0
2016-11-15	ABMD-DELISTED	Stock	110.02	112.04	109.56	111.59	562464.0
2016-11-15	ABR	Stock	7.52	7.88	7.45	7.65	200700.0

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

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