PREVIEW / stock_daily / 2017-11-16

all stock daily files

  file:    by_date/stock_daily/2017/2017-11-16.parquet
  size:    216 KB
  rows:    6,474
  symbols: 2,908

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-11-16	AAPL	Stock	42.795	42.9675	42.575	42.775	94550000.0
2017-11-16	MSFT	Stock	83.1	83.42	82.94	83.2	20962800.0
2017-11-16	NVDA	Stock	5.3245	5.355	5.2812	5.2902	441768000.0
2017-11-16	AMZN	Stock	56.508	56.908	56.5025	56.8645	44266000.0
2017-11-16	GOOGL	Stock	51.9375	52.588	51.9	52.4235	23767840.0
2017-11-16	META	Stock	178.76	179.83	178.5	179.59	15607600.0
2017-11-16	TSLA	Stock	20.9327	21.2093	20.7533	20.8333	87331500.0
2017-11-16	TLT	Stock	126.01	126.33	125.445	125.46	5894944.0
2017-11-16	ES	Stock	65.0	65.23	64.56	64.89	1677300.0
2017-11-16	CL	Stock	72.83	73.0	72.31	72.63	3689200.0
2017-11-16	A	Stock	67.5	68.95	67.45	68.74	2300400.0
2017-11-16	AA	Stock	42.68	43.08	42.06	42.3	3351200.0
2017-11-16	AAAP-DELISTED	Stock	81.08	81.42	80.98	81.27	231034.0
2017-11-16	AABA-DELISTED	Stock	69.8	71.22	69.8	70.78	6563946.0
2017-11-16	AAC-DELISTED	Stock	10.02	10.29	9.8	9.93	156380.0
2017-11-16	AACG	Stock	4.35	4.49	4.35	4.49	6400.0
2017-11-16	AAIC-DELISTED	Stock	11.32	11.52	11.3199	11.41	308488.0
2017-11-16	AAL	Stock	47.26	48.06	47.24	47.68	4461400.0
2017-11-16	AAM.A-DELISTED	Stock	26.3704	26.3704	26.25	26.2615	16217.0
2017-11-16	AAMC-DELISTED	Stock	22.0588	22.5735	22.0441	22.2059	11308.0
2017-11-16	AAME	Stock	3.55	3.65	3.55	3.65	900.0
2017-11-16	AAMI	Stock	15.7	15.83	15.61	15.76	1105500.0
2017-11-16	AAOI	Stock	46.0	46.112	44.21	44.8	1191000.0
2017-11-16	AAON	Stock	22.7333	23.4067	22.6	22.8333	308850.0
2017-11-16	AAP	Stock	92.0	92.77	89.24	90.5	2289000.0
2017-11-16	AAT	Stock	39.41	39.74	39.29	39.58	303500.0
2017-11-16	AAU-DELISTED	Stock	0.8805	0.898	0.85	0.8551	251763.0
2017-11-16	AAUAF-DELISTED	Stock	0.8805	0.898	0.85	0.8551	271373.0
2017-11-16	AAV-DELISTED	Stock	5.2	5.25	5.15	5.15	40720.0
2017-11-16	AAWW-DELISTED	Stock	53.35	54.25	53.35	53.725	122591.0
2017-11-16	AAXJ	Stock	76.04	76.84	76.04	76.72	1428720.0
2017-11-16	AAXN-DELISTED	Stock	21.88	22.46	21.8	22.39	857238.0
2017-11-16	AB	Stock	25.3	25.8	25.15	25.55	265500.0
2017-11-16	ABAC-DELISTED	Stock	2.95	2.95	2.88	2.8884	5425.0
2017-11-16	ABAX-DELISTED	Stock	47.41	48.6	46.85	48.46	68177.0
2017-11-16	ABB-DELISTED	Stock	25.27	25.36	25.23	25.28	1058126.0
2017-11-16	ABBNY-DELISTED	Stock	25.27	25.36	25.23	25.28	1672523.0
2017-11-16	ABBV	Stock	94.44	95.17	93.28	94.47	4301600.0
2017-11-16	ABC-DELISTED	Stock	77.72	80.71	77.41	80.31	2632788.0
2017-11-16	ABCB	Stock	47.05	47.5	46.4	47.3	155000.0
2017-11-16	ABCD-DELISTED	Stock	5.55	5.99	5.55	5.7999	41710.0
2017-11-16	ABCO-DELISTED	Stock	53.8	53.825	53.75	53.8	664270.0
2017-11-16	ABDC-DELISTED	Stock	7.06	7.39	7.06	7.3692	171750.0
2017-11-16	ABE-DELISTED	Stock	14.07	14.175	14.07	14.15	22641.0
2017-11-16	ABEO	Stock	420.0	422.5	390.0	402.5	28928.0
2017-11-16	ABEOW-DELISTED	Stock	11.74	11.75	11.3	11.33	900.0
2017-11-16	ABEV	Stock	6.17	6.24	6.12	6.17	15915700.0
2017-11-16	ABG	Stock	62.25	62.55	61.4	61.7	205400.0
2017-11-16	ABIL-DELISTED	Stock	0.58	0.58	0.521	0.5251	157121.0
2017-11-16	ABLX-DELISTED	Stock	20.44	21.12	20.3	20.78	225025.0

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

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