PREVIEW / stock_daily / 2017-03-31

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-31.parquet
  size:    216 KB
  rows:    6,478
  symbols: 3,050

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-31	AAPL	Stock	35.93	36.0675	35.7525	35.915	78646800.0
2017-03-31	MSFT	Stock	65.65	66.19	65.45	65.86	21040300.0
2017-03-31	NVDA	Stock	2.7253	2.7473	2.71	2.7232	440808000.0
2017-03-31	AMZN	Stock	43.85	44.5175	43.8325	44.327	79152000.0
2017-03-31	GOOGL	Stock	42.3415	42.478	42.2622	42.39	28819640.0
2017-03-31	META	Stock	142.31	142.63	141.89	142.05	11478300.0
2017-03-31	TSLA	Stock	18.582	18.6453	18.4213	18.5533	49419000.0
2017-03-31	TLT	Stock	120.28	120.81	120.21	120.71	5144760.0
2017-03-31	ES	Stock	58.56	59.09	58.56	58.78	1670700.0
2017-03-31	CL	Stock	72.98	73.51	72.78	73.19	2849500.0
2017-03-31	A	Stock	53.07	53.23	52.81	52.87	1705600.0
2017-03-31	AA	Stock	34.06	34.74	33.6	34.4	5188400.0
2017-03-31	AAAP-DELISTED	Stock	40.0	40.05	39.5703	39.86	110625.0
2017-03-31	AABA-DELISTED	Stock	46.52	46.7	46.27	46.42	7329160.0
2017-03-31	AAC-DELISTED	Stock	8.45	8.91	8.42	8.52	82924.0
2017-03-31	AACG	Stock	3.85	3.94	3.8	3.8	6000.0
2017-03-31	AAIC-DELISTED	Stock	14.0	14.18	13.95	14.13	423637.0
2017-03-31	AAL	Stock	42.37	42.94	42.27	42.3	5427700.0
2017-03-31	AAM.A-DELISTED	Stock	25.16	25.2	25.14	25.16	286093.0
2017-03-31	AAMC-DELISTED	Stock	21.4746	22.6471	21.4746	22.1324	44683.0
2017-03-31	AAME	Stock	4.0	4.03	3.95	4.0	8000.0
2017-03-31	AAMI	Stock	15.1	15.22	15.03	15.12	236100.0
2017-03-31	AAOI	Stock	55.35	56.54	54.171	56.15	2467500.0
2017-03-31	AAON	Stock	23.4667	23.7667	23.3667	23.5667	300150.0
2017-03-31	AAP	Stock	148.26	149.4	147.38	148.26	981800.0
2017-03-31	AAT	Stock	41.49	42.01	41.49	41.84	503600.0
2017-03-31	AAU-DELISTED	Stock	1.09	1.18	1.0822	1.18	342851.0
2017-03-31	AAUAF-DELISTED	Stock	1.09	1.18	1.0822	1.18	349377.0
2017-03-31	AAV-DELISTED	Stock	6.6	6.675	6.55	6.65	75976.0
2017-03-31	AAWW-DELISTED	Stock	55.45	56.25	54.95	55.4	274824.0
2017-03-31	AAXJ	Stock	63.03	63.09	62.91	62.94	295673.0
2017-03-31	AAXN-DELISTED	Stock	23.18	23.215	22.77	22.79	750503.0
2017-03-31	AB	Stock	22.5	22.95	22.35	22.85	298100.0
2017-03-31	ABAC-DELISTED	Stock	2.39	2.4	2.25	2.3	21510.0
2017-03-31	ABAX-DELISTED	Stock	48.25	48.95	48.09	48.54	76042.0
2017-03-31	ABB-DELISTED	Stock	23.26	23.465	23.24	23.39	1506866.0
2017-03-31	ABBNY-DELISTED	Stock	23.26	23.465	23.24	23.4	1548457.0
2017-03-31	ABBV	Stock	65.46	65.52	65.15	65.16	4057800.0
2017-03-31	ABC-DELISTED	Stock	88.87	89.65	88.47	88.5	1549344.0
2017-03-31	ABCB	Stock	46.3	46.65	44.05	46.1	485000.0
2017-03-31	ABCD-DELISTED	Stock	4.95	5.18	4.85	4.9	96583.0
2017-03-31	ABCO-DELISTED	Stock	46.7	47.0	46.55	46.8	186848.0
2017-03-31	ABDC-DELISTED	Stock	13.98	13.98	13.25	13.74	68208.0
2017-03-31	ABE-DELISTED	Stock	13.02	13.2	13.02	13.04	2766.0
2017-03-31	ABEO	Stock	121.25	127.5	117.5	125.0	12648.0
2017-03-31	ABEOW-DELISTED	Stock	2.8478	2.95	2.8478	2.93	750.0
2017-03-31	ABEV	Stock	5.75	5.82	5.7	5.76	19543100.0
2017-03-31	ABG	Stock	61.95	61.95	59.9	60.1	254900.0
2017-03-31	ABIL-DELISTED	Stock	2.08	2.08	1.96	1.98	10644.0
2017-03-31	ABM	Stock	43.31	43.87	43.31	43.6	253100.0

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

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