PREVIEW / stock_daily / 2018-05-09

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-09.parquet
  size:    218 KB
  rows:    6,520
  symbols: 2,832

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
2018-05-09	AAPL	Stock	46.6375	46.85	46.305	46.84	92844800.0
2018-05-09	MSFT	Stock	96.01	96.97	95.05	96.94	27327400.0
2018-05-09	NVDA	Stock	6.2803	6.3968	6.2528	6.3945	596760000.0
2018-05-09	AMZN	Stock	80.0	80.4	79.6	80.4	72746000.0
2018-05-09	GOOGL	Stock	53.205	54.7	53.1055	54.4475	47159580.0
2018-05-09	META	Stock	179.67	183.01	178.78	182.66	23282800.0
2018-05-09	TSLA	Stock	20.0273	20.4673	20.0033	20.4567	85911000.0
2018-05-09	TLT	Stock	118.12	118.42	117.98	117.98	7832538.0
2018-05-09	ES	Stock	57.47	57.47	56.38	57.0	1720300.0
2018-05-09	CL	Stock	62.53	62.66	61.75	61.91	5007100.0
2018-05-09	A	Stock	67.38	68.41	67.15	68.13	2108500.0
2018-05-09	AA	Stock	53.72	54.13	53.18	53.49	3647500.0
2018-05-09	AABA-DELISTED	Stock	76.12	76.81	75.8	75.93	3330361.0
2018-05-09	AAC-DELISTED	Stock	11.6	11.89	11.07	11.45	168836.0
2018-05-09	AAIC-DELISTED	Stock	11.08	11.1	10.9	10.9	891580.0
2018-05-09	AAL	Stock	42.93	43.16	41.47	41.5	8273700.0
2018-05-09	AAM.A-DELISTED	Stock	24.89	25.0	24.85	24.92	80032.0
2018-05-09	AAM.B-DELISTED	Stock	24.81	24.81	24.67	24.75	66999.0
2018-05-09	AAMC-DELISTED	Stock	18.8823	18.8824	18.8823	18.8824	1499.0
2018-05-09	AAME	Stock	3.1	3.1	3.1	3.1	4400.0
2018-05-09	AAMI	Stock	15.45	15.59	15.32	15.49	387900.0
2018-05-09	AAOI	Stock	31.64	32.63	30.66	32.26	3177300.0
2018-05-09	AAON	Stock	20.4667	20.4667	20.0333	20.1	252600.0
2018-05-09	AAP	Stock	116.87	118.14	111.86	117.99	1476400.0
2018-05-09	AAT	Stock	34.99	35.1	34.86	35.09	267900.0
2018-05-09	AAU-DELISTED	Stock	0.81	0.8273	0.7933	0.82	122228.0
2018-05-09	AAUAF-DELISTED	Stock	0.81	0.8273	0.7933	0.82	131150.0
2018-05-09	AAV-DELISTED	Stock	3.05	3.15	2.975	2.975	220942.0
2018-05-09	AAWW-DELISTED	Stock	68.35	69.0	67.9	68.55	167568.0
2018-05-09	AAXJ	Stock	76.27	76.38	75.85	76.11	456739.0
2018-05-09	AAXN-DELISTED	Stock	50.4	56.22	49.96	54.61	4364185.0
2018-05-09	AB	Stock	27.0	27.0	26.35	26.55	425700.0
2018-05-09	ABAC-DELISTED	Stock	2.3818	2.449	2.27	2.3179	20135.0
2018-05-09	ABAX-DELISTED	Stock	68.38	68.97	67.72	68.39	116946.0
2018-05-09	ABB-DELISTED	Stock	23.85	23.9	23.7138	23.86	1227222.0
2018-05-09	ABBNY-DELISTED	Stock	23.85	23.9	23.7138	23.86	1415647.0
2018-05-09	ABBV	Stock	99.44	102.04	98.9	101.18	5665600.0
2018-05-09	ABC-DELISTED	Stock	84.82	85.61	84.28	84.73	1696747.0
2018-05-09	ABCB	Stock	55.2	55.5	54.65	55.3	178900.0
2018-05-09	ABCD-DELISTED	Stock	9.99	10.29	9.99	10.14	133352.0
2018-05-09	ABDC-DELISTED	Stock	6.42	6.51	6.38	6.4	78726.0
2018-05-09	ABEO	Stock	483.75	485.0	470.0	480.0	23452.0
2018-05-09	ABEV	Stock	6.13	6.17	6.02	6.04	51041700.0
2018-05-09	ABG	Stock	69.9	70.08	68.3	69.75	180300.0
2018-05-09	ABIL-DELISTED	Stock	2.83	2.83	2.681	2.722	27413.0
2018-05-09	ABLX-DELISTED	Stock	52.99	53.09	52.96	52.96	902.0
2018-05-09	ABM	Stock	30.56	30.68	30.38	30.43	434700.0
2018-05-09	ABMD-DELISTED	Stock	347.65	361.83	347.57	358.11	360633.0
2018-05-09	ABR	Stock	9.47	9.51	9.43	9.47	668100.0
2018-05-09	ABR.A-DELISTED	Stock	25.83	25.85	25.83	25.85	1000.0

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

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