PREVIEW / stock_daily / 2016-10-19

all stock daily files

  file:    by_date/stock_daily/2016/2016-10-19.parquet
  size:    216 KB
  rows:    6,500
  symbols: 3,186

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-19	AAPL	Stock	29.3125	29.44	28.45	29.28	80138400.0
2016-10-19	MSFT	Stock	57.47	57.84	57.4	57.53	22878400.0
2016-10-19	NVDA	Stock	1.654	1.6695	1.6455	1.6618	199060000.0
2016-10-19	AMZN	Stock	41.02	41.0335	40.7585	40.8845	41814000.0
2016-10-19	GOOGL	Stock	41.226	41.4905	41.1603	41.3545	30002840.0
2016-10-19	META	Stock	128.74	130.47	128.6	130.11	16752300.0
2016-10-19	TSLA	Stock	13.316	13.7773	13.204	13.5707	104868000.0
2016-10-19	TLT	Stock	132.37	133.27	132.32	132.97	6941279.0
2016-10-19	ES	Stock	54.13	54.19	53.59	53.97	1629600.0
2016-10-19	CL	Stock	71.81	72.02	71.45	71.7	2941000.0
2016-10-19	A	Stock	45.41	46.15	45.34	46.02	1769000.0
2016-10-19	AA	Stock	21.1864	21.9714	21.1224	21.659	12456679.0
2016-10-19	AA.B-DELISTED	Stock	29.24	30.0293	29.24	29.7	34509.0
2016-10-19	AAAP-DELISTED	Stock	38.66	39.1399	38.1	38.2	39661.0
2016-10-19	AABA-DELISTED	Stock	42.3	42.94	42.26	42.73	13534412.0
2016-10-19	AAC-DELISTED	Stock	16.8	17.0	16.56	16.9	102884.0
2016-10-19	AACG	Stock	3.8	3.94	3.73	3.73	1100.0
2016-10-19	AAIC-DELISTED	Stock	14.46	14.5599	14.41	14.45	113889.0
2016-10-19	AAL	Stock	39.48	40.81	39.4	40.63	12764200.0
2016-10-19	AAMC-DELISTED	Stock	11.1324	12.0	9.9265	10.0735	137204.0
2016-10-19	AAME	Stock	3.81	4.05	3.8	3.95	3200.0
2016-10-19	AAMI	Stock	14.11	14.22	14.0	14.14	144600.0
2016-10-19	AAOI	Stock	20.01	20.33	19.98	20.295	241400.0
2016-10-19	AAON	Stock	19.5333	19.5333	19.1067	19.2333	178200.0
2016-10-19	AAP	Stock	142.06	145.0	138.02	142.23	2178400.0
2016-10-19	AAT	Stock	40.75	40.79	40.37	40.58	167400.0
2016-10-19	AAU-DELISTED	Stock	1.26	1.29	1.2599	1.28	228436.0
2016-10-19	AAUAF-DELISTED	Stock	1.26	1.29	1.2599	1.28	231426.0
2016-10-19	AAV-DELISTED	Stock	7.73	7.86	7.65	7.67	170661.0
2016-10-19	AAWW-DELISTED	Stock	42.3	42.85	42.0	42.7	72094.0
2016-10-19	AAXJ	Stock	60.02	60.27	59.94	60.2	2149208.0
2016-10-19	AAXN-DELISTED	Stock	22.69	23.34	22.63	23.22	573276.0
2016-10-19	AB	Stock	22.0	22.25	21.9	22.0	146900.0
2016-10-19	ABAC-DELISTED	Stock	2.09	2.34	1.925	2.22	31122.0
2016-10-19	ABAX-DELISTED	Stock	52.49	53.09	51.765	52.38	78351.0
2016-10-19	ABB-DELISTED	Stock	22.41	22.52	22.4	22.46	1869699.0
2016-10-19	ABBNY-DELISTED	Stock	22.41	22.52	22.4	22.45	2931201.0
2016-10-19	ABBV	Stock	62.04	62.16	61.17	61.43	5588900.0
2016-10-19	ABC-DELISTED	Stock	81.2	81.2	80.35	80.35	1450438.0
2016-10-19	ABCB	Stock	35.9	36.05	35.8	35.9	180100.0
2016-10-19	ABCD-DELISTED	Stock	5.08	5.19	5.08	5.16	3149.0
2016-10-19	ABCO-DELISTED	Stock	43.7	43.75	43.08	43.08	103671.0
2016-10-19	ABDC-DELISTED	Stock	12.76	12.9	12.7	12.82	17256.0
2016-10-19	ABEO	Stock	197.0	200.0	187.5	194.0	30864.0
2016-10-19	ABEOW-DELISTED	Stock	4.245	4.25	4.05	4.1073	2030.0
2016-10-19	ABEV	Stock	6.15	6.2	6.12	6.2	11059300.0
2016-10-19	ABG	Stock	54.6	56.15	54.25	55.95	147500.0
2016-10-19	ABIL-DELISTED	Stock	3.63	3.6345	3.54	3.6	4466.0
2016-10-19	ABM	Stock	38.11	38.11	37.78	37.86	208100.0
2016-10-19	ABMD-DELISTED	Stock	129.5	129.67	127.12	127.84	157480.0

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

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