PREVIEW / stock_daily / 2019-07-24

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-24.parquet
  size:    221 KB
  rows:    6,587
  symbols: 2,546

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-24	AAPL	Stock	51.9175	52.2875	51.7925	52.1675	59966400.0
2019-07-24	MSFT	Stock	138.9	140.74	138.85	140.72	20738300.0
2019-07-24	NVDA	Stock	4.435	4.4722	4.3585	4.4665	366236000.0
2019-07-24	AMZN	Stock	98.465	100.065	98.2935	100.0405	52626000.0
2019-07-24	GOOGL	Stock	56.631	57.2728	56.4255	56.9865	27199120.0
2019-07-24	META	Stock	197.63	204.81	197.22	204.66	32532500.0
2019-07-24	TSLA	Stock	17.278	17.738	17.2107	17.6587	166092000.0
2019-07-24	TLT	Stock	131.6	131.897	131.465	131.79	6389664.0
2019-07-24	ES	Stock	76.89	76.98	75.9	76.42	1797900.0
2019-07-24	CL	Stock	71.84	72.32	71.22	71.28	3246900.0
2019-07-24	A	Stock	69.25	69.58	68.62	69.58	3190400.0
2019-07-24	AA	Stock	22.93	23.6	22.835	23.56	2951300.0
2019-07-24	AABA-DELISTED	Stock	70.96	71.18	70.79	71.06	1589116.0
2019-07-24	AAC-DELISTED	Stock	0.971	1.065	0.971	1.03	57336.0
2019-07-24	AACG	Stock	2.67	2.68	2.6	2.62	42900.0
2019-07-24	AAIC-DELISTED	Stock	6.68	6.735	6.595	6.65	380856.0
2019-07-24	AAIC.C-DELISTED	Stock	23.0	23.025	22.925	23.0	9108.0
2019-07-24	AAL	Stock	33.62	34.99	33.62	34.59	7315300.0
2019-07-24	AAM.A-DELISTED	Stock	26.07	26.5	26.07	26.5	19602.0
2019-07-24	AAM.B-DELISTED	Stock	26.4451	26.71	26.434	26.71	37782.0
2019-07-24	AAMC-DELISTED	Stock	3.2353	3.2353	3.2353	3.2353	5352.0
2019-07-24	AAME	Stock	2.31	2.31	2.31	2.31	500.0
2019-07-24	AAMI	Stock	10.94	11.28	10.94	11.2	310400.0
2019-07-24	AAOI	Stock	9.33	9.73	9.32	9.5	577000.0
2019-07-24	AAON	Stock	34.4467	35.1667	34.08	35.0467	156750.0
2019-07-24	AAP	Stock	157.64	159.22	157.07	158.5	865500.0
2019-07-24	AAT	Stock	46.86	47.24	46.34	47.15	271200.0
2019-07-24	AAU-DELISTED	Stock	0.75	0.79	0.7304	0.7848	188399.0
2019-07-24	AAUAF-DELISTED	Stock	0.75	0.79	0.7304	0.7848	196949.0
2019-07-24	AAWW-DELISTED	Stock	43.83	45.4566	43.83	45.35	109777.0
2019-07-24	AAXJ	Stock	69.82	70.05	69.8	70.05	1068575.0
2019-07-24	AAXN-DELISTED	Stock	66.0	69.42	65.9	68.73	553657.0
2019-07-24	AB	Stock	30.0	30.15	29.79	29.81	172600.0
2019-07-24	ABB-DELISTED	Stock	19.14	19.4	19.1201	19.32	4017333.0
2019-07-24	ABBNY-DELISTED	Stock	19.14	19.4	19.1201	19.32	4295108.0
2019-07-24	ABBV	Stock	67.77	67.89	66.76	67.46	12595300.0
2019-07-24	ABC-DELISTED	Stock	86.01	87.04	85.6	86.89	570691.0
2019-07-24	ABCB	Stock	37.36	38.66	37.02	38.57	421000.0
2019-07-24	ABDC-DELISTED	Stock	8.33	8.4	8.32	8.33	17513.0
2019-07-24	ABEO	Stock	89.0	93.25	87.75	92.5	19228.0
2019-07-24	ABEV	Stock	4.79	4.82	4.72	4.73	18433100.0
2019-07-24	ABG	Stock	86.52	90.63	85.73	90.48	178600.0
2019-07-24	ABIL-DELISTED	Stock	0.8543	0.8543	0.76	0.85	142931.0
2019-07-24	ABM	Stock	41.28	41.7	40.78	41.58	306600.0
2019-07-24	ABMD-DELISTED	Stock	265.28	276.03	264.7	276.0	343162.0
2019-07-24	ABR	Stock	12.18	12.25	12.07	12.13	743800.0
2019-07-24	ABR.A-DELISTED	Stock	26.1649	26.2883	26.1649	26.2883	950.0
2019-07-24	ABR.B-DELISTED	Stock	25.69	25.8498	25.61	25.8	4801.0
2019-07-24	ABR.C-DELISTED	Stock	26.33	26.4436	26.33	26.4436	900.0
2019-07-24	ABT	Stock	88.45	88.69	87.59	88.59	3879100.0

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

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