PREVIEW / stock_daily / 2016-06-17

all stock daily files

  file:    by_date/stock_daily/2016/2016-06-17.parquet
  size:    219 KB
  rows:    6,546
  symbols: 3,268

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-06-17	AAPL	Stock	24.155	24.1625	23.825	23.8325	244032800.0
2016-06-17	MSFT	Stock	50.41	50.43	49.82	50.13	45710500.0
2016-06-17	NVDA	Stock	1.1902	1.1905	1.1633	1.168	471000000.0
2016-06-17	AMZN	Stock	35.9095	35.91	34.959	35.3195	117956000.0
2016-06-17	GOOGL	Stock	36.0695	36.0695	35.056	35.2125	82261700.0
2016-06-17	META	Stock	114.42	114.43	112.56	113.02	24644300.0
2016-06-17	TSLA	Stock	14.5207	14.666	14.3	14.3647	46689000.0
2016-06-17	TLT	Stock	136.2	136.2699	135.26	135.61	8489852.0
2016-06-17	ES	Stock	56.77	56.89	56.35	56.89	1858700.0
2016-06-17	CL	Stock	71.87	72.08	70.97	71.44	4064400.0
2016-06-17	A	Stock	45.42	45.42	44.87	45.36	3434800.0
2016-06-17	AA.B-DELISTED	Stock	33.13	33.52	32.9829	33.5	35109.0
2016-06-17	AAAP-DELISTED	Stock	29.31	29.31	27.79	28.6	80864.0
2016-06-17	AABA-DELISTED	Stock	37.43	37.4399	36.81	36.95	11713244.0
2016-06-17	AAC-DELISTED	Stock	19.88	19.96	19.0	19.26	172939.0
2016-06-17	AACG	Stock	5.08	5.1	5.06	5.07	8300.0
2016-06-17	AAIC-DELISTED	Stock	13.27	13.63	13.22	13.31	336711.0
2016-06-17	AAL	Stock	29.1	29.55	28.85	29.34	15301900.0
2016-06-17	AAMC-DELISTED	Stock	4.9941	5.8588	4.8971	5.2794	258257.0
2016-06-17	AAME	Stock	3.94	3.94	3.83	3.83	1900.0
2016-06-17	AAMI	Stock	14.3	14.5	14.155	14.24	327600.0
2016-06-17	AAOI	Stock	10.25	10.26	9.85	9.87	412500.0
2016-06-17	AAON	Stock	17.3733	17.4333	17.1533	17.2333	382650.0
2016-06-17	AAP	Stock	153.57	155.0	152.41	154.55	1035900.0
2016-06-17	AAT	Stock	41.0	41.0	40.49	40.73	336200.0
2016-06-17	AAU-DELISTED	Stock	1.2	1.25	1.18	1.22	525251.0
2016-06-17	AAUAF-DELISTED	Stock	1.2	1.25	1.18	1.22	528603.0
2016-06-17	AAV-DELISTED	Stock	5.52	5.64	5.5	5.6	107187.0
2016-06-17	AAWW-DELISTED	Stock	43.02	43.84	42.91	43.35	252394.0
2016-06-17	AAXJ	Stock	53.12	53.17	52.73	53.06	643071.0
2016-06-17	AAXN-DELISTED	Stock	22.7	23.09	22.32	22.93	1053724.0
2016-06-17	AB	Stock	22.53	23.13	22.5	22.98	245300.0
2016-06-17	ABAC-DELISTED	Stock	0.788	0.8095	0.75	0.789	11900.0
2016-06-17	ABAX-DELISTED	Stock	46.06	46.13	44.28	44.85	241094.0
2016-06-17	ABB-DELISTED	Stock	20.5	20.6	20.385	20.55	2528455.0
2016-06-17	ABBNY-DELISTED	Stock	20.5	20.6	20.385	20.55	2583332.0
2016-06-17	ABBV	Stock	60.88	60.97	59.57	60.01	12574700.0
2016-06-17	ABC-DELISTED	Stock	76.01	76.33	75.16	75.71	2803537.0
2016-06-17	ABCB	Stock	29.56	29.85	28.85	29.24	415300.0
2016-06-17	ABCD-DELISTED	Stock	4.7	4.7	4.54	4.55	51451.0
2016-06-17	ABCO-DELISTED	Stock	34.0	35.05	33.63	33.95	588910.0
2016-06-17	ABDC-DELISTED	Stock	12.15	12.195	12.05	12.05	23474.0
2016-06-17	ABE-DELISTED	Stock	11.7917	11.835	11.76	11.8	6047.0
2016-06-17	ABEO	Stock	72.0	73.75	70.75	72.25	2924.0
2016-06-17	ABEV	Stock	5.4	5.43	5.35	5.4	9282900.0
2016-06-17	ABG	Stock	55.18	57.25	54.7	56.15	452000.0
2016-06-17	ABIL-DELISTED	Stock	4.2999	4.2999	4.05	4.13	18525.0
2016-06-17	ABM	Stock	37.07	37.19	36.07	36.26	479000.0
2016-06-17	ABMD-DELISTED	Stock	100.33	100.46	98.07	99.27	701706.0
2016-06-17	ABR	Stock	6.79	6.83	6.79	6.8	357200.0

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

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