PREVIEW / stock_daily / 2019-08-30

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-30.parquet
  size:    219 KB
  rows:    6,572
  symbols: 2,532

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-30	AAPL	Stock	52.54	52.6125	51.8	52.185	84573600.0
2019-08-30	MSFT	Stock	139.15	139.18	136.27	137.86	23940100.0
2019-08-30	NVDA	Stock	4.2215	4.2715	4.1695	4.1878	290616000.0
2019-08-30	AMZN	Stock	89.8745	89.987	88.2285	88.8145	61174000.0
2019-08-30	GOOGL	Stock	60.0175	60.0175	59.286	59.5265	18067500.0
2019-08-30	META	Stock	186.78	186.8	183.46	185.67	10774500.0
2019-08-30	TSLA	Stock	15.2767	15.496	14.9473	15.0407	139809000.0
2019-08-30	TLT	Stock	146.61	147.48	146.36	147.28	13550909.0
2019-08-30	ES	Stock	80.55	80.73	80.01	80.13	1332900.0
2019-08-30	CL	Stock	74.47	74.51	73.91	74.15	2899700.0
2019-08-30	A	Stock	71.45	72.45	70.82	71.11	2356400.0
2019-08-30	AA	Stock	17.94	18.17	17.71	17.93	2095400.0
2019-08-30	AABA-DELISTED	Stock	69.5	69.57	69.35	69.51	8293367.0
2019-08-30	AAC-DELISTED	Stock	0.65	0.67	0.53	0.604	487831.0
2019-08-30	AACG	Stock	1.92	1.93	1.85	1.86	23700.0
2019-08-30	AAIC-DELISTED	Stock	4.96	4.99	4.79	4.94	652315.0
2019-08-30	AAIC.C-DELISTED	Stock	22.03	23.04	22.03	22.99	4766.0
2019-08-30	AAL	Stock	26.4	26.83	26.16	26.31	5076200.0
2019-08-30	AAM.A-DELISTED	Stock	26.28	26.3084	26.11	26.11	68508.0
2019-08-30	AAM.B-DELISTED	Stock	26.5452	26.63	26.44	26.44	70608.0
2019-08-30	AAMC-DELISTED	Stock	3.1618	3.1618	2.9353	2.9353	2315.0
2019-08-30	AAME	Stock	2.57	2.75	2.46	2.52	10100.0
2019-08-30	AAMI	Stock	9.13	9.225	9.0	9.09	610300.0
2019-08-30	AAOI	Stock	8.98	9.04	8.76	8.9	238200.0
2019-08-30	AAON	Stock	31.8467	32.2867	31.6467	31.98	123900.0
2019-08-30	AAP	Stock	138.7	139.82	137.45	137.95	721300.0
2019-08-30	AAT	Stock	46.8	47.0	46.49	46.86	169800.0
2019-08-30	AAU-DELISTED	Stock	0.71	0.7441	0.71	0.7441	190017.0
2019-08-30	AAUAF-DELISTED	Stock	0.71	0.7441	0.71	0.744	214247.0
2019-08-30	AAWW-DELISTED	Stock	26.31	26.64	25.75	25.86	162327.0
2019-08-30	AAXJ	Stock	65.42	65.495	65.02	65.28	1954668.0
2019-08-30	AAXN-DELISTED	Stock	61.56	61.745	59.72	59.96	355510.0
2019-08-30	AB	Stock	28.72	28.83	28.23	28.28	134800.0
2019-08-30	ABB-DELISTED	Stock	19.01	19.1	18.95	19.02	1060391.0
2019-08-30	ABBNY-DELISTED	Stock	19.01	19.1	18.95	19.02	1116323.0
2019-08-30	ABBV	Stock	66.4	66.43	65.49	65.74	6415100.0
2019-08-30	ABC-DELISTED	Stock	82.3	82.49	81.605	82.21	872078.0
2019-08-30	ABCB	Stock	35.51	36.06	35.0	35.19	173300.0
2019-08-30	ABDC-DELISTED	Stock	9.0	9.02	8.93	9.0	56326.0
2019-08-30	ABEO	Stock	46.0	46.25	36.5	38.5	43904.0
2019-08-30	ABEV	Stock	4.49	4.57	4.49	4.54	28067600.0
2019-08-30	ABG	Stock	93.72	94.5	93.13	94.3	142600.0
2019-08-30	ABIL-DELISTED	Stock	0.61	0.69	0.5811	0.66	48230.0
2019-08-30	ABM	Stock	37.48	37.62	36.96	37.26	222500.0
2019-08-30	ABMD-DELISTED	Stock	193.5	194.3526	191.34	193.06	227329.0
2019-08-30	ABR	Stock	12.62	12.64	12.41	12.55	1270400.0
2019-08-30	ABR.A-DELISTED	Stock	25.8881	25.8881	25.8881	25.8881	300.0
2019-08-30	ABR.B-DELISTED	Stock	25.75	25.75	25.661	25.661	540.0
2019-08-30	ABR.C-DELISTED	Stock	26.38	26.38	26.075	26.075	400.0
2019-08-30	ABT	Stock	85.47	85.62	84.63	85.32	3627900.0

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

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