PREVIEW / stock_daily / 2016-12-14

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-14.parquet
  size:    216 KB
  rows:    6,502
  symbols: 3,120

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-12-14	AAPL	Stock	28.76	29.05	28.745	28.7975	136127200.0
2016-12-14	MSFT	Stock	63.0	63.45	62.53	62.68	30352700.0
2016-12-14	NVDA	Stock	2.3135	2.4278	2.2892	2.4113	983980000.0
2016-12-14	AMZN	Stock	38.9125	39.043	38.1405	38.441	109096000.0
2016-12-14	GOOGL	Stock	40.796	41.213	40.639	40.8945	35993080.0
2016-12-14	META	Stock	120.0	121.69	118.85	120.21	25913100.0
2016-12-14	TSLA	Stock	13.2493	13.5333	13.1173	13.246	62263500.0
2016-12-14	TLT	Stock	119.08	119.21	116.8	116.82	16618386.0
2016-12-14	ES	Stock	54.32	54.78	52.96	53.07	1424700.0
2016-12-14	CL	Stock	66.92	67.14	65.79	65.91	3809300.0
2016-12-14	A	Stock	46.43	46.79	46.0	46.14	2044100.0
2016-12-14	AA	Stock	30.11	31.32	30.03	30.45	3176100.0
2016-12-14	AAAP-DELISTED	Stock	27.7	29.0	27.3	28.22	173024.0
2016-12-14	AABA-DELISTED	Stock	41.44	41.53	40.83	40.92	18759435.0
2016-12-14	AAC-DELISTED	Stock	7.39	7.8	7.27	7.77	307021.0
2016-12-14	AACG	Stock	4.02	4.02	3.85	3.86	1300.0
2016-12-14	AAIC-DELISTED	Stock	16.23	16.5	15.97	15.98	384818.0
2016-12-14	AAL	Stock	47.84	48.75	47.81	47.92	5293900.0
2016-12-14	AAMC-DELISTED	Stock	12.0735	13.2647	12.0735	12.8824	57423.0
2016-12-14	AAME	Stock	4.05	4.05	3.9	3.95	8600.0
2016-12-14	AAMI	Stock	14.44	14.5	13.99	14.0	7790000.0
2016-12-14	AAOI	Stock	24.3	24.45	23.38	23.77	300700.0
2016-12-14	AAON	Stock	21.7333	22.1667	21.7	21.7333	205050.0
2016-12-14	AAP	Stock	173.03	174.29	169.89	171.51	1458000.0
2016-12-14	AAT	Stock	43.18	43.18	41.78	41.86	312600.0
2016-12-14	AAU-DELISTED	Stock	1.13	1.1399	1.06	1.0601	225979.0
2016-12-14	AAUAF-DELISTED	Stock	1.13	1.1399	1.06	1.0601	228415.0
2016-12-14	AAV-DELISTED	Stock	7.15	7.25	6.869	6.872	128923.0
2016-12-14	AAWW-DELISTED	Stock	52.4	52.6	51.1	51.55	277180.0
2016-12-14	AAXJ	Stock	57.09	57.41	56.2	56.26	3193110.0
2016-12-14	AAXN-DELISTED	Stock	23.6	24.67	23.6	24.2	1121843.0
2016-12-14	AB	Stock	22.75	22.9	22.3	22.5	427800.0
2016-12-14	ABAC-DELISTED	Stock	3.83	3.9	3.6	3.66	19836.0
2016-12-14	ABAX-DELISTED	Stock	54.82	55.0	53.79	54.16	95924.0
2016-12-14	ABB-DELISTED	Stock	21.36	21.4465	20.93	20.95	3532275.0
2016-12-14	ABBNY-DELISTED	Stock	21.36	21.4465	20.93	20.95	3610918.0
2016-12-14	ABBV	Stock	61.55	62.3	61.51	61.67	5115700.0
2016-12-14	ABC-DELISTED	Stock	78.95	79.4	76.59	77.05	2005317.0
2016-12-14	ABCB	Stock	45.4	46.15	45.15	45.45	144200.0
2016-12-14	ABCD-DELISTED	Stock	4.77	5.0499	4.7	4.8	43056.0
2016-12-14	ABCO-DELISTED	Stock	32.05	32.4	31.2	32.0	304144.0
2016-12-14	ABDC-DELISTED	Stock	12.55	12.55	12.25	12.44	69116.0
2016-12-14	ABE-DELISTED	Stock	11.28	11.33	11.23	11.24	12632.0
2016-12-14	ABEO	Stock	121.25	128.75	116.25	121.25	19152.0
2016-12-14	ABEOW-DELISTED	Stock	3.0	3.08	2.85	2.85	1535.0
2016-12-14	ABEV	Stock	4.82	4.93	4.75	4.78	56554000.0
2016-12-14	ABG	Stock	62.05	62.45	60.8	60.95	137300.0
2016-12-14	ABIL-DELISTED	Stock	3.08	3.125	2.9615	3.08	15501.0
2016-12-14	ABM	Stock	41.49	41.94	38.52	39.51	2668100.0
2016-12-14	ABMD-DELISTED	Stock	118.23	120.36	118.02	119.2	318977.0

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

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