PREVIEW / stock_daily / 2019-08-05

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-05.parquet
  size:    222 KB
  rows:    6,611
  symbols: 2,530

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
2019-08-05	AAPL	Stock	49.4975	49.6625	48.145	48.335	209572000.0
2019-08-05	MSFT	Stock	133.3	133.93	130.78	132.21	42749600.0
2019-08-05	NVDA	Stock	3.845	3.8462	3.7225	3.7698	589156000.0
2019-08-05	AMZN	Stock	88.511	89.4335	87.439	88.2565	121164000.0
2019-08-05	GOOGL	Stock	58.6485	58.844	57.1375	57.7375	47839440.0
2019-08-05	META	Stock	184.69	185.67	179.34	181.73	23086700.0
2019-08-05	TSLA	Stock	15.3067	15.4247	15.052	15.2213	105424500.0
2019-08-05	TLT	Stock	138.14	138.89	137.66	138.87	18542993.0
2019-08-05	ES	Stock	76.94	77.65	76.14	76.55	2481300.0
2019-08-05	CL	Stock	70.99	71.23	68.41	68.8	5215500.0
2019-08-05	A	Stock	66.84	67.17	65.66	65.86	3273100.0
2019-08-05	AA	Stock	20.22	20.266	19.54	20.15	3982200.0
2019-08-05	AABA-DELISTED	Stock	69.5	69.955	69.285	69.505	4007333.0
2019-08-05	AAC-DELISTED	Stock	0.91	0.93	0.7	0.7	236003.0
2019-08-05	AACG	Stock	2.4	2.41	2.1	2.25	126000.0
2019-08-05	AAIC-DELISTED	Stock	6.3	6.31	6.15	6.18	405694.0
2019-08-05	AAIC.C-DELISTED	Stock	23.37	23.37	23.02	23.02	729.0
2019-08-05	AAL	Stock	28.97	28.97	28.0	28.53	8948900.0
2019-08-05	AAM.A-DELISTED	Stock	26.3	26.3	25.95	25.99	23894.0
2019-08-05	AAM.B-DELISTED	Stock	26.9042	26.9042	26.51	26.5354	45606.0
2019-08-05	AAMC-DELISTED	Stock	3.0235	3.2176	2.8353	3.1706	34109.0
2019-08-05	AAME	Stock	2.23	2.35	2.23	2.35	1200.0
2019-08-05	AAMI	Stock	9.53	9.72	9.21	9.39	519500.0
2019-08-05	AAOI	Stock	9.58	9.855	9.47	9.8	565700.0
2019-08-05	AAON	Stock	30.44	31.3067	30.2533	30.64	289650.0
2019-08-05	AAP	Stock	142.95	143.4	139.96	143.16	1604800.0
2019-08-05	AAT	Stock	46.6	46.61	44.9	45.58	333700.0
2019-08-05	AAU-DELISTED	Stock	0.715	0.8	0.715	0.8	411262.0
2019-08-05	AAUAF-DELISTED	Stock	0.715	0.8	0.715	0.8	422359.0
2019-08-05	AAWW-DELISTED	Stock	32.07	32.72	30.82	31.03	472584.0
2019-08-05	AAXJ	Stock	63.91	63.94	62.7	63.06	4305215.0
2019-08-05	AAXN-DELISTED	Stock	67.58	67.58	64.26	65.9	619445.0
2019-08-05	AB	Stock	28.29	28.29	26.8	27.03	530200.0
2019-08-05	ABB-DELISTED	Stock	18.23	18.28	17.94	18.05	3002265.0
2019-08-05	ABBNY-DELISTED	Stock	18.23	18.28	17.94	18.05	3120086.0
2019-08-05	ABBV	Stock	64.98	66.12	64.54	65.23	11618800.0
2019-08-05	ABC-DELISTED	Stock	89.58	90.86	87.82	88.7	1049335.0
2019-08-05	ABCB	Stock	37.34	37.4	36.25	36.73	427500.0
2019-08-05	ABDC-DELISTED	Stock	8.3093	8.3188	8.25	8.28	10688.0
2019-08-05	ABEO	Stock	58.75	62.25	57.5	61.0	24196.0
2019-08-05	ABEV	Stock	5.15	5.17	5.05	5.09	23862800.0
2019-08-05	ABG	Stock	89.71	91.64	89.71	91.17	138000.0
2019-08-05	ABIL-DELISTED	Stock	0.7523	0.7523	0.65	0.72	27895.0
2019-08-05	ABM	Stock	39.74	40.29	38.95	39.5	405800.0
2019-08-05	ABMD-DELISTED	Stock	207.18	212.745	201.4908	204.31	1105778.0
2019-08-05	ABR	Stock	12.77	12.81	12.29	12.3	2133400.0
2019-08-05	ABR.A-DELISTED	Stock	26.191	26.191	26.05	26.18	4750.0
2019-08-05	ABR.B-DELISTED	Stock	25.9	26.0	25.82	25.82	1991.0
2019-08-05	ABR.C-DELISTED	Stock	26.6396	26.6396	26.6396	26.6396	100.0
2019-08-05	ABT	Stock	84.73	84.88	82.42	83.16	6253800.0

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

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