PREVIEW / stock_daily / 2016-10-26

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-26.parquet
  size:    215 KB
  rows:    6,507
  symbols: 3,177

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-10-26	AAPL	Stock	28.5775	28.925	28.3275	28.8975	264536800.0
2016-10-26	MSFT	Stock	60.81	61.2	60.47	60.63	29911600.0
2016-10-26	NVDA	Stock	1.7818	1.8238	1.78	1.804	333792000.0
2016-10-26	AMZN	Stock	41.638	41.672	41.0	41.1295	79962000.0
2016-10-26	GOOGL	Stock	41.356	41.3855	40.8175	41.105	35897360.0
2016-10-26	META	Stock	131.64	132.26	130.94	131.04	13084700.0
2016-10-26	TSLA	Stock	13.4	13.546	13.34	13.4827	84492000.0
2016-10-26	TLT	Stock	132.46	132.8	131.99	132.18	5842548.0
2016-10-26	ES	Stock	54.2	54.43	53.78	54.31	1584900.0
2016-10-26	CL	Stock	71.3	71.35	70.71	71.26	2941300.0
2016-10-26	A	Stock	43.42	43.82	43.24	43.37	2146200.0
2016-10-26	AA	Stock	21.8112	22.3319	21.6831	22.2598	9730587.0
2016-10-26	AA.B-DELISTED	Stock	29.97	30.4999	29.5	30.37	31931.0
2016-10-26	AAAP-DELISTED	Stock	38.08	38.75	38.02	38.65	32752.0
2016-10-26	AABA-DELISTED	Stock	42.26	42.44	41.95	42.1	5466902.0
2016-10-26	AAC-DELISTED	Stock	16.85	17.72	16.74	17.57	146766.0
2016-10-26	AACG	Stock	3.6	3.6	3.57	3.57	1500.0
2016-10-26	AAIC-DELISTED	Stock	15.08	15.1	14.74	14.75	244248.0
2016-10-26	AAL	Stock	38.57	40.26	38.21	39.32	10112300.0
2016-10-26	AAMC-DELISTED	Stock	9.6765	10.0821	9.4412	9.6912	92402.0
2016-10-26	AAME	Stock	3.41	4.3	3.41	4.15	3800.0
2016-10-26	AAMI	Stock	14.19	14.26	13.95	14.1	182700.0
2016-10-26	AAOI	Stock	21.25	21.869	20.975	21.39	131100.0
2016-10-26	AAON	Stock	19.5333	19.7	19.2667	19.4333	222600.0
2016-10-26	AAP	Stock	143.52	144.66	142.69	143.96	871500.0
2016-10-26	AAT	Stock	39.73	39.73	39.18	39.34	126000.0
2016-10-26	AAU-DELISTED	Stock	1.33	1.33	1.26	1.27	137988.0
2016-10-26	AAUAF-DELISTED	Stock	1.33	1.33	1.26	1.28	140458.0
2016-10-26	AAV-DELISTED	Stock	7.13	7.27	7.02	7.07	106229.0
2016-10-26	AAWW-DELISTED	Stock	41.8	42.45	41.775	42.4	146024.0
2016-10-26	AAXJ	Stock	59.68	59.86	59.5	59.63	306363.0
2016-10-26	AAXN-DELISTED	Stock	23.11	23.3	22.95	22.99	520498.0
2016-10-26	AB	Stock	22.3	22.89	22.2	22.4	273200.0
2016-10-26	ABAC-DELISTED	Stock	2.35	2.84	2.3147	2.8	24003.0
2016-10-26	ABAX-DELISTED	Stock	47.5	47.92	45.57	47.03	647962.0
2016-10-26	ABB-DELISTED	Stock	22.22	22.23	22.08	22.09	1470231.0
2016-10-26	ABBNY-DELISTED	Stock	22.22	22.23	22.08	22.08	1548173.0
2016-10-26	ABBV	Stock	61.51	61.71	60.71	61.02	4560800.0
2016-10-26	ABC-DELISTED	Stock	80.01	80.24	79.1	79.37	1890625.0
2016-10-26	ABCB	Stock	36.35	36.58	36.25	36.4	175600.0
2016-10-26	ABCD-DELISTED	Stock	5.031	5.04	4.97	5.02	11146.0
2016-10-26	ABCO-DELISTED	Stock	41.5	41.83	39.99	40.11	171787.0
2016-10-26	ABDC-DELISTED	Stock	13.07	13.31	12.9456	13.24	59648.0
2016-10-26	ABE-DELISTED	Stock	12.39	12.4	12.36	12.3601	2777.0
2016-10-26	ABEO	Stock	197.5	197.5	180.0	186.25	18108.0
2016-10-26	ABEOW-DELISTED	Stock	4.9	4.9	3.81	3.92	5300.0
2016-10-26	ABEV	Stock	6.2	6.28	6.18	6.22	13328100.0
2016-10-26	ABG	Stock	49.4	50.65	49.15	50.55	435900.0
2016-10-26	ABIL-DELISTED	Stock	3.43	3.6	3.42	3.5456	8881.0
2016-10-26	ABM	Stock	38.3	38.67	38.25	38.35	123000.0

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

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