PREVIEW / stock_daily / 2018-08-20

all stock daily files

  file:    by_date/stock_daily/2018/2018-08-20.parquet
  size:    219 KB
  rows:    6,524
  symbols: 2,759

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-08-20	AAPL	Stock	54.525	54.795	53.7775	53.865	121150800.0
2018-08-20	MSFT	Stock	107.51	107.9	106.48	106.87	17914200.0
2018-08-20	NVDA	Stock	6.0795	6.33	5.968	6.196	854388000.0
2018-08-20	AMZN	Stock	94.5285	94.5875	93.303	93.8355	57240000.0
2018-08-20	GOOGL	Stock	61.033	61.2955	60.435	61.0975	22223460.0
2018-08-20	META	Stock	174.04	174.57	170.91	172.5	21518000.0
2018-08-20	TSLA	Stock	19.4467	20.5667	19.2133	20.5627	261034500.0
2018-08-20	TLT	Stock	121.64	121.91	121.535	121.79	5604121.0
2018-08-20	ES	Stock	63.31	63.53	62.91	63.12	871200.0
2018-08-20	CL	Stock	67.62	67.89	67.58	67.66	2151800.0
2018-08-20	A	Stock	64.57	65.11	64.46	64.47	1619900.0
2018-08-20	AA	Stock	42.57	42.87	41.71	41.83	2730900.0
2018-08-20	AABA-DELISTED	Stock	68.84	70.27	68.62	69.3	10212007.0
2018-08-20	AAC-DELISTED	Stock	9.9	10.0	9.72	9.79	295644.0
2018-08-20	AACG	Stock	6.59	6.59	6.26	6.36	97000.0
2018-08-20	AAIC-DELISTED	Stock	10.19	10.29	10.15	10.19	486371.0
2018-08-20	AAL	Stock	38.04	40.1	37.99	39.99	9628900.0
2018-08-20	AAM.A-DELISTED	Stock	25.6	25.65	25.6	25.64	9568.0
2018-08-20	AAM.B-DELISTED	Stock	25.2467	25.3	25.16	25.2505	45679.0
2018-08-20	AAMC-DELISTED	Stock	18.6765	18.9632	18.6765	18.7523	3305.0
2018-08-20	AAME	Stock	2.45	2.7	2.3	2.55	4900.0
2018-08-20	AAMI	Stock	12.54	12.67	12.44	12.57	385700.0
2018-08-20	AAOI	Stock	40.05	40.76	39.5	40.27	603800.0
2018-08-20	AAON	Stock	27.4	28.1667	27.4	28.1	328800.0
2018-08-20	AAP	Stock	160.44	161.25	160.0	160.84	999200.0
2018-08-20	AAT	Stock	39.49	39.85	39.35	39.64	289800.0
2018-08-20	AAU-DELISTED	Stock	0.63	0.639	0.6201	0.6384	209630.0
2018-08-20	AAUAF-DELISTED	Stock	0.63	0.639	0.6201	0.6384	229337.0
2018-08-20	AAV-DELISTED	Stock	3.0	3.04	2.95	2.975	41703.0
2018-08-20	AAWW-DELISTED	Stock	60.4	61.5	60.0	61.15	154739.0
2018-08-20	AAXJ	Stock	69.97	70.181	69.81	70.16	464443.0
2018-08-20	AAXN-DELISTED	Stock	64.45	64.68	63.0753	64.14	395186.0
2018-08-20	AB	Stock	29.9	30.2	29.85	29.95	209500.0
2018-08-20	ABAC-DELISTED	Stock	1.95	1.95	1.9	1.95	788.0
2018-08-20	ABB-DELISTED	Stock	22.8	22.8165	22.68	22.73	920494.0
2018-08-20	ABBNY-DELISTED	Stock	22.8	22.8165	22.68	22.74	964092.0
2018-08-20	ABBV	Stock	99.33	100.23	97.47	97.63	6172500.0
2018-08-20	ABC-DELISTED	Stock	87.71	88.66	87.71	88.28	686689.0
2018-08-20	ABCB	Stock	49.65	49.85	49.18	49.65	187700.0
2018-08-20	ABCD-DELISTED	Stock	13.08	13.44	13.01	13.315	154723.0
2018-08-20	ABDC-DELISTED	Stock	6.34	6.4173	6.3112	6.37	3201.0
2018-08-20	ABEO	Stock	328.75	343.75	328.75	341.25	14408.0
2018-08-20	ABEOW-DELISTED	Stock	8.5	8.5672	8.5	8.5671	750.0
2018-08-20	ABEV	Stock	4.89	4.91	4.81	4.86	39119000.0
2018-08-20	ABG	Stock	75.05	76.35	74.99	76.05	118100.0
2018-08-20	ABIL-DELISTED	Stock	4.7	4.99	4.35	4.44	370367.0
2018-08-20	ABM	Stock	31.9	32.4	31.88	32.29	544900.0
2018-08-20	ABMD-DELISTED	Stock	358.27	364.44	354.52	362.46	286875.0
2018-08-20	ABR	Stock	11.63	11.74	11.58	11.67	1056300.0
2018-08-20	ABR.A-DELISTED	Stock	25.83	25.83	25.79	25.79	500.0

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

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