PREVIEW / stock_daily / 2019-09-25

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-25.parquet
  size:    220 KB
  rows:    6,573
  symbols: 2,493

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-09-25	AAPL	Stock	54.6375	55.375	54.285	55.2575	87613600.0
2019-09-25	MSFT	Stock	137.5	139.96	136.03	139.36	21382000.0
2019-09-25	NVDA	Stock	4.3128	4.4755	4.2678	4.4558	308432000.0
2019-09-25	AMZN	Stock	87.368	88.65	86.15	88.4165	69864000.0
2019-09-25	GOOGL	Stock	60.8005	62.401	60.46	62.297	27103240.0
2019-09-25	META	Stock	181.45	183.42	177.87	182.8	18068300.0
2019-09-25	TSLA	Stock	14.9707	15.2653	14.5573	15.2467	141406500.0
2019-09-25	TLT	Stock	143.26	143.55	141.14	141.47	14520656.0
2019-09-25	ES	Stock	84.61	84.81	84.21	84.64	1255800.0
2019-09-25	CL	Stock	72.54	72.8	71.89	72.24	2784500.0
2019-09-25	A	Stock	76.05	76.56	75.16	76.33	1739200.0
2019-09-25	AA	Stock	20.48	21.56	20.38	21.5	3352100.0
2019-09-25	AABA-DELISTED	Stock	19.49	19.73	19.45	19.56	30580519.0
2019-09-25	AAC-DELISTED	Stock	0.7488	0.7488	0.7	0.7201	68117.0
2019-09-25	AACG	Stock	1.77	1.79	1.68	1.68	81100.0
2019-09-25	AAIC-DELISTED	Stock	5.69	5.81	5.63	5.78	589361.0
2019-09-25	AAIC.C-DELISTED	Stock	21.2053	21.3065	21.2053	21.3065	1220.0
2019-09-25	AAL	Stock	27.13	27.83	27.02	27.44	6369400.0
2019-09-25	AAM.A-DELISTED	Stock	26.37	26.47	26.2716	26.47	12923.0
2019-09-25	AAM.B-DELISTED	Stock	26.636	26.79	26.6212	26.77	19438.0
2019-09-25	AAMC-DELISTED	Stock	3.0856	3.3	3.0279	3.0882	29866.0
2019-09-25	AAME	Stock	2.63	2.78	2.63	2.77	1000.0
2019-09-25	AAMI	Stock	10.22	10.44	10.09	10.16	477200.0
2019-09-25	AAOI	Stock	11.06	11.75	10.93	11.695	842300.0
2019-09-25	AAON	Stock	31.0333	32.0867	31.0333	31.9733	218400.0
2019-09-25	AAP	Stock	159.22	162.67	158.88	162.28	789300.0
2019-09-25	AAT	Stock	46.3	46.71	46.3	46.49	237500.0
2019-09-25	AAU-DELISTED	Stock	0.71	0.73	0.71	0.7117	49544.0
2019-09-25	AAUAF-DELISTED	Stock	0.71	0.73	0.71	0.7117	53304.0
2019-09-25	AAWW-DELISTED	Stock	23.85	24.9344	23.76	24.73	460871.0
2019-09-25	AAXJ	Stock	66.52	66.99	66.31	66.91	812625.0
2019-09-25	AAXN-DELISTED	Stock	60.84	61.25	59.11	60.43	299776.0
2019-09-25	AB	Stock	28.72	29.07	28.65	29.02	114000.0
2019-09-25	ABB-DELISTED	Stock	19.29	19.48	19.26	19.455	1753958.0
2019-09-25	ABBNY-DELISTED	Stock	19.29	19.48	19.26	19.45	2057731.0
2019-09-25	ABBV	Stock	72.88	73.24	72.02	72.09	5922700.0
2019-09-25	ABC-DELISTED	Stock	82.17	84.07	82.17	83.24	631537.0
2019-09-25	ABCB	Stock	39.5	40.08	39.4	39.86	444900.0
2019-09-25	ABDC-DELISTED	Stock	8.72	8.88	8.72	8.84	80282.0
2019-09-25	ABEO	Stock	69.0	70.0	63.75	64.75	22592.0
2019-09-25	ABEOW-DELISTED	Stock	0.37	0.37	0.37	0.37	100.0
2019-09-25	ABEV	Stock	4.61	4.73	4.61	4.73	23106100.0
2019-09-25	ABG	Stock	101.4	102.84	100.77	101.63	160200.0
2019-09-25	ABIL-DELISTED	Stock	0.57	0.6188	0.56	0.56	19786.0
2019-09-25	ABM	Stock	36.05	36.67	35.98	36.51	337400.0
2019-09-25	ABMD-DELISTED	Stock	186.32	186.77	181.2	185.17	248662.0
2019-09-25	ABR	Stock	13.01	13.15	13.01	13.12	646700.0
2019-09-25	ABR.A-DELISTED	Stock	26.21	26.32	26.0	26.0	2346.0
2019-09-25	ABR.B-DELISTED	Stock	25.84	26.05	25.84	26.05	3449.0
2019-09-25	ABR.C-DELISTED	Stock	26.3	26.6342	26.3	26.45	3200.0

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

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