PREVIEW / stock_daily / 2017-03-20

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-20.parquet
  size:    215 KB
  rows:    6,460
  symbols: 3,049

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-20	AAPL	Stock	35.1	35.375	35.0575	35.365	86168000.0
2017-03-20	MSFT	Stock	64.91	65.18	64.72	64.93	14598100.0
2017-03-20	NVDA	Stock	2.6695	2.7402	2.6532	2.7362	748568000.0
2017-03-20	AMZN	Stock	42.5755	42.89	42.5505	42.8485	45654000.0
2017-03-20	GOOGL	Stock	43.474	43.517	43.2332	43.3955	30843980.0
2017-03-20	META	Stock	139.71	140.19	139.25	139.94	12099500.0
2017-03-20	TSLA	Stock	17.3733	17.6367	17.2547	17.4613	54214500.0
2017-03-20	TLT	Stock	118.55	119.23	118.5	119.15	5497756.0
2017-03-20	ES	Stock	58.98	59.3	58.35	58.48	1318400.0
2017-03-20	CL	Stock	73.8	73.99	73.58	73.8	2796100.0
2017-03-20	A	Stock	53.31	53.63	53.0	53.15	1221400.0
2017-03-20	AA	Stock	34.9	35.36	34.1	34.9	2688900.0
2017-03-20	AAAP-DELISTED	Stock	37.24	37.49	36.85	37.34	61664.0
2017-03-20	AABA-DELISTED	Stock	46.62	47.16	46.52	46.77	5413492.0
2017-03-20	AAC-DELISTED	Stock	8.58	8.58	8.3	8.36	79537.0
2017-03-20	AACG	Stock	3.66	3.75	3.53	3.63	16500.0
2017-03-20	AAIC-DELISTED	Stock	14.38	14.4967	14.23	14.42	460334.0
2017-03-20	AAL	Stock	42.18	42.42	41.45	41.7	6229800.0
2017-03-20	AAM.A-DELISTED	Stock	25.0	25.04	24.94	24.97	125997.0
2017-03-20	AAMC-DELISTED	Stock	18.6324	18.9412	17.3936	17.7941	67895.0
2017-03-20	AAME	Stock	3.85	3.85	3.75	3.75	900.0
2017-03-20	AAMI	Stock	14.63	14.71	14.525	14.64	286400.0
2017-03-20	AAOI	Stock	51.37	51.49	49.09	50.33	1098400.0
2017-03-20	AAON	Stock	24.5667	24.7333	24.3	24.4667	201750.0
2017-03-20	AAP	Stock	152.95	154.23	151.86	152.44	1051400.0
2017-03-20	AAT	Stock	42.45	42.54	42.01	42.05	241000.0
2017-03-20	AAU-DELISTED	Stock	1.03	1.04	1.01	1.03	115593.0
2017-03-20	AAUAF-DELISTED	Stock	1.03	1.04	1.01	1.03	116524.0
2017-03-20	AAV-DELISTED	Stock	5.9	6.075	5.9	6.0	37585.0
2017-03-20	AAWW-DELISTED	Stock	54.35	54.85	53.15	53.15	122200.0
2017-03-20	AAXJ	Stock	63.33	63.67	63.27	63.59	2991615.0
2017-03-20	AAXN-DELISTED	Stock	23.46	23.63	22.88	22.94	714000.0
2017-03-20	AB	Stock	22.4	22.55	22.25	22.35	302600.0
2017-03-20	ABAC-DELISTED	Stock	2.35	2.52	2.35	2.4	29964.0
2017-03-20	ABAX-DELISTED	Stock	49.28	49.38	48.8	49.1	35945.0
2017-03-20	ABB-DELISTED	Stock	23.36	23.4	23.25	23.26	2206505.0
2017-03-20	ABBNY-DELISTED	Stock	23.36	23.4	23.25	23.27	2252406.0
2017-03-20	ABBV	Stock	65.78	66.01	65.56	65.8	4252100.0
2017-03-20	ABC-DELISTED	Stock	87.65	87.89	86.25	86.9	1409099.0
2017-03-20	ABCB	Stock	47.45	47.95	46.85	47.35	180800.0
2017-03-20	ABCD-DELISTED	Stock	5.12	5.13	5.04	5.055	26016.0
2017-03-20	ABCO-DELISTED	Stock	44.6	45.675	44.425	45.2	613219.0
2017-03-20	ABDC-DELISTED	Stock	13.57	13.64	13.33	13.63	48861.0
2017-03-20	ABE-DELISTED	Stock	12.5476	12.73	12.5476	12.71	24343.0
2017-03-20	ABEO	Stock	126.25	128.75	125.0	126.25	7600.0
2017-03-20	ABEV	Stock	5.52	5.74	5.5	5.71	20566400.0
2017-03-20	ABG	Stock	61.8	62.05	61.0	61.6	264500.0
2017-03-20	ABIL-DELISTED	Stock	2.42	2.42	2.23	2.31	14078.0
2017-03-20	ABM	Stock	44.48	44.65	43.96	44.02	229500.0
2017-03-20	ABMD-DELISTED	Stock	123.97	124.41	122.5201	123.54	129781.0

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

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