PREVIEW / stock_daily / 2019-05-06

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-06.parquet
  size:    220 KB
  rows:    6,550
  symbols: 2,584

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-05-06	AAPL	Stock	51.0725	52.21	50.875	52.12	129772400.0
2019-05-06	MSFT	Stock	126.39	128.56	126.11	128.15	24239800.0
2019-05-06	NVDA	Stock	4.3875	4.5085	4.35	4.4962	422176000.0
2019-05-06	AMZN	Stock	95.899	97.95	95.525	97.5275	108356000.0
2019-05-06	GOOGL	Stock	58.6	59.7715	58.5578	59.673	31773680.0
2019-05-06	META	Stock	191.24	194.28	190.55	193.88	13994900.0
2019-05-06	TSLA	Stock	16.668	17.2233	16.5667	17.0227	162508500.0
2019-05-06	TLT	Stock	124.31	124.38	123.925	124.0	4482690.0
2019-05-06	ES	Stock	72.1	72.37	71.64	71.87	1008900.0
2019-05-06	CL	Stock	71.53	71.78	71.2	71.69	2383300.0
2019-05-06	A	Stock	77.62	79.41	77.21	79.35	1624300.0
2019-05-06	AA	Stock	25.95	26.0	25.28	25.91	4081500.0
2019-05-06	AABA-DELISTED	Stock	75.15	76.49	75.13	76.16	4770130.0
2019-05-06	AAC-DELISTED	Stock	1.9	1.99	1.76	1.97	131796.0
2019-05-06	AACG	Stock	1.71	1.89	1.61	1.84	338400.0
2019-05-06	AAIC-DELISTED	Stock	7.63	7.79	7.63	7.72	411252.0
2019-05-06	AAIC.C-DELISTED	Stock	23.36	23.5131	23.36	23.5131	1504.0
2019-05-06	AAL	Stock	34.25	34.77	33.72	34.75	4156800.0
2019-05-06	AAM.A-DELISTED	Stock	25.61	25.6134	25.56	25.5858	50257.0
2019-05-06	AAM.B-DELISTED	Stock	25.55	25.62	25.4	25.55	129478.0
2019-05-06	AAMC-DELISTED	Stock	7.6471	8.1735	7.6471	7.794	4855.0
2019-05-06	AAME	Stock	2.51	2.54	2.42	2.47	6300.0
2019-05-06	AAMI	Stock	13.82	13.99	13.66	13.88	474700.0
2019-05-06	AAOI	Stock	12.25	12.75	12.19	12.69	493300.0
2019-05-06	AAON	Stock	33.1467	33.46	32.3333	32.9	527850.0
2019-05-06	AAP	Stock	161.06	163.56	159.83	161.99	1218600.0
2019-05-06	AAT	Stock	46.12	46.39	45.87	46.18	198500.0
2019-05-06	AAU-DELISTED	Stock	0.508	0.5145	0.493	0.4982	75309.0
2019-05-06	AAUAF-DELISTED	Stock	0.508	0.5145	0.493	0.493	80645.0
2019-05-06	AAWW-DELISTED	Stock	45.52	45.98	44.82	44.95	236228.0
2019-05-06	AAXJ	Stock	70.62	71.49	70.555	71.32	895736.0
2019-05-06	AAXN-DELISTED	Stock	63.79	66.0998	63.3765	65.8295	415096.0
2019-05-06	AB	Stock	28.93	29.35	28.51	29.28	274400.0
2019-05-06	ABB-DELISTED	Stock	19.39	19.59	19.36	19.59	1313221.0
2019-05-06	ABBNY-DELISTED	Stock	19.39	19.59	19.36	19.59	1432051.0
2019-05-06	ABBV	Stock	77.75	79.52	77.34	79.26	5413200.0
2019-05-06	ABC-DELISTED	Stock	78.13	78.56	75.62	78.285	902758.0
2019-05-06	ABCB	Stock	36.92	37.55	36.6	37.39	250300.0
2019-05-06	ABDC-DELISTED	Stock	8.29	8.4	8.27	8.32	23910.0
2019-05-06	ABEO	Stock	189.5	201.25	189.5	200.5	17544.0
2019-05-06	ABEV	Stock	4.51	4.6	4.49	4.55	16352800.0
2019-05-06	ABG	Stock	79.53	81.17	79.53	80.58	115900.0
2019-05-06	ABIL-DELISTED	Stock	1.39	1.53	1.31	1.4	267856.0
2019-05-06	ABM	Stock	37.65	38.58	37.65	38.41	201400.0
2019-05-06	ABMD-DELISTED	Stock	265.82	273.14	263.59	268.93	553088.0
2019-05-06	ABR	Stock	13.68	13.84	13.52	13.57	1569600.0
2019-05-06	ABR.A-DELISTED	Stock	26.2084	26.3667	26.11	26.3667	5635.0
2019-05-06	ABR.B-DELISTED	Stock	25.73	25.78	25.73	25.78	2700.0
2019-05-06	ABR.C-DELISTED	Stock	26.3761	26.8	26.37	26.8	2750.0
2019-05-06	ABT	Stock	77.42	79.17	77.35	79.07	4006700.0

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

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