PREVIEW / stock_daily / 2019-07-25

all stock daily files

  file:    by_date/stock_daily/2019/2019-07-25.parquet
  size:    220 KB
  rows:    6,550
  symbols: 2,512

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-25	AAPL	Stock	52.2225	52.31	51.6825	51.755	55638400.0
2019-07-25	MSFT	Stock	140.43	140.61	139.32	140.19	18356900.0
2019-07-25	NVDA	Stock	4.4248	4.4375	4.311	4.3345	392700000.0
2019-07-25	AMZN	Stock	100.05	100.06	98.636	98.691	82730000.0
2019-07-25	GOOGL	Stock	56.9475	57.1796	56.1855	56.797	54762780.0
2019-07-25	META	Stock	206.7	208.66	198.26	200.71	39889900.0
2019-07-25	TSLA	Stock	15.5667	15.6333	15.0367	15.2547	336274500.0
2019-07-25	TLT	Stock	131.25	131.41	130.51	131.16	8893057.0
2019-07-25	ES	Stock	76.42	76.69	75.63	76.2	1644000.0
2019-07-25	CL	Stock	71.13	72.22	71.13	71.93	4383400.0
2019-07-25	A	Stock	69.75	70.01	69.55	69.85	1904700.0
2019-07-25	AA	Stock	23.48	23.63	22.6	22.85	3893100.0
2019-07-25	AABA-DELISTED	Stock	71.0	71.26	70.71	70.89	1724731.0
2019-07-25	AAC-DELISTED	Stock	1.06	1.06	0.9515	1.02	78642.0
2019-07-25	AACG	Stock	2.67	2.67	2.6	2.62	38300.0
2019-07-25	AAIC-DELISTED	Stock	6.68	6.72	6.53	6.57	345903.0
2019-07-25	AAIC.C-DELISTED	Stock	23.1	23.1	23.1	23.1	2344.0
2019-07-25	AAL	Stock	34.55	34.82	31.58	31.67	13152300.0
2019-07-25	AAM.A-DELISTED	Stock	26.5	26.5326	26.4	26.4	33739.0
2019-07-25	AAM.B-DELISTED	Stock	26.74	26.93	26.55	26.811	30916.0
2019-07-25	AAMC-DELISTED	Stock	3.2353	3.3588	3.2353	3.3588	2601.0
2019-07-25	AAMI	Stock	11.19	11.22	10.94	10.99	277800.0
2019-07-25	AAOI	Stock	9.51	9.52	9.16	9.18	445500.0
2019-07-25	AAON	Stock	34.92	35.0933	33.7533	33.7933	141450.0
2019-07-25	AAP	Stock	156.9	158.21	149.94	150.03	1703200.0
2019-07-25	AAT	Stock	47.4	47.4	46.64	46.64	230100.0
2019-07-25	AAU-DELISTED	Stock	0.8	0.8	0.74	0.7725	222098.0
2019-07-25	AAUAF-DELISTED	Stock	0.8	0.8	0.74	0.7725	264150.0
2019-07-25	AAWW-DELISTED	Stock	45.25	45.3	43.35	43.59	129441.0
2019-07-25	AAXJ	Stock	69.91	69.97	69.4	69.54	825825.0
2019-07-25	AAXN-DELISTED	Stock	69.04	69.46	68.05	68.31	372682.0
2019-07-25	AB	Stock	29.79	30.0	28.9	29.18	366300.0
2019-07-25	ABB-DELISTED	Stock	18.95	18.96	18.475	18.53	3103240.0
2019-07-25	ABBNY-DELISTED	Stock	18.95	18.96	18.475	18.53	3239840.0
2019-07-25	ABBV	Stock	67.46	67.87	66.5	66.66	12403500.0
2019-07-25	ABC-DELISTED	Stock	87.23	87.62	85.54	85.94	450948.0
2019-07-25	ABCB	Stock	38.75	39.05	38.2	38.45	503000.0
2019-07-25	ABDC-DELISTED	Stock	8.36	8.4	8.29	8.29	1518.0
2019-07-25	ABEO	Stock	98.25	98.5	81.0	81.25	47788.0
2019-07-25	ABEOW-DELISTED	Stock	0.4	0.4	0.4	0.4	800.0
2019-07-25	ABEV	Stock	5.09	5.2	5.04	5.16	53426200.0
2019-07-25	ABG	Stock	90.19	90.96	88.85	89.76	120500.0
2019-07-25	ABIL-DELISTED	Stock	0.8112	0.841	0.782	0.8166	24217.0
2019-07-25	ABM	Stock	41.5	41.9	41.25	41.43	401300.0
2019-07-25	ABMD-DELISTED	Stock	275.23	275.3311	269.3584	272.35	260123.0
2019-07-25	ABR	Stock	12.17	12.2	12.01	12.02	645400.0
2019-07-25	ABR.A-DELISTED	Stock	26.15	26.26	26.04	26.26	1998.0
2019-07-25	ABR.C-DELISTED	Stock	26.3563	26.4953	26.3563	26.4953	900.0
2019-07-25	ABT	Stock	88.27	88.47	87.74	88.0	4671200.0
2019-07-25	ABTC	Stock	402300.0	411000.0	341400.0	345300.0	15.2

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

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