PREVIEW / stock_daily / 2016-11-18

all stock daily files

  file:    by_date/stock_daily/2016/2016-11-18.parquet
  size:    216 KB
  rows:    6,531
  symbols: 3,160

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-18	AAPL	Stock	27.43	27.635	27.415	27.515	113715600.0
2016-11-18	MSFT	Stock	60.78	61.14	60.3	60.35	27686300.0
2016-11-18	NVDA	Stock	2.3098	2.3582	2.295	2.334	576060000.0
2016-11-18	AMZN	Stock	38.05	38.387	37.882	38.008	87468000.0
2016-11-18	GOOGL	Stock	39.3585	39.5645	38.7675	38.7985	36125280.0
2016-11-18	META	Stock	118.39	119.13	116.84	117.02	22879300.0
2016-11-18	TSLA	Stock	12.71	12.8667	12.3333	12.3347	78154500.0
2016-11-18	TLT	Stock	121.63	121.97	120.34	120.85	13577732.0
2016-11-18	ES	Stock	52.11	52.38	51.54	51.82	1099800.0
2016-11-18	CL	Stock	65.74	66.0	65.5	65.86	4747500.0
2016-11-18	A	Stock	45.91	46.2	45.01	45.04	3148500.0
2016-11-18	AA	Stock	31.73	31.77	30.16	30.42	4421700.0
2016-11-18	AAAP-DELISTED	Stock	36.0	36.0	34.6325	35.97	8348.0
2016-11-18	AABA-DELISTED	Stock	41.59	41.65	40.9	41.2	7176151.0
2016-11-18	AAC-DELISTED	Stock	10.41	10.4835	10.1	10.12	184301.0
2016-11-18	AACG	Stock	4.2	4.2	3.9	4.2	1000.0
2016-11-18	AAIC-DELISTED	Stock	15.65	15.97	15.61	15.93	184444.0
2016-11-18	AAL	Stock	46.15	46.49	45.62	46.26	7795100.0
2016-11-18	AAMC-DELISTED	Stock	8.4853	8.6343	8.0294	8.2941	48052.0
2016-11-18	AAME	Stock	3.65	3.8	3.65	3.8	500.0
2016-11-18	AAMI	Stock	14.6	14.79	14.44	14.73	122200.0
2016-11-18	AAOI	Stock	26.13	26.87	25.9	26.63	379000.0
2016-11-18	AAON	Stock	22.0	22.0333	21.8	21.8667	231000.0
2016-11-18	AAP	Stock	166.12	166.73	162.23	162.57	1226600.0
2016-11-18	AAT	Stock	40.14	40.47	39.88	40.14	275700.0
2016-11-18	AAU-DELISTED	Stock	1.12	1.15	1.06	1.07	280461.0
2016-11-18	AAUAF-DELISTED	Stock	1.12	1.15	1.06	1.07	282496.0
2016-11-18	AAV-DELISTED	Stock	6.85	6.85	6.7	6.8	75116.0
2016-11-18	AAWW-DELISTED	Stock	50.3	50.9	50.25	50.85	172541.0
2016-11-18	AAXJ	Stock	55.95	56.01	55.63	55.75	849620.0
2016-11-18	AAXN-DELISTED	Stock	27.97	28.1353	27.76	27.79	365751.0
2016-11-18	AB	Stock	23.4	23.7	23.2	23.3	207400.0
2016-11-18	ABAC-DELISTED	Stock	2.75	2.94	2.75	2.8	31583.0
2016-11-18	ABAX-DELISTED	Stock	52.94	53.59	51.99	52.16	190735.0
2016-11-18	ABB-DELISTED	Stock	20.63	20.735	20.61	20.7	1368007.0
2016-11-18	ABBNY-DELISTED	Stock	20.63	20.735	20.61	20.69	1775124.0
2016-11-18	ABBV	Stock	61.65	62.14	60.39	60.52	7023200.0
2016-11-18	ABC-DELISTED	Stock	79.91	79.91	78.91	79.22	3284129.0
2016-11-18	ABCB	Stock	41.95	42.5	41.3	42.4	220200.0
2016-11-18	ABCD-DELISTED	Stock	5.06	5.06	4.98	4.99	25955.0
2016-11-18	ABCO-DELISTED	Stock	35.85	36.95	33.955	35.95	446075.0
2016-11-18	ABDC-DELISTED	Stock	11.7	12.15	11.51	11.81	87133.0
2016-11-18	ABE-DELISTED	Stock	11.31	11.375	11.24	11.37	3315.0
2016-11-18	ABEO	Stock	182.5	183.75	176.25	181.25	10700.0
2016-11-18	ABEOW-DELISTED	Stock	3.75	3.75	3.7	3.7	5733.0
2016-11-18	ABEV	Stock	5.15	5.16	4.99	5.06	25740600.0
2016-11-18	ABG	Stock	57.7	59.1	57.25	58.5	194600.0
2016-11-18	ABIL-DELISTED	Stock	2.93	3.09	2.91	2.99	32939.0
2016-11-18	ABM	Stock	43.11	43.92	42.75	43.88	298700.0
2016-11-18	ABMD-DELISTED	Stock	113.51	114.7	113.04	113.42	691481.0

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

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