PREVIEW / stock_daily / 2019-07-15

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-15.parquet
  size:    219 KB
  rows:    6,558
  symbols: 2,529

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-07-15	AAPL	Stock	51.0225	51.4675	51.0	51.3025	67789600.0
2019-07-15	MSFT	Stock	139.44	139.54	138.46	138.9	16651500.0
2019-07-15	NVDA	Stock	4.2115	4.2278	4.1532	4.1818	289840000.0
2019-07-15	AMZN	Stock	101.07	101.145	100.0775	101.0495	59626000.0
2019-07-15	GOOGL	Stock	57.267	57.534	57.0	57.5255	21168620.0
2019-07-15	META	Stock	204.25	205.33	201.82	203.91	16030300.0
2019-07-15	TSLA	Stock	16.5333	16.9613	16.324	16.9	165001500.0
2019-07-15	TLT	Stock	130.45	131.05	130.45	130.97	6055917.0
2019-07-15	ES	Stock	77.4	77.93	77.1	77.75	1258000.0
2019-07-15	CL	Stock	74.42	75.52	73.87	74.0	2487700.0
2019-07-15	A	Stock	71.02	71.02	69.49	70.55	3955300.0
2019-07-15	AA	Stock	22.78	23.23	22.68	23.17	3320900.0
2019-07-15	AABA-DELISTED	Stock	70.03	70.6	69.93	70.26	2520053.0
2019-07-15	AAC-DELISTED	Stock	1.19	1.2	1.15	1.15	95590.0
2019-07-15	AACG	Stock	2.66	2.68	2.56	2.62	35000.0
2019-07-15	AAIC-DELISTED	Stock	6.49	6.61	6.455	6.58	602851.0
2019-07-15	AAIC.C-DELISTED	Stock	21.9745	22.13	21.955	22.0818	8565.0
2019-07-15	AAL	Stock	33.67	33.95	33.42	33.61	3483600.0
2019-07-15	AAM.A-DELISTED	Stock	25.82	25.93	25.82	25.93	9907.0
2019-07-15	AAM.B-DELISTED	Stock	25.92	26.0	25.92	26.0	68835.0
2019-07-15	AAMC-DELISTED	Stock	3.4908	3.4908	3.4908	3.4908	1183.0
2019-07-15	AAME	Stock	2.29	2.31	2.29	2.3	1700.0
2019-07-15	AAMI	Stock	11.51	11.6	11.34	11.57	352100.0
2019-07-15	AAOI	Stock	10.01	10.14	9.58	9.97	541700.0
2019-07-15	AAON	Stock	34.1933	34.26	33.58	33.58	177450.0
2019-07-15	AAP	Stock	159.01	159.14	156.63	158.92	487600.0
2019-07-15	AAT	Stock	47.54	47.54	46.84	47.02	292900.0
2019-07-15	AAU-DELISTED	Stock	0.65	0.6588	0.64	0.6415	84072.0
2019-07-15	AAUAF-DELISTED	Stock	0.65	0.6588	0.64	0.6415	87030.0
2019-07-15	AAWW-DELISTED	Stock	42.81	42.88	41.73	42.32	92822.0
2019-07-15	AAXJ	Stock	69.72	69.82	69.61	69.82	456163.0
2019-07-15	AAXN-DELISTED	Stock	64.65	65.37	63.67	63.76	536685.0
2019-07-15	AB	Stock	30.47	30.62	30.0	30.46	179500.0
2019-07-15	ABB-DELISTED	Stock	19.0	19.01	18.9168	18.97	1140521.0
2019-07-15	ABBNY-DELISTED	Stock	19.0	19.01	18.9168	18.98	1205845.0
2019-07-15	ABBV	Stock	70.31	71.02	69.7	70.27	10253300.0
2019-07-15	ABC-DELISTED	Stock	90.01	90.4	88.955	89.92	629483.0
2019-07-15	ABCB	Stock	38.9	38.91	37.55	37.79	382100.0
2019-07-15	ABDC-DELISTED	Stock	8.34	8.35	8.31	8.31	18265.0
2019-07-15	ABEO	Stock	105.0	109.0	102.75	105.5	20724.0
2019-07-15	ABEV	Stock	4.86	4.9	4.8	4.83	29021400.0
2019-07-15	ABG	Stock	84.59	85.34	82.87	83.72	99700.0
2019-07-15	ABIL-DELISTED	Stock	0.8801	0.92	0.8801	0.92	8610.0
2019-07-15	ABM	Stock	41.32	41.83	41.07	41.5	342800.0
2019-07-15	ABMD-DELISTED	Stock	263.19	265.66	258.075	260.46	226766.0
2019-07-15	ABR	Stock	12.43	12.44	12.32	12.35	687800.0
2019-07-15	ABR.A-DELISTED	Stock	25.95	26.1098	25.95	26.106	1650.0
2019-07-15	ABR.B-DELISTED	Stock	25.89	25.89	25.85	25.85	600.0
2019-07-15	ABR.C-DELISTED	Stock	25.99	25.9961	25.98	25.9961	1600.0
2019-07-15	ABT	Stock	83.81	84.24	83.41	83.81	5177700.0

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

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