PREVIEW / stock_daily / 2019-07-31

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-31.parquet
  size:    222 KB
  rows:    6,642
  symbols: 2,567

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-07-31	AAPL	Stock	54.105	55.3425	52.825	53.26	277125600.0
2019-07-31	MSFT	Stock	140.33	140.49	135.08	136.27	38598800.0
2019-07-31	NVDA	Stock	4.3545	4.3555	4.1755	4.218	359416000.0
2019-07-31	AMZN	Stock	94.9055	94.9775	92.472	93.339	89414000.0
2019-07-31	GOOGL	Stock	61.2435	61.7455	60.409	60.91	39959980.0
2019-07-31	META	Stock	196.95	198.76	192.68	194.23	14593500.0
2019-07-31	TSLA	Stock	16.2	16.4453	15.7767	16.1073	137673000.0
2019-07-31	TLT	Stock	131.7	133.33	131.66	132.89	15798745.0
2019-07-31	ES	Stock	76.36	76.83	75.43	75.86	1988100.0
2019-07-31	CL	Stock	74.59	74.93	71.35	71.74	5187400.0
2019-07-31	A	Stock	70.19	70.66	68.92	69.41	3846100.0
2019-07-31	AA	Stock	23.05	23.24	22.42	22.49	2763800.0
2019-07-31	AABA-DELISTED	Stock	70.84	70.84	70.2	70.43	2309338.0
2019-07-31	AAC-DELISTED	Stock	0.9961	1.02	0.9701	0.9941	84785.0
2019-07-31	AACG	Stock	2.61	2.63	2.6	2.63	26100.0
2019-07-31	AAIC-DELISTED	Stock	6.72	6.74	6.51	6.58	460362.0
2019-07-31	AAIC.C-DELISTED	Stock	23.34	23.34	22.81	23.24	6014.0
2019-07-31	AAL	Stock	30.68	31.14	30.27	30.51	6269400.0
2019-07-31	AAM.A-DELISTED	Stock	26.3	26.3	26.12	26.12	69057.0
2019-07-31	AAM.B-DELISTED	Stock	26.785	26.85	26.63	26.85	36282.0
2019-07-31	AAMC-DELISTED	Stock	2.9382	3.0715	2.7824	2.7824	12580.0
2019-07-31	AAME	Stock	2.48	2.48	2.35	2.35	2400.0
2019-07-31	AAMI	Stock	10.92	11.0	10.67	10.7	359900.0
2019-07-31	AAOI	Stock	9.54	10.31	9.54	10.01	870700.0
2019-07-31	AAON	Stock	34.52	35.1267	33.5	33.8667	454500.0
2019-07-31	AAP	Stock	151.65	152.48	149.71	150.64	1057100.0
2019-07-31	AAT	Stock	46.71	46.71	45.8	46.4	723200.0
2019-07-31	AAU-DELISTED	Stock	0.75	0.7717	0.72	0.72	168778.0
2019-07-31	AAUAF-DELISTED	Stock	0.75	0.7717	0.72	0.7267	193184.0
2019-07-31	AAWW-DELISTED	Stock	46.39	46.84	45.22	45.54	305705.0
2019-07-31	AAXJ	Stock	68.54	68.545	67.17	67.86	2210624.0
2019-07-31	AAXN-DELISTED	Stock	69.81	71.69	69.52	70.22	464205.0
2019-07-31	AB	Stock	29.89	30.46	29.65	30.17	280700.0
2019-07-31	ABB-DELISTED	Stock	19.05	19.06	18.62	18.8	2211668.0
2019-07-31	ABBNY-DELISTED	Stock	19.05	19.06	18.62	18.8	2453505.0
2019-07-31	ABBV	Stock	66.91	67.38	65.63	66.62	11300000.0
2019-07-31	ABC-DELISTED	Stock	88.72	88.73	85.53	87.155	1163354.0
2019-07-31	ABCB	Stock	40.0	40.43	39.64	39.77	644600.0
2019-07-31	ABDC-DELISTED	Stock	8.37	8.37	8.25	8.27	24836.0
2019-07-31	ABEO	Stock	74.25	74.5	61.0	64.75	85016.0
2019-07-31	ABEOW-DELISTED	Stock	0.3	0.31	0.2	0.2	3406.0
2019-07-31	ABEV	Stock	5.32	5.36	5.17	5.27	32962700.0
2019-07-31	ABG	Stock	93.0	93.99	91.55	92.08	171500.0
2019-07-31	ABIL-DELISTED	Stock	0.75	0.8001	0.6109	0.78	64966.0
2019-07-31	ABM	Stock	42.33	42.58	41.42	42.09	1595600.0
2019-07-31	ABMD-DELISTED	Stock	280.37	285.77	276.05	278.28	423635.0
2019-07-31	ABR	Stock	12.27	12.36	12.18	12.19	884800.0
2019-07-31	ABR.A-DELISTED	Stock	26.337	26.35	26.2698	26.35	1206.0
2019-07-31	ABR.B-DELISTED	Stock	25.8102	25.8102	25.8102	25.8102	100.0
2019-07-31	ABR.C-DELISTED	Stock	26.5035	26.6525	26.4211	26.4211	1200.0

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

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