PREVIEW / stock_daily / 2017-04-19

all stock daily files

  file:    by_date/stock_daily/2017/2017-04-19.parquet
  size:    215 KB
  rows:    6,459
  symbols: 3,035

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-19	AAPL	Stock	35.47	35.5	35.1125	35.17	69313600.0
2017-04-19	MSFT	Stock	65.65	65.75	64.89	65.04	26992800.0
2017-04-19	NVDA	Stock	2.5	2.5245	2.4852	2.492	380828000.0
2017-04-19	AMZN	Stock	45.392	45.525	44.8685	44.96	57404000.0
2017-04-19	GOOGL	Stock	42.8692	43.01	42.6764	42.8255	21606720.0
2017-04-19	META	Stock	141.35	143.04	141.27	142.27	15563900.0
2017-04-19	TSLA	Stock	20.164	20.4413	20.1407	20.368	58470000.0
2017-04-19	TLT	Stock	124.1	124.169	123.7	124.02	7343991.0
2017-04-19	ES	Stock	60.12	60.14	59.33	59.64	1414700.0
2017-04-19	CL	Stock	73.81	73.89	73.22	73.39	3246100.0
2017-04-19	A	Stock	53.35	53.42	52.95	53.07	2095700.0
2017-04-19	AA	Stock	32.18	32.44	31.28	31.3	2465500.0
2017-04-19	AAAP-DELISTED	Stock	37.9	38.1	36.89	36.89	31004.0
2017-04-19	AABA-DELISTED	Stock	47.64	47.88	46.925	47.01	11606103.0
2017-04-19	AAC-DELISTED	Stock	7.71	7.82	7.46	7.54	99125.0
2017-04-19	AACG	Stock	3.74	3.79	3.65	3.66	28200.0
2017-04-19	AAIC-DELISTED	Stock	14.31	14.46	14.27	14.29	235887.0
2017-04-19	AAL	Stock	44.07	44.78	43.9	44.4	6573400.0
2017-04-19	AAM.A-DELISTED	Stock	25.14	25.18	25.09	25.12	179884.0
2017-04-19	AAMC-DELISTED	Stock	21.5294	21.6176	21.2723	21.4706	23038.0
2017-04-19	AAMI	Stock	14.95	15.0	14.85	14.96	193500.0
2017-04-19	AAOI	Stock	44.34	44.899	43.08	43.73	1678300.0
2017-04-19	AAON	Stock	23.1667	23.3333	23.0667	23.2667	171300.0
2017-04-19	AAP	Stock	141.53	144.77	141.53	142.42	1230100.0
2017-04-19	AAT	Stock	44.66	44.81	44.43	44.51	271600.0
2017-04-19	AAU-DELISTED	Stock	1.52	1.5999	1.45	1.46	632844.0
2017-04-19	AAUAF-DELISTED	Stock	1.52	1.5999	1.45	1.48	635574.0
2017-04-19	AAV-DELISTED	Stock	6.6	6.6	6.425	6.5	59032.0
2017-04-19	AAWW-DELISTED	Stock	55.3	56.2	55.3	55.8	127219.0
2017-04-19	AAXJ	Stock	62.45	62.45	61.965	62.07	1828593.0
2017-04-19	AAXN-DELISTED	Stock	22.55	22.91	22.545	22.735	371422.0
2017-04-19	AB	Stock	23.2	23.2	22.8	23.0	233400.0
2017-04-19	ABAC-DELISTED	Stock	2.39	2.44	2.3101	2.32	13683.0
2017-04-19	ABAX-DELISTED	Stock	47.62	48.43	47.62	47.98	50148.0
2017-04-19	ABB-DELISTED	Stock	22.25	22.36	22.23	22.27	2255005.0
2017-04-19	ABBNY-DELISTED	Stock	22.26	22.36	22.23	22.27	6246002.0
2017-04-19	ABBV	Stock	63.9	63.93	63.31	63.45	4057100.0
2017-04-19	ABC-DELISTED	Stock	82.64	83.09	81.62	81.87	1675175.0
2017-04-19	ABCB	Stock	43.9	44.7	43.9	44.55	135900.0
2017-04-19	ABCD-DELISTED	Stock	4.86	4.88	4.75	4.79	17840.0
2017-04-19	ABCO-DELISTED	Stock	47.1	47.55	47.0	47.25	294874.0
2017-04-19	ABDC-DELISTED	Stock	14.31	14.4999	14.08	14.29	32139.0
2017-04-19	ABE-DELISTED	Stock	13.42	13.4525	13.13	13.22	12759.0
2017-04-19	ABEO	Stock	121.25	130.0	120.0	126.25	11552.0
2017-04-19	ABEOW-DELISTED	Stock	2.75	2.75	2.75	2.75	100.0
2017-04-19	ABEV	Stock	5.76	5.78	5.7	5.71	13246000.0
2017-04-19	ABG	Stock	59.2	61.8	59.2	61.0	367100.0
2017-04-19	ABIL-DELISTED	Stock	1.11	1.14	1.07	1.1	87423.0
2017-04-19	ABM	Stock	42.65	42.92	42.53	42.65	230800.0
2017-04-19	ABMD-DELISTED	Stock	121.26	123.67	121.26	123.12	233225.0

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

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