PREVIEW / stock_daily / 2018-05-24

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-24.parquet
  size:    217 KB
  rows:    6,479
  symbols: 2,791

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-24	AAPL	Stock	47.1925	47.21	46.5525	47.0375	92936000.0
2018-05-24	MSFT	Stock	98.73	98.94	96.81	98.31	26649300.0
2018-05-24	NVDA	Stock	6.1848	6.235	6.131	6.1923	437372000.0
2018-05-24	AMZN	Stock	79.9015	80.412	79.419	80.1535	68600000.0
2018-05-24	GOOGL	Stock	54.345	54.356	53.615	54.2725	20603880.0
2018-05-24	META	Stock	185.88	186.8	185.03	185.93	12354700.0
2018-05-24	TSLA	Stock	18.56	18.7407	18.326	18.5233	62650500.0
2018-05-24	TLT	Stock	118.69	119.055	118.6408	118.88	8204131.0
2018-05-24	ES	Stock	56.54	56.66	56.06	56.63	2857700.0
2018-05-24	CL	Stock	62.73	63.12	62.35	62.49	3433900.0
2018-05-24	A	Stock	64.62	65.0	64.07	64.12	1525800.0
2018-05-24	AA	Stock	48.62	49.44	48.55	49.15	1867200.0
2018-05-24	AABA-DELISTED	Stock	76.84	77.49	76.4	77.18	3488423.0
2018-05-24	AAC-DELISTED	Stock	11.72	11.88	11.32	11.5889	110647.0
2018-05-24	AACG	Stock	5.28	5.28	5.16	5.16	4600.0
2018-05-24	AAIC-DELISTED	Stock	11.3	11.34	11.2201	11.26	348468.0
2018-05-24	AAL	Stock	42.94	43.89	42.76	43.56	3855300.0
2018-05-24	AAM.A-DELISTED	Stock	25.38	25.45	25.32	25.45	23396.0
2018-05-24	AAM.B-DELISTED	Stock	24.97	25.0	24.91	25.0	71667.0
2018-05-24	AAMC-DELISTED	Stock	19.1618	19.4118	18.4118	18.4118	2717.0
2018-05-24	AAME	Stock	2.75	2.75	2.65	2.65	2200.0
2018-05-24	AAMI	Stock	15.4	15.53	15.29	15.46	323000.0
2018-05-24	AAOI	Stock	33.37	34.56	33.37	33.93	478500.0
2018-05-24	AAON	Stock	20.7	20.7333	20.4333	20.5	229650.0
2018-05-24	AAP	Stock	123.32	126.0	120.96	125.17	1270200.0
2018-05-24	AAT	Stock	35.47	35.62	35.1	35.27	165400.0
2018-05-24	AAU-DELISTED	Stock	0.72	0.7297	0.7021	0.706	141091.0
2018-05-24	AAUAF-DELISTED	Stock	0.72	0.7297	0.7021	0.706	149489.0
2018-05-24	AAV-DELISTED	Stock	3.0	3.05	2.9	2.95	226746.0
2018-05-24	AAWW-DELISTED	Stock	68.3	68.35	67.35	68.2	94144.0
2018-05-24	AAXJ	Stock	76.42	76.46	75.51	76.38	1756211.0
2018-05-24	AAXN-DELISTED	Stock	60.0	62.5	59.4	62.09	890855.0
2018-05-24	AB	Stock	28.15	28.35	27.9	28.25	473000.0
2018-05-24	ABAC-DELISTED	Stock	2.24	2.24	2.24	2.24	134.0
2018-05-24	ABAX-DELISTED	Stock	83.08	83.3	82.97	83.0	417238.0
2018-05-24	ABB-DELISTED	Stock	23.77	23.84	23.54	23.76	1160633.0
2018-05-24	ABBNY-DELISTED	Stock	23.77	23.84	23.54	23.76	3333347.0
2018-05-24	ABBV	Stock	104.55	104.55	101.61	103.14	13164500.0
2018-05-24	ABC-DELISTED	Stock	83.56	85.23	82.34	84.11	1050392.0
2018-05-24	ABCB	Stock	56.3	56.3	55.25	56.2	102900.0
2018-05-24	ABCD-DELISTED	Stock	9.92	10.11	9.9101	10.01	95269.0
2018-05-24	ABDC-DELISTED	Stock	6.63	6.68	6.44	6.555	78490.0
2018-05-24	ABEO	Stock	402.5	413.75	400.0	406.25	25572.0
2018-05-24	ABEV	Stock	5.49	5.56	5.43	5.55	19389200.0
2018-05-24	ABG	Stock	68.85	70.55	68.6	70.15	161400.0
2018-05-24	ABIL-DELISTED	Stock	2.48	2.49	2.4478	2.47	5559.0
2018-05-24	ABLX-DELISTED	Stock	52.838	52.838	52.68	52.68	200.0
2018-05-24	ABM	Stock	29.42	29.43	29.03	29.23	1040600.0
2018-05-24	ABMD-DELISTED	Stock	396.17	403.445	389.1	394.52	358331.0
2018-05-24	ABR	Stock	9.45	9.49	9.43	9.47	678700.0

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

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