PREVIEW / stock_daily / 2017-03-15

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-15.parquet
  size:    216 KB
  rows:    6,484
  symbols: 3,058

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-03-15	AAPL	Stock	34.8525	35.1875	34.7575	35.115	102767200.0
2017-03-15	MSFT	Stock	64.55	64.92	64.25	64.75	24833800.0
2017-03-15	NVDA	Stock	2.5563	2.5748	2.508	2.5638	615036000.0
2017-03-15	AMZN	Stock	42.7165	42.7225	42.3555	42.6485	51244000.0
2017-03-15	GOOGL	Stock	43.397	43.494	43.0648	43.4195	26657700.0
2017-03-15	META	Stock	139.29	140.1	138.49	139.72	19344800.0
2017-03-15	TSLA	Stock	17.1333	17.4	16.9513	17.0487	79962000.0
2017-03-15	TLT	Stock	117.56	118.83	117.43	118.5	14600488.0
2017-03-15	ES	Stock	58.39	59.45	58.34	59.13	2074100.0
2017-03-15	CL	Stock	73.59	74.1	73.33	73.94	4176100.0
2017-03-15	A	Stock	53.31	54.82	53.02	54.1	4118000.0
2017-03-15	AA	Stock	34.4	35.29	33.95	35.14	3753400.0
2017-03-15	AAAP-DELISTED	Stock	36.72	37.35	35.5301	36.79	64943.0
2017-03-15	AABA-DELISTED	Stock	46.55	46.55	45.9	46.28	4953709.0
2017-03-15	AAC-DELISTED	Stock	8.65	9.12	8.42	8.9	155403.0
2017-03-15	AACG	Stock	3.64	3.72	3.57	3.58	14400.0
2017-03-15	AAIC-DELISTED	Stock	13.91	14.28	13.73	14.22	572641.0
2017-03-15	AAL	Stock	40.5	42.19	40.21	42.09	13986200.0
2017-03-15	AAM.A-DELISTED	Stock	24.71	24.89	24.71	24.87	247013.0
2017-03-15	AAMC-DELISTED	Stock	22.0441	22.9045	21.5	21.8235	19241.0
2017-03-15	AAME	Stock	3.95	3.95	3.86	3.95	8100.0
2017-03-15	AAMI	Stock	15.01	15.13	14.99	15.05	354100.0
2017-03-15	AAOI	Stock	48.27	49.15	46.9	47.4	1448200.0
2017-03-15	AAON	Stock	23.7333	24.2	23.5667	24.1333	298200.0
2017-03-15	AAP	Stock	153.58	153.6	151.15	152.92	1593700.0
2017-03-15	AAT	Stock	41.92	43.08	41.89	42.72	245700.0
2017-03-15	AAU-DELISTED	Stock	0.9968	1.06	0.9801	1.06	403153.0
2017-03-15	AAUAF-DELISTED	Stock	0.9968	1.07	0.9801	1.07	404888.0
2017-03-15	AAV-DELISTED	Stock	5.85	6.175	5.85	6.1	107216.0
2017-03-15	AAWW-DELISTED	Stock	54.0	54.75	53.05	54.1	227056.0
2017-03-15	AAXJ	Stock	61.44	62.56	61.32	62.38	897603.0
2017-03-15	AAXN-DELISTED	Stock	22.99	23.1	22.63	23.015	751176.0
2017-03-15	AB	Stock	22.55	22.7	22.35	22.55	400600.0
2017-03-15	ABAC-DELISTED	Stock	2.32	2.3865	2.1912	2.35	8017.0
2017-03-15	ABAX-DELISTED	Stock	48.97	49.13	48.62	48.89	81760.0
2017-03-15	ABB-DELISTED	Stock	22.64	23.05	22.64	22.99	1652866.0
2017-03-15	ABBNY-DELISTED	Stock	22.64	23.05	22.64	23.0	1692982.0
2017-03-15	ABBV	Stock	65.7	66.79	65.68	66.55	5241200.0
2017-03-15	ABC-DELISTED	Stock	88.85	89.57	88.14	89.47	1577538.0
2017-03-15	ABCB	Stock	46.6	47.4	46.5	46.8	393300.0
2017-03-15	ABCD-DELISTED	Stock	4.86	4.97	4.765	4.81	33237.0
2017-03-15	ABCO-DELISTED	Stock	45.5	45.95	45.05	45.15	313812.0
2017-03-15	ABDC-DELISTED	Stock	13.22	13.4	13.08	13.3	65357.0
2017-03-15	ABE-DELISTED	Stock	12.2	12.48	12.195	12.4408	21676.0
2017-03-15	ABEO	Stock	130.0	137.5	126.25	130.0	7132.0
2017-03-15	ABEV	Stock	5.4	5.53	5.35	5.51	16070500.0
2017-03-15	ABG	Stock	62.7	63.2	61.85	62.75	196800.0
2017-03-15	ABIL-DELISTED	Stock	2.35	2.36	2.25	2.3385	10451.0
2017-03-15	ABM	Stock	43.75	44.47	43.63	44.3	345900.0
2017-03-15	ABMD-DELISTED	Stock	120.77	123.385	120.43	122.98	175406.0

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

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