PREVIEW / stock_daily / 2018-10-09

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-09.parquet
  size:    222 KB
  rows:    6,562
  symbols: 2,753

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
2018-10-09	AAPL	Stock	55.91	56.8175	55.5625	56.7175	107564000.0
2018-10-09	MSFT	Stock	111.14	113.08	110.8	112.26	26198600.0
2018-10-09	NVDA	Stock	6.6235	6.719	6.57	6.6385	273500000.0
2018-10-09	AMZN	Stock	92.9995	94.834	92.616	93.516	95458000.0
2018-10-09	GOOGL	Stock	57.5655	58.0775	57.2085	57.2585	33694560.0
2018-10-09	META	Stock	157.69	160.59	157.42	157.9	18844400.0
2018-10-09	TSLA	Stock	17.0167	17.7847	16.8867	17.52	180909000.0
2018-10-09	TLT	Stock	113.14	113.85	113.07	113.8	11530860.0
2018-10-09	ES	Stock	62.96	63.6	62.72	63.36	1440800.0
2018-10-09	CL	Stock	65.47	65.69	65.06	65.07	4603300.0
2018-10-09	A	Stock	69.34	69.63	68.71	69.41	2179200.0
2018-10-09	AA	Stock	38.48	38.73	37.405	37.64	5164800.0
2018-10-09	AABA-DELISTED	Stock	62.15	62.859	61.44	61.51	14862592.0
2018-10-09	AAC-DELISTED	Stock	7.05	7.36	7.0	7.11	76390.0
2018-10-09	AACG	Stock	1.08	1.13	1.0	1.02	71300.0
2018-10-09	AAIC-DELISTED	Stock	8.91	8.98	8.88	8.89	293943.0
2018-10-09	AAL	Stock	36.3	36.39	33.41	33.55	19662600.0
2018-10-09	AAM.A-DELISTED	Stock	24.26	24.33	24.15	24.2876	27360.0
2018-10-09	AAM.B-DELISTED	Stock	24.0297	24.2119	24.0	24.11	30843.0
2018-10-09	AAMC-DELISTED	Stock	15.8235	16.1765	14.7235	15.5882	7082.0
2018-10-09	AAME	Stock	2.68	2.78	2.45	2.71	1600.0
2018-10-09	AAMI	Stock	13.01	13.01	12.72	12.85	551700.0
2018-10-09	AAOI	Stock	22.68	23.33	22.25	22.56	1008500.0
2018-10-09	AAON	Stock	23.08	23.3867	22.6333	22.6667	222900.0
2018-10-09	AAP	Stock	168.27	171.5	168.16	168.89	850400.0
2018-10-09	AAT	Stock	37.42	37.72	37.11	37.42	212500.0
2018-10-09	AAU-DELISTED	Stock	0.6	0.609	0.56	0.5696	295598.0
2018-10-09	AAUAF-DELISTED	Stock	0.6	0.609	0.56	0.5696	306513.0
2018-10-09	AAWW-DELISTED	Stock	59.43	59.7556	55.75	55.96	489658.0
2018-10-09	AAXJ	Stock	65.67	66.1	65.48	65.74	1689429.0
2018-10-09	AAXN-DELISTED	Stock	63.41	64.77	62.17	62.82	414836.0
2018-10-09	AB	Stock	30.18	30.31	30.09	30.15	143200.0
2018-10-09	ABAC-DELISTED	Stock	1.9	1.92	1.85	1.85	11090.0
2018-10-09	ABB-DELISTED	Stock	22.26	22.415	22.18	22.315	1392566.0
2018-10-09	ABBNY-DELISTED	Stock	22.26	22.415	22.18	22.32	1453483.0
2018-10-09	ABBV	Stock	94.71	95.26	93.8	94.57	3625600.0
2018-10-09	ABC-DELISTED	Stock	91.49	91.8	90.435	90.92	914780.0
2018-10-09	ABCB	Stock	45.73	45.9	45.4	45.66	227200.0
2018-10-09	ABCD-DELISTED	Stock	11.51	11.79	11.51	11.62	82679.0
2018-10-09	ABDC-DELISTED	Stock	6.04	6.04	5.99	6.015	20289.0
2018-10-09	ABEO	Stock	276.25	282.75	267.25	269.25	27952.0
2018-10-09	ABEOW-DELISTED	Stock	6.213	6.213	6.213	6.213	100.0
2018-10-09	ABEV	Stock	4.79	4.82	4.69	4.7	42788700.0
2018-10-09	ABG	Stock	63.62	63.89	62.8	63.06	345800.0
2018-10-09	ABIL-DELISTED	Stock	3.4015	3.4015	3.21	3.2368	82938.0
2018-10-09	ABM	Stock	32.09	32.79	31.94	32.65	697700.0
2018-10-09	ABMD-DELISTED	Stock	397.35	408.87	393.96	395.15	364320.0
2018-10-09	ABR	Stock	11.75	11.84	11.64	11.79	1277500.0
2018-10-09	ABR.A-DELISTED	Stock	25.69	25.69	25.58	25.61	1525.0
2018-10-09	ABR.B-DELISTED	Stock	25.2182	25.3313	25.2182	25.3176	2360.0

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

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