PREVIEW / stock_daily / 2019-08-14

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-14.parquet
  size:    222 KB
  rows:    6,634
  symbols: 2,533

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-14	AAPL	Stock	50.79	51.61	50.6475	50.6875	146189600.0
2019-08-14	MSFT	Stock	136.36	136.92	133.67	133.98	32527300.0
2019-08-14	NVDA	Stock	3.8125	3.8238	3.7078	3.7518	419880000.0
2019-08-14	AMZN	Stock	89.6505	89.7825	87.861	88.148	97872000.0
2019-08-14	GOOGL	Stock	58.8035	59.1395	58.0535	58.2125	35430020.0
2019-08-14	META	Stock	185.8	185.99	179.31	179.71	18903700.0
2019-08-14	TSLA	Stock	15.414	15.4333	14.446	14.6413	143439000.0
2019-08-14	TLT	Stock	145.16	145.7261	144.71	145.69	15068949.0
2019-08-14	ES	Stock	78.19	78.35	76.91	77.16	1885000.0
2019-08-14	CL	Stock	71.01	71.74	70.5	70.52	3990000.0
2019-08-14	A	Stock	66.58	67.02	65.35	65.59	3509700.0
2019-08-14	AA	Stock	18.35	18.41	17.5	17.5	5541500.0
2019-08-14	AABA-DELISTED	Stock	70.01	70.135	69.9	69.92	5137537.0
2019-08-14	AAC-DELISTED	Stock	0.81	0.81	0.66	0.67	417830.0
2019-08-14	AACG	Stock	2.07	2.26	2.07	2.24	50300.0
2019-08-14	AAIC-DELISTED	Stock	5.71	5.75	5.5	5.58	880374.0
2019-08-14	AAIC.C-DELISTED	Stock	22.539	22.539	22.25	22.37	4670.0
2019-08-14	AAL	Stock	27.05	27.07	26.09	26.1	10104400.0
2019-08-14	AAM.A-DELISTED	Stock	26.4981	26.4981	26.31	26.45	5423.0
2019-08-14	AAM.B-DELISTED	Stock	26.57	26.7	26.5	26.55	30592.0
2019-08-14	AAMC-DELISTED	Stock	3.0088	3.0088	2.4765	2.6471	76459.0
2019-08-14	AAME	Stock	2.25	2.39	2.25	2.34	1500.0
2019-08-14	AAMI	Stock	8.7	8.735	8.52	8.53	580600.0
2019-08-14	AAOI	Stock	9.62	9.72	9.29	9.31	468700.0
2019-08-14	AAON	Stock	29.36	29.7	29.0267	29.5867	156900.0
2019-08-14	AAP	Stock	138.24	140.46	135.44	136.49	2424500.0
2019-08-14	AAT	Stock	46.58	46.8	46.19	46.43	310900.0
2019-08-14	AAU-DELISTED	Stock	0.77	0.793	0.76	0.7854	261397.0
2019-08-14	AAUAF-DELISTED	Stock	0.77	0.793	0.76	0.7854	266554.0
2019-08-14	AAWW-DELISTED	Stock	27.59	27.86	26.12	26.33	338013.0
2019-08-14	AAXJ	Stock	63.23	63.41	62.74	62.74	1570766.0
2019-08-14	AAXN-DELISTED	Stock	58.68	58.86	57.05	57.92	668511.0
2019-08-14	AB	Stock	26.93	27.11	26.49	26.51	267600.0
2019-08-14	ABB-DELISTED	Stock	18.42	18.48	18.25	18.27	3540132.0
2019-08-14	ABBNY-DELISTED	Stock	18.42	18.5957	18.25	18.28	6722859.0
2019-08-14	ABBV	Stock	64.5	64.99	63.5	63.5	9373300.0
2019-08-14	ABC-DELISTED	Stock	88.48	88.48	86.14	86.34	1045114.0
2019-08-14	ABCB	Stock	35.99	36.36	35.27	35.48	282500.0
2019-08-14	ABDC-DELISTED	Stock	9.19	9.19	8.95	9.0	253414.0
2019-08-14	ABEO	Stock	60.75	62.5	58.5	60.75	23920.0
2019-08-14	ABEV	Stock	4.77	4.8	4.66	4.68	25831300.0
2019-08-14	ABG	Stock	90.61	91.44	88.96	89.44	187400.0
2019-08-14	ABIL-DELISTED	Stock	0.62	0.666	0.5902	0.5999	45201.0
2019-08-14	ABM	Stock	39.25	39.3	38.18	38.4	258000.0
2019-08-14	ABMD-DELISTED	Stock	194.03	197.68	189.73	190.26	382264.0
2019-08-14	ABR	Stock	12.29	12.29	11.92	11.96	1642800.0
2019-08-14	ABR.A-DELISTED	Stock	25.9378	25.9378	25.858	25.858	655.0
2019-08-14	ABR.B-DELISTED	Stock	25.7599	25.7599	25.5434	25.5434	1101.0
2019-08-14	ABR.C-DELISTED	Stock	26.16	26.7	26.16	26.7	795.0
2019-08-14	ABT	Stock	85.88	86.31	83.91	83.94	4106200.0

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

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