PREVIEW / stock_daily / 2017-09-25

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-25.parquet
  size:    215 KB
  rows:    6,447
  symbols: 2,942

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-09-25	AAPL	Stock	37.4975	37.9575	37.29	37.6375	177549200.0
2017-09-25	MSFT	Stock	74.09	74.25	72.92	73.26	24149200.0
2017-09-25	NVDA	Stock	4.4438	4.445	4.254	4.275	874580000.0
2017-09-25	AMZN	Stock	47.4655	47.471	46.6445	46.9895	102480000.0
2017-09-25	GOOGL	Stock	46.9725	46.9875	46.2255	46.714	37467500.0
2017-09-25	META	Stock	169.24	169.3	161.56	162.87	41251600.0
2017-09-25	TSLA	Stock	23.5433	23.8313	22.8587	22.9993	114088500.0
2017-09-25	TLT	Stock	126.32	127.27	126.2	126.99	9679004.0
2017-09-25	ES	Stock	60.78	61.55	60.66	61.47	1283600.0
2017-09-25	CL	Stock	73.05	73.91	72.61	73.0	7226300.0
2017-09-25	A	Stock	65.8	65.9	64.44	64.73	1841800.0
2017-09-25	AA	Stock	45.33	45.7	44.62	45.29	3071200.0
2017-09-25	AAAP-DELISTED	Stock	54.3	56.14	54.26	56.06	381164.0
2017-09-25	AABA-DELISTED	Stock	67.0	67.0	64.21	64.96	17184517.0
2017-09-25	AAC-DELISTED	Stock	9.73	10.22	9.73	10.13	179897.0
2017-09-25	AACG	Stock	4.69	4.8	4.69	4.8	1200.0
2017-09-25	AAIC-DELISTED	Stock	13.34	13.35	13.2	13.26	650293.0
2017-09-25	AAL	Stock	46.98	47.96	46.89	47.7	6363200.0
2017-09-25	AAM.A-DELISTED	Stock	26.14	26.2	26.11	26.15	16747.0
2017-09-25	AAMC-DELISTED	Stock	25.8235	25.8235	24.4118	25.0	13909.0
2017-09-25	AAME	Stock	3.24	3.25	3.22	3.25	1500.0
2017-09-25	AAMI	Stock	13.96	14.195	13.9	14.17	291300.0
2017-09-25	AAOI	Stock	62.57	63.8	59.29	61.11	2185600.0
2017-09-25	AAON	Stock	22.1667	22.3333	22.0333	22.2667	129000.0
2017-09-25	AAP	Stock	95.83	98.55	95.39	97.94	2681300.0
2017-09-25	AAT	Stock	39.83	40.41	39.8	40.04	227600.0
2017-09-25	AAU-DELISTED	Stock	1.12	1.19	1.12	1.17	146811.0
2017-09-25	AAUAF-DELISTED	Stock	1.12	1.19	1.12	1.17	156909.0
2017-09-25	AAV-DELISTED	Stock	6.6	6.7	6.6	6.6	49313.0
2017-09-25	AAWW-DELISTED	Stock	67.55	67.9	65.6	65.95	238332.0
2017-09-25	AAXJ	Stock	72.28	72.28	71.32	71.59	984602.0
2017-09-25	AAXN-DELISTED	Stock	22.66	22.7312	22.18	22.58	445888.0
2017-09-25	AB	Stock	24.3	24.6	24.2	24.45	246100.0
2017-09-25	ABAC-DELISTED	Stock	2.3	2.3	2.15	2.17	23416.0
2017-09-25	ABAX-DELISTED	Stock	44.69	45.03	44.36	44.75	44736.0
2017-09-25	ABB-DELISTED	Stock	24.72	24.7875	24.63	24.65	1250584.0
2017-09-25	ABBNY-DELISTED	Stock	24.72	24.7875	24.63	24.65	1293314.0
2017-09-25	ABBV	Stock	86.92	87.78	86.4	86.57	8287000.0
2017-09-25	ABC-DELISTED	Stock	80.23	81.36	80.14	80.98	552574.0
2017-09-25	ABCB	Stock	45.3	45.65	44.85	45.15	156600.0
2017-09-25	ABCD-DELISTED	Stock	6.25	6.51	6.12	6.39	161198.0
2017-09-25	ABCO-DELISTED	Stock	53.45	53.5	53.35	53.4	504604.0
2017-09-25	ABDC-DELISTED	Stock	10.81	11.13	10.81	11.02	67278.0
2017-09-25	ABE-DELISTED	Stock	14.15	14.2705	14.105	14.19	7887.0
2017-09-25	ABEO	Stock	370.0	385.0	342.5	367.5	45552.0
2017-09-25	ABEOW-DELISTED	Stock	10.238	10.25	9.25	9.99	1000.0
2017-09-25	ABEV	Stock	6.8	6.81	6.72	6.75	20550200.0
2017-09-25	ABG	Stock	59.45	60.9	59.45	60.15	177400.0
2017-09-25	ABIL-DELISTED	Stock	0.745	0.79	0.7126	0.7629	72662.0
2017-09-25	ABM	Stock	39.31	39.93	39.31	39.87	197900.0

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

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