PREVIEW / stock_daily / 2018-01-09

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-09.parquet
  size:    217 KB
  rows:    6,495
  symbols: 2,883

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-01-09	AAPL	Stock	43.6375	43.765	43.3525	43.5825	86336000.0
2018-01-09	MSFT	Stock	88.65	88.73	87.86	88.22	19484300.0
2018-01-09	NVDA	Stock	5.5555	5.5955	5.466	5.5485	497000000.0
2018-01-09	AMZN	Stock	62.845	62.9665	62.088	62.635	73226000.0
2018-01-09	GOOGL	Stock	55.922	55.922	55.41	55.6395	26807620.0
2018-01-09	META	Stock	188.7	188.8	187.1	187.87	12393100.0
2018-01-09	TSLA	Stock	22.344	22.5867	21.8267	22.246	107199000.0
2018-01-09	TLT	Stock	124.81	124.83	123.81	123.95	16226402.0
2018-01-09	ES	Stock	62.2	62.39	61.46	61.78	2255300.0
2018-01-09	CL	Stock	75.58	75.87	75.25	75.64	2518300.0
2018-01-09	A	Stock	70.68	72.33	70.17	71.77	2666100.0
2018-01-09	AA	Stock	55.0	55.08	54.0	54.2	3533000.0
2018-01-09	AAAP-DELISTED	Stock	81.76	81.85	81.76	81.8	85577.0
2018-01-09	AABA-DELISTED	Stock	77.02	77.23	75.835	76.6	3621908.0
2018-01-09	AAC-DELISTED	Stock	9.0	9.12	8.91	9.05	71154.0
2018-01-09	AACG	Stock	5.3	5.33	5.3	5.32	2500.0
2018-01-09	AAIC-DELISTED	Stock	11.86	11.88	11.77	11.8	347979.0
2018-01-09	AAL	Stock	52.97	53.37	52.01	52.08	3426000.0
2018-01-09	AAM.A-DELISTED	Stock	26.08	26.2	26.011	26.2	21472.0
2018-01-09	AAMC-DELISTED	Stock	23.2353	23.2353	23.2353	23.2353	721.0
2018-01-09	AAME	Stock	3.35	3.44	3.35	3.4	2000.0
2018-01-09	AAMI	Stock	17.61	17.95	17.61	17.64	589600.0
2018-01-09	AAOI	Stock	38.14	38.3	35.1	35.54	3015300.0
2018-01-09	AAON	Stock	24.9667	24.9667	24.4667	24.7333	328650.0
2018-01-09	AAP	Stock	111.69	111.69	109.81	110.49	1091400.0
2018-01-09	AAT	Stock	37.2	37.2	36.54	36.56	113300.0
2018-01-09	AAU-DELISTED	Stock	0.9522	0.9663	0.93	0.9407	101471.0
2018-01-09	AAUAF-DELISTED	Stock	0.9522	0.9663	0.93	0.9407	108995.0
2018-01-09	AAV-DELISTED	Stock	4.05	4.05	3.85	3.85	203338.0
2018-01-09	AAWW-DELISTED	Stock	56.6	57.8	55.75	57.2	355083.0
2018-01-09	AAXJ	Stock	79.43	79.49	79.1	79.41	679295.0
2018-01-09	AAXN-DELISTED	Stock	26.77	27.08	26.65	26.81	289637.0
2018-01-09	AB	Stock	26.85	27.8	26.75	27.5	1006000.0
2018-01-09	ABAC-DELISTED	Stock	2.89	3.07	2.84	2.85	13069.0
2018-01-09	ABAX-DELISTED	Stock	54.04	62.7	53.19	61.54	490893.0
2018-01-09	ABB-DELISTED	Stock	27.55	27.58	27.43	27.47	1815592.0
2018-01-09	ABBNY-DELISTED	Stock	27.55	27.58	27.43	27.48	2514960.0
2018-01-09	ABBV	Stock	99.49	100.66	98.7	100.24	4055400.0
2018-01-09	ABC-DELISTED	Stock	96.95	97.86	95.91	97.52	1478111.0
2018-01-09	ABCB	Stock	50.55	51.35	50.4	51.05	285700.0
2018-01-09	ABCD-DELISTED	Stock	5.98	6.19	5.9	6.09	49731.0
2018-01-09	ABDC-DELISTED	Stock	8.59	8.65	8.36	8.4	62153.0
2018-01-09	ABE-DELISTED	Stock	15.04	15.0942	15.04	15.05	989.0
2018-01-09	ABEO	Stock	383.75	406.25	380.0	402.5	32260.0
2018-01-09	ABEOW-DELISTED	Stock	10.8	11.45	10.35	11.45	6120.0
2018-01-09	ABEV	Stock	6.6	6.64	6.57	6.58	8450900.0
2018-01-09	ABG	Stock	71.0	71.63	70.0	71.05	411000.0
2018-01-09	ABIL-DELISTED	Stock	0.54	0.54	0.4569	0.486	253012.0
2018-01-09	ABLX-DELISTED	Stock	40.21	42.245	39.335	42.0	1196321.0
2018-01-09	ABM	Stock	39.62	39.72	39.41	39.5	425700.0

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

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