PREVIEW / stock_daily / 2016-10-11

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-11.parquet
  size:    217 KB
  rows:    6,494
  symbols: 3,171

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
2016-10-11	AAPL	Stock	29.425	29.6725	29.05	29.075	256164000.0
2016-10-11	MSFT	Stock	57.89	58.02	56.89	57.19	26497400.0
2016-10-11	NVDA	Stock	1.672	1.6745	1.6405	1.6532	388540000.0
2016-10-11	AMZN	Stock	42.051	42.0645	41.4175	41.55	71764000.0
2016-10-11	GOOGL	Stock	40.7085	40.993	40.3685	40.4785	34431500.0
2016-10-11	META	Stock	130.23	130.64	128.23	128.88	17537900.0
2016-10-11	TSLA	Stock	13.4567	13.48	13.2207	13.34	34926000.0
2016-10-11	TLT	Stock	132.86	133.55	132.57	132.83	9670399.0
2016-10-11	ES	Stock	52.66	52.66	51.88	51.98	1781300.0
2016-10-11	CL	Stock	72.54	72.63	71.89	72.2	2971900.0
2016-10-11	A	Stock	47.19	47.19	45.42	45.69	2912500.0
2016-10-11	AA.B-DELISTED	Stock	31.5	31.5	30.4542	30.47	78938.0
2016-10-11	AAAP-DELISTED	Stock	39.12	39.12	37.94	38.24	101843.0
2016-10-11	AABA-DELISTED	Stock	43.87	44.08	42.49	42.68	8788040.0
2016-10-11	AAC-DELISTED	Stock	17.27	17.3	17.09	17.17	64957.0
2016-10-11	AACG	Stock	4.39	4.39	4.1	4.27	1100.0
2016-10-11	AAIC-DELISTED	Stock	14.28	14.28	14.08	14.22	201216.0
2016-10-11	AAL	Stock	39.99	39.99	38.06	38.2	10034700.0
2016-10-11	AAMC-DELISTED	Stock	8.3824	9.9853	8.2359	9.8971	195486.0
2016-10-11	AAME	Stock	3.35	3.5	3.35	3.49	9800.0
2016-10-11	AAMI	Stock	14.2	14.2	13.79	13.92	87400.0
2016-10-11	AAOI	Stock	23.08	23.2	21.82	22.04	358500.0
2016-10-11	AAON	Stock	19.9667	20.06	19.5667	19.6667	177750.0
2016-10-11	AAP	Stock	147.96	148.47	146.45	146.76	628600.0
2016-10-11	AAT	Stock	40.93	41.04	40.27	40.36	125800.0
2016-10-11	AAU-DELISTED	Stock	1.26	1.26	1.2	1.2	244555.0
2016-10-11	AAUAF-DELISTED	Stock	1.26	1.26	1.2	1.21	247580.0
2016-10-11	AAV-DELISTED	Stock	7.27	7.45	7.26	7.35	142672.0
2016-10-11	AAWW-DELISTED	Stock	42.8	43.3	42.14	42.45	115652.0
2016-10-11	AAXJ	Stock	59.98	60.045	59.38	59.62	1634890.0
2016-10-11	AAXN-DELISTED	Stock	23.82	23.82	22.18	22.4	955481.0
2016-10-11	AB	Stock	22.25	22.4	21.6	21.85	215200.0
2016-10-11	ABAC-DELISTED	Stock	2.02	2.076	2.01	2.076	4757.0
2016-10-11	ABAX-DELISTED	Stock	53.49	53.49	51.8684	52.35	68457.0
2016-10-11	ABB-DELISTED	Stock	22.71	22.72	22.295	22.38	1406154.0
2016-10-11	ABBNY-DELISTED	Stock	22.71	22.72	22.295	22.37	2284517.0
2016-10-11	ABBV	Stock	63.08	63.26	62.05	62.39	5308400.0
2016-10-11	ABC-DELISTED	Stock	79.55	80.035	79.26	79.62	2153365.0
2016-10-11	ABCB	Stock	36.2	36.31	35.68	35.86	84700.0
2016-10-11	ABCD-DELISTED	Stock	5.53	5.53	5.27	5.34	14669.0
2016-10-11	ABCO-DELISTED	Stock	43.54	44.03	42.34	43.02	236233.0
2016-10-11	ABDC-DELISTED	Stock	12.75	12.89	12.64	12.75	25591.0
2016-10-11	ABE-DELISTED	Stock	12.54	12.54	12.38	12.38	4388.0
2016-10-11	ABEO	Stock	170.25	171.75	162.0	164.75	7076.0
2016-10-11	ABEV	Stock	6.08	6.11	6.0	6.04	16236900.0
2016-10-11	ABG	Stock	54.55	55.0	53.75	54.75	225800.0
2016-10-11	ABIL-DELISTED	Stock	3.822	3.822	3.5664	3.68	3434.0
2016-10-11	ABM	Stock	38.84	38.84	38.07	38.21	221000.0
2016-10-11	ABMD-DELISTED	Stock	131.73	131.73	126.53	127.62	256604.0
2016-10-11	ABR	Stock	7.41	7.41	7.3	7.34	62100.0

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

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