PREVIEW / stock_daily / 2019-07-19

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-19.parquet
  size:    220 KB
  rows:    6,574
  symbols: 2,541

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-19	AAPL	Stock	51.4475	51.625	50.59	50.6475	83717200.0
2019-07-19	MSFT	Stock	140.22	140.67	136.45	136.62	48992400.0
2019-07-19	NVDA	Stock	4.293	4.2995	4.205	4.211	344896000.0
2019-07-19	AMZN	Stock	99.5605	99.8	98.1115	98.226	63712000.0
2019-07-19	GOOGL	Stock	57.466	57.579	56.5625	56.5775	23183060.0
2019-07-19	META	Stock	202.18	202.33	198.07	198.36	12098300.0
2019-07-19	TSLA	Stock	17.046	17.3307	16.9747	17.212	105726000.0
2019-07-19	TLT	Stock	131.59	131.93	131.505	131.69	5804843.0
2019-07-19	ES	Stock	78.12	78.53	76.74	76.77	1904000.0
2019-07-19	CL	Stock	73.77	73.88	72.69	72.7	2417400.0
2019-07-19	A	Stock	70.58	70.58	68.6	68.7	2694400.0
2019-07-19	AA	Stock	23.36	23.78	22.87	23.11	4645200.0
2019-07-19	AABA-DELISTED	Stock	70.7	70.72	70.21	70.24	1656214.0
2019-07-19	AAC-DELISTED	Stock	1.03	1.0661	0.95	0.95	96520.0
2019-07-19	AACG	Stock	2.81	2.81	2.46	2.63	128000.0
2019-07-19	AAIC-DELISTED	Stock	6.56	6.63	6.51	6.51	407035.0
2019-07-19	AAIC.C-DELISTED	Stock	22.8	22.8	22.4885	22.68	6170.0
2019-07-19	AAL	Stock	33.82	34.02	33.06	33.08	4249000.0
2019-07-19	AAM.A-DELISTED	Stock	26.12	26.16	26.0602	26.12	20551.0
2019-07-19	AAM.B-DELISTED	Stock	26.18	26.29	26.18	26.22	18297.0
2019-07-19	AAMC-DELISTED	Stock	3.4382	3.6382	3.3853	3.4403	5447.0
2019-07-19	AAME	Stock	2.41	2.41	2.41	2.41	100.0
2019-07-19	AAMI	Stock	11.25	11.43	11.13	11.13	336100.0
2019-07-19	AAOI	Stock	9.68	9.74	9.48	9.62	497000.0
2019-07-19	AAON	Stock	33.7333	34.8133	33.44	34.1133	299700.0
2019-07-19	AAP	Stock	158.09	158.73	156.14	156.93	965300.0
2019-07-19	AAT	Stock	46.39	46.54	45.66	45.82	401100.0
2019-07-19	AAU-DELISTED	Stock	0.66	0.66	0.62	0.636	203611.0
2019-07-19	AAUAF-DELISTED	Stock	0.66	0.66	0.62	0.636	208144.0
2019-07-19	AAWW-DELISTED	Stock	42.56	43.1	42.49	42.73	115256.0
2019-07-19	AAXJ	Stock	70.08	70.15	69.66	69.67	573769.0
2019-07-19	AAXN-DELISTED	Stock	65.83	66.77	65.69	65.92	423310.0
2019-07-19	AB	Stock	30.47	30.66	30.17	30.22	85200.0
2019-07-19	ABB-DELISTED	Stock	18.83	18.98	18.815	18.97	2090395.0
2019-07-19	ABBNY-DELISTED	Stock	18.84	18.98	18.815	18.96	2441302.0
2019-07-19	ABBV	Stock	68.14	68.82	68.1	68.54	9806900.0
2019-07-19	ABC-DELISTED	Stock	86.64	86.64	85.09	85.54	707597.0
2019-07-19	ABCB	Stock	37.51	38.63	37.51	37.78	369300.0
2019-07-19	ABDC-DELISTED	Stock	8.29	8.35	8.27	8.32	11541.0
2019-07-19	ABEO	Stock	96.25	97.75	93.25	93.5	15092.0
2019-07-19	ABEV	Stock	4.92	4.93	4.8	4.8	22680600.0
2019-07-19	ABG	Stock	84.47	85.41	84.4	84.44	90500.0
2019-07-19	ABIL-DELISTED	Stock	0.8404	0.87	0.8403	0.8689	14541.0
2019-07-19	ABM	Stock	41.86	42.21	41.35	41.36	287000.0
2019-07-19	ABMD-DELISTED	Stock	264.08	266.86	260.31	260.73	149867.0
2019-07-19	ABR	Stock	12.13	12.16	12.07	12.11	790400.0
2019-07-19	ABR.A-DELISTED	Stock	26.13	26.13	26.0936	26.0936	1200.0
2019-07-19	ABR.B-DELISTED	Stock	25.8999	25.9	25.8999	25.9	500.0
2019-07-19	ABR.C-DELISTED	Stock	26.375	26.4199	26.375	26.4189	2392.0
2019-07-19	ABT	Stock	88.29	88.33	87.45	87.49	5824000.0

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

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