PREVIEW / stock_daily / 2014-09-17

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-17.parquet
  size:    222 KB
  rows:    6,634
  symbols: 3,580

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
2014-09-17	AAPL	Stock	25.3175	25.45	25.1475	25.395	243706000.0
2014-09-17	MSFT	Stock	46.26	46.69	46.23	46.52	38311900.0
2014-09-17	NVDA	Stock	0.4772	0.4832	0.475	0.4788	173584000.0
2014-09-17	AMZN	Stock	16.388	16.4	16.076	16.2	82720000.0
2014-09-17	GOOGL	Stock	29.4755	29.8035	29.356	29.6645	34418420.0
2014-09-17	META	Stock	75.96	77.25	75.57	76.43	28693000.0
2014-09-17	TSLA	Stock	17.494	17.6467	17.3	17.4253	77665500.0
2014-09-17	TLT	Stock	113.53	113.83	112.73	112.8	12917553.0
2014-09-17	ES	Stock	45.8	45.93	45.38	45.62	2088800.0
2014-09-17	CL	Stock	65.41	65.42	64.84	65.24	3709500.0
2014-09-17	A	Stock	41.4878	42.196	41.4306	42.1245	3788440.0
2014-09-17	AABA-DELISTED	Stock	42.37	42.96	42.3	42.585	37704321.0
2014-09-17	AACG	Stock	4.59	4.59	4.5	4.51	6900.0
2014-09-17	AAIC-DELISTED	Stock	27.08	27.43	27.0045	27.29	233701.0
2014-09-17	AAL	Stock	37.92	38.24	37.04	37.46	6682700.0
2014-09-17	AAMC-DELISTED	Stock	198.5294	207.3529	198.5294	204.4118	22471.0
2014-09-17	AAME	Stock	3.95	4.02	3.95	4.02	1600.0
2014-09-17	AAOI	Stock	17.94	18.54	17.755	18.07	158800.0
2014-09-17	AAON	Stock	12.3333	12.42	12.2267	12.2533	170400.0
2014-09-17	AAP	Stock	135.31	136.16	134.28	134.37	361200.0
2014-09-17	AAT	Stock	33.61	33.97	33.58	33.7	156500.0
2014-09-17	AAU-DELISTED	Stock	1.6	1.6513	1.58	1.58	154979.0
2014-09-17	AAUAF-DELISTED	Stock	1.6	1.62	1.55	1.58	159819.0
2014-09-17	AAV-DELISTED	Stock	5.62	5.64	5.48	5.53	492281.0
2014-09-17	AAVL-DELISTED	Stock	32.3	34.0	32.19	32.8	88700.0
2014-09-17	AAWW-DELISTED	Stock	35.72	36.5	35.41	36.0	138916.0
2014-09-17	AAXJ	Stock	64.39	64.5	63.933	63.98	296539.0
2014-09-17	AAXN-DELISTED	Stock	17.76	17.95	17.08	17.195	3224018.0
2014-09-17	AB	Stock	27.41	27.5	27.22	27.4	99600.0
2014-09-17	ABAC-DELISTED	Stock	1.8999	1.9	1.79	1.9	82504.0
2014-09-17	ABAX-DELISTED	Stock	52.16	52.5275	51.88	52.46	117111.0
2014-09-17	ABB-DELISTED	Stock	23.0	23.21	22.97	23.02	2897791.0
2014-09-17	ABBNY-DELISTED	Stock	23.0	23.21	22.97	23.02	3013042.0
2014-09-17	ABBV	Stock	58.89	60.02	58.75	59.62	14389400.0
2014-09-17	ABC-DELISTED	Stock	77.25	77.29	76.19	76.53	1469940.0
2014-09-17	ABCB	Stock	22.66	22.92	22.51	22.67	57700.0
2014-09-17	ABCD-DELISTED	Stock	1.54	1.56	1.29	1.5	62190.0
2014-09-17	ABCO-DELISTED	Stock	47.96	48.87	47.47	48.3	540434.0
2014-09-17	ABDC-DELISTED	Stock	13.61	13.84	13.51	13.53	40488.0
2014-09-17	ABE-DELISTED	Stock	14.53	14.638	14.4	14.47	9641.0
2014-09-17	ABEO	Stock	350.0	387.5	350.0	387.5	8.0
2014-09-17	ABEV	Stock	6.95	6.99	6.73	6.77	16072500.0
2014-09-17	ABG	Stock	66.42	67.12	66.25	66.57	285000.0
2014-09-17	ABGB-DELISTED	Stock	28.3	28.49	28.19	28.19	40797.0
2014-09-17	ABIL-DELISTED	Stock	9.81	9.82	9.8	9.82	3000.0
2014-09-17	ABM	Stock	27.62	27.74	27.32	27.6	254500.0
2014-09-17	ABMD-DELISTED	Stock	24.93	25.84	24.8	25.18	187410.0
2014-09-17	ABR	Stock	6.82	6.85	6.75	6.76	80800.0
2014-09-17	ABR.A-DELISTED	Stock	24.59	24.6	24.59	24.6	6500.0
2014-09-17	ABR.B-DELISTED	Stock	23.95	24.025	23.87	23.947	8021.0

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

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