PREVIEW / stock_daily / 2019-08-01

all stock daily files

  file:    by_date/stock_daily/2019/2019-08-01.parquet
  size:    222 KB
  rows:    6,613
  symbols: 2,535

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-01	AAPL	Stock	53.475	54.5075	51.685	52.1075	216071600.0
2019-08-01	MSFT	Stock	137.0	140.94	136.93	138.06	40557500.0
2019-08-01	NVDA	Stock	4.2285	4.3195	4.0705	4.123	421212000.0
2019-08-01	AMZN	Stock	93.586	94.896	92.2005	92.766	94266000.0
2019-08-01	GOOGL	Stock	60.8815	61.8149	60.35	60.589	35425420.0
2019-08-01	META	Stock	194.17	198.47	190.88	192.73	17777000.0
2019-08-01	TSLA	Stock	16.1767	16.3007	15.4513	15.59	123892500.0
2019-08-01	TLT	Stock	133.39	135.39	133.26	135.26	26665016.0
2019-08-01	ES	Stock	75.74	77.06	75.61	76.54	2484000.0
2019-08-01	CL	Stock	71.63	72.47	71.21	71.26	4618400.0
2019-08-01	A	Stock	69.63	70.68	68.39	69.21	2494100.0
2019-08-01	AA	Stock	22.27	22.45	21.0	21.33	4783900.0
2019-08-01	AABA-DELISTED	Stock	70.8	70.99	69.84	69.985	4125072.0
2019-08-01	AAC-DELISTED	Stock	0.983	1.03	0.86	0.8748	178346.0
2019-08-01	AACG	Stock	2.64	2.64	2.6	2.61	25100.0
2019-08-01	AAIC-DELISTED	Stock	6.54	6.58	6.38	6.41	454849.0
2019-08-01	AAIC.C-DELISTED	Stock	23.4	23.4	23.364	23.38	1016.0
2019-08-01	AAL	Stock	30.43	30.57	29.43	29.84	8013000.0
2019-08-01	AAM.A-DELISTED	Stock	26.17	26.34	26.17	26.25	20885.0
2019-08-01	AAM.B-DELISTED	Stock	26.7	26.9777	26.7	26.84	17958.0
2019-08-01	AAMC-DELISTED	Stock	2.9529	2.9529	2.2353	2.35	47104.0
2019-08-01	AAME	Stock	2.35	2.35	2.35	2.35	900.0
2019-08-01	AAMI	Stock	10.64	10.81	9.94	9.99	939500.0
2019-08-01	AAOI	Stock	10.02	10.29	9.73	9.93	743200.0
2019-08-01	AAON	Stock	32.74	35.5133	31.9667	34.5733	366900.0
2019-08-01	AAP	Stock	150.52	153.52	149.72	149.95	1460300.0
2019-08-01	AAT	Stock	46.37	47.35	46.09	46.76	365700.0
2019-08-01	AAU-DELISTED	Stock	0.75	0.752	0.7195	0.7365	138986.0
2019-08-01	AAUAF-DELISTED	Stock	0.75	0.752	0.7195	0.7365	154845.0
2019-08-01	AAWW-DELISTED	Stock	40.69	40.7	33.725	34.4	2162610.0
2019-08-01	AAXJ	Stock	67.84	68.375	66.21	66.46	2456928.0
2019-08-01	AAXN-DELISTED	Stock	70.12	70.96	68.38	68.42	417142.0
2019-08-01	AB	Stock	30.2	30.24	29.37	29.41	544900.0
2019-08-01	ABB-DELISTED	Stock	18.66	18.85	18.42	18.47	1570454.0
2019-08-01	ABBNY-DELISTED	Stock	18.66	18.85	18.42	18.48	1660350.0
2019-08-01	ABBV	Stock	66.93	67.2	65.11	65.8	13106700.0
2019-08-01	ABC-DELISTED	Stock	90.88	94.75	90.575	91.7	2662295.0
2019-08-01	ABCB	Stock	38.45	40.19	38.28	38.58	728700.0
2019-08-01	ABDC-DELISTED	Stock	8.32	8.359	8.25	8.34	8476.0
2019-08-01	ABEO	Stock	64.75	70.0	62.25	63.0	50576.0
2019-08-01	ABEOW-DELISTED	Stock	0.2	0.4988	0.1994	0.33	10429.0
2019-08-01	ABEV	Stock	5.28	5.4	5.25	5.29	34618000.0
2019-08-01	ABG	Stock	92.86	93.99	89.13	91.48	200300.0
2019-08-01	ABIL-DELISTED	Stock	0.82	0.8254	0.77	0.77	28824.0
2019-08-01	ABM	Stock	42.1	42.67	40.93	41.09	384200.0
2019-08-01	ABMD-DELISTED	Stock	222.7	224.99	197.81	204.89	3301213.0
2019-08-01	ABR	Stock	12.18	12.4	12.18	12.25	861500.0
2019-08-01	ABR.A-DELISTED	Stock	26.39	26.4	26.329	26.33	2408.0
2019-08-01	ABR.C-DELISTED	Stock	26.4296	26.65	26.38	26.38	1800.0
2019-08-01	ABT	Stock	87.18	88.06	85.64	86.08	7022000.0

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

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