PREVIEW / stock_daily / 2017-10-09

all stock daily files

  file:    by_date/stock_daily/2017/2017-10-09.parquet
  size:    212 KB
  rows:    6,402
  symbols: 2,899

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-10-09	AAPL	Stock	38.9525	39.1825	38.8725	38.96	65051600.0
2017-10-09	MSFT	Stock	75.97	76.55	75.86	76.29	11386500.0
2017-10-09	NVDA	Stock	4.5698	4.6682	4.5508	4.6347	563492000.0
2017-10-09	AMZN	Stock	49.662	49.925	49.375	49.5495	58772000.0
2017-10-09	GOOGL	Stock	49.75	50.023	49.575	49.6155	25909340.0
2017-10-09	META	Stock	172.7	174.88	172.0	172.5	14570400.0
2017-10-09	TSLA	Stock	23.31	23.45	22.8447	22.8627	112405500.0
2017-10-09	TLT	Stock	123.78	124.06	123.64	123.98	3590926.0
2017-10-09	ES	Stock	60.44	60.68	60.25	60.32	1774300.0
2017-10-09	CL	Stock	72.81	72.96	72.22	72.36	1513900.0
2017-10-09	A	Stock	66.49	66.77	66.02	66.56	1542300.0
2017-10-09	AA	Stock	47.63	47.72	46.58	47.07	2235600.0
2017-10-09	AAAP-DELISTED	Stock	71.0	71.0	64.71	66.83	468496.0
2017-10-09	AABA-DELISTED	Stock	67.85	69.06	67.75	68.73	2380721.0
2017-10-09	AAC-DELISTED	Stock	9.18	9.24	8.26	8.375	143955.0
2017-10-09	AACG	Stock	4.7	4.77	4.7	4.76	4200.0
2017-10-09	AAIC-DELISTED	Stock	12.7	12.78	12.6675	12.75	377562.0
2017-10-09	AAL	Stock	51.23	51.48	50.4	50.6	3691500.0
2017-10-09	AAM.A-DELISTED	Stock	25.9	25.9	25.55	25.7	43955.0
2017-10-09	AAMC-DELISTED	Stock	25.7794	25.7794	25.7794	25.7794	1057.0
2017-10-09	AAMI	Stock	15.17	15.2	15.04	15.14	306900.0
2017-10-09	AAOI	Stock	59.24	59.399	57.9	58.79	1461100.0
2017-10-09	AAON	Stock	23.6333	23.8333	22.0267	23.6	167550.0
2017-10-09	AAP	Stock	94.23	94.47	90.99	91.12	1951300.0
2017-10-09	AAT	Stock	40.27	40.63	40.27	40.52	61200.0
2017-10-09	AAU-DELISTED	Stock	1.2	1.2	1.17	1.18	98996.0
2017-10-09	AAUAF-DELISTED	Stock	1.2	1.2	1.17	1.18	103347.0
2017-10-09	AAV-DELISTED	Stock	5.855	5.908	5.85	5.9	13213.0
2017-10-09	AAWW-DELISTED	Stock	66.0	66.5	64.05	64.3	181995.0
2017-10-09	AAXJ	Stock	73.5	73.795	73.48	73.77	879600.0
2017-10-09	AAXN-DELISTED	Stock	23.72	23.82	23.53	23.57	243394.0
2017-10-09	AB	Stock	24.7	24.95	24.7	24.9	96400.0
2017-10-09	ABAC-DELISTED	Stock	3.57	3.82	3.28	3.29	25551.0
2017-10-09	ABAX-DELISTED	Stock	46.65	46.65	45.615	45.93	81167.0
2017-10-09	ABB-DELISTED	Stock	24.95	25.075	24.93	24.96	741345.0
2017-10-09	ABBNY-DELISTED	Stock	24.95	25.075	24.93	24.96	773987.0
2017-10-09	ABBV	Stock	90.57	91.19	90.15	90.78	4331500.0
2017-10-09	ABC-DELISTED	Stock	80.21	80.49	77.87	78.36	2318353.0
2017-10-09	ABCB	Stock	49.4	49.95	49.0	49.85	239300.0
2017-10-09	ABCD-DELISTED	Stock	6.53	6.59	6.41	6.5	72140.0
2017-10-09	ABCO-DELISTED	Stock	53.9	54.1	53.725	53.8	830971.0
2017-10-09	ABDC-DELISTED	Stock	10.7	10.73	10.48	10.62	54299.0
2017-10-09	ABE-DELISTED	Stock	14.65	14.67	14.61	14.61	6411.0
2017-10-09	ABEO	Stock	446.25	452.5	430.0	437.5	27680.0
2017-10-09	ABEOW-DELISTED	Stock	13.05	13.15	13.05	13.15	1100.0
2017-10-09	ABEV	Stock	6.57	6.61	6.57	6.57	5210100.0
2017-10-09	ABG	Stock	61.75	61.75	60.4	60.65	115700.0
2017-10-09	ABIL-DELISTED	Stock	0.8047	0.89	0.79	0.8161	111383.0
2017-10-09	ABM	Stock	42.57	42.81	42.38	42.77	351600.0
2017-10-09	ABMD-DELISTED	Stock	175.59	175.715	173.63	174.0	147355.0

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

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