PREVIEW / stock_daily / 2014-09-25

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-25.parquet
  size:    221 KB
  rows:    6,609
  symbols: 3,563

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-25	AAPL	Stock	25.1275	25.1775	24.43	24.4675	400368000.0
2014-09-25	MSFT	Stock	46.88	47.09	46.03	46.04	33077400.0
2014-09-25	NVDA	Stock	0.4725	0.4738	0.4618	0.4628	298440000.0
2014-09-25	AMZN	Stock	16.3995	16.427	16.07	16.0965	58576000.0
2014-09-25	GOOGL	Stock	29.8495	29.9035	29.237	29.2625	33529700.0
2014-09-25	META	Stock	78.6	78.94	77.13	77.22	37533000.0
2014-09-25	TSLA	Stock	16.8347	16.9973	16.4067	16.4633	72513000.0
2014-09-25	TLT	Stock	115.31	116.18	115.31	116.17	8949883.0
2014-09-25	ES	Stock	44.52	44.75	44.26	44.27	921900.0
2014-09-25	CL	Stock	66.02	66.06	65.46	65.48	2553000.0
2014-09-25	A	Stock	41.3877	41.4807	40.6938	40.6938	2278181.0
2014-09-25	AA.B-DELISTED	Stock	49.65	49.7	48.78	49.18	112818.0
2014-09-25	AABA-DELISTED	Stock	39.56	39.8	38.82	38.9535	34842573.0
2014-09-25	AACG	Stock	4.5	4.5	4.5	4.5	3200.0
2014-09-25	AAIC-DELISTED	Stock	26.23	26.36	25.92	26.2	464106.0
2014-09-25	AAL	Stock	35.88	35.98	34.87	35.21	10931800.0
2014-09-25	AAMC-DELISTED	Stock	211.7647	211.7647	205.0	205.0	16048.0
2014-09-25	AAME	Stock	3.82	3.83	3.78	3.79	3200.0
2014-09-25	AAOI	Stock	17.75	17.94	16.91	16.96	177700.0
2014-09-25	AAON	Stock	11.8333	11.8667	11.6133	11.6533	209850.0
2014-09-25	AAP	Stock	130.62	130.92	128.2	128.2	467700.0
2014-09-25	AAT	Stock	33.3	33.36	32.9	33.21	134400.0
2014-09-25	AAU-DELISTED	Stock	1.4	1.42	1.37	1.39	135470.0
2014-09-25	AAUAF-DELISTED	Stock	1.4	1.42	1.37	1.39	136167.0
2014-09-25	AAV-DELISTED	Stock	5.25	5.26	4.97	5.09	413307.0
2014-09-25	AAVL-DELISTED	Stock	34.2	36.1	32.7	35.17	202896.0
2014-09-25	AAWW-DELISTED	Stock	34.13	34.17	33.33	33.88	135771.0
2014-09-25	AAXJ	Stock	62.69	62.69	62.17	62.28	756477.0
2014-09-25	AAXN-DELISTED	Stock	16.1	16.59	15.98	15.99	2135755.0
2014-09-25	AB	Stock	27.13	27.19	26.02	26.11	321100.0
2014-09-25	ABAC-DELISTED	Stock	1.891	1.94	1.88	1.94	17437.0
2014-09-25	ABAX-DELISTED	Stock	51.61	51.68	50.02	50.4	580962.0
2014-09-25	ABB-DELISTED	Stock	22.85	22.86	22.51	22.57	2110943.0
2014-09-25	ABBNY-DELISTED	Stock	22.85	22.86	22.51	22.56	2161675.0
2014-09-25	ABBV	Stock	58.47	59.5	57.97	58.0	10079400.0
2014-09-25	ABC-DELISTED	Stock	77.71	78.02	77.09	77.525	1516642.0
2014-09-25	ABCB	Stock	21.99	22.05	21.67	21.92	69100.0
2014-09-25	ABCD-DELISTED	Stock	1.49	1.56	1.45	1.5	4186.0
2014-09-25	ABCO-DELISTED	Stock	44.1	44.63	43.0	44.25	395999.0
2014-09-25	ABDC-DELISTED	Stock	13.61	13.75	13.5	13.54	30688.0
2014-09-25	ABE-DELISTED	Stock	14.09	14.12	14.03	14.04	18667.0
2014-09-25	ABEO	Stock	375.0	387.5	337.5	387.5	17.0
2014-09-25	ABEV	Stock	6.81	6.84	6.7	6.77	12919000.0
2014-09-25	ABG	Stock	64.38	65.31	63.93	65.19	582500.0
2014-09-25	ABGB-DELISTED	Stock	26.69	26.69	26.18	26.28	14755.0
2014-09-25	ABM	Stock	26.9	26.97	26.36	26.38	218800.0
2014-09-25	ABMD-DELISTED	Stock	24.98	25.075	24.7	24.92	196923.0
2014-09-25	ABR	Stock	6.75	6.8	6.65	6.65	48700.0
2014-09-25	ABR.A-DELISTED	Stock	24.6	24.6	24.56	24.5854	5866.0
2014-09-25	ABR.B-DELISTED	Stock	24.26	24.35	24.25	24.35	2000.0

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

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