PREVIEW / stock_daily / 2019-05-08

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-08.parquet
  size:    220 KB
  rows:    6,512
  symbols: 2,556

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-08	AAPL	Stock	50.475	51.335	50.4375	50.725	105358000.0
2019-05-08	MSFT	Stock	125.44	126.37	124.75	125.51	28419000.0
2019-05-08	NVDA	Stock	4.3	4.4288	4.288	4.348	419168000.0
2019-05-08	AMZN	Stock	95.9435	96.7685	95.5	95.8885	81572000.0
2019-05-08	GOOGL	Stock	58.8645	59.2135	58.3815	58.539	25520440.0
2019-05-08	META	Stock	189.39	190.72	188.55	189.54	12505700.0
2019-05-08	TSLA	Stock	16.4627	16.7067	16.28	16.3227	92646000.0
2019-05-08	TLT	Stock	125.15	125.2999	124.3	124.41	6907690.0
2019-05-08	ES	Stock	71.4	71.47	70.35	70.4	1284900.0
2019-05-08	CL	Stock	70.62	71.5	70.05	70.99	3273900.0
2019-05-08	A	Stock	76.78	77.3	76.13	76.61	2243600.0
2019-05-08	AA	Stock	25.03	25.43	24.67	24.69	3304000.0
2019-05-08	AABA-DELISTED	Stock	72.99	73.87	72.25	72.64	3504269.0
2019-05-08	AAC-DELISTED	Stock	2.0	2.0	1.8	1.85	78405.0
2019-05-08	AACG	Stock	2.42	2.67	2.15	2.19	3243800.0
2019-05-08	AAIC-DELISTED	Stock	7.61	7.68	7.6	7.62	251359.0
2019-05-08	AAIC.C-DELISTED	Stock	23.5	23.5	23.5	23.5	397.0
2019-05-08	AAL	Stock	33.7	34.38	33.56	33.75	4374100.0
2019-05-08	AAM.A-DELISTED	Stock	25.5527	25.59	25.53	25.58	5328.0
2019-05-08	AAM.B-DELISTED	Stock	25.56	25.58	25.52	25.5631	24374.0
2019-05-08	AAMC-DELISTED	Stock	7.3912	7.3912	7.15	7.15	2723.0
2019-05-08	AAME	Stock	2.46	2.46	2.35	2.35	1300.0
2019-05-08	AAMI	Stock	13.82	13.89	13.69	13.8	321900.0
2019-05-08	AAOI	Stock	12.07	12.34	11.9	12.06	1155900.0
2019-05-08	AAON	Stock	31.6733	32.1067	31.4333	31.5667	252750.0
2019-05-08	AAP	Stock	160.12	160.45	157.73	158.62	586200.0
2019-05-08	AAT	Stock	45.12	45.64	44.86	45.31	257300.0
2019-05-08	AAU-DELISTED	Stock	0.505	0.5145	0.48	0.486	158737.0
2019-05-08	AAUAF-DELISTED	Stock	0.505	0.5145	0.48	0.486	164756.0
2019-05-08	AAWW-DELISTED	Stock	43.41	43.965	43.12	43.19	149462.0
2019-05-08	AAXJ	Stock	69.87	70.145	69.565	69.58	4128616.0
2019-05-08	AAXN-DELISTED	Stock	64.96	67.87	64.75	67.01	667425.0
2019-05-08	AB	Stock	28.36	28.98	28.09	28.8	233200.0
2019-05-08	ABB-DELISTED	Stock	19.18	19.21	19.025	19.04	1795434.0
2019-05-08	ABBNY-DELISTED	Stock	19.18	19.21	19.025	19.03	2150959.0
2019-05-08	ABBV	Stock	77.95	78.89	77.32	77.99	3820700.0
2019-05-08	ABC-DELISTED	Stock	77.84	79.56	76.505	78.73	1501044.0
2019-05-08	ABCB	Stock	36.53	36.9	36.22	36.25	227300.0
2019-05-08	ABDC-DELISTED	Stock	8.31	8.41	8.25	8.35	30117.0
2019-05-08	ABEO	Stock	196.0	199.0	194.0	196.75	14280.0
2019-05-08	ABEV	Stock	4.5	4.58	4.49	4.56	49348300.0
2019-05-08	ABG	Stock	79.76	80.63	79.35	79.84	84200.0
2019-05-08	ABIL-DELISTED	Stock	1.4038	1.49	1.38	1.45	230054.0
2019-05-08	ABM	Stock	38.06	38.34	37.81	37.93	211600.0
2019-05-08	ABMD-DELISTED	Stock	260.25	263.04	257.025	260.32	374226.0
2019-05-08	ABR	Stock	13.3	13.33	12.93	12.97	2391900.0
2019-05-08	ABR.A-DELISTED	Stock	26.3253	26.3795	26.19	26.19	6331.0
2019-05-08	ABR.B-DELISTED	Stock	25.9	25.9	25.6977	25.85	1429.0
2019-05-08	ABR.C-DELISTED	Stock	26.3685	26.48	26.3485	26.3848	1600.0
2019-05-08	ABT	Stock	76.93	76.97	76.14	76.22	4362800.0

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

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