PREVIEW / stock_daily / 2014-09-15

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-15.parquet
  size:    222 KB
  rows:    6,665
  symbols: 3,596

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-15	AAPL	Stock	25.7025	25.7625	25.36	25.4075	245266000.0
2014-09-15	MSFT	Stock	46.54	46.71	46.1	46.24	37667600.0
2014-09-15	NVDA	Stock	0.4795	0.4803	0.4695	0.4715	294152000.0
2014-09-15	AMZN	Stock	16.5455	16.5665	15.95	16.1945	80008000.0
2014-09-15	GOOGL	Stock	29.112	29.196	28.8505	29.082	31002200.0
2014-09-15	META	Stock	77.15	77.25	73.43	74.58	49679000.0
2014-09-15	TSLA	Stock	18.2913	18.2933	16.6087	16.924	246831000.0
2014-09-15	TLT	Stock	113.85	114.07	113.36	113.55	5513040.0
2014-09-15	ES	Stock	44.67	44.94	44.56	44.62	1152600.0
2014-09-15	CL	Stock	64.22	64.79	64.13	64.51	3135900.0
2014-09-15	A	Stock	41.8455	41.8455	41.3019	41.4306	2266298.0
2014-09-15	AABA-DELISTED	Stock	43.98	44.005	42.14	42.545	69368550.0
2014-09-15	AACG	Stock	4.5	4.58	4.41	4.54	9900.0
2014-09-15	AAIC-DELISTED	Stock	27.05	27.059	26.8	26.82	257483.0
2014-09-15	AAL	Stock	37.6	37.8	36.84	37.07	7954200.0
2014-09-15	AAMC-DELISTED	Stock	202.9412	204.4147	198.5294	200.6765	23640.0
2014-09-15	AAME	Stock	3.96	3.99	3.88	3.94	5400.0
2014-09-15	AAOI	Stock	18.93	19.18	17.8	17.88	182700.0
2014-09-15	AAON	Stock	12.2867	12.46	12.02	12.08	250200.0
2014-09-15	AAP	Stock	133.71	134.76	132.85	133.99	684000.0
2014-09-15	AAT	Stock	34.57	34.57	33.6	33.61	175200.0
2014-09-15	AAU-DELISTED	Stock	1.6	1.6	1.55	1.6	153412.0
2014-09-15	AAUAF-DELISTED	Stock	1.6	1.6	1.55	1.6	154658.0
2014-09-15	AAV-DELISTED	Stock	5.53	5.635	5.44	5.6	300021.0
2014-09-15	AAVL-DELISTED	Stock	35.76	35.98	32.0001	33.03	276939.0
2014-09-15	AAWW-DELISTED	Stock	36.5	36.5	35.41	35.77	198673.0
2014-09-15	AAXJ	Stock	64.3	64.35	63.85	63.85	1869976.0
2014-09-15	AAXN-DELISTED	Stock	18.6	18.65	17.77	17.78	2562222.0
2014-09-15	AB	Stock	27.38	27.57	27.35	27.52	191400.0
2014-09-15	ABAC-DELISTED	Stock	1.67	1.949	1.65	1.758	188702.0
2014-09-15	ABAX-DELISTED	Stock	51.16	52.48	50.66	52.28	205518.0
2014-09-15	ABB-DELISTED	Stock	22.9	22.9	22.75	22.8	1032564.0
2014-09-15	ABBNY-DELISTED	Stock	22.9	22.9	22.75	22.8	1150898.0
2014-09-15	ABBV	Stock	57.75	58.15	57.47	57.93	8632700.0
2014-09-15	ABC-DELISTED	Stock	76.99	77.1025	76.55	76.83	859095.0
2014-09-15	ABCB	Stock	23.06	23.06	22.58	22.77	60700.0
2014-09-15	ABCD-DELISTED	Stock	1.52	1.59	1.5	1.58	8014.0
2014-09-15	ABCO-DELISTED	Stock	49.92	50.19	48.82	49.39	261963.0
2014-09-15	ABDC-DELISTED	Stock	13.75	13.92	13.58	13.61	39370.0
2014-09-15	ABE-DELISTED	Stock	14.4392	14.45	14.33	14.43	19774.0
2014-09-15	ABEV	Stock	6.65	6.82	6.65	6.8	10367200.0
2014-09-15	ABG	Stock	67.03	67.55	65.61	65.67	324800.0
2014-09-15	ABGB-DELISTED	Stock	27.11	27.11	26.86	26.98	4664.0
2014-09-15	ABM	Stock	27.75	27.77	27.41	27.61	188800.0
2014-09-15	ABMD-DELISTED	Stock	25.07	25.16	24.48	24.68	285525.0
2014-09-15	ABR	Stock	6.8	6.86	6.8	6.82	95200.0
2014-09-15	ABR.A-DELISTED	Stock	24.45	24.7199	24.45	24.5999	1060.0
2014-09-15	ABR.B-DELISTED	Stock	23.69	23.91	23.69	23.87	2100.0
2014-09-15	ABR.C-DELISTED	Stock	25.18	25.18	25.01	25.11	6496.0
2014-09-15	ABRN-DELISTED	Stock	24.3	24.3	24.167	24.25	9440.0

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

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