PREVIEW / stock_daily / 2016-12-23

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-23.parquet
  size:    214 KB
  rows:    6,511
  symbols: 3,128

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-23	AAPL	Stock	28.8975	29.13	28.8975	29.13	56998000.0
2016-12-23	MSFT	Stock	63.45	63.54	62.8	63.24	12403800.0
2016-12-23	NVDA	Stock	2.6595	2.746	2.6568	2.7445	647692000.0
2016-12-23	AMZN	Stock	38.2275	38.325	37.8995	38.0295	39632000.0
2016-12-23	GOOGL	Stock	40.4005	40.5485	40.2555	40.39	15310740.0
2016-12-23	META	Stock	117.0	117.56	116.3	117.27	10890000.0
2016-12-23	TSLA	Stock	13.8667	14.23	13.8473	14.2227	70057500.0
2016-12-23	TLT	Stock	118.24	118.39	117.95	118.05	4461570.0
2016-12-23	ES	Stock	55.56	55.7	55.26	55.46	760100.0
2016-12-23	CL	Stock	66.39	66.5	66.0	66.27	1210700.0
2016-12-23	A	Stock	46.08	46.23	45.93	46.2	727700.0
2016-12-23	AA	Stock	29.79	30.13	29.34	29.71	2881800.0
2016-12-23	AAAP-DELISTED	Stock	23.79	24.39	23.51	24.0675	144039.0
2016-12-23	AABA-DELISTED	Stock	38.46	38.81	38.37	38.66	3580348.0
2016-12-23	AAC-DELISTED	Stock	7.39	7.44	7.26	7.3	92071.0
2016-12-23	AACG	Stock	3.72	3.83	3.63	3.83	1500.0
2016-12-23	AAIC-DELISTED	Stock	15.8	15.8	15.52	15.65	393143.0
2016-12-23	AAL	Stock	48.61	48.84	48.29	48.48	2914800.0
2016-12-23	AAMC-DELISTED	Stock	15.3824	16.1765	15.3235	15.8235	18340.0
2016-12-23	AAME	Stock	3.98	3.98	3.98	3.98	900.0
2016-12-23	AAMI	Stock	14.35	14.415	14.24	14.33	344300.0
2016-12-23	AAOI	Stock	24.73	25.1	24.34	24.82	200200.0
2016-12-23	AAON	Stock	21.9667	22.1667	21.9	22.1667	102750.0
2016-12-23	AAP	Stock	170.69	172.08	170.0	170.89	334200.0
2016-12-23	AAT	Stock	42.65	42.65	42.24	42.42	103700.0
2016-12-23	AAU-DELISTED	Stock	0.835	0.94	0.835	0.92	313342.0
2016-12-23	AAUAF-DELISTED	Stock	0.835	0.94	0.835	0.9205	317754.0
2016-12-23	AAV-DELISTED	Stock	6.85	6.85	6.65	6.75	88964.0
2016-12-23	AAWW-DELISTED	Stock	52.8	53.15	51.7	52.8	106221.0
2016-12-23	AAXJ	Stock	54.01	54.25	54.01	54.24	593312.0
2016-12-23	AAXN-DELISTED	Stock	24.74	24.74	24.18	24.52	352881.0
2016-12-23	AB	Stock	23.55	23.95	23.1	23.7	207100.0
2016-12-23	ABAC-DELISTED	Stock	3.56	3.94	3.56	3.71	12736.0
2016-12-23	ABAX-DELISTED	Stock	51.19	52.2	51.1166	51.99	48063.0
2016-12-23	ABB-DELISTED	Stock	21.09	21.13	21.03	21.04	988436.0
2016-12-23	ABBNY-DELISTED	Stock	21.1	21.13	21.03	21.04	1019138.0
2016-12-23	ABBV	Stock	61.78	62.4	61.47	62.34	4795900.0
2016-12-23	ABC-DELISTED	Stock	78.04	78.93	77.89	78.56	458926.0
2016-12-23	ABCB	Stock	44.05	44.55	44.0	44.4	136000.0
2016-12-23	ABCD-DELISTED	Stock	4.88	4.98	4.87	4.98	16595.0
2016-12-23	ABCO-DELISTED	Stock	32.35	32.55	31.9	32.45	395538.0
2016-12-23	ABDC-DELISTED	Stock	12.65	12.66	12.53	12.57	46582.0
2016-12-23	ABE-DELISTED	Stock	10.98	11.1099	10.93	11.1099	14839.0
2016-12-23	ABEO	Stock	116.25	120.0	112.5	120.0	6844.0
2016-12-23	ABEOW-DELISTED	Stock	3.69	3.69	3.15	3.25	4000.0
2016-12-23	ABEV	Stock	4.85	4.88	4.82	4.86	5973200.0
2016-12-23	ABG	Stock	62.55	63.75	61.95	62.45	107100.0
2016-12-23	ABIL-DELISTED	Stock	2.7	2.7	2.6	2.64	77312.0
2016-12-23	ABM	Stock	40.36	40.42	39.94	40.14	357200.0
2016-12-23	ABMD-DELISTED	Stock	111.76	113.08	110.496	112.27	113211.0

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

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