PREVIEW / stock_daily / 2018-11-08

all stock daily files

  file:    by_date/stock_daily/2018/2018-11-08.parquet
  size:    222 KB
  rows:    6,557
  symbols: 2,708

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-11-08	AAPL	Stock	52.495	52.53	51.6875	52.1225	101450400.0
2018-11-08	MSFT	Stock	111.8	112.21	110.91	111.75	25644100.0
2018-11-08	NVDA	Stock	5.285	5.2858	5.0958	5.1498	511352000.0
2018-11-08	AMZN	Stock	87.75	89.2	86.2555	87.7455	130698000.0
2018-11-08	GOOGL	Stock	55.365	55.411	54.218	54.7315	33703860.0
2018-11-08	META	Stock	150.49	150.94	146.74	147.87	24145800.0
2018-11-08	TSLA	Stock	23.2333	23.8387	23.2293	23.4267	106360500.0
2018-11-08	TLT	Stock	112.96	112.97	112.41	112.51	6905193.0
2018-11-08	ES	Stock	64.49	64.66	64.04	64.54	1317100.0
2018-11-08	CL	Stock	61.08	61.1	60.38	60.9	5212800.0
2018-11-08	A	Stock	67.99	68.36	67.38	67.79	2444600.0
2018-11-08	AA	Stock	36.86	37.94	36.16	36.38	3763900.0
2018-11-08	AABA-DELISTED	Stock	63.18	63.33	61.63	62.45	3958845.0
2018-11-08	AAC-DELISTED	Stock	3.0	3.13	2.68	2.99	795464.0
2018-11-08	AACG	Stock	1.2	1.21	1.11	1.11	143800.0
2018-11-08	AAIC-DELISTED	Stock	8.7	8.78	8.665	8.69	240420.0
2018-11-08	AAL	Stock	36.77	37.05	35.97	36.86	6884800.0
2018-11-08	AAM.A-DELISTED	Stock	24.67	24.75	24.66	24.68	8761.0
2018-11-08	AAM.B-DELISTED	Stock	24.5	24.545	24.42	24.4268	8998.0
2018-11-08	AAMC-DELISTED	Stock	14.7059	14.7059	13.2353	13.2353	7541.0
2018-11-08	AAME	Stock	3.18	3.6	3.18	3.6	3800.0
2018-11-08	AAMI	Stock	13.16	13.26	12.93	12.98	735700.0
2018-11-08	AAOI	Stock	18.0	22.83	17.95	21.7	4030200.0
2018-11-08	AAON	Stock	28.8	29.9333	28.3333	29.22	490200.0
2018-11-08	AAP	Stock	170.12	173.69	169.45	172.45	1354200.0
2018-11-08	AAT	Stock	38.83	39.08	38.54	39.04	126800.0
2018-11-08	AAU-DELISTED	Stock	0.5212	0.525	0.51	0.518	117107.0
2018-11-08	AAUAF-DELISTED	Stock	0.5212	0.525	0.51	0.518	123494.0
2018-11-08	AAWW-DELISTED	Stock	56.92	56.92	55.64	56.16	68674.0
2018-11-08	AAXJ	Stock	65.9	66.14	65.12	65.35	829703.0
2018-11-08	AAXN-DELISTED	Stock	52.82	52.9	50.29	50.66	915680.0
2018-11-08	AB	Stock	29.91	30.3	29.86	30.09	221000.0
2018-11-08	ABAC-DELISTED	Stock	1.65	1.69	1.65	1.69	302.0
2018-11-08	ABB-DELISTED	Stock	20.6	20.66	20.34	20.38	1399163.0
2018-11-08	ABBNY-DELISTED	Stock	20.6	20.66	20.34	20.39	1456776.0
2018-11-08	ABBV	Stock	87.13	89.71	87.0	87.73	9333200.0
2018-11-08	ABC-DELISTED	Stock	85.87	90.02	84.87	89.18	1839399.0
2018-11-08	ABCB	Stock	43.66	44.79	43.5	44.68	214300.0
2018-11-08	ABCD-DELISTED	Stock	14.43	14.52	14.39	14.49	181995.0
2018-11-08	ABDC-DELISTED	Stock	6.61	6.72	6.54	6.57	76023.0
2018-11-08	ABEO	Stock	218.25	259.25	217.75	247.0	39436.0
2018-11-08	ABEOW-DELISTED	Stock	5.5	5.5	5.5	5.5	1950.0
2018-11-08	ABEV	Stock	4.29	4.32	4.13	4.16	29218700.0
2018-11-08	ABG	Stock	67.82	69.4	67.53	69.0	119100.0
2018-11-08	ABIL-DELISTED	Stock	3.29	3.29	3.2	3.26	24934.0
2018-11-08	ABM	Stock	32.66	32.94	32.28	32.54	215000.0
2018-11-08	ABMD-DELISTED	Stock	409.8	420.18	404.01	413.85	294758.0
2018-11-08	ABR	Stock	12.14	12.17	12.03	12.08	794600.0
2018-11-08	ABR.A-DELISTED	Stock	25.55	25.57	25.52	25.55	8300.0
2018-11-08	ABR.B-DELISTED	Stock	25.47	25.68	25.41	25.41	1818.0

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

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