PREVIEW / stock_daily / 2016-09-09

all stock daily files

  file:    by_date/stock_daily/2016/2016-09-09.parquet
  size:    219 KB
  rows:    6,564
  symbols: 3,235

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-09-09	AAPL	Stock	26.16	26.43	25.7825	25.7825	186228000.0
2016-09-09	MSFT	Stock	56.79	57.52	56.21	56.21	35113900.0
2016-09-09	NVDA	Stock	1.5488	1.5575	1.475	1.488	697760000.0
2016-09-09	AMZN	Stock	38.968	39.05	38.0055	38.007	85146000.0
2016-09-09	GOOGL	Stock	39.9385	40.0875	39.4025	39.424	37752660.0
2016-09-09	META	Stock	129.71	129.95	127.1	127.1	27100700.0
2016-09-09	TSLA	Stock	13.2727	13.328	12.9133	12.9647	56355000.0
2016-09-09	TLT	Stock	136.07	136.12	135.41	135.52	13347664.0
2016-09-09	ES	Stock	54.52	54.6	53.24	53.25	2740000.0
2016-09-09	CL	Stock	72.35	72.48	70.86	70.86	5626300.0
2016-09-09	A	Stock	46.51	46.53	44.87	44.88	2507000.0
2016-09-09	AA.B-DELISTED	Stock	34.27	34.27	32.45	32.66	221785.0
2016-09-09	AAAP-DELISTED	Stock	34.75	34.78	33.757	34.78	30388.0
2016-09-09	AABA-DELISTED	Stock	43.94	44.15	42.82	42.92	11324692.0
2016-09-09	AAC-DELISTED	Stock	19.23	19.27	18.69	18.72	65195.0
2016-09-09	AACG	Stock	4.8	4.9	4.6	4.89	5600.0
2016-09-09	AAIC-DELISTED	Stock	15.25	15.26	14.71	14.71	286840.0
2016-09-09	AAL	Stock	39.0	39.34	38.17	38.49	8623600.0
2016-09-09	AAMC-DELISTED	Stock	3.9441	4.0941	3.8509	3.9706	23739.0
2016-09-09	AAME	Stock	3.44	3.57	3.37	3.57	28700.0
2016-09-09	AAMI	Stock	13.42	13.52	13.05	13.06	91100.0
2016-09-09	AAOI	Stock	20.1	20.53	19.57	19.63	629100.0
2016-09-09	AAON	Stock	18.5	18.5	17.9067	17.9133	241500.0
2016-09-09	AAP	Stock	156.86	157.74	152.96	152.96	1497800.0
2016-09-09	AAT	Stock	44.06	44.06	42.86	42.87	199800.0
2016-09-09	AAU-DELISTED	Stock	1.53	1.55	1.39	1.409	488138.0
2016-09-09	AAUAF-DELISTED	Stock	1.53	1.55	1.39	1.39	492727.0
2016-09-09	AAV-DELISTED	Stock	7.2	7.2	6.88	6.95	92889.0
2016-09-09	AAWW-DELISTED	Stock	39.38	39.42	38.54	38.58	287444.0
2016-09-09	AAXJ	Stock	60.26	60.26	59.34	59.34	984714.0
2016-09-09	AAXN-DELISTED	Stock	25.64	25.84	25.05	25.18	826761.0
2016-09-09	AB	Stock	22.0	22.17	21.91	21.99	282600.0
2016-09-09	ABAC-DELISTED	Stock	2.22	2.76	1.6236	2.03	50869.0
2016-09-09	ABAX-DELISTED	Stock	48.85	49.11	47.56	47.6	124545.0
2016-09-09	ABB-DELISTED	Stock	22.57	22.58	22.17	22.175	1785704.0
2016-09-09	ABBNY-DELISTED	Stock	22.57	22.58	22.17	22.17	1837843.0
2016-09-09	ABBV	Stock	63.22	64.0	63.06	63.36	8848500.0
2016-09-09	ABC-DELISTED	Stock	86.82	86.82	85.05	85.13	2110489.0
2016-09-09	ABCB	Stock	35.82	36.2	35.72	35.77	305200.0
2016-09-09	ABCD-DELISTED	Stock	5.3112	5.53	5.27	5.42	30464.0
2016-09-09	ABCO-DELISTED	Stock	43.32	43.44	43.035	43.31	265315.0
2016-09-09	ABDC-DELISTED	Stock	12.85	12.89	12.72	12.82	20003.0
2016-09-09	ABE-DELISTED	Stock	12.65	12.65	12.45	12.55	22810.0
2016-09-09	ABEO	Stock	128.0	129.25	119.25	121.5	10852.0
2016-09-09	ABEOW-DELISTED	Stock	2.2	2.2	2.2	2.2	500.0
2016-09-09	ABEV	Stock	6.07	6.1	5.99	5.99	21874600.0
2016-09-09	ABG	Stock	54.77	54.77	53.46	53.5	174000.0
2016-09-09	ABIL-DELISTED	Stock	3.95	3.95	3.82	3.87	20950.0
2016-09-09	ABM	Stock	40.2	40.2	38.55	38.58	350800.0
2016-09-09	ABMD-DELISTED	Stock	119.11	120.1	116.3	116.33	313105.0

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

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