PREVIEW / stock_daily / 2019-09-03

all stock daily files

  file:    by_date/stock_daily/2019/2019-09-03.parquet
  size:    219 KB
  rows:    6,579
  symbols: 2,521

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-03	AAPL	Stock	51.6075	51.745	51.055	51.425	80092000.0
2019-09-03	MSFT	Stock	136.61	137.2	135.7	136.04	18869300.0
2019-09-03	NVDA	Stock	4.1145	4.1478	4.0812	4.1042	296140000.0
2019-09-03	AMZN	Stock	88.5	90.04	88.4	89.492	70860000.0
2019-09-03	GOOGL	Stock	59.0925	59.454	58.1858	58.4775	25922320.0
2019-09-03	META	Stock	184.0	185.67	182.11	182.39	9779400.0
2019-09-03	TSLA	Stock	14.9387	15.2633	14.8773	15.0007	80311500.0
2019-09-03	TLT	Stock	147.09	148.67	146.57	147.21	15662954.0
2019-09-03	ES	Stock	80.03	81.48	79.87	81.47	2007700.0
2019-09-03	CL	Stock	73.67	74.55	73.46	74.31	1963800.0
2019-09-03	A	Stock	70.7	71.04	69.48	70.41	2227800.0
2019-09-03	AA	Stock	17.63	17.7	17.09	17.61	2604500.0
2019-09-03	AABA-DELISTED	Stock	69.47	69.6	69.28	69.46	10279367.0
2019-09-03	AAC-DELISTED	Stock	0.62	0.64	0.52	0.535	334252.0
2019-09-03	AACG	Stock	1.86	1.89	1.8	1.87	7000.0
2019-09-03	AAIC-DELISTED	Stock	4.87	4.95	4.82	4.93	443072.0
2019-09-03	AAIC.C-DELISTED	Stock	22.2665	22.3534	22.05	22.06	2454.0
2019-09-03	AAL	Stock	26.16	26.66	25.95	26.51	6730000.0
2019-09-03	AAM.A-DELISTED	Stock	26.18	26.33	26.18	26.27	12705.0
2019-09-03	AAM.B-DELISTED	Stock	26.63	26.63	26.44	26.53	35900.0
2019-09-03	AAMC-DELISTED	Stock	2.6765	2.9412	2.6765	2.9412	3335.0
2019-09-03	AAME	Stock	2.41	2.65	2.41	2.61	3400.0
2019-09-03	AAMI	Stock	9.03	9.165	8.86	9.06	648200.0
2019-09-03	AAOI	Stock	8.77	8.99	8.64	8.74	520500.0
2019-09-03	AAON	Stock	31.74	31.74	30.4733	30.7533	146100.0
2019-09-03	AAP	Stock	137.19	140.43	136.77	140.36	1002500.0
2019-09-03	AAT	Stock	46.82	47.31	46.74	47.16	178400.0
2019-09-03	AAU-DELISTED	Stock	0.77	0.7709	0.7422	0.77	170101.0
2019-09-03	AAUAF-DELISTED	Stock	0.77	0.7709	0.7422	0.7443	179363.0
2019-09-03	AAWW-DELISTED	Stock	25.4	25.4761	24.7	24.93	256428.0
2019-09-03	AAXJ	Stock	64.52	64.88	64.52	64.72	1460988.0
2019-09-03	AAXN-DELISTED	Stock	59.53	59.53	57.9	58.995	502705.0
2019-09-03	AB	Stock	28.02	28.29	27.81	28.2	124400.0
2019-09-03	ABB-DELISTED	Stock	18.85	18.86	18.68	18.7	1275500.0
2019-09-03	ABBNY-DELISTED	Stock	18.85	18.86	18.68	18.71	1355540.0
2019-09-03	ABBV	Stock	65.78	65.8	64.93	65.4	7915700.0
2019-09-03	ABC-DELISTED	Stock	81.87	84.5	81.555	84.05	1210908.0
2019-09-03	ABCB	Stock	34.71	34.83	33.71	33.96	330100.0
2019-09-03	ABDC-DELISTED	Stock	8.98	9.035	8.8905	8.98	89486.0
2019-09-03	ABEO	Stock	49.25	83.25	46.25	73.5	925280.0
2019-09-03	ABEOW-DELISTED	Stock	0.16	0.48	0.1597	0.48	20398.0
2019-09-03	ABEV	Stock	4.43	4.54	4.41	4.44	29304400.0
2019-09-03	ABG	Stock	93.69	94.05	92.28	92.67	150000.0
2019-09-03	ABIL-DELISTED	Stock	0.67	0.67	0.6208	0.64	12261.0
2019-09-03	ABM	Stock	37.01	37.14	36.45	36.59	506700.0
2019-09-03	ABMD-DELISTED	Stock	192.08	192.47	182.05	183.75	450276.0
2019-09-03	ABR	Stock	12.57	12.57	12.42	12.44	680200.0
2019-09-03	ABR.A-DELISTED	Stock	25.95	25.95	25.9105	25.9105	776.0
2019-09-03	ABR.B-DELISTED	Stock	25.87	25.87	25.8699	25.8699	300.0
2019-09-03	ABR.C-DELISTED	Stock	26.032	26.284	26.032	26.156	900.0

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

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