PREVIEW / stock_daily / 2014-01-29

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-29.parquet
  size:    216 KB
  rows:    6,439
  symbols: 3,524

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-01-29	AAPL	Stock	17.9982	18.1204	17.8079	17.8839	502810000.0
2014-01-29	MSFT	Stock	35.98	36.88	35.9	36.66	52745900.0
2014-01-29	NVDA	Stock	0.3888	0.391	0.3862	0.3865	162944000.0
2014-01-29	AMZN	Stock	19.608	19.6425	19.162	19.21	67646000.0
2014-01-29	META	Stock	54.61	54.95	53.19	53.53	92995600.0
2014-01-29	TSLA	Stock	11.6867	11.9393	11.542	11.682	89032500.0
2014-01-29	TLT	Stock	107.37	108.15	106.99	107.87	11718542.0
2014-01-29	ES	Stock	42.77	43.04	42.56	42.81	1577800.0
2014-01-29	CL	Stock	62.79	62.79	61.43	61.59	5682200.0
2014-01-29	A	Stock	41.2518	41.6452	41.0658	41.2375	3023874.0
2014-01-29	AABA-DELISTED	Stock	35.76	36.31	34.82	34.89	62533707.0
2014-01-29	AAIC-DELISTED	Stock	26.16	26.1672	25.9	26.0	137190.0
2014-01-29	AAL	Stock	32.24	33.4	32.1	32.98	22683700.0
2014-01-29	AAMC-DELISTED	Stock	298.2294	298.2294	287.9206	291.1765	47631.0
2014-01-29	AAME	Stock	3.99	4.0	3.9	3.97	7700.0
2014-01-29	AAOI	Stock	13.63	13.82	13.57	13.61	26100.0
2014-01-29	AAON	Stock	14.2311	14.5822	13.6133	13.72	252450.0
2014-01-29	AAP	Stock	115.41	116.61	113.79	113.9	643900.0
2014-01-29	AAT	Stock	31.75	32.13	31.27	31.37	131900.0
2014-01-29	AAU-DELISTED	Stock	1.43	1.45	1.33	1.36	198213.0
2014-01-29	AAUAF-DELISTED	Stock	1.43	1.45	1.33	1.37	199943.0
2014-01-29	AAV-DELISTED	Stock	4.18	4.18	4.07	4.1	115540.0
2014-01-29	AAWW-DELISTED	Stock	36.1	36.2899	35.4	35.46	328267.0
2014-01-29	AAXJ	Stock	55.62	55.92	55.3	55.55	1035168.0
2014-01-29	AAXN-DELISTED	Stock	16.41	16.6	15.8	15.89	977503.0
2014-01-29	AB	Stock	22.02	22.14	21.57	21.87	223500.0
2014-01-29	ABAC-DELISTED	Stock	2.05	2.05	1.95	1.9601	22901.0
2014-01-29	ABAX-DELISTED	Stock	40.69	41.52	39.76	39.81	191826.0
2014-01-29	ABB-DELISTED	Stock	25.29	25.38	25.12	25.16	1671536.0
2014-01-29	ABBNY-DELISTED	Stock	25.28	25.38	25.12	25.15	1824840.0
2014-01-29	ABBV	Stock	47.15	47.84	46.98	47.61	7608500.0
2014-01-29	ABC-DELISTED	Stock	66.67	67.92	66.67	67.26	1595381.0
2014-01-29	ABCB	Stock	20.25	20.5	19.75	19.92	120400.0
2014-01-29	ABCD-DELISTED	Stock	1.98	2.06	1.8	1.83	20027.0
2014-01-29	ABCO-DELISTED	Stock	63.38	63.78	62.66	63.45	221268.0
2014-01-29	ABE-DELISTED	Stock	12.29	12.29	12.17	12.219	7974.0
2014-01-29	ABEO	Stock	475.0	487.5	475.0	475.0	13.0
2014-01-29	ABEV	Stock	6.56	6.69	6.44	6.53	11179800.0
2014-01-29	ABFS-DELISTED	Stock	32.81	33.39	32.04	32.22	425247.0
2014-01-29	ABG	Stock	46.48	47.07	46.09	46.15	610700.0
2014-01-29	ABGB-DELISTED	Stock	17.14	17.1893	17.14	17.18	500.0
2014-01-29	ABM	Stock	26.87	27.11	26.69	26.77	145600.0
2014-01-29	ABMD-DELISTED	Stock	26.35	26.526	25.92	26.21	300073.0
2014-01-29	ABR	Stock	6.8	6.86	6.79	6.82	42000.0
2014-01-29	ABR.A-DELISTED	Stock	25.05	25.05	24.9189	24.9189	5370.0
2014-01-29	ABR.B-DELISTED	Stock	22.9104	22.9503	22.9101	22.95	4837.0
2014-01-29	ABT	Stock	36.26	36.5	35.65	35.85	10404300.0
2014-01-29	ABTL-DELISTED	Stock	16.09	16.68	15.0	15.25	291953.0
2014-01-29	ABUS	Stock	12.0	12.5	11.81	12.05	124000.0
2014-01-29	ABX-DELISTED	Stock	19.11	19.6	19.07	19.52	20495951.0

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

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