PREVIEW / stock_daily / 2017-02-09

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-09.parquet
  size:    216 KB
  rows:    6,481
  symbols: 3,088

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-02-09	AAPL	Stock	32.9125	33.1125	32.78	33.105	113399600.0
2017-02-09	MSFT	Stock	63.52	64.44	63.32	64.06	22644400.0
2017-02-09	NVDA	Stock	2.9715	2.9765	2.89	2.9095	842568000.0
2017-02-09	AMZN	Stock	41.08	41.25	40.9855	41.068	49698000.0
2017-02-09	GOOGL	Stock	41.5865	41.599	41.325	41.503	23884760.0
2017-02-09	META	Stock	134.49	134.5	133.31	134.14	16470600.0
2017-02-09	TSLA	Stock	17.75	18.0787	17.7433	17.9467	117303000.0
2017-02-09	TLT	Stock	121.41	121.59	120.66	120.83	16890586.0
2017-02-09	ES	Stock	56.35	56.62	56.0	56.05	1087700.0
2017-02-09	CL	Stock	66.59	66.81	66.26	66.6	3223700.0
2017-02-09	A	Stock	49.93	50.8	49.93	50.47	2557700.0
2017-02-09	AA	Stock	37.41	37.75	36.994	37.42	3392400.0
2017-02-09	AAAP-DELISTED	Stock	35.0	35.5	34.935	35.25	316040.0
2017-02-09	AABA-DELISTED	Stock	44.95	45.24	44.82	45.07	3360422.0
2017-02-09	AAC-DELISTED	Stock	7.87	7.97	7.75	7.9	81666.0
2017-02-09	AACG	Stock	3.27	3.47	3.25	3.44	13900.0
2017-02-09	AAIC-DELISTED	Stock	14.85	14.89	14.68	14.69	494113.0
2017-02-09	AAL	Stock	45.07	46.6	44.94	46.3	7089900.0
2017-02-09	AAMC-DELISTED	Stock	23.0147	23.0147	21.1912	21.5591	20186.0
2017-02-09	AAMI	Stock	14.51	14.82	14.48	14.64	243900.0
2017-02-09	AAOI	Stock	31.4	32.6	31.15	31.75	441400.0
2017-02-09	AAON	Stock	22.7333	23.0	22.7	22.9	168600.0
2017-02-09	AAP	Stock	162.26	165.17	161.31	164.83	1102000.0
2017-02-09	AAT	Stock	43.21	43.43	43.09	43.19	76000.0
2017-02-09	AAU-DELISTED	Stock	1.24	1.24	1.15	1.19	387513.0
2017-02-09	AAUAF-DELISTED	Stock	1.24	1.24	1.15	1.19	407430.0
2017-02-09	AAV-DELISTED	Stock	6.45	6.7	6.4	6.65	191891.0
2017-02-09	AAWW-DELISTED	Stock	50.95	52.35	50.75	51.65	115864.0
2017-02-09	AAXJ	Stock	59.97	60.08	59.88	59.96	420634.0
2017-02-09	AAXN-DELISTED	Stock	26.5	27.17	26.4	26.89	550517.0
2017-02-09	AB	Stock	23.25	23.3	23.1	23.25	183900.0
2017-02-09	ABAC-DELISTED	Stock	3.6201	3.72	3.58	3.58	750.0
2017-02-09	ABAX-DELISTED	Stock	50.01	50.37	49.78	50.29	107937.0
2017-02-09	ABB-DELISTED	Stock	22.85	22.88	22.73	22.765	1986277.0
2017-02-09	ABBNY-DELISTED	Stock	22.85	22.88	22.73	22.77	2049295.0
2017-02-09	ABBV	Stock	60.52	61.0	60.42	60.84	4324600.0
2017-02-09	ABC-DELISTED	Stock	91.05	91.78	90.16	91.63	1366022.0
2017-02-09	ABCB	Stock	45.15	46.2	45.15	46.15	123300.0
2017-02-09	ABCD-DELISTED	Stock	5.0	5.05	4.91	4.96	15114.0
2017-02-09	ABCO-DELISTED	Stock	46.75	47.4	46.65	47.2	639790.0
2017-02-09	ABDC-DELISTED	Stock	12.27	12.49	12.1401	12.39	49454.0
2017-02-09	ABE-DELISTED	Stock	12.013	12.0205	12.0	12.0155	4303.0
2017-02-09	ABEO	Stock	128.75	132.5	126.25	126.25	6404.0
2017-02-09	ABEOW-DELISTED	Stock	3.0	3.0	3.0	3.0	1026.0
2017-02-09	ABEV	Stock	5.39	5.43	5.34	5.34	18919700.0
2017-02-09	ABG	Stock	65.8	66.35	65.0	65.55	368200.0
2017-02-09	ABIL-DELISTED	Stock	3.29	3.54	3.28	3.48	64382.0
2017-02-09	ABM	Stock	40.03	40.53	39.66	40.29	352500.0
2017-02-09	ABMD-DELISTED	Stock	109.0	109.44	107.33	108.44	296216.0
2017-02-09	ABR	Stock	7.36	7.36	7.26	7.3	102800.0

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

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