PREVIEW / stock_daily / 2017-03-16

all stock daily files

  file:    by_date/stock_daily/2017/2017-03-16.parquet
  size:    215 KB
  rows:    6,478
  symbols: 3,066

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-03-16	AAPL	Stock	35.18	35.255	35.065	35.1725	76928000.0
2017-03-16	MSFT	Stock	64.75	64.76	64.3	64.64	20674300.0
2017-03-16	NVDA	Stock	2.5745	2.5958	2.5602	2.5952	523100000.0
2017-03-16	AMZN	Stock	42.765	42.775	42.5255	42.671	36846000.0
2017-03-16	GOOGL	Stock	43.5265	43.6355	43.376	43.5	22089040.0
2017-03-16	META	Stock	140.2	140.25	139.73	139.99	13612900.0
2017-03-16	TSLA	Stock	17.4933	17.7167	17.2707	17.47	106983000.0
2017-03-16	TLT	Stock	117.99	118.15	117.63	117.9	8018165.0
2017-03-16	ES	Stock	58.85	58.95	58.4	58.54	1047600.0
2017-03-16	CL	Stock	73.83	74.03	73.57	73.9	3182200.0
2017-03-16	A	Stock	53.43	54.05	52.83	53.05	2676900.0
2017-03-16	AA	Stock	35.66	35.99	34.98	35.38	3644300.0
2017-03-16	AAAP-DELISTED	Stock	36.8	36.94	36.38	36.48	90725.0
2017-03-16	AABA-DELISTED	Stock	46.6	46.62	46.3	46.61	3288643.0
2017-03-16	AAC-DELISTED	Stock	8.88	8.955	8.56	8.58	123165.0
2017-03-16	AACG	Stock	3.69	3.79	3.69	3.77	5100.0
2017-03-16	AAIC-DELISTED	Stock	14.27	14.33	14.04	14.19	352238.0
2017-03-16	AAL	Stock	42.18	42.35	41.45	42.13	7058300.0
2017-03-16	AAM.A-DELISTED	Stock	24.85	24.94	24.83	24.85	162454.0
2017-03-16	AAMC-DELISTED	Stock	22.0294	22.5735	20.6471	21.6176	16170.0
2017-03-16	AAME	Stock	3.95	3.95	3.95	3.95	300.0
2017-03-16	AAMI	Stock	15.03	15.17	14.96	15.07	182500.0
2017-03-16	AAOI	Stock	47.8	48.3	46.61	47.96	1216100.0
2017-03-16	AAON	Stock	24.1333	24.4	24.1	24.3667	223950.0
2017-03-16	AAP	Stock	152.74	153.77	151.83	153.41	583400.0
2017-03-16	AAT	Stock	42.62	43.06	42.52	42.6	207200.0
2017-03-16	AAU-DELISTED	Stock	1.08	1.09	1.01	1.04	226686.0
2017-03-16	AAUAF-DELISTED	Stock	1.08	1.09	1.01	1.04	227738.0
2017-03-16	AAV-DELISTED	Stock	6.1	6.15	5.975	6.0	91008.0
2017-03-16	AAWW-DELISTED	Stock	54.45	54.7	53.55	53.75	92927.0
2017-03-16	AAXJ	Stock	62.85	63.035	62.72	62.92	2113557.0
2017-03-16	AAXN-DELISTED	Stock	23.03	23.19	22.718	22.755	626927.0
2017-03-16	AB	Stock	22.6	22.9	22.6	22.65	320700.0
2017-03-16	ABAC-DELISTED	Stock	2.35	2.37	2.25	2.32	9931.0
2017-03-16	ABAX-DELISTED	Stock	48.94	49.16	48.51	48.99	44553.0
2017-03-16	ABB-DELISTED	Stock	23.04	23.15	23.03	23.12	2059549.0
2017-03-16	ABBNY-DELISTED	Stock	23.04	23.15	23.03	23.13	2121133.0
2017-03-16	ABBV	Stock	66.4	66.45	65.55	65.9	5162800.0
2017-03-16	ABC-DELISTED	Stock	89.58	89.76	87.89	87.97	1336279.0
2017-03-16	ABCB	Stock	47.05	47.75	46.75	47.7	248100.0
2017-03-16	ABCD-DELISTED	Stock	4.86	5.05	4.84	5.03	61795.0
2017-03-16	ABCO-DELISTED	Stock	45.35	45.5	44.475	44.8	242191.0
2017-03-16	ABDC-DELISTED	Stock	13.3	13.47	13.08	13.4	50877.0
2017-03-16	ABE-DELISTED	Stock	12.46	12.4999	12.45	12.46	32850.0
2017-03-16	ABEO	Stock	128.75	131.25	126.25	127.5	6540.0
2017-03-16	ABEV	Stock	5.51	5.56	5.48	5.53	10125400.0
2017-03-16	ABG	Stock	62.55	63.4	62.15	62.9	195100.0
2017-03-16	ABIL-DELISTED	Stock	2.3692	2.3692	2.32	2.32	4636.0
2017-03-16	ABM	Stock	44.4	44.58	44.15	44.43	212800.0
2017-03-16	ABMD-DELISTED	Stock	123.0	123.2	121.84	122.94	106524.0

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

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