PREVIEW / stock_daily / 2014-09-16

all stock daily files

  file:    by_date/stock_daily/2014/2014-09-16.parquet
  size:    222 KB
  rows:    6,635
  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-16	AAPL	Stock	24.95	25.315	24.7225	25.215	267632400.0
2014-09-16	MSFT	Stock	46.39	46.85	46.29	46.76	27910600.0
2014-09-16	NVDA	Stock	0.4702	0.481	0.4688	0.4785	219936000.0
2014-09-16	AMZN	Stock	16.0535	16.474	16.005	16.388	65198000.0
2014-09-16	GOOGL	Stock	29.0475	29.5075	29.0475	29.439	31631780.0
2014-09-16	META	Stock	73.52	76.23	73.07	76.08	37742000.0
2014-09-16	TSLA	Stock	17.01	17.4973	16.828	17.3827	124501500.0
2014-09-16	TLT	Stock	113.61	113.86	113.08	113.09	9305931.0
2014-09-16	ES	Stock	44.62	45.68	44.54	45.56	2162000.0
2014-09-16	CL	Stock	64.38	65.4	64.25	65.14	4466400.0
2014-09-16	A	Stock	41.3591	41.5665	41.0372	41.4235	1928960.0
2014-09-16	AABA-DELISTED	Stock	42.61	42.96	41.69	42.71	58615533.0
2014-09-16	AACG	Stock	4.51	4.51	4.4	4.4	4100.0
2014-09-16	AAIC-DELISTED	Stock	26.82	27.06	26.75	26.99	244077.0
2014-09-16	AAL	Stock	37.0	38.01	36.81	37.98	6723000.0
2014-09-16	AAMC-DELISTED	Stock	200.5912	200.6824	200.5912	200.6824	3618.0
2014-09-16	AAME	Stock	3.95	3.95	3.92	3.95	3600.0
2014-09-16	AAOI	Stock	17.76	18.113	17.6	17.87	231300.0
2014-09-16	AAON	Stock	12.02	12.4067	12.0067	12.34	199950.0
2014-09-16	AAP	Stock	133.39	136.47	133.1	135.42	735600.0
2014-09-16	AAT	Stock	33.62	33.8	33.44	33.63	145000.0
2014-09-16	AAU-DELISTED	Stock	1.62	1.64	1.58	1.58	154587.0
2014-09-16	AAUAF-DELISTED	Stock	1.62	1.64	1.58	1.58	156205.0
2014-09-16	AAV-DELISTED	Stock	5.58	5.7	5.58	5.62	647453.0
2014-09-16	AAVL-DELISTED	Stock	32.83	33.53	31.19	32.68	75017.0
2014-09-16	AAWW-DELISTED	Stock	35.7	35.84	35.1	35.62	180789.0
2014-09-16	AAXJ	Stock	63.61	64.71	63.5	64.36	1288735.0
2014-09-16	AAXN-DELISTED	Stock	17.65	18.22	17.31	18.01	2889246.0
2014-09-16	AB	Stock	27.5	27.55	27.35	27.4	182800.0
2014-09-16	ABAC-DELISTED	Stock	1.81	1.84	1.7101	1.83	75897.0
2014-09-16	ABAX-DELISTED	Stock	52.36	52.52	51.71	51.99	122513.0
2014-09-16	ABB-DELISTED	Stock	22.92	23.18	22.865	23.1	1801854.0
2014-09-16	ABBNY-DELISTED	Stock	22.92	23.18	22.865	23.09	2017911.0
2014-09-16	ABBV	Stock	57.63	58.7	57.46	58.6	9112400.0
2014-09-16	ABC-DELISTED	Stock	76.47	77.44	75.71	77.11	1753883.0
2014-09-16	ABCB	Stock	22.77	22.83	22.5	22.7	94300.0
2014-09-16	ABCD-DELISTED	Stock	1.59	1.64	1.56	1.57	15604.0
2014-09-16	ABCO-DELISTED	Stock	49.33	49.62	47.6	47.84	243707.0
2014-09-16	ABDC-DELISTED	Stock	13.64	13.94	13.58	13.58	36009.0
2014-09-16	ABE-DELISTED	Stock	14.35	14.63	14.35	14.63	18841.0
2014-09-16	ABEO	Stock	362.5	387.5	362.5	387.5	20.0
2014-09-16	ABEV	Stock	6.85	7.09	6.81	6.96	15936500.0
2014-09-16	ABG	Stock	65.31	66.52	65.0	66.4	284600.0
2014-09-16	ABGB-DELISTED	Stock	26.71	27.6999	26.65	27.67	3943.0
2014-09-16	ABM	Stock	27.58	27.73	27.25	27.65	274400.0
2014-09-16	ABMD-DELISTED	Stock	24.65	24.89	24.5	24.82	272408.0
2014-09-16	ABR	Stock	6.84	6.9	6.81	6.81	63000.0
2014-09-16	ABR.A-DELISTED	Stock	24.698	24.7	24.698	24.7	400.0
2014-09-16	ABR.B-DELISTED	Stock	23.8701	23.99	23.8701	23.97	900.0
2014-09-16	ABR.C-DELISTED	Stock	25.05	25.1	25.03	25.03	6470.0

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

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