PREVIEW / stock_daily / 2019-10-07

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-07.parquet
  size:    220 KB
  rows:    6,591
  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-10-07	AAPL	Stock	56.5675	57.4825	56.46	56.765	122306000.0
2019-10-07	MSFT	Stock	137.14	138.18	137.02	137.12	15303700.0
2019-10-07	NVDA	Stock	4.6145	4.7085	4.6057	4.6083	480984000.0
2019-10-07	AMZN	Stock	86.5815	87.3915	86.185	86.633	43094000.0
2019-10-07	GOOGL	Stock	60.35	60.9455	60.218	60.4125	17580400.0
2019-10-07	META	Stock	180.0	181.18	178.09	179.68	9178300.0
2019-10-07	TSLA	Stock	15.32	15.904	15.2367	15.848	120963000.0
2019-10-07	TLT	Stock	145.16	145.53	144.71	144.78	11751551.0
2019-10-07	ES	Stock	85.31	85.69	85.08	85.37	1430900.0
2019-10-07	CL	Stock	71.97	72.18	71.56	71.62	2484400.0
2019-10-07	A	Stock	75.35	75.69	74.64	75.1	1048000.0
2019-10-07	AA	Stock	19.41	19.775	19.19	19.25	2624400.0
2019-10-07	AAC-DELISTED	Stock	0.6994	0.6994	0.6511	0.6969	17560.0
2019-10-07	AACG	Stock	1.63	1.76	1.62	1.76	6300.0
2019-10-07	AAIC-DELISTED	Stock	5.29	5.42	5.28	5.39	285603.0
2019-10-07	AAIC.C-DELISTED	Stock	21.1	21.1	21.003	21.005	18101.0
2019-10-07	AAL	Stock	25.8	26.06	25.52	25.83	5725400.0
2019-10-07	AAM.A-DELISTED	Stock	26.5479	26.55	26.35	26.54	28187.0
2019-10-07	AAM.B-DELISTED	Stock	26.77	26.84	26.71	26.84	19440.0
2019-10-07	AAMC-DELISTED	Stock	3.0912	3.2941	2.9853	3.153	50738.0
2019-10-07	AAME	Stock	2.51	2.57	2.5	2.5	2000.0
2019-10-07	AAMI	Stock	9.39	9.54	9.28	9.43	551100.0
2019-10-07	AAOI	Stock	10.45	10.73	10.38	10.47	196200.0
2019-10-07	AAON	Stock	30.0067	30.3	29.8	29.9667	308400.0
2019-10-07	AAP	Stock	159.09	160.37	157.1	158.27	1206600.0
2019-10-07	AAT	Stock	46.28	46.77	46.21	46.63	322500.0
2019-10-07	AAU-DELISTED	Stock	0.7	0.72	0.6873	0.6911	200430.0
2019-10-07	AAUAF-DELISTED	Stock	0.7	0.72	0.6873	0.6911	203182.0
2019-10-07	AAWW-DELISTED	Stock	22.73	22.85	21.77	21.93	448135.0
2019-10-07	AAXJ	Stock	66.01	66.35	65.94	66.02	487964.0
2019-10-07	AAXN-DELISTED	Stock	54.65	55.16	53.75	54.62	457454.0
2019-10-07	AB	Stock	28.5	28.98	28.41	28.89	146000.0
2019-10-07	ABB-DELISTED	Stock	18.09	18.295	18.07	18.11	2245239.0
2019-10-07	ABBNY-DELISTED	Stock	18.09	18.295	18.07	18.11	2327966.0
2019-10-07	ABBV	Stock	74.72	75.27	74.08	74.33	5163500.0
2019-10-07	ABC-DELISTED	Stock	81.39	82.69	80.74	81.85	969534.0
2019-10-07	ABCB	Stock	39.86	39.89	39.43	39.71	279100.0
2019-10-07	ABDC-DELISTED	Stock	8.83	8.88	8.83	8.8612	10126.0
2019-10-07	ABEO	Stock	57.0	61.75	56.0	59.5	14736.0
2019-10-07	ABEOW-DELISTED	Stock	0.19	0.21	0.19	0.21	600.0
2019-10-07	ABEV	Stock	4.72	4.74	4.58	4.58	13558300.0
2019-10-07	ABG	Stock	97.0	97.81	96.03	96.48	102100.0
2019-10-07	ABIL-DELISTED	Stock	0.5022	0.5023	0.452	0.4706	27616.0
2019-10-07	ABM	Stock	34.63	34.87	34.42	34.51	320400.0
2019-10-07	ABMD-DELISTED	Stock	167.02	169.665	164.305	164.35	380799.0
2019-10-07	ABR	Stock	13.03	13.15	13.02	13.1	1693900.0
2019-10-07	ABR.A-DELISTED	Stock	26.0957	26.35	26.0957	26.35	700.0
2019-10-07	ABR.C-DELISTED	Stock	26.3272	26.368	26.3272	26.368	800.0
2019-10-07	ABT	Stock	81.4	81.98	80.97	81.04	2673200.0
2019-10-07	ABTC	Stock	193500.0	195990.0	183150.0	186900.0	2.08

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

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