PREVIEW / stock_daily / 2018-05-23

all stock daily files

  file:    by_date/stock_daily/2018/2018-05-23.parquet
  size:    217 KB
  rows:    6,515
  symbols: 2,816

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-05-23	AAPL	Stock	46.5875	47.125	46.44	47.09	80233600.0
2018-05-23	MSFT	Stock	96.71	98.73	96.32	98.66	21251200.0
2018-05-23	NVDA	Stock	6.007	6.1898	6.0063	6.1885	442956000.0
2018-05-23	AMZN	Stock	78.5525	80.093	78.317	80.093	67238000.0
2018-05-23	GOOGL	Stock	53.5	54.4	53.348	54.298	23739960.0
2018-05-23	META	Stock	182.5	186.91	182.18	186.9	16628100.0
2018-05-23	TSLA	Stock	18.5173	18.6607	18.2667	18.6047	89776500.0
2018-05-23	TLT	Stock	117.75	118.11	117.6552	117.94	9633993.0
2018-05-23	ES	Stock	57.43	57.85	55.31	56.54	5314600.0
2018-05-23	CL	Stock	62.4	63.01	62.23	62.72	3409500.0
2018-05-23	A	Stock	64.21	65.0	64.21	64.53	3222400.0
2018-05-23	AA	Stock	49.26	49.38	48.31	48.57	2276100.0
2018-05-23	AABA-DELISTED	Stock	75.84	76.72	75.44	76.54	6623796.0
2018-05-23	AAC-DELISTED	Stock	11.6	11.96	11.38	11.69	175507.0
2018-05-23	AACG	Stock	5.27	5.27	5.15	5.15	1200.0
2018-05-23	AAIC-DELISTED	Stock	11.26	11.325	11.2101	11.3	287011.0
2018-05-23	AAL	Stock	42.64	42.87	42.27	42.8	3915900.0
2018-05-23	AAM.A-DELISTED	Stock	25.33	25.3553	25.2887	25.3015	11345.0
2018-05-23	AAM.B-DELISTED	Stock	24.97	24.97	24.82	24.92	34271.0
2018-05-23	AAMC-DELISTED	Stock	19.0294	19.3897	18.2353	19.0	8877.0
2018-05-23	AAME	Stock	2.85	2.85	2.75	2.75	2300.0
2018-05-23	AAMI	Stock	15.66	15.66	15.37	15.49	271800.0
2018-05-23	AAOI	Stock	33.0	33.75	32.77	33.67	508100.0
2018-05-23	AAON	Stock	20.6667	20.7333	20.5	20.6667	227550.0
2018-05-23	AAP	Stock	115.82	123.63	115.63	123.25	1964800.0
2018-05-23	AAT	Stock	35.02	35.83	34.94	35.47	161400.0
2018-05-23	AAU-DELISTED	Stock	0.71	0.7397	0.71	0.7197	147606.0
2018-05-23	AAUAF-DELISTED	Stock	0.71	0.7397	0.71	0.7197	153360.0
2018-05-23	AAV-DELISTED	Stock	3.1	3.15	3.0	3.0	164755.0
2018-05-23	AAWW-DELISTED	Stock	68.35	68.35	66.6	67.9	90675.0
2018-05-23	AAXJ	Stock	75.77	76.61	75.76	76.61	621323.0
2018-05-23	AAXN-DELISTED	Stock	61.26	61.96	59.16	59.79	1563580.0
2018-05-23	AB	Stock	28.15	28.35	27.75	28.2	458600.0
2018-05-23	ABAC-DELISTED	Stock	2.2286	2.24	2.17	2.24	8035.0
2018-05-23	ABAX-DELISTED	Stock	83.04	83.68	82.955	83.0	455710.0
2018-05-23	ABB-DELISTED	Stock	24.04	24.08	23.7948	23.91	2153973.0
2018-05-23	ABBNY-DELISTED	Stock	24.04	24.08	23.7948	23.91	3024154.0
2018-05-23	ABBV	Stock	105.85	106.32	104.74	105.6	12816600.0
2018-05-23	ABC-DELISTED	Stock	83.88	84.63	83.35	83.96	796445.0
2018-05-23	ABCB	Stock	56.45	56.6	56.0	56.35	116100.0
2018-05-23	ABCD-DELISTED	Stock	9.6	9.9	9.6	9.88	181636.0
2018-05-23	ABDC-DELISTED	Stock	6.67	6.74	6.51	6.65	73817.0
2018-05-23	ABEO	Stock	405.0	426.25	400.0	401.25	34048.0
2018-05-23	ABEOW-DELISTED	Stock	11.75	11.92	11.7	11.92	1510.0
2018-05-23	ABEV	Stock	5.5	5.54	5.47	5.51	23445900.0
2018-05-23	ABG	Stock	69.4	69.9	68.45	68.85	135700.0
2018-05-23	ABIL-DELISTED	Stock	2.58	2.62	2.4232	2.44	21431.0
2018-05-23	ABLX-DELISTED	Stock	52.58	52.76	52.58	52.73	3130.0
2018-05-23	ABM	Stock	29.75	29.79	29.2	29.38	694200.0
2018-05-23	ABMD-DELISTED	Stock	384.6	396.47	384.2	395.77	327731.0

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

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