PREVIEW / stock_daily / 2019-10-30

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-30.parquet
  size:    221 KB
  rows:    6,588
  symbols: 2,465

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-10-30	AAPL	Stock	61.19	61.325	60.3025	60.815	124522000.0
2019-10-30	MSFT	Stock	143.52	145.0	142.79	144.61	18496600.0
2019-10-30	NVDA	Stock	5.1	5.1058	5.0065	5.075	205960000.0
2019-10-30	AMZN	Stock	88.012	89.119	87.956	88.9995	48988000.0
2019-10-30	GOOGL	Stock	62.7575	63.4008	62.5325	63.035	29203860.0
2019-10-30	META	Stock	189.56	190.45	185.98	188.25	28734600.0
2019-10-30	TSLA	Stock	20.8667	21.2527	20.6647	21.0007	144627000.0
2019-10-30	TLT	Stock	137.77	139.45	137.77	139.36	10914151.0
2019-10-30	ES	Stock	83.08	83.78	82.68	83.24	2185000.0
2019-10-30	CL	Stock	67.98	68.64	67.8	68.58	2575700.0
2019-10-30	A	Stock	76.04	76.15	75.24	76.12	914800.0
2019-10-30	AA	Stock	21.3	21.345	20.775	21.29	3718500.0
2019-10-30	AACG	Stock	1.71	1.79	1.71	1.79	16600.0
2019-10-30	AAIC-DELISTED	Stock	5.8	5.83	5.75	5.8	186009.0
2019-10-30	AAIC.C-DELISTED	Stock	21.39	21.4292	21.35	21.38	6679.0
2019-10-30	AAL	Stock	30.77	30.94	29.93	30.29	10356100.0
2019-10-30	AAM.A-DELISTED	Stock	26.645	26.69	26.55	26.55	9125.0
2019-10-30	AAM.B-DELISTED	Stock	27.06	27.18	26.98	26.98	23771.0
2019-10-30	AAME	Stock	2.12	2.25	2.11	2.25	1700.0
2019-10-30	AAMI	Stock	9.77	10.12	9.72	10.02	605500.0
2019-10-30	AAOI	Stock	9.81	9.913	9.305	9.36	647600.0
2019-10-30	AAON	Stock	33.1267	33.1733	32.2933	33.1067	210300.0
2019-10-30	AAP	Stock	163.99	165.55	162.8	163.97	721600.0
2019-10-30	AAT	Stock	47.39	48.7	47.18	48.63	454700.0
2019-10-30	AAU-DELISTED	Stock	0.61	0.6101	0.4821	0.5486	1705553.0
2019-10-30	AAUAF-DELISTED	Stock	0.61	0.6101	0.4821	0.54	1733404.0
2019-10-30	AAWW-DELISTED	Stock	23.24	23.81	20.84	21.31	1170074.0
2019-10-30	AAXJ	Stock	69.21	69.6	68.97	69.54	1012734.0
2019-10-30	AAXN-DELISTED	Stock	52.84	53.46	51.8	52.52	505566.0
2019-10-30	AB	Stock	29.69	29.71	29.27	29.35	539000.0
2019-10-30	ABB-DELISTED	Stock	21.05	21.175	20.89	21.14	1506947.0
2019-10-30	ABBNY-DELISTED	Stock	21.05	21.175	20.89	21.15	1583958.0
2019-10-30	ABBV	Stock	78.51	79.79	78.01	79.66	7222500.0
2019-10-30	ABC-DELISTED	Stock	88.0	88.0	84.83	85.88	1074889.0
2019-10-30	ABCB	Stock	43.94	43.94	43.01	43.43	213800.0
2019-10-30	ABDC-DELISTED	Stock	8.91	8.99	8.9	8.94	10684.0
2019-10-30	ABEO	Stock	62.5	64.0	59.5	62.75	8192.0
2019-10-30	ABEV	Stock	4.32	4.37	4.28	4.36	17908800.0
2019-10-30	ABG	Stock	104.3	105.16	103.28	103.46	89400.0
2019-10-30	ABIL-DELISTED	Stock	0.46	0.47	0.4122	0.4314	25296.0
2019-10-30	ABM	Stock	37.32	37.32	36.75	37.05	260100.0
2019-10-30	ABMD-DELISTED	Stock	184.07	184.48	177.75	181.77	746291.0
2019-10-30	ABR	Stock	13.58	13.63	13.54	13.62	648800.0
2019-10-30	ABR.A-DELISTED	Stock	26.31	26.31	26.0	26.0	1227.0
2019-10-30	ABR.B-DELISTED	Stock	26.0	26.0	25.9775	25.99	1002.0
2019-10-30	ABR.C-DELISTED	Stock	26.2	26.26	25.9693	25.9693	6300.0
2019-10-30	ABT	Stock	83.32	84.09	82.9	84.01	3534800.0
2019-10-30	ABTC	Stock	151800.0	155820.0	149400.0	150000.0	0.56
2019-10-30	ABTS	Stock	25.59	29.7	25.59	29.7	293.0
2019-10-30	ABTX-DELISTED	Stock	33.14	33.18	32.62	33.04	86273.0

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

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