PREVIEW / stock_daily / 2017-06-07

all stock daily files

  file:    by_date/stock_daily/2017/2017-06-07.parquet
  size:    215 KB
  rows:    6,469
  symbols: 3,013

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-06-07	AAPL	Stock	38.755	38.995	38.62	38.8425	84278400.0
2017-06-07	MSFT	Stock	72.64	72.77	71.95	72.39	22301800.0
2017-06-07	NVDA	Stock	3.7083	3.747	3.6925	3.728	612612000.0
2017-06-07	AMZN	Stock	50.2975	50.5125	50.1	50.5035	56460000.0
2017-06-07	GOOGL	Stock	49.941	50.1955	49.7905	50.0795	27481940.0
2017-06-07	META	Stock	153.27	153.75	152.34	153.12	12066700.0
2017-06-07	TSLA	Stock	23.756	24.0333	23.676	23.9767	140970000.0
2017-06-07	TLT	Stock	125.24	125.52	124.79	124.92	12852353.0
2017-06-07	ES	Stock	62.11	62.98	62.11	62.58	1744200.0
2017-06-07	CL	Stock	77.0	77.27	76.81	77.16	2099500.0
2017-06-07	A	Stock	60.26	60.77	59.98	60.63	1617500.0
2017-06-07	AA	Stock	33.15	33.17	32.4	32.82	3330700.0
2017-06-07	AAAP-DELISTED	Stock	36.35	36.74	35.85	36.51	25090.0
2017-06-07	AABA-DELISTED	Stock	50.53	50.72	50.28	50.55	16760917.0
2017-06-07	AAC-DELISTED	Stock	6.28	6.409	5.99	6.05	126615.0
2017-06-07	AACG	Stock	3.63	3.97	3.61	3.91	90300.0
2017-06-07	AAIC-DELISTED	Stock	14.4	14.4899	14.25	14.31	311457.0
2017-06-07	AAL	Stock	49.44	50.91	48.8	50.86	7078400.0
2017-06-07	AAM.A-DELISTED	Stock	25.53	25.6	25.5	25.57	99469.0
2017-06-07	AAMC-DELISTED	Stock	26.1471	26.1471	25.4706	25.6103	5484.0
2017-06-07	AAME	Stock	3.83	3.85	3.82	3.85	1200.0
2017-06-07	AAMI	Stock	14.45	14.59	14.45	14.49	1295800.0
2017-06-07	AAOI	Stock	73.3	73.87	70.03	71.48	2756500.0
2017-06-07	AAON	Stock	24.3333	24.4333	23.9467	24.0667	120450.0
2017-06-07	AAP	Stock	132.09	133.94	130.37	130.62	996300.0
2017-06-07	AAT	Stock	39.68	40.45	39.65	40.23	220200.0
2017-06-07	AAU-DELISTED	Stock	1.44	1.5	1.4	1.42	192377.0
2017-06-07	AAUAF-DELISTED	Stock	1.44	1.5	1.4	1.43	193834.0
2017-06-07	AAV-DELISTED	Stock	6.25	6.275	6.0	6.1	81400.0
2017-06-07	AAWW-DELISTED	Stock	52.1	52.25	51.65	52.25	196861.0
2017-06-07	AAXJ	Stock	67.66	67.83	67.52	67.77	406028.0
2017-06-07	AAXN-DELISTED	Stock	24.6	24.71	24.17	24.25	444303.0
2017-06-07	AB	Stock	22.75	23.03	22.66	22.9	361500.0
2017-06-07	ABAC-DELISTED	Stock	2.19	2.22	2.02	2.1001	2400.0
2017-06-07	ABAX-DELISTED	Stock	50.45	51.905	50.22	51.02	110291.0
2017-06-07	ABB-DELISTED	Stock	25.43	25.4558	25.21	25.31	1381721.0
2017-06-07	ABBNY-DELISTED	Stock	25.43	25.4558	25.21	25.3	1425666.0
2017-06-07	ABBV	Stock	68.01	69.32	68.01	68.75	8406300.0
2017-06-07	ABC-DELISTED	Stock	91.95	92.23	91.45	91.94	1007335.0
2017-06-07	ABCB	Stock	43.95	44.8	43.9	44.6	159900.0
2017-06-07	ABCD-DELISTED	Stock	5.03	5.06	4.9808	5.03	13955.0
2017-06-07	ABCO-DELISTED	Stock	51.8	51.85	51.1	51.4	420388.0
2017-06-07	ABDC-DELISTED	Stock	13.19	13.25	13.15	13.16	20227.0
2017-06-07	ABE-DELISTED	Stock	13.9175	13.9175	13.8301	13.8401	1229.0
2017-06-07	ABEO	Stock	126.25	128.75	123.75	125.0	4500.0
2017-06-07	ABEV	Stock	5.77	5.82	5.66	5.69	41353300.0
2017-06-07	ABG	Stock	56.45	57.5	56.45	56.6	138900.0
2017-06-07	ABIL-DELISTED	Stock	0.6318	0.91	0.6298	0.8464	922321.0
2017-06-07	ABM	Stock	42.99	43.22	42.42	42.9	382100.0
2017-06-07	ABMD-DELISTED	Stock	142.63	142.9989	141.52	142.02	227847.0

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

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