PREVIEW / stock_daily / 2018-01-18

all stock daily files

  file:    by_date/stock_daily/2018/2018-01-18.parquet
  size:    217 KB
  rows:    6,498
  symbols: 2,874

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-01-18	AAPL	Stock	44.8425	45.025	44.5625	44.815	124773600.0
2018-01-18	MSFT	Stock	89.8	90.67	89.66	90.1	24159700.0
2018-01-18	NVDA	Stock	5.5985	5.666	5.567	5.611	408632000.0
2018-01-18	AMZN	Stock	64.6975	65.23	64.201	64.666	80538000.0
2018-01-18	GOOGL	Stock	56.9675	57.0292	56.2232	56.7985	27497460.0
2018-01-18	META	Stock	178.13	180.98	177.08	179.8	23304900.0
2018-01-18	TSLA	Stock	23.0447	23.4867	22.916	22.9713	85287000.0
2018-01-18	TLT	Stock	123.93	124.27	123.535	123.71	10843892.0
2018-01-18	ES	Stock	61.76	61.76	60.65	60.81	4200700.0
2018-01-18	CL	Stock	76.72	77.29	76.35	76.63	4040100.0
2018-01-18	A	Stock	72.2	72.5	71.67	72.19	1828300.0
2018-01-18	AA	Stock	53.67	53.87	51.72	53.0	19521000.0
2018-01-18	AAAP-DELISTED	Stock	81.84	81.95	81.84	81.94	85539.0
2018-01-18	AABA-DELISTED	Stock	73.86	74.71	73.83	74.25	5007344.0
2018-01-18	AAC-DELISTED	Stock	9.05	9.1351	8.98	8.99	153249.0
2018-01-18	AACG	Stock	5.55	5.78	5.49	5.7	2600.0
2018-01-18	AAIC-DELISTED	Stock	11.81	11.82	11.61	11.72	448773.0
2018-01-18	AAL	Stock	58.0	58.71	57.56	58.34	3969100.0
2018-01-18	AAM.A-DELISTED	Stock	25.75	25.782	25.52	25.5299	30666.0
2018-01-18	AAME	Stock	3.3	3.35	3.3	3.35	2300.0
2018-01-18	AAMI	Stock	18.28	18.46	18.1	18.18	273000.0
2018-01-18	AAOI	Stock	33.73	33.928	32.32	32.79	1629800.0
2018-01-18	AAON	Stock	24.1667	24.2533	23.9667	24.0667	237000.0
2018-01-18	AAP	Stock	115.67	115.86	113.66	115.53	920900.0
2018-01-18	AAT	Stock	36.27	36.27	35.62	35.79	203900.0
2018-01-18	AAU-DELISTED	Stock	0.95	0.9595	0.93	0.95	117491.0
2018-01-18	AAUAF-DELISTED	Stock	0.95	0.9595	0.93	0.95	122794.0
2018-01-18	AAV-DELISTED	Stock	3.6	3.65	3.41	3.5	437765.0
2018-01-18	AAWW-DELISTED	Stock	61.9	62.2	60.8	61.45	240209.0
2018-01-18	AAXJ	Stock	80.4	80.6	80.28	80.5	3081724.0
2018-01-18	AAXN-DELISTED	Stock	27.63	27.73	27.27	27.43	433077.0
2018-01-18	AB	Stock	27.15	27.48	26.8	27.15	355700.0
2018-01-18	ABAC-DELISTED	Stock	2.91	2.938	2.805	2.81	17607.0
2018-01-18	ABAX-DELISTED	Stock	60.9	61.22	60.1	60.79	239332.0
2018-01-18	ABB-DELISTED	Stock	28.01	28.065	27.9	27.98	1176981.0
2018-01-18	ABBNY-DELISTED	Stock	28.01	28.065	27.9	27.98	1232869.0
2018-01-18	ABBV	Stock	104.29	104.85	103.44	103.81	6371200.0
2018-01-18	ABC-DELISTED	Stock	101.53	101.64	99.75	100.87	1643712.0
2018-01-18	ABCB	Stock	53.55	53.6	53.2	53.35	150900.0
2018-01-18	ABCD-DELISTED	Stock	7.09	7.0901	6.82	6.9	176647.0
2018-01-18	ABDC-DELISTED	Stock	8.47	8.49	8.3	8.36	82876.0
2018-01-18	ABE-DELISTED	Stock	15.31	15.31	15.2895	15.2925	1400.0
2018-01-18	ABEO	Stock	381.25	385.0	363.75	363.75	17284.0
2018-01-18	ABEOW-DELISTED	Stock	9.9	9.9499	9.8708	9.9499	1304.0
2018-01-18	ABEV	Stock	6.81	6.84	6.75	6.76	15194800.0
2018-01-18	ABG	Stock	72.8	73.15	71.95	72.85	226600.0
2018-01-18	ABIL-DELISTED	Stock	0.515	0.519	0.485	0.49	111890.0
2018-01-18	ABLX-DELISTED	Stock	42.87	43.15	42.11	42.35	393530.0
2018-01-18	ABM	Stock	38.68	39.19	38.53	38.62	695000.0
2018-01-18	ABMD-DELISTED	Stock	224.76	228.08	224.0	225.89	269547.0

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

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