PREVIEW / stock_daily / 2016-11-16

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-16.parquet
  size:    216 KB
  rows:    6,526
  symbols: 3,164

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-11-16	AAPL	Stock	26.675	27.5575	26.65	27.4975	235362000.0
2016-11-16	MSFT	Stock	58.94	59.66	58.81	59.65	27332500.0
2016-11-16	NVDA	Stock	2.1835	2.314	2.1588	2.2908	987984000.0
2016-11-16	AMZN	Stock	36.994	37.4935	36.7805	37.3245	72976000.0
2016-11-16	GOOGL	Stock	38.521	39.175	38.3165	38.999	35967200.0
2016-11-16	META	Stock	114.48	117.88	114.21	116.34	32397900.0
2016-11-16	TSLA	Stock	12.1767	12.3153	12.0807	12.262	51516000.0
2016-11-16	TLT	Stock	122.3	123.14	122.17	123.01	9149498.0
2016-11-16	ES	Stock	52.5	52.7	51.67	51.97	1579200.0
2016-11-16	CL	Stock	66.93	66.94	66.33	66.74	3000800.0
2016-11-16	A	Stock	46.3	47.8	46.15	46.18	4026800.0
2016-11-16	AA	Stock	29.69	31.69	29.66	31.42	6153000.0
2016-11-16	AAAP-DELISTED	Stock	36.79	36.87	36.23	36.33	43227.0
2016-11-16	AABA-DELISTED	Stock	40.1	41.05	40.1	40.97	12184806.0
2016-11-16	AAC-DELISTED	Stock	9.7	9.85	9.37	9.7501	354037.0
2016-11-16	AACG	Stock	3.88	4.2	3.88	4.2	700.0
2016-11-16	AAIC-DELISTED	Stock	15.92	16.08	15.64	15.7	236796.0
2016-11-16	AAL	Stock	44.66	44.8	43.93	44.45	6167000.0
2016-11-16	AAMC-DELISTED	Stock	9.4412	9.4412	8.8676	8.8971	38138.0
2016-11-16	AAME	Stock	3.75	3.81	3.75	3.81	4800.0
2016-11-16	AAMI	Stock	14.18	14.41	14.18	14.4	202600.0
2016-11-16	AAOI	Stock	25.3	26.09	24.7	26.08	635000.0
2016-11-16	AAON	Stock	21.5	21.6	21.3	21.6	202500.0
2016-11-16	AAP	Stock	163.21	163.74	160.95	162.98	1880500.0
2016-11-16	AAT	Stock	40.49	40.73	40.04	40.24	244700.0
2016-11-16	AAU-DELISTED	Stock	1.23	1.29	1.19	1.19	220026.0
2016-11-16	AAUAF-DELISTED	Stock	1.23	1.29	1.19	1.19	221513.0
2016-11-16	AAV-DELISTED	Stock	6.75	6.85	6.71	6.825	28568.0
2016-11-16	AAWW-DELISTED	Stock	49.9	49.95	49.05	49.3	247023.0
2016-11-16	AAXJ	Stock	55.65	55.71	55.4	55.6	1924129.0
2016-11-16	AAXN-DELISTED	Stock	27.59	27.95	27.33	27.76	541331.0
2016-11-16	AB	Stock	23.05	23.7	23.05	23.25	183500.0
2016-11-16	ABAC-DELISTED	Stock	2.88	2.88	2.7	2.83	23267.0
2016-11-16	ABAX-DELISTED	Stock	52.96	53.05	52.05	52.4	96191.0
2016-11-16	ABB-DELISTED	Stock	21.01	21.08	20.865	20.88	1349892.0
2016-11-16	ABBNY-DELISTED	Stock	21.01	21.08	20.865	20.88	1388856.0
2016-11-16	ABBV	Stock	62.67	62.97	61.42	61.54	6571200.0
2016-11-16	ABC-DELISTED	Stock	79.16	80.21	78.66	78.87	2604977.0
2016-11-16	ABCB	Stock	42.25	42.48	41.95	42.0	199100.0
2016-11-16	ABCD-DELISTED	Stock	5.0	5.0927	4.97	5.01	25275.0
2016-11-16	ABCO-DELISTED	Stock	33.25	35.35	33.2	35.35	390691.0
2016-11-16	ABDC-DELISTED	Stock	11.4	11.6	11.17	11.4	50273.0
2016-11-16	ABE-DELISTED	Stock	11.29	11.33	11.23	11.32	5262.0
2016-11-16	ABEO	Stock	176.25	182.5	172.5	175.0	14108.0
2016-11-16	ABEOW-DELISTED	Stock	3.6	3.6	3.6	3.6	499.0
2016-11-16	ABEV	Stock	5.1	5.2	5.1	5.17	22207000.0
2016-11-16	ABG	Stock	57.45	60.0	57.45	58.4	350600.0
2016-11-16	ABIL-DELISTED	Stock	3.06	3.15	3.06	3.11	8082.0
2016-11-16	ABM	Stock	42.97	43.33	42.16	42.52	377000.0
2016-11-16	ABMD-DELISTED	Stock	111.42	112.52	110.01	111.55	572247.0

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

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