PREVIEW / stock_daily / 2019-06-06

all stock daily files

  file:    by_date/stock_daily/2019/2019-06-06.parquet
  size:    220 KB
  rows:    6,561
  symbols: 2,566

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-06-06	AAPL	Stock	45.77	46.3675	45.5375	46.305	90105200.0
2019-06-06	MSFT	Stock	126.44	127.97	125.6	127.82	21459000.0
2019-06-06	NVDA	Stock	3.5362	3.6193	3.5338	3.5945	408140000.0
2019-06-06	AMZN	Stock	86.8855	88.0	86.3065	87.718	73786000.0
2019-06-06	GOOGL	Stock	52.3105	52.5	51.7755	52.388	29020520.0
2019-06-06	META	Stock	168.3	169.7	167.23	168.33	12446400.0
2019-06-06	TSLA	Stock	13.6293	14.0667	13.4533	13.73	303633000.0
2019-06-06	TLT	Stock	130.97	131.59	130.32	130.61	9621094.0
2019-06-06	ES	Stock	76.4	77.34	76.27	76.85	1586900.0
2019-06-06	CL	Stock	72.11	73.25	72.06	73.11	3866500.0
2019-06-06	A	Stock	68.52	69.68	68.52	69.16	2469000.0
2019-06-06	AA	Stock	21.45	21.98	21.21	21.57	4244700.0
2019-06-06	AABA-DELISTED	Stock	60.62	61.12	60.6	60.87	3098488.0
2019-06-06	AAC-DELISTED	Stock	0.9848	0.9848	0.89	0.9101	257473.0
2019-06-06	AACG	Stock	1.84	2.05	1.84	1.99	206400.0
2019-06-06	AAIC-DELISTED	Stock	6.86	6.93	6.73	6.75	353443.0
2019-06-06	AAIC.C-DELISTED	Stock	22.0	22.0	21.5776	21.73	22246.0
2019-06-06	AAL	Stock	30.4	30.51	29.88	30.38	5507600.0
2019-06-06	AAM.A-DELISTED	Stock	25.7114	25.82	25.7114	25.72	19783.0
2019-06-06	AAM.B-DELISTED	Stock	25.79	25.82	25.7401	25.775	20596.0
2019-06-06	AAMC-DELISTED	Stock	4.0471	4.4265	3.9853	4.0971	12206.0
2019-06-06	AAME	Stock	2.41	2.45	2.41	2.45	300.0
2019-06-06	AAMI	Stock	10.84	10.94	10.62	10.91	451800.0
2019-06-06	AAOI	Stock	9.21	9.38	8.99	9.3	485400.0
2019-06-06	AAON	Stock	32.0	32.24	31.7067	32.12	275400.0
2019-06-06	AAP	Stock	154.64	155.4	153.42	154.9	919500.0
2019-06-06	AAT	Stock	46.51	46.64	45.99	46.39	281900.0
2019-06-06	AAU-DELISTED	Stock	0.48	0.4805	0.43	0.4652	345503.0
2019-06-06	AAUAF-DELISTED	Stock	0.48	0.4805	0.43	0.4652	348604.0
2019-06-06	AAWW-DELISTED	Stock	38.69	38.82	37.55	38.03	156422.0
2019-06-06	AAXJ	Stock	66.15	66.33	65.95	66.22	1049497.0
2019-06-06	AAXN-DELISTED	Stock	67.91	68.3663	67.16	67.95	240508.0
2019-06-06	AB	Stock	28.11	28.21	27.74	28.13	162400.0
2019-06-06	ABB-DELISTED	Stock	19.11	19.15	19.0	19.07	2291555.0
2019-06-06	ABBNY-DELISTED	Stock	19.11	19.15	19.0	19.08	2392200.0
2019-06-06	ABBV	Stock	77.16	77.72	76.86	77.07	4032800.0
2019-06-06	ABC-DELISTED	Stock	81.55	82.46	81.54	81.77	782774.0
2019-06-06	ABCB	Stock	37.0	37.01	36.33	36.9	167600.0
2019-06-06	ABDC-DELISTED	Stock	8.07	8.22	8.06	8.15	23727.0
2019-06-06	ABEO	Stock	131.25	133.75	125.5	132.25	14088.0
2019-06-06	ABEOW-DELISTED	Stock	1.3381	1.3381	1.3381	1.3381	500.0
2019-06-06	ABEV	Stock	4.52	4.59	4.51	4.54	16129400.0
2019-06-06	ABG	Stock	77.56	78.08	75.69	76.95	107100.0
2019-06-06	ABIL-DELISTED	Stock	1.22	1.22	1.16	1.19	52228.0
2019-06-06	ABM	Stock	39.0	41.34	38.05	39.78	1020200.0
2019-06-06	ABMD-DELISTED	Stock	268.48	271.61	265.77	269.2	450147.0
2019-06-06	ABR	Stock	12.53	12.57	12.3	12.43	942700.0
2019-06-06	ABR.A-DELISTED	Stock	26.0562	26.0562	26.0073	26.0073	400.0
2019-06-06	ABR.B-DELISTED	Stock	25.63	25.63	25.63	25.63	204.0
2019-06-06	ABR.C-DELISTED	Stock	25.9805	26.1401	25.9805	26.1169	1200.0

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

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