PREVIEW / stock_daily / 2019-05-02

all stock daily files

  file:    by_date/stock_daily/2019/2019-05-02.parquet
  size:    221 KB
  rows:    6,528
  symbols: 2,577

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-02	AAPL	Stock	52.46	53.1625	52.0325	52.2875	127985200.0
2019-05-02	MSFT	Stock	127.98	128.0	125.52	126.21	27350200.0
2019-05-02	NVDA	Stock	4.5215	4.6218	4.478	4.5798	394684000.0
2019-05-02	AMZN	Stock	95.6665	96.0775	94.0935	95.041	79258000.0
2019-05-02	GOOGL	Stock	58.63	58.969	57.9165	58.3255	45097800.0
2019-05-02	META	Stock	193.0	194.0	189.75	192.53	13209500.0
2019-05-02	TSLA	Stock	16.368	16.4753	15.848	16.2733	272389500.0
2019-05-02	TLT	Stock	123.68	123.81	123.04	123.31	6613062.0
2019-05-02	ES	Stock	72.16	72.5	71.39	71.52	2231900.0
2019-05-02	CL	Stock	71.31	71.93	71.23	71.82	2209900.0
2019-05-02	A	Stock	77.41	78.34	77.15	78.2	946800.0
2019-05-02	AA	Stock	25.88	26.38	25.719	25.93	2917100.0
2019-05-02	AABA-DELISTED	Stock	76.67	78.05	75.87	77.4	3772409.0
2019-05-02	AAC-DELISTED	Stock	1.63	1.69	1.6	1.62	37753.0
2019-05-02	AACG	Stock	1.74	1.8	1.67	1.69	124100.0
2019-05-02	AAIC-DELISTED	Stock	7.75	7.81	7.6	7.6	823454.0
2019-05-02	AAIC.C-DELISTED	Stock	23.53	23.5651	23.53	23.538	1780.0
2019-05-02	AAL	Stock	33.96	34.85	33.84	33.95	5320300.0
2019-05-02	AAM.A-DELISTED	Stock	25.29	25.4686	25.29	25.4686	30322.0
2019-05-02	AAM.B-DELISTED	Stock	25.27	25.501	25.27	25.5	101709.0
2019-05-02	AAMC-DELISTED	Stock	7.7941	8.0912	7.3529	7.9882	28550.0
2019-05-02	AAME	Stock	2.53	2.54	2.47	2.52	2500.0
2019-05-02	AAMI	Stock	14.05	14.45	13.86	13.99	746100.0
2019-05-02	AAOI	Stock	12.29	12.55	11.87	12.09	719900.0
2019-05-02	AAON	Stock	33.2467	33.6533	32.4267	33.0133	217800.0
2019-05-02	AAP	Stock	164.05	167.21	163.3	166.78	1154500.0
2019-05-02	AAT	Stock	46.24	46.59	45.78	46.12	163200.0
2019-05-02	AAU-DELISTED	Stock	0.517	0.517	0.49	0.4936	236735.0
2019-05-02	AAUAF-DELISTED	Stock	0.517	0.517	0.49	0.4936	252020.0
2019-05-02	AAWW-DELISTED	Stock	47.08	47.67	44.91	45.94	495386.0
2019-05-02	AAXJ	Stock	72.21	72.47	71.83	72.15	1207366.0
2019-05-02	AAXN-DELISTED	Stock	63.8	64.45	63.56	64.26	359839.0
2019-05-02	AB	Stock	29.69	29.71	29.32	29.5	254400.0
2019-05-02	ABB-DELISTED	Stock	20.44	20.44	20.25	20.28	1360725.0
2019-05-02	ABBNY-DELISTED	Stock	20.44	20.44	20.25	20.28	1421420.0
2019-05-02	ABBV	Stock	78.73	78.78	77.6	78.47	5206300.0
2019-05-02	ABC-DELISTED	Stock	75.52	78.77	75.301	77.08	2627261.0
2019-05-02	ABCB	Stock	36.23	36.77	36.07	36.75	239300.0
2019-05-02	ABDC-DELISTED	Stock	8.38	8.44	8.35	8.35	12186.0
2019-05-02	ABEO	Stock	192.25	197.5	190.25	193.25	8676.0
2019-05-02	ABEV	Stock	4.61	4.68	4.53	4.56	23684300.0
2019-05-02	ABG	Stock	79.06	79.64	78.45	79.07	89700.0
2019-05-02	ABIL-DELISTED	Stock	1.35	1.468	1.3059	1.37	54889.0
2019-05-02	ABM	Stock	36.55	37.47	36.52	37.42	226000.0
2019-05-02	ABMD-DELISTED	Stock	232.0	280.0	228.0	264.81	3755026.0
2019-05-02	ABR	Stock	13.61	13.72	13.58	13.67	1199500.0
2019-05-02	ABR.A-DELISTED	Stock	26.0891	26.3	26.0891	26.3	1478.0
2019-05-02	ABR.B-DELISTED	Stock	25.7	25.7	25.7	25.7	200.0
2019-05-02	ABR.C-DELISTED	Stock	26.59	26.84	26.2623	26.43	3929.0
2019-05-02	ABT	Stock	78.42	78.87	77.91	78.78	5112200.0

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

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