PREVIEW / stock_daily / 2019-04-11

all stock daily files

  file:    by_date/stock_daily/2019/2019-04-11.parquet
  size:    220 KB
  rows:    6,524
  symbols: 2,582

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-04-11	AAPL	Stock	50.2125	50.25	49.61	49.7375	83603200.0
2019-04-11	MSFT	Stock	120.54	120.85	119.92	120.33	14209100.0
2019-04-11	NVDA	Stock	4.805	4.8368	4.7388	4.7885	374600000.0
2019-04-11	AMZN	Stock	92.435	92.4975	92.0155	92.2035	53096000.0
2019-04-11	GOOGL	Stock	60.445	60.637	60.227	60.4795	16998940.0
2019-04-11	META	Stock	178.24	178.4	177.0	177.51	8071000.0
2019-04-11	TSLA	Stock	17.8867	18.0333	17.7067	17.8947	147538500.0
2019-04-11	TLT	Stock	123.93	124.02	123.41	123.55	8679319.0
2019-04-11	ES	Stock	69.87	70.78	69.87	70.6	1294600.0
2019-04-11	CL	Stock	68.31	68.48	67.75	68.09	2508900.0
2019-04-11	A	Stock	81.88	81.92	80.89	81.08	1071500.0
2019-04-11	AA	Stock	28.85	29.11	28.3	28.49	3409900.0
2019-04-11	AABA-DELISTED	Stock	75.45	75.45	74.66	75.06	4620310.0
2019-04-11	AAC-DELISTED	Stock	2.18	2.2	1.97	2.01	93577.0
2019-04-11	AACG	Stock	3.0	3.46	2.85	3.05	6180700.0
2019-04-11	AAIC-DELISTED	Stock	7.88	7.89	7.6866	7.71	658646.0
2019-04-11	AAIC.C-DELISTED	Stock	23.72	23.7201	23.46	23.5999	11384.0
2019-04-11	AAL	Stock	33.99	34.97	33.91	34.81	7352400.0
2019-04-11	AAM.A-DELISTED	Stock	24.89	24.89	24.81	24.86	15628.0
2019-04-11	AAM.B-DELISTED	Stock	24.63	24.8	24.63	24.75	30610.0
2019-04-11	AAME	Stock	2.47	2.47	2.38	2.41	1800.0
2019-04-11	AAMI	Stock	14.45	14.64	14.34	14.6	683300.0
2019-04-11	AAOI	Stock	12.33	12.41	12.18	12.37	293700.0
2019-04-11	AAON	Stock	29.9	30.2733	29.7467	30.08	164850.0
2019-04-11	AAP	Stock	178.65	181.02	177.89	180.96	705300.0
2019-04-11	AAT	Stock	45.94	46.17	45.67	45.88	187700.0
2019-04-11	AAU-DELISTED	Stock	0.57	0.5796	0.56	0.5611	82566.0
2019-04-11	AAUAF-DELISTED	Stock	0.57	0.5796	0.56	0.5611	88398.0
2019-04-11	AAWW-DELISTED	Stock	49.69	50.42	49.52	50.22	160830.0
2019-04-11	AAXJ	Stock	72.62	72.64	72.29	72.44	968884.0
2019-04-11	AAXN-DELISTED	Stock	60.19	61.04	60.0498	60.89	315725.0
2019-04-11	AB	Stock	29.26	29.56	29.11	29.33	219800.0
2019-04-11	ABB-DELISTED	Stock	19.54	19.585	19.445	19.515	1263106.0
2019-04-11	ABBNY-DELISTED	Stock	19.54	19.585	19.445	19.51	1422478.0
2019-04-11	ABBV	Stock	83.2	83.25	81.23	81.77	9094200.0
2019-04-11	ABC-DELISTED	Stock	74.49	75.27	73.46	74.17	1350342.0
2019-04-11	ABCB	Stock	35.13	35.67	35.09	35.33	174200.0
2019-04-11	ABDC-DELISTED	Stock	7.82	7.83	7.78	7.78	14520.0
2019-04-11	ABEO	Stock	193.5	202.5	189.25	191.0	21376.0
2019-04-11	ABEV	Stock	4.54	4.58	4.42	4.45	23572700.0
2019-04-11	ABG	Stock	72.6	73.37	72.47	73.1	135300.0
2019-04-11	ABIL-DELISTED	Stock	1.72	1.72	1.64	1.68	47506.0
2019-04-11	ABM	Stock	37.03	37.27	36.93	37.0	270400.0
2019-04-11	ABMD-DELISTED	Stock	280.18	280.49	270.25	271.88	619190.0
2019-04-11	ABR	Stock	13.52	13.7	13.51	13.63	867800.0
2019-04-11	ABR.A-DELISTED	Stock	25.8988	25.8988	25.71	25.71	800.0
2019-04-11	ABR.B-DELISTED	Stock	25.55	25.55	25.47	25.505	1808.0
2019-04-11	ABR.C-DELISTED	Stock	26.2163	26.2649	26.1282	26.25	1889.0
2019-04-11	ABT	Stock	79.19	79.23	78.35	78.51	4432100.0
2019-04-11	ABTC	Stock	303900.0	303900.0	303300.0	303600.0	0.56

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

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