PREVIEW / stock_daily / 2017-04-26

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-26.parquet
  size:    215 KB
  rows:    6,448
  symbols: 3,027

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-04-26	AAPL	Stock	36.1175	36.15	35.845	35.92	80164800.0
2017-04-26	MSFT	Stock	68.08	68.31	67.62	67.83	26190800.0
2017-04-26	NVDA	Stock	2.6323	2.6348	2.5985	2.6005	327004000.0
2017-04-26	AMZN	Stock	45.515	45.7875	45.378	45.4645	52178000.0
2017-04-26	GOOGL	Stock	44.5695	44.6495	44.2575	44.457	26465940.0
2017-04-26	META	Stock	147.09	147.59	146.09	146.56	12395000.0
2017-04-26	TSLA	Stock	20.8247	20.9667	20.6	20.678	70425000.0
2017-04-26	TLT	Stock	121.52	122.14	121.43	122.12	5766213.0
2017-04-26	ES	Stock	59.95	60.16	59.71	59.74	1105400.0
2017-04-26	CL	Stock	74.16	74.16	73.46	73.5	3244900.0
2017-04-26	A	Stock	55.0	55.33	54.81	54.83	1835000.0
2017-04-26	AA	Stock	36.0	37.2	35.85	36.45	7528300.0
2017-04-26	AAAP-DELISTED	Stock	37.25	37.7	36.32	37.55	33463.0
2017-04-26	AABA-DELISTED	Stock	48.4	48.47	48.17	48.26	3757295.0
2017-04-26	AAC-DELISTED	Stock	7.05	7.55	7.05	7.49	110410.0
2017-04-26	AACG	Stock	3.78	4.05	3.68	3.7	25300.0
2017-04-26	AAIC-DELISTED	Stock	14.53	15.17	14.5	14.78	928175.0
2017-04-26	AAL	Stock	46.51	46.9	46.24	46.4	6027600.0
2017-04-26	AAM.A-DELISTED	Stock	25.3	25.4	25.2501	25.4	125231.0
2017-04-26	AAMC-DELISTED	Stock	21.9118	22.0588	21.7638	21.9118	5766.0
2017-04-26	AAME	Stock	3.86	3.86	3.85	3.85	1500.0
2017-04-26	AAMI	Stock	15.55	15.68	15.51	15.64	272900.0
2017-04-26	AAOI	Stock	49.45	49.84	46.75	47.47	3035300.0
2017-04-26	AAON	Stock	24.7	25.1667	24.3333	24.8333	329550.0
2017-04-26	AAP	Stock	146.29	146.91	145.4	145.78	1112900.0
2017-04-26	AAT	Stock	43.48	43.67	43.05	43.22	336200.0
2017-04-26	AAU-DELISTED	Stock	1.47	1.59	1.45	1.54	513994.0
2017-04-26	AAUAF-DELISTED	Stock	1.47	1.59	1.45	1.55	516690.0
2017-04-26	AAV-DELISTED	Stock	6.3	6.4	6.2	6.25	120718.0
2017-04-26	AAWW-DELISTED	Stock	58.15	60.0	58.15	59.45	138278.0
2017-04-26	AAXJ	Stock	64.25	64.36	64.14	64.17	1639072.0
2017-04-26	AAXN-DELISTED	Stock	24.12	24.48	24.0	24.28	531581.0
2017-04-26	AB	Stock	22.75	23.1	22.7	22.75	764800.0
2017-04-26	ABAC-DELISTED	Stock	1.85	1.85	1.62	1.69	82459.0
2017-04-26	ABAX-DELISTED	Stock	49.2	49.66	48.8	49.24	77215.0
2017-04-26	ABB-DELISTED	Stock	24.27	24.42	24.23	24.24	2694149.0
2017-04-26	ABBNY-DELISTED	Stock	24.27	24.42	24.23	24.23	2838816.0
2017-04-26	ABBV	Stock	65.19	65.92	65.02	65.04	5008900.0
2017-04-26	ABC-DELISTED	Stock	81.5	82.17	81.2	81.27	1006977.0
2017-04-26	ABCB	Stock	48.5	49.45	48.45	49.2	390200.0
2017-04-26	ABCD-DELISTED	Stock	4.95	5.01	4.91	4.93	25719.0
2017-04-26	ABCO-DELISTED	Stock	46.85	47.1	46.55	46.55	197577.0
2017-04-26	ABDC-DELISTED	Stock	14.16	14.32	13.75	13.95	44289.0
2017-04-26	ABE-DELISTED	Stock	13.53	13.61	13.53	13.5801	7320.0
2017-04-26	ABEO	Stock	135.0	145.0	135.0	145.0	10996.0
2017-04-26	ABEOW-DELISTED	Stock	2.75	2.75	2.75	2.75	100.0
2017-04-26	ABEV	Stock	5.72	5.73	5.62	5.68	28586800.0
2017-04-26	ABG	Stock	62.9	63.25	62.05	63.1	399100.0
2017-04-26	ABIL-DELISTED	Stock	0.9	0.9	0.794	0.794	55967.0
2017-04-26	ABM	Stock	43.65	43.99	43.43	43.59	307400.0

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

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