PREVIEW / stock_daily / 2019-10-08

all stock daily files

  file:    by_date/stock_daily/2019/2019-10-08.parquet
  size:    218 KB
  rows:    6,553
  symbols: 2,465

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-10-08	AAPL	Stock	56.455	57.015	56.0825	56.1	111820000.0
2019-10-08	MSFT	Stock	137.08	137.76	135.62	135.67	25550500.0
2019-10-08	NVDA	Stock	4.516	4.516	4.4125	4.4308	444436000.0
2019-10-08	AMZN	Stock	86.1245	86.35	85.25	85.2755	50840000.0
2019-10-08	GOOGL	Stock	59.9385	60.3434	59.474	59.5065	20648520.0
2019-10-08	META	Stock	178.26	180.37	177.72	177.75	9466900.0
2019-10-08	TSLA	Stock	15.7247	16.2627	15.6333	16.0033	130173000.0
2019-10-08	TLT	Stock	145.82	145.93	144.62	145.17	14540249.0
2019-10-08	ES	Stock	85.41	85.58	84.84	84.85	1308700.0
2019-10-08	CL	Stock	71.49	71.58	70.63	70.68	2539200.0
2019-10-08	A	Stock	73.97	73.97	71.73	72.49	3001900.0
2019-10-08	AA	Stock	18.9	19.01	18.47	18.49	3526900.0
2019-10-08	AAC-DELISTED	Stock	0.6604	0.683	0.5153	0.5498	322577.0
2019-10-08	AACG	Stock	1.7	1.72	1.62	1.62	10400.0
2019-10-08	AAIC-DELISTED	Stock	5.37	5.38	5.27	5.28	296136.0
2019-10-08	AAIC.C-DELISTED	Stock	21.0929	21.0929	20.48	20.9071	14602.0
2019-10-08	AAL	Stock	25.56	26.8	25.45	26.26	9028100.0
2019-10-08	AAM.A-DELISTED	Stock	26.5	26.5602	26.41	26.515	11085.0
2019-10-08	AAM.B-DELISTED	Stock	26.83	26.89	26.71	26.86	14409.0
2019-10-08	AAMC-DELISTED	Stock	3.1029	3.4647	3.1029	3.4647	7205.0
2019-10-08	AAME	Stock	2.5	2.52	2.5	2.52	1900.0
2019-10-08	AAMI	Stock	9.27	9.31	9.05	9.07	703800.0
2019-10-08	AAOI	Stock	10.36	10.36	10.01	10.075	300700.0
2019-10-08	AAON	Stock	29.6533	30.2733	29.4	29.9267	151800.0
2019-10-08	AAP	Stock	156.6	156.89	153.25	154.33	913200.0
2019-10-08	AAT	Stock	46.6	46.72	46.09	46.48	247800.0
2019-10-08	AAU-DELISTED	Stock	0.69	0.7443	0.68	0.7299	145125.0
2019-10-08	AAUAF-DELISTED	Stock	0.69	0.7443	0.68	0.7299	148709.0
2019-10-08	AAWW-DELISTED	Stock	21.77	21.88	20.8	20.96	521548.0
2019-10-08	AAXJ	Stock	65.87	65.945	65.54	65.64	854855.0
2019-10-08	AAXN-DELISTED	Stock	54.01	54.63	52.59	52.75	363877.0
2019-10-08	AB	Stock	28.55	28.92	28.45	28.47	104700.0
2019-10-08	ABB-DELISTED	Stock	18.0	18.0491	17.88	17.905	2976790.0
2019-10-08	ABBNY-DELISTED	Stock	18.0	18.0491	17.88	17.89	3109513.0
2019-10-08	ABBV	Stock	73.88	74.75	73.42	73.53	6121500.0
2019-10-08	ABC-DELISTED	Stock	81.26	81.87	80.125	80.17	1087239.0
2019-10-08	ABCB	Stock	39.29	39.29	38.55	38.57	220600.0
2019-10-08	ABDC-DELISTED	Stock	8.84	8.873	8.83	8.85	39393.0
2019-10-08	ABEO	Stock	59.25	61.25	56.5	57.25	11372.0
2019-10-08	ABEOW-DELISTED	Stock	0.2	0.2	0.1992	0.1992	1800.0
2019-10-08	ABEV	Stock	4.6	4.61	4.52	4.54	22207900.0
2019-10-08	ABG	Stock	95.5	96.58	94.67	94.8	408100.0
2019-10-08	ABIL-DELISTED	Stock	0.49	0.49	0.45	0.464	30148.0
2019-10-08	ABM	Stock	34.13	34.56	33.93	34.3	234200.0
2019-10-08	ABMD-DELISTED	Stock	163.5	164.375	158.45	159.34	607954.0
2019-10-08	ABR	Stock	13.1	13.17	13.0	13.1	714900.0
2019-10-08	ABR.A-DELISTED	Stock	26.11	26.1198	25.96	26.0998	2516.0
2019-10-08	ABR.B-DELISTED	Stock	26.0	26.1	26.0	26.1	2400.0
2019-10-08	ABT	Stock	80.56	80.56	78.51	78.51	5924200.0
2019-10-08	ABTC	Stock	188700.0	188700.0	179700.0	180000.0	0.8799999999999999

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

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