PREVIEW / stock_daily / 2017-02-08

all stock daily files

  file:    by_date/stock_daily/2017/2017-02-08.parquet
  size:    216 KB
  rows:    6,474
  symbols: 3,076

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
2017-02-08	AAPL	Stock	32.8375	33.055	32.805	33.01	92016400.0
2017-02-08	MSFT	Stock	63.57	63.81	63.22	63.34	18096400.0
2017-02-08	NVDA	Stock	2.96	2.9828	2.9095	2.9652	449580000.0
2017-02-08	AMZN	Stock	40.6345	41.074	40.625	40.9855	57160000.0
2017-02-08	GOOGL	Stock	41.5265	41.7125	41.2555	41.494	26044500.0
2017-02-08	META	Stock	132.6	134.44	132.44	134.2	22390600.0
2017-02-08	TSLA	Stock	17.1567	17.5573	17.08	17.472	58995000.0
2017-02-08	TLT	Stock	121.42	122.27	121.41	122.24	15734201.0
2017-02-08	ES	Stock	55.66	56.71	55.66	56.49	1341600.0
2017-02-08	CL	Stock	66.67	66.99	66.4	66.59	3575100.0
2017-02-08	A	Stock	49.37	50.03	49.23	49.93	2107100.0
2017-02-08	AA	Stock	37.93	38.5	37.11	37.54	3121700.0
2017-02-08	AAAP-DELISTED	Stock	34.63	35.0	34.6	35.0	80962.0
2017-02-08	AABA-DELISTED	Stock	44.52	45.19	44.34	45.07	6138030.0
2017-02-08	AAC-DELISTED	Stock	7.85	7.95	7.76	7.8	80013.0
2017-02-08	AACG	Stock	3.23	3.23	3.0	3.18	20100.0
2017-02-08	AAIC-DELISTED	Stock	14.95	14.98	14.44	14.89	1185716.0
2017-02-08	AAL	Stock	45.26	45.26	44.51	45.06	4329900.0
2017-02-08	AAMC-DELISTED	Stock	23.6765	24.7059	22.4044	22.8676	36319.0
2017-02-08	AAME	Stock	3.7	3.7	3.7	3.7	300.0
2017-02-08	AAMI	Stock	14.59	14.6	14.43	14.48	321800.0
2017-02-08	AAOI	Stock	31.5	31.575	30.68	31.34	387000.0
2017-02-08	AAON	Stock	22.5	22.7333	22.4	22.6333	126450.0
2017-02-08	AAP	Stock	158.29	163.65	158.26	162.73	1921800.0
2017-02-08	AAT	Stock	42.55	43.15	42.51	43.13	123700.0
2017-02-08	AAU-DELISTED	Stock	1.26	1.3	1.2	1.205	578667.0
2017-02-08	AAUAF-DELISTED	Stock	1.26	1.3	1.2	1.205	584381.0
2017-02-08	AAV-DELISTED	Stock	6.05	6.35	5.975	6.3	106190.0
2017-02-08	AAWW-DELISTED	Stock	51.5	51.55	50.5	50.75	126451.0
2017-02-08	AAXJ	Stock	59.54	59.825	59.44	59.74	770103.0
2017-02-08	AAXN-DELISTED	Stock	26.79	26.85	26.22	26.52	809077.0
2017-02-08	AB	Stock	23.25	23.45	23.05	23.1	296100.0
2017-02-08	ABAC-DELISTED	Stock	3.7618	3.83	3.5628	3.67	27380.0
2017-02-08	ABAX-DELISTED	Stock	50.41	50.475	49.44	49.94	170972.0
2017-02-08	ABB-DELISTED	Stock	22.71	22.72	22.57	22.61	3462010.0
2017-02-08	ABBNY-DELISTED	Stock	22.71	22.72	22.57	22.61	3670237.0
2017-02-08	ABBV	Stock	60.14	61.02	60.05	60.52	5357800.0
2017-02-08	ABC-DELISTED	Stock	90.18	91.11	89.675	91.06	1243586.0
2017-02-08	ABCB	Stock	45.3	45.55	44.6	45.05	105900.0
2017-02-08	ABCD-DELISTED	Stock	4.96	5.01	4.92	4.96	39811.0
2017-02-08	ABCO-DELISTED	Stock	46.45	46.75	46.25	46.4	510625.0
2017-02-08	ABDC-DELISTED	Stock	12.33	12.35	12.19	12.34	22045.0
2017-02-08	ABE-DELISTED	Stock	11.9	11.9599	11.8506	11.954	2790.0
2017-02-08	ABEO	Stock	133.75	136.25	125.0	127.5	16148.0
2017-02-08	ABEOW-DELISTED	Stock	3.0	3.0	3.0	3.0	465.0
2017-02-08	ABEV	Stock	5.4	5.42	5.34	5.39	15662600.0
2017-02-08	ABG	Stock	66.4	66.45	65.0	65.65	333000.0
2017-02-08	ABIL-DELISTED	Stock	3.23	3.3	3.21	3.26	43391.0
2017-02-08	ABM	Stock	40.03	40.03	39.41	39.9	353700.0
2017-02-08	ABMD-DELISTED	Stock	109.9	110.38	108.42	108.73	220303.0

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

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