PREVIEW / stock_daily / 2019-01-23

all stock daily files

  file:    by_date/stock_daily/2019/2019-01-23.parquet
  size:    219 KB
  rows:    6,510
  symbols: 2,640

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-23	AAPL	Stock	38.5375	38.785	37.925	38.48	92522400.0
2019-01-23	MSFT	Stock	106.12	107.04	105.34	106.71	25874300.0
2019-01-23	NVDA	Stock	3.775	3.8645	3.7008	3.7322	591020000.0
2019-01-23	AMZN	Stock	82.8	82.8715	80.6	82.001	104504000.0
2019-01-23	GOOGL	Stock	54.343	54.6475	53.3785	54.2205	25194760.0
2019-01-23	META	Stock	148.28	148.8	143.06	144.3	20098400.0
2019-01-23	TSLA	Stock	19.5	19.6333	18.7793	19.1727	187950000.0
2019-01-23	TLT	Stock	119.88	120.62	119.83	120.32	5776907.0
2019-01-23	ES	Stock	67.42	68.33	67.42	68.3	1284300.0
2019-01-23	CL	Stock	61.93	62.53	61.64	62.35	4038100.0
2019-01-23	A	Stock	71.95	72.85	70.74	71.65	2050300.0
2019-01-23	AA	Stock	28.15	28.66	27.845	28.3	4392900.0
2019-01-23	AABA-DELISTED	Stock	63.62	64.15	62.56	62.86	3722765.0
2019-01-23	AAC-DELISTED	Stock	2.52	2.6	2.49	2.505	141561.0
2019-01-23	AACG	Stock	0.96	1.0	0.96	0.96	23200.0
2019-01-23	AAIC-DELISTED	Stock	8.12	8.17	8.06	8.15	179911.0
2019-01-23	AAL	Stock	32.93	33.1	31.39	31.65	14317900.0
2019-01-23	AAM.A-DELISTED	Stock	24.52	24.53	24.4263	24.52	16290.0
2019-01-23	AAM.B-DELISTED	Stock	24.3284	24.39	24.2507	24.339	18806.0
2019-01-23	AAMC-DELISTED	Stock	7.5294	8.1618	7.5294	8.0324	22127.0
2019-01-23	AAME	Stock	2.51	2.51	2.51	2.51	100.0
2019-01-23	AAMI	Stock	12.15	12.31	12.09	12.23	681800.0
2019-01-23	AAOI	Stock	16.41	16.625	16.01	16.21	384400.0
2019-01-23	AAON	Stock	25.2067	25.2933	24.0	24.1733	188400.0
2019-01-23	AAP	Stock	164.04	166.6	162.16	164.33	1207800.0
2019-01-23	AAT	Stock	40.5	40.65	40.3	40.63	161700.0
2019-01-23	AAU-DELISTED	Stock	0.72	0.76	0.7101	0.715	117183.0
2019-01-23	AAUAF-DELISTED	Stock	0.72	0.76	0.7101	0.715	123917.0
2019-01-23	AAWW-DELISTED	Stock	50.35	50.57	49.25	49.67	208664.0
2019-01-23	AAXJ	Stock	66.15	66.19	65.71	66.19	2261539.0
2019-01-23	AAXN-DELISTED	Stock	49.08	50.05	47.46	48.06	357178.0
2019-01-23	AB	Stock	29.59	29.85	29.39	29.81	256200.0
2019-01-23	ABB-DELISTED	Stock	19.19	19.2	18.965	19.13	2250763.0
2019-01-23	ABBNY-DELISTED	Stock	19.19	19.2	18.965	19.13	2499919.0
2019-01-23	ABBV	Stock	88.84	89.28	87.7	88.45	4969300.0
2019-01-23	ABC-DELISTED	Stock	79.81	79.98	77.67	79.35	853836.0
2019-01-23	ABCB	Stock	35.64	35.69	35.2	35.45	359100.0
2019-01-23	ABDC-DELISTED	Stock	6.67	6.78	6.67	6.6812	6873.0
2019-01-23	ABEO	Stock	174.0	177.25	166.25	168.75	8604.0
2019-01-23	ABEV	Stock	4.55	4.56	4.46	4.54	27489300.0
2019-01-23	ABG	Stock	70.72	70.98	68.98	69.32	167000.0
2019-01-23	ABIL-DELISTED	Stock	2.25	2.33	2.05	2.15	808748.0
2019-01-23	ABM	Stock	35.29	35.59	34.3	34.57	961000.0
2019-01-23	ABMD-DELISTED	Stock	339.14	344.97	332.75	336.82	268299.0
2019-01-23	ABR	Stock	11.15	11.22	11.08	11.21	873200.0
2019-01-23	ABR.A-DELISTED	Stock	25.57	25.5869	25.458	25.458	2758.0
2019-01-23	ABR.C-DELISTED	Stock	25.6501	25.7499	25.6501	25.7	1580.0
2019-01-23	ABT	Stock	70.5	71.55	69.27	69.91	10196300.0
2019-01-23	ABTC	Stock	309000.0	309000.0	302820.0	304500.0	12.533333333333333
2019-01-23	ABTS	Stock	57.75	62.25	54.225	59.25	3747.0

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

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