PREVIEW / stock_daily / 2018-07-17

all stock daily files

  file:    by_date/stock_daily/2018/2018-07-17.parquet
  size:    218 KB
  rows:    6,511
  symbols: 2,780

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-07-17	AAPL	Stock	47.4375	47.9675	47.3	47.8625	62138000.0
2018-07-17	MSFT	Stock	104.61	106.5	104.32	105.95	25901700.0
2018-07-17	NVDA	Stock	6.1553	6.3575	6.1295	6.3422	362136000.0
2018-07-17	AMZN	Stock	90.578	92.5845	89.869	92.1965	113658000.0
2018-07-17	GOOGL	Stock	59.137	60.938	59.1	60.654	40162660.0
2018-07-17	META	Stock	204.9	210.46	204.84	209.99	15349900.0
2018-07-17	TSLA	Stock	20.5873	21.6493	20.5667	21.5127	104943000.0
2018-07-17	TLT	Stock	122.29	122.39	121.9	121.98	3764341.0
2018-07-17	ES	Stock	59.17	59.25	58.68	58.87	1926200.0
2018-07-17	CL	Stock	65.04	65.95	65.04	65.56	3120500.0
2018-07-17	A	Stock	62.52	63.26	62.15	63.04	1469800.0
2018-07-17	AA	Stock	47.4	48.29	47.395	48.02	2203000.0
2018-07-17	AABA-DELISTED	Stock	73.98	75.55	73.62	75.36	4386650.0
2018-07-17	AAC-DELISTED	Stock	9.7	9.88	9.42	9.56	109472.0
2018-07-17	AACG	Stock	4.61	4.82	4.61	4.78	4600.0
2018-07-17	AAIC-DELISTED	Stock	10.16	10.25	10.16	10.19	251540.0
2018-07-17	AAL	Stock	37.1	38.05	37.08	37.38	6274400.0
2018-07-17	AAM.A-DELISTED	Stock	25.72	25.72	25.49	25.51	11909.0
2018-07-17	AAM.B-DELISTED	Stock	24.9	24.99	24.8601	24.93	66842.0
2018-07-17	AAMC-DELISTED	Stock	19.4118	19.4118	19.2353	19.2353	1894.0
2018-07-17	AAME	Stock	2.38	2.7	2.38	2.7	9900.0
2018-07-17	AAMI	Stock	13.74	13.99	13.74	13.88	510200.0
2018-07-17	AAOI	Stock	48.28	49.43	47.01	47.4	941600.0
2018-07-17	AAON	Stock	23.8	24.0333	23.6333	23.8333	192150.0
2018-07-17	AAP	Stock	139.15	141.29	139.15	140.28	809100.0
2018-07-17	AAT	Stock	37.95	38.22	37.39	37.46	203100.0
2018-07-17	AAU-DELISTED	Stock	0.7	0.71	0.69	0.6909	129994.0
2018-07-17	AAUAF-DELISTED	Stock	0.7	0.71	0.69	0.6909	134559.0
2018-07-17	AAV-DELISTED	Stock	3.1	3.15	3.1	3.125	27067.0
2018-07-17	AAWW-DELISTED	Stock	68.1	69.35	67.525	69.1	208382.0
2018-07-17	AAXJ	Stock	71.34	71.99	71.18	71.9	745907.0
2018-07-17	AAXN-DELISTED	Stock	69.12	70.89	68.68	70.64	487436.0
2018-07-17	AB	Stock	29.3	29.68	29.3	29.5	167100.0
2018-07-17	ABAC-DELISTED	Stock	2.37	2.389	2.28	2.3562	2500.0
2018-07-17	ABAX-DELISTED	Stock	83.27	83.3669	83.23	83.35	163744.0
2018-07-17	ABB-DELISTED	Stock	21.8	21.8599	21.73	21.795	2058789.0
2018-07-17	ABBNY-DELISTED	Stock	21.8	21.8599	21.73	21.8	2122043.0
2018-07-17	ABBV	Stock	96.27	97.17	95.33	95.41	5107500.0
2018-07-17	ABC-DELISTED	Stock	86.67	87.58	86.45	86.84	1027101.0
2018-07-17	ABCB	Stock	51.3	51.6	50.8	50.85	299300.0
2018-07-17	ABCD-DELISTED	Stock	11.45	11.91	11.4	11.82	105745.0
2018-07-17	ABDC-DELISTED	Stock	6.2	6.29	6.08	6.22	35596.0
2018-07-17	ABEO	Stock	355.0	363.25	352.5	353.75	18452.0
2018-07-17	ABEV	Stock	4.92	5.01	4.88	5.0	35458600.0
2018-07-17	ABG	Stock	67.6	70.1	67.6	68.75	232200.0
2018-07-17	ABIL-DELISTED	Stock	5.09	5.7	5.09	5.12	142342.0
2018-07-17	ABM	Stock	30.03	30.12	29.24	29.34	944800.0
2018-07-17	ABMD-DELISTED	Stock	417.61	428.61	417.61	427.37	755670.0
2018-07-17	ABR	Stock	11.08	11.72	10.98	11.68	8864000.0
2018-07-17	ABR.A-DELISTED	Stock	25.89	25.9216	25.8	25.8	846.0

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

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