PREVIEW / stock_daily / 2016-10-13

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-13.parquet
  size:    217 KB
  rows:    6,500
  symbols: 3,181

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-13	AAPL	Stock	29.1975	29.36	28.93	29.245	140769600.0
2016-10-13	MSFT	Stock	56.7	57.3	56.32	56.92	25313700.0
2016-10-13	NVDA	Stock	1.6413	1.645	1.5925	1.6338	390116000.0
2016-10-13	AMZN	Stock	41.45	41.59	41.0605	41.464	61828000.0
2016-10-13	GOOGL	Stock	40.3035	40.328	39.931	40.204	27379620.0
2016-10-13	META	Stock	128.21	128.25	126.75	127.82	17139300.0
2016-10-13	TSLA	Stock	13.3667	13.3933	13.1367	13.3493	37419000.0
2016-10-13	TLT	Stock	133.64	133.93	133.37	133.46	7080582.0
2016-10-13	ES	Stock	52.71	53.54	52.54	53.3	1850300.0
2016-10-13	CL	Stock	72.07	72.49	71.76	72.16	2991600.0
2016-10-13	A	Stock	44.84	45.32	44.76	45.16	1336000.0
2016-10-13	AA.B-DELISTED	Stock	29.35	29.52	28.77	29.52	66477.0
2016-10-13	AAAP-DELISTED	Stock	37.68	38.45	37.68	38.38	49159.0
2016-10-13	AABA-DELISTED	Stock	42.0	42.08	41.17	41.62	14457551.0
2016-10-13	AAC-DELISTED	Stock	17.15	17.37	17.02	17.27	148219.0
2016-10-13	AACG	Stock	4.1	4.1	3.59	3.59	4500.0
2016-10-13	AAIC-DELISTED	Stock	14.15	14.38	14.13	14.31	148364.0
2016-10-13	AAL	Stock	36.95	39.5	36.8	39.24	14773300.0
2016-10-13	AAMC-DELISTED	Stock	16.1765	17.5004	11.5794	12.1176	1022060.0
2016-10-13	AAME	Stock	3.5	3.84	3.5	3.58	8900.0
2016-10-13	AAMI	Stock	13.84	13.92	13.61	13.86	71400.0
2016-10-13	AAOI	Stock	21.2	21.2	19.83	20.16	502700.0
2016-10-13	AAON	Stock	19.6667	19.6667	19.3667	19.5333	115200.0
2016-10-13	AAP	Stock	147.26	147.61	145.1	146.78	767200.0
2016-10-13	AAT	Stock	40.61	41.05	40.53	40.91	170400.0
2016-10-13	AAU-DELISTED	Stock	1.2	1.26	1.2	1.24	303729.0
2016-10-13	AAUAF-DELISTED	Stock	1.2	1.26	1.2	1.24	308876.0
2016-10-13	AAV-DELISTED	Stock	7.25	7.58	7.25	7.44	212841.0
2016-10-13	AAWW-DELISTED	Stock	42.18	42.18	41.4875	41.62	111071.0
2016-10-13	AAXJ	Stock	58.75	59.22	58.41	59.06	654326.0
2016-10-13	AAXN-DELISTED	Stock	21.79	22.2	21.5	22.095	883991.0
2016-10-13	AB	Stock	21.9	22.1	21.56	21.85	125400.0
2016-10-13	ABAC-DELISTED	Stock	2.06	2.16	2.01	2.08	12107.0
2016-10-13	ABAX-DELISTED	Stock	52.23	52.77	51.74	52.28	60555.0
2016-10-13	ABB-DELISTED	Stock	22.09	22.329	22.05	22.25	1391658.0
2016-10-13	ABBNY-DELISTED	Stock	22.09	22.329	22.05	22.25	1531310.0
2016-10-13	ABBV	Stock	60.96	61.61	60.68	61.15	5988600.0
2016-10-13	ABC-DELISTED	Stock	80.28	80.93	79.93	80.38	2229488.0
2016-10-13	ABCB	Stock	35.73	35.73	35.01	35.21	85700.0
2016-10-13	ABCD-DELISTED	Stock	5.37	5.37	5.31	5.32	4155.0
2016-10-13	ABCO-DELISTED	Stock	43.64	43.83	43.1201	43.5	138419.0
2016-10-13	ABDC-DELISTED	Stock	12.88	12.885	12.73	12.79	31228.0
2016-10-13	ABE-DELISTED	Stock	12.22	12.23	12.1849	12.22	8900.0
2016-10-13	ABEO	Stock	162.5	168.75	156.25	167.75	6344.0
2016-10-13	ABEOW-DELISTED	Stock	3.68	3.68	3.5499	3.55	3200.0
2016-10-13	ABEV	Stock	5.96	6.05	5.91	6.02	15802800.0
2016-10-13	ABG	Stock	54.75	55.35	53.6	54.6	199300.0
2016-10-13	ABM	Stock	37.77	38.44	37.72	38.08	484400.0
2016-10-13	ABMD-DELISTED	Stock	126.75	128.5	126.0501	127.7325	144770.0
2016-10-13	ABR	Stock	7.36	7.41	7.32	7.38	71200.0

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

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