PREVIEW / stock_daily / 2017-01-11

all stock daily files

  file:    by_date/stock_daily/2017/2017-01-11.parquet
  size:    215 KB
  rows:    6,494
  symbols: 3,106

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
2017-01-11	AAPL	Stock	29.685	29.9825	29.65	29.9375	110354400.0
2017-01-11	MSFT	Stock	62.61	63.23	62.43	63.19	21517300.0
2017-01-11	NVDA	Stock	2.65	2.655	2.6038	2.629	525664000.0
2017-01-11	AMZN	Stock	39.683	39.975	39.4755	39.951	59856000.0
2017-01-11	GOOGL	Stock	41.331	41.495	41.0735	41.493	26507880.0
2017-01-11	META	Stock	124.35	126.12	124.06	126.09	18356500.0
2017-01-11	TSLA	Stock	15.2713	15.332	15.112	15.3153	54762000.0
2017-01-11	TLT	Stock	121.94	122.69	121.41	122.16	9402523.0
2017-01-11	ES	Stock	54.4	55.11	54.36	55.06	1369600.0
2017-01-11	CL	Stock	65.3	65.41	65.0	65.31	3809000.0
2017-01-11	A	Stock	48.03	49.48	47.95	49.25	5624300.0
2017-01-11	AA	Stock	31.08	32.0	31.08	31.97	3068300.0
2017-01-11	AAAP-DELISTED	Stock	28.4	29.03	28.17	28.85	46983.0
2017-01-11	AABA-DELISTED	Stock	42.27	42.59	42.07	42.58	6585714.0
2017-01-11	AAC-DELISTED	Stock	7.94	8.31	7.82	8.26	164230.0
2017-01-11	AACG	Stock	3.61	3.61	3.33	3.54	13600.0
2017-01-11	AAIC-DELISTED	Stock	15.38	15.59	15.2	15.35	271535.0
2017-01-11	AAL	Stock	49.29	49.9	48.1	48.64	6925800.0
2017-01-11	AAMC-DELISTED	Stock	17.8971	18.8676	17.8971	18.8676	26044.0
2017-01-11	AAMI	Stock	14.43	14.64	14.19	14.64	490300.0
2017-01-11	AAOI	Stock	22.86	23.46	22.5	22.72	382500.0
2017-01-11	AAON	Stock	22.2	22.5	22.0333	22.5	225300.0
2017-01-11	AAP	Stock	173.51	174.99	170.92	173.43	889000.0
2017-01-11	AAT	Stock	43.07	43.42	42.9	43.01	150000.0
2017-01-11	AAU-DELISTED	Stock	1.03	1.06	0.99	1.05	202703.0
2017-01-11	AAUAF-DELISTED	Stock	1.03	1.06	0.99	1.05	204424.0
2017-01-11	AAV-DELISTED	Stock	6.35	6.6	6.325	6.5	70642.0
2017-01-11	AAWW-DELISTED	Stock	52.25	53.15	51.55	53.15	93910.0
2017-01-11	AAXJ	Stock	57.45	57.775	57.22	57.67	2003628.0
2017-01-11	AAXN-DELISTED	Stock	24.7	24.75	24.2878	24.63	328770.0
2017-01-11	AB	Stock	22.8	23.29	22.75	23.1	243900.0
2017-01-11	ABAC-DELISTED	Stock	3.4998	3.65	3.499	3.61	7445.0
2017-01-11	ABAX-DELISTED	Stock	48.62	50.44	48.225	50.18	316612.0
2017-01-11	ABB-DELISTED	Stock	22.1	22.32	22.08	22.28	3475508.0
2017-01-11	ABBNY-DELISTED	Stock	22.1	22.32	22.08	22.28	3642118.0
2017-01-11	ABBV	Stock	63.38	63.65	60.59	61.14	13565200.0
2017-01-11	ABC-DELISTED	Stock	85.15	86.315	79.94	81.525	3502152.0
2017-01-11	ABCB	Stock	43.75	44.55	43.3	44.55	224000.0
2017-01-11	ABCD-DELISTED	Stock	4.94	5.3	4.94	5.19	60908.0
2017-01-11	ABCO-DELISTED	Stock	35.3	36.25	35.2	36.15	373399.0
2017-01-11	ABDC-DELISTED	Stock	12.46	12.46	12.19	12.4	14046.0
2017-01-11	ABE-DELISTED	Stock	11.45	11.5	11.3	11.4	312888.0
2017-01-11	ABEO	Stock	143.75	144.75	129.0	133.75	17272.0
2017-01-11	ABEOW-DELISTED	Stock	3.0	3.015	3.0	3.015	200.0
2017-01-11	ABEV	Stock	5.02	5.17	4.98	5.17	19500000.0
2017-01-11	ABG	Stock	63.55	63.65	61.85	63.3	230500.0
2017-01-11	ABIL-DELISTED	Stock	3.4	3.4	3.2301	3.3	2082.0
2017-01-11	ABM	Stock	39.64	40.24	39.53	40.21	313100.0
2017-01-11	ABMD-DELISTED	Stock	112.35	112.95	109.83	111.27	422369.0
2017-01-11	ABR	Stock	7.61	7.65	7.57	7.57	104200.0

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

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