PREVIEW / stock_daily / 2016-10-17

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-17.parquet
  size:    215 KB
  rows:    6,498
  symbols: 3,165

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-17	AAPL	Stock	29.3325	29.46	29.195	29.3875	94499600.0
2016-10-17	MSFT	Stock	57.36	57.46	56.87	57.22	23830000.0
2016-10-17	NVDA	Stock	1.6495	1.665	1.638	1.6402	195328000.0
2016-10-17	AMZN	Stock	41.075	41.1	40.584	40.6475	67230000.0
2016-10-17	GOOGL	Stock	40.2995	40.6745	40.1915	40.342	21127340.0
2016-10-17	META	Stock	128.2	128.47	127.32	127.54	11351700.0
2016-10-17	TSLA	Stock	13.1367	13.226	12.8	12.9307	68311500.0
2016-10-17	TLT	Stock	132.1	132.74	132.09	132.43	10595886.0
2016-10-17	ES	Stock	53.24	53.77	53.24	53.75	1455100.0
2016-10-17	CL	Stock	72.41	72.72	72.05	72.08	2273400.0
2016-10-17	A	Stock	45.08	45.47	45.0	45.15	1160300.0
2016-10-17	AA.B-DELISTED	Stock	29.21	29.23	28.9	29.03	17935.0
2016-10-17	AAAP-DELISTED	Stock	38.0	38.97	37.61	38.17	184604.0
2016-10-17	AABA-DELISTED	Stock	41.35	41.94	41.24	41.78	8293556.0
2016-10-17	AAC-DELISTED	Stock	17.1	17.2	16.75	16.93	104390.0
2016-10-17	AACG	Stock	3.95	3.95	3.78	3.78	1200.0
2016-10-17	AAIC-DELISTED	Stock	14.31	14.3858	14.26	14.3	186523.0
2016-10-17	AAL	Stock	38.66	39.73	38.37	38.58	5602000.0
2016-10-17	AAMC-DELISTED	Stock	10.0	11.1765	9.4706	9.8382	228534.0
2016-10-17	AAME	Stock	3.9	4.65	3.65	3.75	14800.0
2016-10-17	AAMI	Stock	13.96	14.035	13.78	14.0	141200.0
2016-10-17	AAOI	Stock	20.25	20.338	20.0	20.03	143800.0
2016-10-17	AAON	Stock	19.5	19.5667	19.2667	19.5333	107250.0
2016-10-17	AAP	Stock	146.39	146.72	143.14	143.27	804200.0
2016-10-17	AAT	Stock	40.87	41.06	40.76	40.78	103600.0
2016-10-17	AAU-DELISTED	Stock	1.22	1.22	1.2	1.2	136962.0
2016-10-17	AAUAF-DELISTED	Stock	1.22	1.22	1.2	1.2	138162.0
2016-10-17	AAV-DELISTED	Stock	7.8	7.877	7.66	7.69	114666.0
2016-10-17	AAWW-DELISTED	Stock	41.3	41.4	40.855	41.15	61494.0
2016-10-17	AAXJ	Stock	59.0	59.16	58.91	59.0	401685.0
2016-10-17	AAXN-DELISTED	Stock	22.68	23.05	22.62	22.92	860523.0
2016-10-17	AB	Stock	21.95	22.15	21.8	21.85	119300.0
2016-10-17	ABAC-DELISTED	Stock	2.1	2.1	2.08	2.08	1600.0
2016-10-17	ABAX-DELISTED	Stock	52.0	52.6	51.41	52.4	34703.0
2016-10-17	ABB-DELISTED	Stock	22.33	22.415	22.285	22.325	986660.0
2016-10-17	ABBNY-DELISTED	Stock	22.33	22.415	22.285	22.33	1019594.0
2016-10-17	ABBV	Stock	60.1	60.71	59.86	60.14	6138700.0
2016-10-17	ABC-DELISTED	Stock	79.75	79.91	79.23	79.74	2013464.0
2016-10-17	ABCB	Stock	36.25	36.25	35.4	35.8	197400.0
2016-10-17	ABCD-DELISTED	Stock	5.17	5.25	5.1591	5.21	18069.0
2016-10-17	ABCO-DELISTED	Stock	43.47	43.8	42.63	43.49	205533.0
2016-10-17	ABDC-DELISTED	Stock	12.83	12.83	12.6999	12.73	19787.0
2016-10-17	ABE-DELISTED	Stock	12.34	12.344	12.28	12.344	2893.0
2016-10-17	ABEO	Stock	167.5	170.25	160.0	170.0	13660.0
2016-10-17	ABEOW-DELISTED	Stock	3.5	3.67	3.4999	3.6317	2450.0
2016-10-17	ABEV	Stock	6.06	6.15	6.05	6.08	9229200.0
2016-10-17	ABG	Stock	55.25	55.95	55.2	55.25	129100.0
2016-10-17	ABIL-DELISTED	Stock	3.58	3.5935	3.58	3.58	2600.0
2016-10-17	ABM	Stock	37.78	37.94	37.6	37.87	326100.0
2016-10-17	ABMD-DELISTED	Stock	127.0	129.37	126.391	127.95	281691.0

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

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