PREVIEW / stock_daily / 2017-09-11

all stock daily files

  file:    by_date/stock_daily/2017/2017-09-11.parquet
  size:    213 KB
  rows:    6,447
  symbols: 2,943

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-11	AAPL	Stock	40.125	40.5125	39.9725	40.375	126323200.0
2017-09-11	MSFT	Stock	74.31	74.94	74.31	74.76	17910400.0
2017-09-11	NVDA	Stock	4.1385	4.2358	4.133	4.225	567444000.0
2017-09-11	AMZN	Stock	48.723	49.097	48.711	48.898	43734000.0
2017-09-11	GOOGL	Stock	47.36	47.634	47.05	47.1645	26747300.0
2017-09-11	META	Stock	172.4	173.89	172.2	173.51	12372000.0
2017-09-11	TSLA	Stock	23.4233	24.2473	23.3333	24.246	115006500.0
2017-09-11	TLT	Stock	127.87	128.05	127.26	127.46	17856690.0
2017-09-11	ES	Stock	63.44	64.19	63.25	64.11	1393900.0
2017-09-11	CL	Stock	71.82	72.15	71.72	72.02	2351700.0
2017-09-11	A	Stock	65.5	66.27	65.38	66.11	1770000.0
2017-09-11	AA	Stock	43.25	44.49	43.13	43.6	4177300.0
2017-09-11	AAAP-DELISTED	Stock	50.01	52.83	49.79	52.52	217037.0
2017-09-11	AABA-DELISTED	Stock	64.68	65.26	64.4	65.16	5067425.0
2017-09-11	AAC-DELISTED	Stock	10.28	10.85	10.28	10.76	44098.0
2017-09-11	AACG	Stock	4.72	4.81	4.61	4.61	7300.0
2017-09-11	AAIC-DELISTED	Stock	12.92	13.05	12.92	12.99	372399.0
2017-09-11	AAL	Stock	44.01	46.09	44.0	45.86	7921600.0
2017-09-11	AAM.A-DELISTED	Stock	26.1359	26.3	26.0649	26.3	22756.0
2017-09-11	AAMC-DELISTED	Stock	32.0588	32.3676	30.2794	32.0588	21185.0
2017-09-11	AAME	Stock	3.4	3.4	3.35	3.4	1000.0
2017-09-11	AAMI	Stock	13.69	13.87	13.56	13.59	485400.0
2017-09-11	AAOI	Stock	58.0	58.39	56.94	58.11	1248000.0
2017-09-11	AAON	Stock	21.3333	21.4467	21.1667	21.2667	179550.0
2017-09-11	AAP	Stock	94.0	95.02	93.37	94.4	1249900.0
2017-09-11	AAT	Stock	40.82	41.18	40.77	40.86	160600.0
2017-09-11	AAU-DELISTED	Stock	1.24	1.24	1.19	1.19	302533.0
2017-09-11	AAUAF-DELISTED	Stock	1.24	1.24	1.19	1.19	313553.0
2017-09-11	AAV-DELISTED	Stock	6.2	6.3	6.2	6.3	24658.0
2017-09-11	AAWW-DELISTED	Stock	66.1	66.35	65.25	65.7	103503.0
2017-09-11	AAXJ	Stock	72.46	72.95	72.46	72.95	674910.0
2017-09-11	AAXN-DELISTED	Stock	21.79	22.25	21.72	21.87	382272.0
2017-09-11	AB	Stock	23.5	23.84	23.5	23.6	232300.0
2017-09-11	ABAC-DELISTED	Stock	2.1047	2.1901	2.1	2.16	7170.0
2017-09-11	ABAX-DELISTED	Stock	45.44	45.74	45.13	45.44	88023.0
2017-09-11	ABB-DELISTED	Stock	24.26	24.3101	24.185	24.22	773054.0
2017-09-11	ABBNY-DELISTED	Stock	24.26	24.3101	24.185	24.23	806440.0
2017-09-11	ABBV	Stock	84.46	87.1	84.38	87.0	12687000.0
2017-09-11	ABC-DELISTED	Stock	83.24	84.56	82.89	84.41	1026950.0
2017-09-11	ABCB	Stock	42.4	43.25	42.4	42.9	116400.0
2017-09-11	ABCD-DELISTED	Stock	6.09	6.35	6.09	6.3	154617.0
2017-09-11	ABCO-DELISTED	Stock	53.35	53.475	53.35	53.45	504287.0
2017-09-11	ABDC-DELISTED	Stock	11.02	11.02	10.639	10.81	55736.0
2017-09-11	ABE-DELISTED	Stock	14.75	14.75	14.512	14.54	2477.0
2017-09-11	ABEO	Stock	347.5	365.0	343.75	350.0	32424.0
2017-09-11	ABEOW-DELISTED	Stock	8.95	9.35	8.95	9.35	4077.0
2017-09-11	ABEV	Stock	6.49	6.57	6.47	6.48	14027400.0
2017-09-11	ABG	Stock	56.3	57.1	56.1	56.95	305600.0
2017-09-11	ABIL-DELISTED	Stock	0.76	0.77	0.7	0.726	133789.0
2017-09-11	ABM	Stock	41.75	41.75	40.01	40.97	553300.0

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

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