PREVIEW / stock_daily / 2017-04-18

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-18.parquet
  size:    214 KB
  rows:    6,448
  symbols: 3,028

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
2017-04-18	AAPL	Stock	35.3525	35.51	35.2775	35.3	58790000.0
2017-04-18	MSFT	Stock	65.33	65.71	65.16	65.39	15155600.0
2017-04-18	NVDA	Stock	2.4663	2.4885	2.44	2.4823	370116000.0
2017-04-18	AMZN	Stock	45.0495	45.4805	45.039	45.189	59984000.0
2017-04-18	GOOGL	Stock	42.627	42.8695	42.5625	42.6995	18724020.0
2017-04-18	META	Stock	141.27	141.91	140.61	140.96	14807500.0
2017-04-18	TSLA	Stock	19.98	20.056	19.86	20.0167	45535500.0
2017-04-18	TLT	Stock	123.86	124.98	123.55	124.7	11529704.0
2017-04-18	ES	Stock	60.2	60.5	59.89	60.14	1385700.0
2017-04-18	CL	Stock	74.07	74.88	73.97	74.37	3914500.0
2017-04-18	A	Stock	53.02	53.6	52.68	53.03	1241000.0
2017-04-18	AA	Stock	30.78	32.37	30.45	31.76	5018300.0
2017-04-18	AAAP-DELISTED	Stock	37.65	37.99	37.09	37.97	44228.0
2017-04-18	AABA-DELISTED	Stock	47.25	47.745	47.14	47.57	8612952.0
2017-04-18	AAC-DELISTED	Stock	7.93	7.93	7.46	7.67	104626.0
2017-04-18	AACG	Stock	3.67	3.72	3.66	3.68	6900.0
2017-04-18	AAIC-DELISTED	Stock	14.12	14.3	14.11	14.26	325491.0
2017-04-18	AAL	Stock	44.03	44.53	43.4	43.81	5808900.0
2017-04-18	AAM.A-DELISTED	Stock	25.24	25.255	25.08	25.14	345174.0
2017-04-18	AAMC-DELISTED	Stock	22.0588	22.0588	20.5147	21.4559	24776.0
2017-04-18	AAME	Stock	3.7	3.75	3.7	3.7	3900.0
2017-04-18	AAMI	Stock	14.83	14.94	14.7	14.88	147800.0
2017-04-18	AAOI	Stock	42.6	44.65	42.43	44.2	2232900.0
2017-04-18	AAON	Stock	22.9333	23.2	22.9333	23.0667	153300.0
2017-04-18	AAP	Stock	140.33	141.6	140.33	140.91	646400.0
2017-04-18	AAT	Stock	44.53	44.83	44.38	44.53	282500.0
2017-04-18	AAU-DELISTED	Stock	1.62	1.62	1.58	1.58	276763.0
2017-04-18	AAUAF-DELISTED	Stock	1.62	1.62	1.58	1.6	282670.0
2017-04-18	AAV-DELISTED	Stock	6.65	6.65	6.55	6.55	30336.0
2017-04-18	AAWW-DELISTED	Stock	54.7	55.0	54.25	54.95	65190.0
2017-04-18	AAXJ	Stock	62.38	62.49	62.16	62.36	1535276.0
2017-04-18	AAXN-DELISTED	Stock	22.06	22.51	22.02	22.5	734189.0
2017-04-18	AB	Stock	23.0	23.1	22.75	23.05	208400.0
2017-04-18	ABAC-DELISTED	Stock	2.45	2.51	2.21	2.33	25010.0
2017-04-18	ABAX-DELISTED	Stock	47.21	47.6871	46.67	47.5	38352.0
2017-04-18	ABB-DELISTED	Stock	22.1	22.265	22.04	22.18	1435530.0
2017-04-18	ABBNY-DELISTED	Stock	22.1	22.265	22.04	22.19	1485984.0
2017-04-18	ABBV	Stock	64.03	64.08	63.12	63.65	4755800.0
2017-04-18	ABC-DELISTED	Stock	83.17	83.44	81.13	82.54	4033241.0
2017-04-18	ABCB	Stock	43.5	44.15	43.0	43.6	192400.0
2017-04-18	ABCD-DELISTED	Stock	4.78	4.85	4.77	4.79	13861.0
2017-04-18	ABCO-DELISTED	Stock	46.9	47.3	46.55	46.95	162144.0
2017-04-18	ABDC-DELISTED	Stock	14.11	14.47	14.0876	14.4	58941.0
2017-04-18	ABE-DELISTED	Stock	13.54	13.54	13.38	13.38	13933.0
2017-04-18	ABEO	Stock	121.25	122.5	118.75	121.25	5664.0
2017-04-18	ABEV	Stock	5.79	5.86	5.78	5.79	14985800.0
2017-04-18	ABG	Stock	58.6	59.05	58.1	58.7	248400.0
2017-04-18	ABIL-DELISTED	Stock	1.19	1.19	1.12	1.12	12035.0
2017-04-18	ABM	Stock	42.12	42.67	42.12	42.65	227900.0
2017-04-18	ABMD-DELISTED	Stock	120.44	121.44	117.365	121.18	172998.0

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

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