PREVIEW / stock_daily / 2018-10-17

all stock daily files

  file:    by_date/stock_daily/2018/2018-10-17.parquet
  size:    220 KB
  rows:    6,516
  symbols: 2,716

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-17	AAPL	Stock	55.575	55.66	54.835	55.2975	91541600.0
2018-10-17	MSFT	Stock	111.68	111.81	109.55	110.71	26548200.0
2018-10-17	NVDA	Stock	6.2085	6.247	6.027	6.0765	329668000.0
2018-10-17	AMZN	Stock	92.1395	92.25	90.35	91.5865	105904000.0
2018-10-17	GOOGL	Stock	57.0	57.35	55.7	56.3795	35652280.0
2018-10-17	META	Stock	159.56	160.49	157.95	159.42	17592000.0
2018-10-17	TSLA	Stock	18.8267	18.8467	17.72	18.1187	129832500.0
2018-10-17	TLT	Stock	114.66	114.785	113.98	114.0	5880696.0
2018-10-17	ES	Stock	62.07	62.86	62.0	62.49	1930500.0
2018-10-17	CL	Stock	62.17	63.62	62.02	63.55	5446700.0
2018-10-17	A	Stock	67.17	67.46	66.31	67.2	1991200.0
2018-10-17	AA	Stock	36.38	36.71	35.56	36.7	7398600.0
2018-10-17	AABA-DELISTED	Stock	63.04	63.36	61.61	62.16	5057411.0
2018-10-17	AAC-DELISTED	Stock	6.91	7.0	6.78	6.87	119802.0
2018-10-17	AACG	Stock	1.08	1.34	1.02	1.17	828500.0
2018-10-17	AAIC-DELISTED	Stock	8.62	8.6631	8.565	8.62	262592.0
2018-10-17	AAL	Stock	34.45	35.4	33.53	33.57	15068600.0
2018-10-17	AAM.A-DELISTED	Stock	24.0872	24.0872	23.9	23.9	39084.0
2018-10-17	AAM.B-DELISTED	Stock	23.96	23.9728	23.8306	23.89	29994.0
2018-10-17	AAMC-DELISTED	Stock	14.7794	15.25	14.6912	14.6912	6729.0
2018-10-17	AAME	Stock	2.95	2.95	2.93	2.95	2200.0
2018-10-17	AAMI	Stock	12.28	12.45	12.16	12.4	553700.0
2018-10-17	AAOI	Stock	23.21	23.4	22.52	23.15	468700.0
2018-10-17	AAON	Stock	21.7467	21.8333	21.4933	21.7733	193650.0
2018-10-17	AAP	Stock	166.81	167.8	154.02	159.58	1967500.0
2018-10-17	AAT	Stock	36.8	36.95	36.39	36.61	104900.0
2018-10-17	AAU-DELISTED	Stock	0.5601	0.57	0.5266	0.5366	149205.0
2018-10-17	AAUAF-DELISTED	Stock	0.5601	0.57	0.5266	0.5366	151136.0
2018-10-17	AAWW-DELISTED	Stock	53.83	53.83	52.72	53.58	148710.0
2018-10-17	AAXJ	Stock	65.15	65.15	64.44	64.71	604154.0
2018-10-17	AAXN-DELISTED	Stock	62.73	62.73	59.52	61.65	450362.0
2018-10-17	AB	Stock	30.55	30.68	30.22	30.65	371300.0
2018-10-17	ABAC-DELISTED	Stock	1.8056	2.2	1.8056	1.82	90316.0
2018-10-17	ABB-DELISTED	Stock	21.34	21.45	21.205	21.36	2068522.0
2018-10-17	ABBNY-DELISTED	Stock	21.34	21.45	21.205	21.37	2145979.0
2018-10-17	ABBV	Stock	91.82	92.41	90.83	92.27	2857400.0
2018-10-17	ABC-DELISTED	Stock	92.77	94.57	92.5	93.75	1193988.0
2018-10-17	ABCB	Stock	43.57	44.34	43.08	43.95	364800.0
2018-10-17	ABCD-DELISTED	Stock	14.37	14.42	14.37	14.37	852206.0
2018-10-17	ABDC-DELISTED	Stock	5.95	5.999	5.95	5.97	60360.0
2018-10-17	ABEO	Stock	260.25	260.25	248.0	250.75	17740.0
2018-10-17	ABEOW-DELISTED	Stock	5.36	5.36	5.35	5.35	300.0
2018-10-17	ABEV	Stock	4.59	4.7	4.57	4.61	26365600.0
2018-10-17	ABG	Stock	61.29	61.55	59.51	60.72	587600.0
2018-10-17	ABIL-DELISTED	Stock	3.22	3.3475	3.02	3.09	31117.0
2018-10-17	ABM	Stock	32.29	32.76	31.96	32.58	330600.0
2018-10-17	ABMD-DELISTED	Stock	391.57	391.57	380.05	389.79	240648.0
2018-10-17	ABR	Stock	11.86	11.92	11.81	11.92	568200.0
2018-10-17	ABR.A-DELISTED	Stock	25.52	25.52	25.5	25.5	1100.0
2018-10-17	ABR.C-DELISTED	Stock	25.8212	25.8212	25.66	25.756	1690.0

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

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