PREVIEW / stock_daily / 2017-08-21

all stock daily files

  file:    by_date/stock_daily/2017/2017-08-21.parquet
  size:    213 KB
  rows:    6,427
  symbols: 2,941

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-08-21	AAPL	Stock	39.375	39.4725	38.7775	39.3025	105474000.0
2017-08-21	MSFT	Stock	72.47	72.48	71.7	72.15	17734800.0
2017-08-21	NVDA	Stock	4.0623	4.0737	3.9343	3.9788	623672000.0
2017-08-21	AMZN	Stock	47.8785	48.06	47.273	47.6645	63290000.0
2017-08-21	GOOGL	Stock	46.2885	46.4125	45.93	46.0435	26024860.0
2017-08-21	META	Stock	167.16	168.0	165.82	167.78	11907500.0
2017-08-21	TSLA	Stock	23.0547	23.0547	22.1233	22.524	97431000.0
2017-08-21	TLT	Stock	126.77	127.02	126.5	126.93	7669826.0
2017-08-21	ES	Stock	63.12	63.18	62.74	62.97	1275300.0
2017-08-21	CL	Stock	71.08	71.75	71.08	71.61	2436300.0
2017-08-21	A	Stock	61.09	62.0	60.96	61.74	1486100.0
2017-08-21	AA	Stock	38.19	38.66	38.05	38.47	2336800.0
2017-08-21	AAAP-DELISTED	Stock	46.675	48.79	45.31	48.65	60185.0
2017-08-21	AABA-DELISTED	Stock	63.15	64.0	62.9	63.62	3421479.0
2017-08-21	AAC-DELISTED	Stock	9.08	9.15	8.79	8.98	128121.0
2017-08-21	AACG	Stock	4.67	4.72	4.67	4.72	9100.0
2017-08-21	AAIC-DELISTED	Stock	12.9	12.9	12.62	12.76	432894.0
2017-08-21	AAL	Stock	45.73	46.09	45.41	45.71	4353900.0
2017-08-21	AAM.A-DELISTED	Stock	26.15	26.15	26.0501	26.07	8649.0
2017-08-21	AAMC-DELISTED	Stock	23.0	23.0	22.6129	22.6404	7358.0
2017-08-21	AAME	Stock	3.4	3.45	3.35	3.35	500.0
2017-08-21	AAMI	Stock	13.32	13.63	13.28	13.57	483200.0
2017-08-21	AAOI	Stock	63.93	64.418	60.05	60.6	3114200.0
2017-08-21	AAON	Stock	21.1333	21.3	20.9	21.1333	237150.0
2017-08-21	AAP	Stock	93.93	95.95	93.52	95.19	1968900.0
2017-08-21	AAT	Stock	39.83	40.65	39.73	40.43	137900.0
2017-08-21	AAU-DELISTED	Stock	1.12	1.14	1.08	1.11	120074.0
2017-08-21	AAUAF-DELISTED	Stock	1.12	1.14	1.08	1.11	123673.0
2017-08-21	AAV-DELISTED	Stock	6.45	6.45	6.275	6.35	87954.0
2017-08-21	AAWW-DELISTED	Stock	61.7	62.2	61.7	61.8	129716.0
2017-08-21	AAXJ	Stock	70.45	70.51	70.18	70.44	378125.0
2017-08-21	AAXN-DELISTED	Stock	22.03	22.14	21.85	22.08	650201.0
2017-08-21	AB	Stock	23.05	23.73	23.05	23.35	285900.0
2017-08-21	ABAC-DELISTED	Stock	2.06	2.06	2.03	2.06	7670.0
2017-08-21	ABAX-DELISTED	Stock	46.52	46.86	46.25	46.55	29165.0
2017-08-21	ABB-DELISTED	Stock	22.75	22.83	22.67	22.78	921445.0
2017-08-21	ABBNY-DELISTED	Stock	22.75	22.83	22.67	22.76	948050.0
2017-08-21	ABBV	Stock	69.92	70.83	69.91	70.7	4666400.0
2017-08-21	ABC-DELISTED	Stock	78.43	78.59	77.9	78.055	1192996.0
2017-08-21	ABCB	Stock	43.35	43.6	42.8	43.45	108600.0
2017-08-21	ABCD-DELISTED	Stock	5.18	5.3	5.13	5.15	92696.0
2017-08-21	ABCO-DELISTED	Stock	51.6	51.85	51.1	51.65	306924.0
2017-08-21	ABDC-DELISTED	Stock	10.65	10.87	10.55	10.64	28991.0
2017-08-21	ABE-DELISTED	Stock	14.14	14.14	13.8301	13.8448	1490.0
2017-08-21	ABEO	Stock	196.25	203.75	187.5	196.25	20136.0
2017-08-21	ABEOW-DELISTED	Stock	4.05	4.1	4.05	4.1	400.0
2017-08-21	ABEV	Stock	6.22	6.27	6.16	6.18	9092400.0
2017-08-21	ABG	Stock	50.6	51.4	50.25	50.85	103700.0
2017-08-21	ABIL-DELISTED	Stock	0.65	0.672	0.6	0.62	92000.0
2017-08-21	ABM	Stock	42.93	43.17	42.72	43.04	105500.0

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

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