PREVIEW / stock_daily / 2019-08-16

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-16.parquet
  size:    219 KB
  rows:    6,554
  symbols: 2,523

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-08-16	AAPL	Stock	51.07	51.79	50.96	51.625	110481600.0
2019-08-16	MSFT	Stock	134.88	136.46	134.72	136.13	24449100.0
2019-08-16	NVDA	Stock	3.9838	4.0385	3.922	3.989	1007960000.0
2019-08-16	AMZN	Stock	89.6445	90.1455	89.2275	89.6285	60360000.0
2019-08-16	GOOGL	Stock	59.0395	59.192	58.65	58.9605	25303740.0
2019-08-16	META	Stock	183.75	185.1	182.36	183.7	12654600.0
2019-08-16	TSLA	Stock	14.444	14.816	14.4013	14.6627	76477500.0
2019-08-16	TLT	Stock	146.06	146.51	144.84	146.13	17649776.0
2019-08-16	ES	Stock	78.86	79.08	78.35	78.64	1421800.0
2019-08-16	CL	Stock	71.69	72.5	71.62	72.28	2549000.0
2019-08-16	A	Stock	69.9	71.18	68.96	71.08	3367100.0
2019-08-16	AA	Stock	17.04	17.63	17.04	17.52	4273200.0
2019-08-16	AABA-DELISTED	Stock	69.99	70.035	69.815	69.84	6967938.0
2019-08-16	AAC-DELISTED	Stock	0.65	0.6634	0.55	0.6085	380741.0
2019-08-16	AACG	Stock	2.12	2.12	2.06	2.08	74100.0
2019-08-16	AAIC-DELISTED	Stock	5.6	5.67	5.59	5.6	285753.0
2019-08-16	AAIC.C-DELISTED	Stock	22.535	22.55	22.3591	22.42	2387.0
2019-08-16	AAL	Stock	25.62	26.05	25.39	25.79	8826800.0
2019-08-16	AAM.A-DELISTED	Stock	26.55	26.61	26.5	26.5	11281.0
2019-08-16	AAM.B-DELISTED	Stock	26.6	26.7	26.54	26.5944	26388.0
2019-08-16	AAMC-DELISTED	Stock	2.6941	2.6941	2.6794	2.6794	1822.0
2019-08-16	AAMI	Stock	8.45	8.69	8.45	8.59	550100.0
2019-08-16	AAOI	Stock	8.99	9.42	8.974	9.24	480300.0
2019-08-16	AAON	Stock	30.4867	31.4267	30.4867	31.38	156000.0
2019-08-16	AAP	Stock	137.73	139.69	136.43	136.59	1277800.0
2019-08-16	AAT	Stock	46.57	47.15	46.45	47.06	158500.0
2019-08-16	AAU-DELISTED	Stock	0.81	0.819	0.74	0.7401	219068.0
2019-08-16	AAUAF-DELISTED	Stock	0.81	0.819	0.74	0.7401	227510.0
2019-08-16	AAWW-DELISTED	Stock	26.69	27.05	26.41	26.95	161946.0
2019-08-16	AAXJ	Stock	64.18	64.63	64.17	64.5	1264127.0
2019-08-16	AAXN-DELISTED	Stock	57.79	59.39	56.92	59.23	568800.0
2019-08-16	AB	Stock	26.5	27.21	26.39	27.03	158900.0
2019-08-16	ABB-DELISTED	Stock	18.36	18.52	18.36	18.47	1376037.0
2019-08-16	ABBNY-DELISTED	Stock	18.36	18.52	18.36	18.47	1564598.0
2019-08-16	ABBV	Stock	63.51	64.81	63.07	64.43	8348100.0
2019-08-16	ABC-DELISTED	Stock	86.15	87.9	86.0	87.33	593897.0
2019-08-16	ABCB	Stock	35.47	36.5	35.42	36.43	447900.0
2019-08-16	ABDC-DELISTED	Stock	8.9036	8.98	8.81	8.84	229365.0
2019-08-16	ABEO	Stock	54.5	58.0	54.5	55.0	18056.0
2019-08-16	ABEV	Stock	4.68	4.74	4.66	4.7	21250600.0
2019-08-16	ABG	Stock	89.06	91.1	89.06	90.07	100600.0
2019-08-16	ABIL-DELISTED	Stock	0.54	0.62	0.5314	0.615	18971.0
2019-08-16	ABM	Stock	38.18	38.85	38.17	38.53	212000.0
2019-08-16	ABMD-DELISTED	Stock	192.64	194.4737	191.84	193.05	355153.0
2019-08-16	ABR	Stock	12.11	12.22	12.11	12.21	927000.0
2019-08-16	ABR.A-DELISTED	Stock	26.0	26.015	25.98	25.995	1500.0
2019-08-16	ABR.B-DELISTED	Stock	25.679	25.74	25.668	25.7	990.0
2019-08-16	ABR.C-DELISTED	Stock	25.93	26.33	25.93	26.33	1862.0
2019-08-16	ABT	Stock	84.74	85.08	84.27	84.78	5786300.0
2019-08-16	ABTC	Stock	270300.0	280860.0	258060.0	258300.0	2.32

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

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