PREVIEW / stock_daily / 2019-01-22

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-22.parquet
  size:    219 KB
  rows:    6,543
  symbols: 2,650

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-01-22	AAPL	Stock	39.1025	39.1825	38.155	38.325	121576000.0
2019-01-22	MSFT	Stock	106.75	107.1	104.86	105.68	32371300.0
2019-01-22	NVDA	Stock	3.8928	3.9045	3.6888	3.7193	661552000.0
2019-01-22	AMZN	Stock	84.05	84.0935	80.51	81.6085	128336000.0
2019-01-22	GOOGL	Stock	54.8	54.9485	53.5445	53.9315	39631880.0
2019-01-22	META	Stock	149.2	151.53	146.37	147.57	22378700.0
2019-01-22	TSLA	Stock	20.3213	20.5333	19.7	19.928	181000500.0
2019-01-22	TLT	Stock	120.31	120.72	120.07	120.37	8881123.0
2019-01-22	ES	Stock	67.8	68.3	66.82	67.49	1780900.0
2019-01-22	CL	Stock	62.13	62.45	61.05	61.74	5542200.0
2019-01-22	A	Stock	71.44	71.48	70.47	71.32	1972700.0
2019-01-22	AA	Stock	29.0	29.0	27.53	27.81	5026800.0
2019-01-22	AABA-DELISTED	Stock	64.16	64.46	62.28	63.0	5445479.0
2019-01-22	AAC-DELISTED	Stock	2.77	2.79	2.45	2.45	280593.0
2019-01-22	AACG	Stock	1.02	1.02	0.96	0.96	12200.0
2019-01-22	AAIC-DELISTED	Stock	8.13	8.145	8.0	8.07	350463.0
2019-01-22	AAL	Stock	33.76	33.88	32.45	32.74	14598200.0
2019-01-22	AAM.A-DELISTED	Stock	24.56	24.5699	24.34	24.43	15172.0
2019-01-22	AAM.B-DELISTED	Stock	24.47	24.47	24.21	24.3	17145.0
2019-01-22	AAMC-DELISTED	Stock	7.5588	7.7088	6.6471	7.5971	92014.0
2019-01-22	AAME	Stock	2.6	2.6	2.51	2.51	1600.0
2019-01-22	AAMI	Stock	11.78	12.08	11.78	12.04	844500.0
2019-01-22	AAOI	Stock	16.12	16.66	16.05	16.27	680400.0
2019-01-22	AAON	Stock	24.8533	25.1667	24.7733	25.12	153600.0
2019-01-22	AAP	Stock	166.67	168.42	162.26	164.13	1384200.0
2019-01-22	AAT	Stock	40.66	41.0	40.21	40.47	149400.0
2019-01-22	AAU-DELISTED	Stock	0.73	0.75	0.7125	0.72	305532.0
2019-01-22	AAUAF-DELISTED	Stock	0.73	0.75	0.7125	0.72	368951.0
2019-01-22	AAWW-DELISTED	Stock	50.15	50.59	49.37	50.22	248549.0
2019-01-22	AAXJ	Stock	65.97	66.06	65.305	65.67	3533649.0
2019-01-22	AAXN-DELISTED	Stock	49.86	49.895	48.05	48.7	377178.0
2019-01-22	AB	Stock	29.5	30.08	29.4	29.5	454600.0
2019-01-22	ABB-DELISTED	Stock	19.15	19.25	19.07	19.18	2720574.0
2019-01-22	ABBNY-DELISTED	Stock	19.15	19.25	19.07	19.17	2792436.0
2019-01-22	ABBV	Stock	88.86	89.36	87.9	88.66	5664600.0
2019-01-22	ABC-DELISTED	Stock	79.25	79.91	78.22	79.73	1125957.0
2019-01-22	ABCB	Stock	36.02	36.17	35.23	35.54	550800.0
2019-01-22	ABDC-DELISTED	Stock	6.68	6.78	6.66	6.66	15476.0
2019-01-22	ABEO	Stock	179.75	182.0	171.75	172.25	9060.0
2019-01-22	ABEV	Stock	4.72	4.75	4.54	4.57	27176300.0
2019-01-22	ABG	Stock	72.16	72.58	69.99	70.52	150600.0
2019-01-22	ABIL-DELISTED	Stock	2.1	2.47	2.1	2.3259	2605861.0
2019-01-22	ABM	Stock	35.8	36.26	35.09	35.23	490400.0
2019-01-22	ABMD-DELISTED	Stock	333.55	339.67	330.8505	336.35	544477.0
2019-01-22	ABR	Stock	11.34	11.34	11.05	11.11	1031700.0
2019-01-22	ABR.A-DELISTED	Stock	25.6516	25.6516	25.6333	25.6333	1200.0
2019-01-22	ABR.B-DELISTED	Stock	25.26	25.34	25.26	25.34	840.0
2019-01-22	ABR.C-DELISTED	Stock	25.89	25.89	25.7517	25.7517	300.0
2019-01-22	ABT	Stock	70.97	71.67	70.69	71.49	6541600.0
2019-01-22	ABTC	Stock	304800.0	304800.0	301800.0	301800.0	0.6666666666666666

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

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