PREVIEW / stock_daily / 2016-10-10

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-10.parquet
  size:    216 KB
  rows:    6,470
  symbols: 3,158

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-10	AAPL	Stock	28.755	29.1875	28.68	29.0125	144944000.0
2016-10-10	MSFT	Stock	57.91	58.39	57.87	58.04	18196500.0
2016-10-10	NVDA	Stock	1.68	1.689	1.6618	1.6775	287876000.0
2016-10-10	AMZN	Stock	42.1625	42.26	42.0135	42.0855	36542000.0
2016-10-10	GOOGL	Stock	40.1965	40.869	40.112	40.7085	29922300.0
2016-10-10	META	Stock	129.68	130.7	129.2	130.24	15138700.0
2016-10-10	TSLA	Stock	13.4233	13.6093	13.3107	13.3967	49744500.0
2016-10-10	TLT	Stock	132.85	133.16	132.51	133.13	6089117.0
2016-10-10	ES	Stock	52.46	52.81	52.34	52.76	1110900.0
2016-10-10	CL	Stock	73.36	73.5	72.4	72.61	2986100.0
2016-10-10	A	Stock	47.58	48.15	47.55	47.69	1544900.0
2016-10-10	AA.B-DELISTED	Stock	33.8	33.9	33.52	33.7	28058.0
2016-10-10	AAAP-DELISTED	Stock	39.5	39.5	38.86	38.88	61986.0
2016-10-10	AABA-DELISTED	Stock	43.36	44.07	43.25	43.92	6144536.0
2016-10-10	AAC-DELISTED	Stock	17.32	17.68	17.29	17.36	95793.0
2016-10-10	AACG	Stock	4.17	4.32	4.15	4.15	2100.0
2016-10-10	AAIC-DELISTED	Stock	14.21	14.3925	14.21	14.32	166476.0
2016-10-10	AAL	Stock	37.95	38.95	37.47	38.89	6939900.0
2016-10-10	AAMC-DELISTED	Stock	7.3618	8.2829	7.3494	8.2471	146254.0
2016-10-10	AAME	Stock	3.39	3.39	3.3	3.3	2700.0
2016-10-10	AAMI	Stock	14.16	14.3	14.16	14.25	106800.0
2016-10-10	AAOI	Stock	23.04	23.35	22.93	23.15	198600.0
2016-10-10	AAON	Stock	19.7333	20.0667	19.7333	19.9667	78300.0
2016-10-10	AAP	Stock	149.0	149.82	147.81	148.06	436400.0
2016-10-10	AAT	Stock	40.59	41.05	40.59	40.94	245600.0
2016-10-10	AAU-DELISTED	Stock	1.23	1.26	1.23	1.25	191683.0
2016-10-10	AAUAF-DELISTED	Stock	1.23	1.26	1.23	1.25	193019.0
2016-10-10	AAV-DELISTED	Stock	7.31	7.41	7.18	7.215	73229.0
2016-10-10	AAWW-DELISTED	Stock	42.42	43.29	42.42	42.89	144287.0
2016-10-10	AAXJ	Stock	60.95	61.37	60.95	61.22	525380.0
2016-10-10	AAXN-DELISTED	Stock	22.51	22.91	22.51	22.7	1129763.0
2016-10-10	AB	Stock	22.6	22.83	22.23	22.25	100400.0
2016-10-10	ABAC-DELISTED	Stock	2.055	2.055	2.0148	2.0201	7303.0
2016-10-10	ABAX-DELISTED	Stock	52.76	54.1699	52.76	53.82	68224.0
2016-10-10	ABB-DELISTED	Stock	22.8	22.865	22.765	22.77	1029266.0
2016-10-10	ABBNY-DELISTED	Stock	22.8	22.865	22.765	22.78	1075169.0
2016-10-10	ABBV	Stock	63.07	63.66	62.92	63.31	3135300.0
2016-10-10	ABC-DELISTED	Stock	79.07	80.01	78.78	79.64	1096469.0
2016-10-10	ABCB	Stock	35.7	36.2	35.7	36.18	119300.0
2016-10-10	ABCD-DELISTED	Stock	5.48	5.55	5.47	5.49	4900.0
2016-10-10	ABCO-DELISTED	Stock	42.65	44.47	42.65	43.74	271907.0
2016-10-10	ABDC-DELISTED	Stock	12.41	12.79	12.41	12.6999	31329.0
2016-10-10	ABE-DELISTED	Stock	12.49	12.7699	12.49	12.7699	3044.0
2016-10-10	ABEO	Stock	172.75	178.5	168.5	171.5	19308.0
2016-10-10	ABEOW-DELISTED	Stock	3.8	3.97	3.8	3.9601	5694.0
2016-10-10	ABEV	Stock	6.1	6.13	6.08	6.1	4667800.0
2016-10-10	ABG	Stock	54.2	54.95	54.2	54.55	86500.0
2016-10-10	ABIL-DELISTED	Stock	3.7777	3.7777	3.7777	3.7777	100.0
2016-10-10	ABM	Stock	38.97	39.3	38.79	38.8	153500.0
2016-10-10	ABMD-DELISTED	Stock	128.9	132.95	128.7	131.7299	227934.0

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

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