PREVIEW / stock_daily / 2017-04-21

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-21.parquet
  size:    214 KB
  rows:    6,444
  symbols: 3,029

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-21	AAPL	Stock	35.61	35.67	35.4625	35.5675	69283600.0
2017-04-21	MSFT	Stock	65.67	66.7	65.45	66.4	32522600.0
2017-04-21	NVDA	Stock	2.521	2.5448	2.509	2.542	341896000.0
2017-04-21	AMZN	Stock	45.1335	45.1825	44.8385	44.9265	48410000.0
2017-04-21	GOOGL	Stock	43.031	43.122	42.8865	42.9475	23457400.0
2017-04-21	META	Stock	143.9	144.17	142.27	143.68	12382000.0
2017-04-21	TSLA	Stock	20.1333	20.4267	20.028	20.3733	67647000.0
2017-04-21	TLT	Stock	123.82	124.24	123.49	123.54	9798520.0
2017-04-21	ES	Stock	59.45	59.97	59.45	59.8	1286800.0
2017-04-21	CL	Stock	73.03	73.39	72.92	73.02	2718200.0
2017-04-21	A	Stock	53.26	53.39	52.84	53.27	2189400.0
2017-04-21	AA	Stock	32.2	32.55	31.65	31.7	5041900.0
2017-04-21	AAAP-DELISTED	Stock	37.69	37.69	36.12	37.23	34776.0
2017-04-21	AABA-DELISTED	Stock	47.73	47.77	47.37	47.53	6596466.0
2017-04-21	AAC-DELISTED	Stock	7.58	7.6804	7.31	7.39	77323.0
2017-04-21	AACG	Stock	3.77	3.77	3.7	3.7	14100.0
2017-04-21	AAIC-DELISTED	Stock	14.46	14.47	14.33	14.35	307524.0
2017-04-21	AAL	Stock	45.5	45.5	44.99	45.15	5536000.0
2017-04-21	AAM.A-DELISTED	Stock	25.15	25.34	25.14	25.3	1741645.0
2017-04-21	AAMC-DELISTED	Stock	20.2353	21.8824	20.2353	20.5294	28795.0
2017-04-21	AAME	Stock	3.85	3.85	3.85	3.85	1100.0
2017-04-21	AAMI	Stock	15.11	15.18	15.0	15.07	150200.0
2017-04-21	AAOI	Stock	45.86	47.14	44.75	45.54	4223900.0
2017-04-21	AAON	Stock	23.8333	24.3333	23.6333	24.1333	279450.0
2017-04-21	AAP	Stock	146.47	147.02	145.03	146.84	1021600.0
2017-04-21	AAT	Stock	44.5	44.54	43.96	44.18	191500.0
2017-04-21	AAU-DELISTED	Stock	1.59	1.59	1.52	1.54	269803.0
2017-04-21	AAUAF-DELISTED	Stock	1.59	1.59	1.5	1.5	273787.0
2017-04-21	AAV-DELISTED	Stock	6.5	6.5	6.3744	6.45	62712.0
2017-04-21	AAWW-DELISTED	Stock	57.4	57.6525	56.75	57.3	80945.0
2017-04-21	AAXJ	Stock	62.91	62.95	62.74	62.89	580394.0
2017-04-21	AAXN-DELISTED	Stock	23.34	23.78	23.29	23.69	915518.0
2017-04-21	AB	Stock	23.1	23.2	22.85	22.9	180800.0
2017-04-21	ABAC-DELISTED	Stock	2.2	2.3	2.2	2.21	27791.0
2017-04-21	ABAX-DELISTED	Stock	48.75	49.05	48.4	48.89	80506.0
2017-04-21	ABB-DELISTED	Stock	23.11	23.37	23.08	23.32	2897413.0
2017-04-21	ABBNY-DELISTED	Stock	23.11	23.37	23.08	23.32	4141926.0
2017-04-21	ABBV	Stock	63.76	64.29	63.55	63.82	4154900.0
2017-04-21	ABC-DELISTED	Stock	82.2	82.2905	81.11	81.28	962777.0
2017-04-21	ABCB	Stock	46.0	46.95	45.15	46.3	301100.0
2017-04-21	ABCD-DELISTED	Stock	4.88	4.9	4.81	4.87	21740.0
2017-04-21	ABCO-DELISTED	Stock	47.45	47.7	47.25	47.5	210945.0
2017-04-21	ABDC-DELISTED	Stock	14.34	14.46	14.18	14.4	31168.0
2017-04-21	ABE-DELISTED	Stock	13.49	13.49	13.45	13.4725	7319.0
2017-04-21	ABEO	Stock	131.25	131.25	127.5	130.0	4984.0
2017-04-21	ABEOW-DELISTED	Stock	2.75	2.75	2.75	2.75	100.0
2017-04-21	ABEV	Stock	5.65	5.7	5.59	5.64	19450600.0
2017-04-21	ABG	Stock	62.2	62.2	60.3	61.35	299300.0
2017-04-21	ABIL-DELISTED	Stock	1.5	1.5	1.0	1.0	51270.0
2017-04-21	ABM	Stock	42.92	43.27	42.79	43.07	237300.0

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

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