PREVIEW / stock_daily / 2019-11-13

all stock daily files

  file:    by_date/stock_daily/2019/2019-11-13.parquet
  size:    222 KB
  rows:    6,612
  symbols: 2,477

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-11-13	AAPL	Stock	65.2825	66.195	65.2675	66.1175	102734400.0
2019-11-13	MSFT	Stock	146.74	147.46	146.28	147.31	16919200.0
2019-11-13	NVDA	Stock	5.2088	5.2365	5.1475	5.2142	300188000.0
2019-11-13	AMZN	Stock	88.6695	88.75	87.366	87.6555	59790000.0
2019-11-13	GOOGL	Stock	64.659	65.126	64.6074	64.809	18721700.0
2019-11-13	META	Stock	194.7	195.7	192.74	193.19	10860700.0
2019-11-13	TSLA	Stock	23.6667	23.7553	23.012	23.074	126301500.0
2019-11-13	TLT	Stock	136.81	136.96	136.165	136.5	6751842.0
2019-11-13	ES	Stock	79.53	80.93	79.29	80.91	1809800.0
2019-11-13	CL	Stock	67.0	67.08	66.52	66.88	3454600.0
2019-11-13	A	Stock	76.82	77.5	76.56	77.16	1096000.0
2019-11-13	AA	Stock	21.53	21.82	20.98	21.22	4458400.0
2019-11-13	AACG	Stock	1.71	1.71	1.71	1.71	400.0
2019-11-13	AAIC-DELISTED	Stock	5.79	5.83	5.68	5.8	572225.0
2019-11-13	AAIC.C-DELISTED	Stock	21.71	21.96	21.71	21.9501	4521.0
2019-11-13	AAL	Stock	29.03	29.16	28.57	28.66	7152300.0
2019-11-13	AAM.A-DELISTED	Stock	26.5	26.5807	26.47	26.47	16074.0
2019-11-13	AAM.B-DELISTED	Stock	26.93	27.0	26.84	26.85	35510.0
2019-11-13	AAMC-DELISTED	Stock	3.2982	3.2982	3.2679	3.2948	2910.0
2019-11-13	AAME	Stock	1.76	1.8	1.5	1.5	4700.0
2019-11-13	AAMI	Stock	9.83	9.875	9.45	9.47	415100.0
2019-11-13	AAOI	Stock	11.53	11.655	11.26	11.34	705400.0
2019-11-13	AAON	Stock	33.3133	33.9533	33.2333	33.7533	162000.0
2019-11-13	AAP	Stock	155.31	158.88	153.76	158.58	1370900.0
2019-11-13	AAT	Stock	46.3	46.94	46.28	46.7	244200.0
2019-11-13	AAU-DELISTED	Stock	0.48	0.4991	0.45	0.4983	511051.0
2019-11-13	AAUAF-DELISTED	Stock	0.48	0.4991	0.45	0.4983	611136.0
2019-11-13	AAWW-DELISTED	Stock	25.89	26.15	25.24	25.3	261779.0
2019-11-13	AAXJ	Stock	69.67	69.92	69.59	69.8	652576.0
2019-11-13	AAXN-DELISTED	Stock	63.53	64.98	63.2572	64.66	423495.0
2019-11-13	AB	Stock	29.6	29.93	29.4	29.82	341100.0
2019-11-13	ABB-DELISTED	Stock	21.83	21.97	21.78	21.93	1280187.0
2019-11-13	ABBNY-DELISTED	Stock	21.83	21.97	21.78	21.93	1340356.0
2019-11-13	ABBV	Stock	85.74	87.27	85.33	86.66	5798800.0
2019-11-13	ABC-DELISTED	Stock	85.14	86.73	84.725	86.1	545756.0
2019-11-13	ABCB	Stock	43.98	44.06	43.5	43.74	210400.0
2019-11-13	ABDC-DELISTED	Stock	8.89	9.02	8.89	9.01	25334.0
2019-11-13	ABEO	Stock	57.5	61.75	55.25	58.25	13708.0
2019-11-13	ABEOW-DELISTED	Stock	0.1113	0.1113	0.1113	0.1113	1000.0
2019-11-13	ABEV	Stock	4.11	4.16	4.1	4.15	14126500.0
2019-11-13	ABG	Stock	108.51	109.24	107.61	108.56	132500.0
2019-11-13	ABIL-DELISTED	Stock	0.4011	0.41	0.37	0.3779	120552.0
2019-11-13	ABM	Stock	37.94	38.15	37.71	37.99	200200.0
2019-11-13	ABMD-DELISTED	Stock	221.98	223.73	218.91	220.0	270448.0
2019-11-13	ABR	Stock	14.9	15.15	14.9	15.12	1398300.0
2019-11-13	ABR.A-DELISTED	Stock	26.2875	26.35	26.2875	26.304	2140.0
2019-11-13	ABR.B-DELISTED	Stock	26.32	26.33	25.3	25.78	23227.0
2019-11-13	ABR.C-DELISTED	Stock	26.51	26.61	26.4223	26.61	3738.0
2019-11-13	ABT	Stock	83.96	84.42	83.27	84.22	3976900.0
2019-11-13	ABTC	Stock	119700.0	123600.0	108000.0	108000.0	2.2133333333333334

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

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