PREVIEW / stock_daily / 2018-03-16

all stock daily files

  file:    by_date/stock_daily/2018/2018-03-16.parquet
  size:    218 KB
  rows:    6,494
  symbols: 2,847

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-03-16	AAPL	Stock	44.6625	44.78	44.405	44.505	157618800.0
2018-03-16	MSFT	Stock	94.68	95.38	93.92	94.6	49081300.0
2018-03-16	NVDA	Stock	6.25	6.2812	6.212	6.262	399456000.0
2018-03-16	AMZN	Stock	79.1725	79.472	78.375	78.584	108500000.0
2018-03-16	GOOGL	Stock	57.7675	57.8405	56.568	56.721	58655180.0
2018-03-16	META	Stock	184.49	185.33	183.41	185.09	24403400.0
2018-03-16	TSLA	Stock	21.5287	21.8267	21.2713	21.4233	91759500.0
2018-03-16	TLT	Stock	119.8	120.01	119.55	119.81	6084329.0
2018-03-16	ES	Stock	57.72	58.48	57.66	58.26	3854500.0
2018-03-16	CL	Stock	69.63	69.97	69.44	69.62	7050400.0
2018-03-16	A	Stock	69.92	70.34	69.05	69.9	3378100.0
2018-03-16	AA	Stock	46.8	47.919	46.74	47.23	3129700.0
2018-03-16	AABA-DELISTED	Stock	79.05	80.05	78.8	79.81	5807973.0
2018-03-16	AAC-DELISTED	Stock	12.69	12.92	12.68	12.88	160904.0
2018-03-16	AACG	Stock	5.38	5.38	5.2	5.2	56900.0
2018-03-16	AAIC-DELISTED	Stock	11.68	11.899	11.62	11.78	705572.0
2018-03-16	AAL	Stock	55.31	56.41	55.27	55.4	4574400.0
2018-03-16	AAM.A-DELISTED	Stock	25.19	25.2	25.11	25.1601	56600.0
2018-03-16	AAMC-DELISTED	Stock	18.3971	18.5	17.7059	18.5	14681.0
2018-03-16	AAME	Stock	3.21	3.3	3.2	3.2	2800.0
2018-03-16	AAMI	Stock	15.72	15.9	15.58	15.75	659600.0
2018-03-16	AAOI	Stock	27.38	27.38	26.57	26.78	1338700.0
2018-03-16	AAON	Stock	25.8667	26.0667	25.7667	26.0667	697050.0
2018-03-16	AAP	Stock	116.93	117.81	115.76	116.63	1354400.0
2018-03-16	AAT	Stock	32.93	33.3	32.89	33.22	1078200.0
2018-03-16	AAU-DELISTED	Stock	0.81	0.85	0.8	0.85	324871.0
2018-03-16	AAUAF-DELISTED	Stock	0.81	0.85	0.8	0.846	329553.0
2018-03-16	AAV-DELISTED	Stock	2.85	3.0	2.8	2.9	254954.0
2018-03-16	AAWW-DELISTED	Stock	62.75	64.45	62.5	64.2	322684.0
2018-03-16	AAXJ	Stock	79.44	79.65	79.36	79.51	439445.0
2018-03-16	AAXN-DELISTED	Stock	37.95	38.39	37.54	37.96	1831995.0
2018-03-16	AB	Stock	26.1	26.8	26.05	26.6	240800.0
2018-03-16	ABAC-DELISTED	Stock	2.5	2.5	2.45	2.45	365.0
2018-03-16	ABAX-DELISTED	Stock	74.34	75.3399	74.12	74.97	385419.0
2018-03-16	ABB-DELISTED	Stock	24.12	24.29	24.1067	24.24	1419583.0
2018-03-16	ABBNY-DELISTED	Stock	24.12	24.29	24.1067	24.25	1470084.0
2018-03-16	ABBV	Stock	114.89	116.73	113.59	113.71	8879300.0
2018-03-16	ABC-DELISTED	Stock	97.43	98.23	96.46	96.63	1363604.0
2018-03-16	ABCB	Stock	56.8	57.4	56.45	56.5	752100.0
2018-03-16	ABCD-DELISTED	Stock	9.66	10.31	9.51	10.11	233473.0
2018-03-16	ABDC-DELISTED	Stock	6.25	6.34	6.25	6.27	259838.0
2018-03-16	ABE-DELISTED	Stock	15.28	15.3	15.19	15.285	4447.0
2018-03-16	ABEO	Stock	380.0	389.5	373.75	383.75	40996.0
2018-03-16	ABEV	Stock	7.22	7.23	7.13	7.13	14089100.0
2018-03-16	ABG	Stock	68.75	69.45	68.4	69.05	387600.0
2018-03-16	ABIL-DELISTED	Stock	0.3889	0.4398	0.38	0.4	294437.0
2018-03-16	ABLX-DELISTED	Stock	53.96	54.09	53.74	54.0	26922.0
2018-03-16	ABM	Stock	34.74	35.07	34.4	34.98	1296100.0
2018-03-16	ABMD-DELISTED	Stock	295.13	297.6139	289.27	293.02	461985.0
2018-03-16	ABR	Stock	8.85	8.91	8.82	8.88	468300.0

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

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