PREVIEW / stock_daily / 2014-02-11

all stock daily files

  file:    by_date/stock_daily/2014/2014-02-11.parquet
  size:    218 KB
  rows:    6,479
  symbols: 3,547

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-02-11	AAPL	Stock	18.9504	19.2054	18.9107	19.1414	282256800.0
2014-02-11	MSFT	Stock	36.88	37.26	36.86	37.17	32141400.0
2014-02-11	NVDA	Stock	0.4003	0.4072	0.3982	0.4062	235384000.0
2014-02-11	AMZN	Stock	18.092	18.1805	17.8125	18.0895	64442000.0
2014-02-11	META	Stock	63.75	65.0	63.35	64.85	45675600.0
2014-02-11	TSLA	Stock	13.2647	13.48	12.8467	13.108	160648500.0
2014-02-11	TLT	Stock	106.61	106.69	106.16	106.47	5904855.0
2014-02-11	ES	Stock	43.72	44.58	43.7	44.26	1909500.0
2014-02-11	CL	Stock	61.67	62.48	61.39	62.4	3701400.0
2014-02-11	A	Stock	42.2031	42.9185	42.1173	42.7253	2985848.0
2014-02-11	AABA-DELISTED	Stock	38.15	38.86	38.08	38.5	17551838.0
2014-02-11	AACG	Stock	3.91	3.91	3.8	3.82	37300.0
2014-02-11	AAIC-DELISTED	Stock	25.05	25.5897	25.03	25.4	168515.0
2014-02-11	AAL	Stock	35.58	35.64	34.39	35.13	11988300.0
2014-02-11	AAMC-DELISTED	Stock	292.6412	305.8765	288.2412	294.1176	72699.0
2014-02-11	AAME	Stock	3.93	3.95	3.93	3.94	2400.0
2014-02-11	AAOI	Stock	13.19	13.35	12.78	12.79	22400.0
2014-02-11	AAON	Stock	12.1733	12.48	12.0578	12.36	244350.0
2014-02-11	AAP	Stock	123.47	125.87	123.14	125.44	927600.0
2014-02-11	AAT	Stock	32.42	32.89	32.15	32.57	242900.0
2014-02-11	AAU-DELISTED	Stock	1.7549	1.8646	1.665	1.685	425355.0
2014-02-11	AAUAF-DELISTED	Stock	1.76	1.87	1.67	1.68	428843.0
2014-02-11	AAV-DELISTED	Stock	3.89	4.04	3.86	3.92	153363.0
2014-02-11	AAWW-DELISTED	Stock	33.68	34.02	32.881	33.77	618695.0
2014-02-11	AAXJ	Stock	56.33	57.17	56.33	57.08	879972.0
2014-02-11	AAXN-DELISTED	Stock	16.94	17.16	16.66	16.91	953528.0
2014-02-11	AB	Stock	22.42	22.7	22.32	22.41	292100.0
2014-02-11	ABAC-DELISTED	Stock	1.8242	1.8242	1.73	1.77	1952.0
2014-02-11	ABAX-DELISTED	Stock	37.0	37.77	36.75	37.75	146459.0
2014-02-11	ABB-DELISTED	Stock	25.52	25.8	25.49	25.69	2361506.0
2014-02-11	ABBNY-DELISTED	Stock	25.52	25.8	25.49	25.7	3747056.0
2014-02-11	ABBV	Stock	49.41	49.97	49.04	49.66	7217600.0
2014-02-11	ABC-DELISTED	Stock	66.23	67.89	66.19	67.56	2303128.0
2014-02-11	ABCB	Stock	20.03	20.43	19.9	20.24	121100.0
2014-02-11	ABCD-DELISTED	Stock	1.88	1.98	1.87	1.87	24815.0
2014-02-11	ABCO-DELISTED	Stock	59.08	59.94	57.76	59.29	172270.0
2014-02-11	ABE-DELISTED	Stock	12.46	12.67	12.46	12.6699	42776.0
2014-02-11	ABEO	Stock	425.0	425.0	375.0	400.0	23.0
2014-02-11	ABEV	Stock	6.68	6.92	6.67	6.87	10257200.0
2014-02-11	ABFS-DELISTED	Stock	30.98	31.0	29.88	30.4	356237.0
2014-02-11	ABG	Stock	49.55	49.9	48.86	49.1	210100.0
2014-02-11	ABGB-DELISTED	Stock	20.22	20.54	20.22	20.54	1700.0
2014-02-11	ABIL-DELISTED	Stock	9.54	9.55	9.54	9.54	2209.0
2014-02-11	ABM	Stock	26.52	27.1	26.46	27.07	289400.0
2014-02-11	ABMD-DELISTED	Stock	26.94	27.33	26.58	27.18	219727.0
2014-02-11	ABR	Stock	6.91	7.06	6.91	7.02	210300.0
2014-02-11	ABR.A-DELISTED	Stock	24.9101	25.1	24.9101	25.1	200.0
2014-02-11	ABR.B-DELISTED	Stock	23.5	23.5	23.45	23.5	4350.0
2014-02-11	ABT	Stock	37.05	38.0	37.05	37.95	8643000.0
2014-02-11	ABTL-DELISTED	Stock	16.51	18.07	16.46	17.81	706375.0

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

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