PREVIEW / stock_daily / 2019-01-17

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-17.parquet
  size:    219 KB
  rows:    6,531
  symbols: 2,648

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-01-17	AAPL	Stock	38.55	39.415	38.315	38.965	119284800.0
2019-01-17	MSFT	Stock	105.0	106.63	104.76	106.12	28393000.0
2019-01-17	NVDA	Stock	3.6878	3.8333	3.6602	3.793	493436000.0
2019-01-17	AMZN	Stock	84.0	85.0085	83.875	84.661	84178000.0
2019-01-17	GOOGL	Stock	54.3995	55.035	54.1628	54.956	24896020.0
2019-01-17	META	Stock	146.95	149.0	146.5	148.3	15787900.0
2019-01-17	TSLA	Stock	23.0807	23.4333	22.9433	23.154	55150500.0
2019-01-17	TLT	Stock	120.22	120.53	119.89	120.19	8153350.0
2019-01-17	ES	Stock	66.72	67.44	66.52	67.28	1595500.0
2019-01-17	CL	Stock	62.12	62.5	61.91	62.0	3549400.0
2019-01-17	A	Stock	69.76	71.24	69.76	70.82	1225800.0
2019-01-17	AA	Stock	28.21	30.28	27.51	29.59	12073100.0
2019-01-17	AABA-DELISTED	Stock	63.2	65.27	63.08	64.31	4404782.0
2019-01-17	AAC-DELISTED	Stock	2.74	2.78	2.6	2.65	120720.0
2019-01-17	AACG	Stock	1.0	1.0	0.96	0.99	55800.0
2019-01-17	AAIC-DELISTED	Stock	8.11	8.12	7.96	8.08	298208.0
2019-01-17	AAL	Stock	32.75	33.89	32.63	33.58	5917500.0
2019-01-17	AAM.A-DELISTED	Stock	24.4	24.47	24.26	24.47	24472.0
2019-01-17	AAM.B-DELISTED	Stock	24.27	24.27	24.01	24.151	10479.0
2019-01-17	AAMC-DELISTED	Stock	8.4882	8.4882	8.0324	8.2912	2778.0
2019-01-17	AAME	Stock	2.62	2.67	2.44	2.5	6000.0
2019-01-17	AAMI	Stock	11.57	11.76	11.48	11.6	608800.0
2019-01-17	AAOI	Stock	15.89	16.24	15.45	16.04	568300.0
2019-01-17	AAON	Stock	23.6933	24.66	23.6933	24.5333	220350.0
2019-01-17	AAP	Stock	161.99	167.42	161.5	166.28	1455100.0
2019-01-17	AAT	Stock	40.73	41.41	40.73	41.1	286200.0
2019-01-17	AAU-DELISTED	Stock	0.82	0.82	0.75	0.7602	195679.0
2019-01-17	AAUAF-DELISTED	Stock	0.82	0.82	0.75	0.7602	199090.0
2019-01-17	AAWW-DELISTED	Stock	47.55	49.33	47.41	49.17	194308.0
2019-01-17	AAXJ	Stock	65.62	66.69	65.62	66.48	1278715.0
2019-01-17	AAXN-DELISTED	Stock	49.41	50.61	49.3917	50.23	411546.0
2019-01-17	AB	Stock	29.45	29.88	29.18	29.55	371700.0
2019-01-17	ABB-DELISTED	Stock	18.85	19.275	18.8375	19.15	2685629.0
2019-01-17	ABBNY-DELISTED	Stock	18.85	19.275	18.8375	19.15	2765567.0
2019-01-17	ABBV	Stock	85.54	87.69	85.42	87.2	6438700.0
2019-01-17	ABC-DELISTED	Stock	77.79	78.13	76.0	76.09	1180378.0
2019-01-17	ABCB	Stock	35.16	35.99	34.96	35.9	688600.0
2019-01-17	ABDC-DELISTED	Stock	6.87	6.87	6.75	6.75	7332.0
2019-01-17	ABEO	Stock	174.75	180.5	173.75	178.0	12756.0
2019-01-17	ABEV	Stock	4.65	4.76	4.63	4.74	24061900.0
2019-01-17	ABG	Stock	69.92	72.13	69.69	71.09	196600.0
2019-01-17	ABIL-DELISTED	Stock	2.27	2.3299	2.15	2.23	862271.0
2019-01-17	ABM	Stock	34.85	35.27	34.53	34.96	398100.0
2019-01-17	ABMD-DELISTED	Stock	324.06	332.94	324.06	330.45	213687.0
2019-01-17	ABR	Stock	11.34	11.41	11.29	11.4	598300.0
2019-01-17	ABR.A-DELISTED	Stock	25.4868	25.6872	25.4128	25.5802	2950.0
2019-01-17	ABR.B-DELISTED	Stock	25.25	25.38	25.05	25.38	36287.0
2019-01-17	ABR.C-DELISTED	Stock	25.64	25.8028	25.5	25.7	1320.0
2019-01-17	ABT	Stock	69.87	70.97	69.77	70.52	5427800.0
2019-01-17	ABTC	Stock	301200.0	301200.0	301200.0	301200.0	0.02666666666666667

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

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