PREVIEW / stock_daily / 2014-01-13

all stock daily files

  file:    by_date/stock_daily/2014/2014-01-13.parquet
  size:    218 KB
  rows:    6,463
  symbols: 3,533

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-13	AAPL	Stock	18.9254	19.375	18.9243	19.1332	378492800.0
2014-01-13	MSFT	Stock	35.99	36.02	34.83	34.98	45901900.0
2014-01-13	NVDA	Stock	0.3933	0.3958	0.3833	0.384	243332000.0
2014-01-13	AMZN	Stock	19.899	19.989	19.4225	19.549	56898000.0
2014-01-13	META	Stock	57.91	58.25	55.38	55.91	63010900.0
2014-01-13	TSLA	Stock	9.7187	9.8	9.188	9.2893	94741500.0
2014-01-13	TLT	Stock	104.51	105.14	104.465	104.93	9671509.0
2014-01-13	ES	Stock	42.55	42.65	42.23	42.33	2004000.0
2014-01-13	CL	Stock	64.9	65.39	64.54	64.69	3140800.0
2014-01-13	A	Stock	42.0386	42.2747	41.917	42.1531	4119487.0
2014-01-13	AABA-DELISTED	Stock	41.19	41.22	39.8	39.98	15438762.0
2014-01-13	AACG	Stock	3.85	4.01	3.85	3.94	21400.0
2014-01-13	AAIC-DELISTED	Stock	26.7	26.839	26.39	26.56	122988.0
2014-01-13	AAL	Stock	29.18	29.53	28.58	28.65	10587800.0
2014-01-13	AAMC-DELISTED	Stock	301.5029	313.1482	301.5	309.1794	38736.0
2014-01-13	AAME	Stock	3.99	4.05	3.99	4.05	6100.0
2014-01-13	AAOI	Stock	13.83	14.06	13.69	13.7	43300.0
2014-01-13	AAON	Stock	13.9689	14.2	13.6178	13.7467	331650.0
2014-01-13	AAP	Stock	115.45	115.99	113.77	114.29	941700.0
2014-01-13	AAT	Stock	31.81	31.88	31.41	31.63	88000.0
2014-01-13	AAU-DELISTED	Stock	1.22	1.27	1.2	1.27	145916.0
2014-01-13	AAUAF-DELISTED	Stock	1.22	1.27	1.2	1.27	147731.0
2014-01-13	AAV-DELISTED	Stock	4.34	4.34	4.185	4.2	82587.0
2014-01-13	AAWW-DELISTED	Stock	42.9	43.03	42.2	42.85	217140.0
2014-01-13	AAXJ	Stock	58.39	58.44	57.74	57.9	447845.0
2014-01-13	AAXN-DELISTED	Stock	18.66	18.68	17.34	17.485	2051024.0
2014-01-13	AB	Stock	22.34	22.82	22.25	22.4	542000.0
2014-01-13	ABAC-DELISTED	Stock	2.11	2.14	2.0998	2.14	16033.0
2014-01-13	ABAX-DELISTED	Stock	43.23	43.33	42.43	42.85	291267.0
2014-01-13	ABB-DELISTED	Stock	26.23	26.301	26.04	26.09	1001862.0
2014-01-13	ABBNY-DELISTED	Stock	26.23	26.301	26.04	26.08	1059573.0
2014-01-13	ABBV	Stock	50.66	50.74	49.64	49.83	7055200.0
2014-01-13	ABC-DELISTED	Stock	71.42	71.75	70.38	70.61	1679504.0
2014-01-13	ABCB	Stock	20.45	20.9	20.26	20.29	101500.0
2014-01-13	ABCD-DELISTED	Stock	2.3	2.54	2.141	2.22	34704.0
2014-01-13	ABCO-DELISTED	Stock	60.01	60.2	59.0	59.59	141002.0
2014-01-13	ABE-DELISTED	Stock	13.5	13.579	13.341	13.54	6831.0
2014-01-13	ABEO	Stock	375.0	375.0	350.0	350.0	31.0
2014-01-13	ABEV	Stock	7.29	7.32	7.21	7.24	10418300.0
2014-01-13	ABFS-DELISTED	Stock	34.28	34.88	33.33	33.54	376371.0
2014-01-13	ABG	Stock	51.01	51.53	49.72	49.81	232600.0
2014-01-13	ABGB-DELISTED	Stock	16.49	16.74	16.1828	16.1828	8164.0
2014-01-13	ABM	Stock	28.28	28.31	27.72	27.83	288800.0
2014-01-13	ABMD-DELISTED	Stock	30.01	30.035	28.84	29.25	299852.0
2014-01-13	ABR	Stock	6.82	6.9	6.79	6.84	72100.0
2014-01-13	ABR.A-DELISTED	Stock	24.48	24.5	24.45	24.5	2234.0
2014-01-13	ABR.B-DELISTED	Stock	22.599	22.599	22.599	22.599	100.0
2014-01-13	ABT	Stock	39.11	39.67	39.06	39.11	12136000.0
2014-01-13	ABTL-DELISTED	Stock	14.12	14.67	13.43	13.65	213914.0
2014-01-13	ABUS	Stock	12.75	13.35	11.56	12.04	2206200.0

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

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