PREVIEW / stock_daily / 2016-12-27

all stock daily files

  file:    by_date/stock_daily/2016/2016-12-27.parquet
  size:    215 KB
  rows:    6,534
  symbols: 3,144

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-27	AAPL	Stock	29.13	29.45	29.1225	29.315	73187600.0
2016-12-27	MSFT	Stock	63.21	64.07	63.21	63.28	11763200.0
2016-12-27	NVDA	Stock	2.8015	2.934	2.7805	2.933	1194272000.0
2016-12-27	AMZN	Stock	38.17	38.7325	38.06	38.57	52774000.0
2016-12-27	GOOGL	Stock	40.434	40.8	40.29	40.4965	19519240.0
2016-12-27	META	Stock	116.96	118.68	116.86	118.01	12051500.0
2016-12-27	TSLA	Stock	14.3253	14.8167	14.2947	14.6353	88735500.0
2016-12-27	TLT	Stock	117.42	117.7	117.23	117.67	5276560.0
2016-12-27	ES	Stock	55.48	55.52	55.15	55.38	817700.0
2016-12-27	CL	Stock	66.2	66.42	65.82	66.01	1629500.0
2016-12-27	A	Stock	46.37	46.66	46.32	46.51	1535500.0
2016-12-27	AA	Stock	29.58	30.04	29.4	29.65	1708900.0
2016-12-27	AAAP-DELISTED	Stock	23.77	27.675	23.77	26.3	356040.0
2016-12-27	AABA-DELISTED	Stock	38.59	39.065	38.5	38.92	3086026.0
2016-12-27	AAC-DELISTED	Stock	7.3	7.35	7.15	7.16	205909.0
2016-12-27	AACG	Stock	3.73	3.73	3.73	3.73	300.0
2016-12-27	AAIC-DELISTED	Stock	15.69	15.72	15.57	15.71	633637.0
2016-12-27	AAL	Stock	48.29	48.92	48.14	48.61	2797800.0
2016-12-27	AAMC-DELISTED	Stock	15.75	17.2456	15.75	16.9859	73256.0
2016-12-27	AAME	Stock	3.9	3.9	3.75	3.75	1900.0
2016-12-27	AAMI	Stock	14.35	14.58	14.35	14.51	356900.0
2016-12-27	AAOI	Stock	24.95	25.45	24.63	24.72	249000.0
2016-12-27	AAON	Stock	22.2333	22.6	22.2	22.4667	126300.0
2016-12-27	AAP	Stock	170.72	172.75	170.72	171.84	508700.0
2016-12-27	AAT	Stock	42.37	42.77	42.0	42.55	180800.0
2016-12-27	AAU-DELISTED	Stock	0.9475	0.9475	0.88	0.89	207069.0
2016-12-27	AAUAF-DELISTED	Stock	0.9475	0.9475	0.88	0.89	218964.0
2016-12-27	AAV-DELISTED	Stock	6.8	6.9	6.75	6.8	58490.0
2016-12-27	AAWW-DELISTED	Stock	53.0	53.45	52.4	52.9	63240.0
2016-12-27	AAXJ	Stock	54.27	54.4724	54.27	54.32	1934669.0
2016-12-27	AAXN-DELISTED	Stock	24.54	25.03	24.27	24.82	491162.0
2016-12-27	AB	Stock	23.7	24.0	23.55	23.75	358800.0
2016-12-27	ABAC-DELISTED	Stock	3.89	3.89	3.7	3.86	1827.0
2016-12-27	ABAX-DELISTED	Stock	52.14	52.8	52.11	52.33	44517.0
2016-12-27	ABB-DELISTED	Stock	21.04	21.1299	21.02	21.085	653222.0
2016-12-27	ABBNY-DELISTED	Stock	21.04	21.1299	21.02	21.08	675530.0
2016-12-27	ABBV	Stock	62.52	63.02	62.41	62.5	5396200.0
2016-12-27	ABC-DELISTED	Stock	78.42	79.27	78.3	78.83	551670.0
2016-12-27	ABCB	Stock	44.5	45.1	44.3	45.1	109500.0
2016-12-27	ABCD-DELISTED	Stock	4.92	5.0	4.92	4.96	9514.0
2016-12-27	ABCO-DELISTED	Stock	32.35	33.65	32.35	33.25	350321.0
2016-12-27	ABDC-DELISTED	Stock	12.57	12.64	12.5135	12.6145	47512.0
2016-12-27	ABE-DELISTED	Stock	10.9	11.0	10.9	11.0	61338.0
2016-12-27	ABEO	Stock	118.75	133.75	118.75	130.0	13140.0
2016-12-27	ABEV	Stock	4.91	4.92	4.87	4.89	7997700.0
2016-12-27	ABG	Stock	62.15	64.55	61.9	63.65	184000.0
2016-12-27	ABIL-DELISTED	Stock	2.74	2.85	2.74	2.8	55002.0
2016-12-27	ABM	Stock	40.17	40.73	40.12	40.58	361300.0
2016-12-27	ABMD-DELISTED	Stock	112.37	113.95	112.05	113.7	158319.0
2016-12-27	ABR	Stock	7.47	7.52	7.38	7.42	102900.0

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

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