PREVIEW / stock_daily / 2017-05-09

all stock daily files

  file:    by_date/stock_daily/2017/2017-05-09.parquet
  size:    214 KB
  rows:    6,439
  symbols: 3,006

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-05-09	AAPL	Stock	38.4675	38.72	38.3625	38.4975	156521600.0
2017-05-09	MSFT	Stock	68.86	69.28	68.68	69.04	22858400.0
2017-05-09	NVDA	Stock	2.575	2.6233	2.5665	2.5735	847672000.0
2017-05-09	AMZN	Stock	47.64	47.8945	47.51	47.641	65242000.0
2017-05-09	GOOGL	Stock	48.0665	48.11	47.72	47.8355	33758840.0
2017-05-09	META	Stock	151.49	152.59	150.21	150.48	17453900.0
2017-05-09	TSLA	Stock	20.6253	21.466	20.6067	21.4173	145147500.0
2017-05-09	TLT	Stock	120.38	120.63	120.14	120.62	5536746.0
2017-05-09	ES	Stock	59.6	59.82	59.28	59.35	899700.0
2017-05-09	CL	Stock	71.85	72.12	71.37	71.5	2251200.0
2017-05-09	A	Stock	56.42	56.89	56.29	56.87	1559200.0
2017-05-09	AA	Stock	31.22	31.24	30.46	30.82	3415300.0
2017-05-09	AAAP-DELISTED	Stock	37.26	37.27	36.3	36.87	55751.0
2017-05-09	AABA-DELISTED	Stock	49.18	49.67	48.94	49.48	9672369.0
2017-05-09	AAC-DELISTED	Stock	7.21	7.21	7.02	7.09	65969.0
2017-05-09	AACG	Stock	3.71	3.8	3.65	3.8	15800.0
2017-05-09	AAIC-DELISTED	Stock	14.36	14.39	14.07	14.17	349223.0
2017-05-09	AAL	Stock	45.4	47.3	45.25	47.08	11116800.0
2017-05-09	AAM.A-DELISTED	Stock	25.67	25.78	25.6	25.7	90783.0
2017-05-09	AAMC-DELISTED	Stock	21.2794	22.2059	20.9853	22.2059	13658.0
2017-05-09	AAME	Stock	3.76	3.76	3.75	3.75	800.0
2017-05-09	AAMI	Stock	15.3	15.64	15.2	15.62	308400.0
2017-05-09	AAOI	Stock	57.75	62.64	56.01	62.11	5046800.0
2017-05-09	AAON	Stock	24.6333	24.8	24.3333	24.6667	227100.0
2017-05-09	AAP	Stock	146.81	147.11	144.79	146.12	807800.0
2017-05-09	AAT	Stock	40.52	40.52	39.87	40.02	300900.0
2017-05-09	AAU-DELISTED	Stock	1.31	1.37	1.26	1.285	259523.0
2017-05-09	AAUAF-DELISTED	Stock	1.31	1.37	1.26	1.3	270304.0
2017-05-09	AAV-DELISTED	Stock	6.2	6.2	6.075	6.1	100498.0
2017-05-09	AAWW-DELISTED	Stock	52.45	52.85	52.3	52.35	213330.0
2017-05-09	AAXJ	Stock	65.07	65.48	64.97	65.31	1903119.0
2017-05-09	AAXN-DELISTED	Stock	24.9	25.51	24.9	25.18	1172456.0
2017-05-09	AB	Stock	20.9	21.15	20.85	21.05	558700.0
2017-05-09	ABAC-DELISTED	Stock	1.73	1.816	1.68	1.73	21813.0
2017-05-09	ABAX-DELISTED	Stock	47.93	48.15	47.64	48.04	74206.0
2017-05-09	ABB-DELISTED	Stock	24.65	24.7	24.505	24.56	1567461.0
2017-05-09	ABBNY-DELISTED	Stock	24.65	24.7	24.505	24.56	1670705.0
2017-05-09	ABBV	Stock	66.2	66.95	65.86	66.17	4395200.0
2017-05-09	ABC-DELISTED	Stock	86.7	88.21	86.67	87.54	1467928.0
2017-05-09	ABCB	Stock	47.2	47.5	46.45	46.7	117600.0
2017-05-09	ABCD-DELISTED	Stock	5.36	5.37	5.02	5.16	46657.0
2017-05-09	ABCO-DELISTED	Stock	51.25	51.95	49.06	51.7	290712.0
2017-05-09	ABDC-DELISTED	Stock	14.47	14.5	14.1918	14.22	23378.0
2017-05-09	ABE-DELISTED	Stock	13.7307	13.8	13.7307	13.78	4807.0
2017-05-09	ABEO	Stock	141.25	147.5	141.25	145.0	5316.0
2017-05-09	ABEOW-DELISTED	Stock	2.8	2.8	2.7999	2.7999	1100.0
2017-05-09	ABEV	Stock	5.88	5.97	5.86	5.94	29721600.0
2017-05-09	ABG	Stock	59.3	59.7	58.4	58.45	147500.0
2017-05-09	ABIL-DELISTED	Stock	0.75	0.8	0.75	0.75	15495.0
2017-05-09	ABM	Stock	43.1	43.23	42.81	43.2	206000.0

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

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