PREVIEW / stock_daily / 2016-12-28

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-28.parquet
  size:    215 KB
  rows:    6,533
  symbols: 3,140

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-28	AAPL	Stock	29.38	29.505	29.05	29.19	83623600.0
2016-12-28	MSFT	Stock	63.4	63.4	62.83	62.99	14653300.0
2016-12-28	NVDA	Stock	2.99	2.9983	2.7172	2.7312	2295764000.0
2016-12-28	AMZN	Stock	38.8125	39.0	38.525	38.6065	66020000.0
2016-12-28	GOOGL	Stock	40.6665	40.6665	40.122	40.2285	24295120.0
2016-12-28	META	Stock	118.19	118.25	116.65	116.92	12087400.0
2016-12-28	TSLA	Stock	14.7687	14.92	14.48	14.6493	56737500.0
2016-12-28	TLT	Stock	117.86	118.88	117.7	118.53	7578597.0
2016-12-28	ES	Stock	55.4	55.44	54.63	54.72	802500.0
2016-12-28	CL	Stock	66.01	66.24	65.58	65.61	1671300.0
2016-12-28	A	Stock	46.51	46.7	45.68	45.72	1177300.0
2016-12-28	AA	Stock	29.78	30.17	29.35	29.43	2751100.0
2016-12-28	AAAP-DELISTED	Stock	26.8	26.9799	26.0427	26.5	87528.0
2016-12-28	AABA-DELISTED	Stock	39.12	39.22	38.71	38.74	4050446.0
2016-12-28	AAC-DELISTED	Stock	7.13	7.2008	6.8	7.0	237360.0
2016-12-28	AACG	Stock	3.6	3.85	3.43	3.62	12000.0
2016-12-28	AAIC-DELISTED	Stock	15.07	15.1199	14.71	14.8	432821.0
2016-12-28	AAL	Stock	48.73	48.83	47.61	47.67	4153600.0
2016-12-28	AAMC-DELISTED	Stock	17.0588	17.6126	15.2206	15.2353	66286.0
2016-12-28	AAME	Stock	3.75	3.8	3.75	3.8	500.0
2016-12-28	AAMI	Stock	14.5	14.59	14.475	14.53	481200.0
2016-12-28	AAOI	Stock	24.9	24.93	24.31	24.39	240900.0
2016-12-28	AAON	Stock	22.5333	22.5667	22.1333	22.2667	126300.0
2016-12-28	AAP	Stock	172.01	172.93	170.35	170.42	360300.0
2016-12-28	AAT	Stock	42.68	42.68	41.97	42.18	220500.0
2016-12-28	AAU-DELISTED	Stock	0.92	0.995	0.89	0.995	278479.0
2016-12-28	AAUAF-DELISTED	Stock	0.92	0.995	0.89	0.995	285960.0
2016-12-28	AAV-DELISTED	Stock	6.8	6.8	6.7	6.8	82174.0
2016-12-28	AAWW-DELISTED	Stock	53.2	53.35	51.8	52.3	99326.0
2016-12-28	AAXJ	Stock	54.61	54.67	54.32	54.4	1897164.0
2016-12-28	AAXN-DELISTED	Stock	24.88	24.98	24.5	24.56	345269.0
2016-12-28	AB	Stock	23.75	24.1	23.3	23.5	320400.0
2016-12-28	ABAC-DELISTED	Stock	3.69	3.7	3.6301	3.7	1575.0
2016-12-28	ABAX-DELISTED	Stock	52.44	52.61	51.5	51.73	39230.0
2016-12-28	ABB-DELISTED	Stock	21.23	21.23	21.01	21.04	1272246.0
2016-12-28	ABBNY-DELISTED	Stock	21.23	21.23	21.01	21.04	1314197.0
2016-12-28	ABBV	Stock	62.51	62.75	62.25	62.27	5190400.0
2016-12-28	ABC-DELISTED	Stock	78.86	79.22	78.21	78.33	712646.0
2016-12-28	ABCB	Stock	45.15	45.15	44.1	44.55	96000.0
2016-12-28	ABCD-DELISTED	Stock	5.0	5.0	4.88	5.0	15788.0
2016-12-28	ABCO-DELISTED	Stock	33.4	33.58	32.5	32.7	405803.0
2016-12-28	ABDC-DELISTED	Stock	12.5	12.56	11.66	11.7	141218.0
2016-12-28	ABE-DELISTED	Stock	11.0	11.12	11.0	11.1	7974.0
2016-12-28	ABEO	Stock	132.5	136.0	122.5	127.5	9780.0
2016-12-28	ABEOW-DELISTED	Stock	3.55	3.55	3.32	3.32	2300.0
2016-12-28	ABEV	Stock	4.9	4.94	4.86	4.91	10682800.0
2016-12-28	ABG	Stock	63.75	64.0	61.7	62.1	81300.0
2016-12-28	ABIL-DELISTED	Stock	2.83	3.12	2.63	2.8	192509.0
2016-12-28	ABM	Stock	40.6	40.7	40.38	40.42	418700.0
2016-12-28	ABMD-DELISTED	Stock	113.7	114.3	112.53	112.78	127924.0

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

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