PREVIEW / etf_daily / 2014-11-12

all etf daily files

  file:    by_date/etf_daily/2014/2014-11-12.parquet
  size:    46 KB
  rows:    1,131

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-11-12	SPY	ETF	203.35	204.24	203.31	203.96	90120300.0
2014-11-12	QQQ	ETF	101.87	102.57	101.87	102.46	22050317.0
2014-11-12	IWM	ETF	116.69	118.08	116.66	117.9	34594700.0
2014-11-12	DIA	ETF	175.26	176.2	175.25	176.04	2836500.0
2014-11-12	GLD	ETF	112.05	112.17	111.23	111.5	5133300.0
2014-11-12	TLT	ETF	119.2	119.53	118.45	118.63	4040800.0
2014-11-12	AADR	ETF	37.54	37.54	37.54	37.54	2400.0
2014-11-12	AAXJ	ETF	62.25	62.47	62.19	62.23	313100.0
2014-11-12	ACWI	ETF	59.29	59.59	59.29	59.54	3081100.0
2014-11-12	ACWV	ETF	69.22	69.31	68.89	69.27	51000.0
2014-11-12	ACWX	ETF	44.7	44.87	44.66	44.75	247831.0
2014-11-12	ADRE	ETF	38.75	38.974	38.59	38.67	4986.0
2014-11-12	AFK	ETF	29.64	29.64	29.27	29.51	105629.0
2014-11-12	AGG	ETF	109.74	109.88	109.66	109.71	1123700.0
2014-11-12	AGQ	ETF	38.37	38.83	38.25	38.44	131900.0
2014-11-12	AGZ	ETF	112.75	113.14	112.75	112.78	16400.0
2014-11-12	AGZD	ETF	24.64	24.805	24.64	24.8	16200.0
2014-11-12	AIA	ETF	47.69	47.84	47.66	47.71	21581.0
2014-11-12	AIQ	ETF	22.22	22.36	22.12	22.2	25812.0
2014-11-12	AIRR	ETF	19.0	19.13	18.97	19.13	21500.0
2014-11-12	AIVI	ETF	45.55	45.68	45.52	45.61	25700.0
2014-11-12	AMJ	ETF	50.2	50.78	50.0001	50.58	500055.0
2014-11-12	AMLP	ETF	91.6	92.0	91.25	92.0	561540.0
2014-11-12	AMZA	ETF	242.5	243.15	242.39	242.81	260.0
2014-11-12	ANGL	ETF	27.8	27.8	27.66	27.66	1200.0
2014-11-12	AOA	ETF	46.44	46.52	46.41	46.51	22000.0
2014-11-12	AOK	ETF	32.66	32.75	32.66	32.711	18635.0
2014-11-12	AOM	ETF	35.3	35.3283	35.27	35.32	106034.0
2014-11-12	AOR	ETF	40.14	40.19	40.126	40.18	45148.0
2014-11-12	ARGT	ETF	20.86	20.87	20.7	20.7	8600.0
2014-11-12	ARKG	ETF	19.84	19.98	19.839	19.98	6900.0
2014-11-12	ARKK	ETF	20.26	20.36	20.24	20.36	2300.0
2014-11-12	ARKQ	ETF	20.05	20.06	19.97	20.045	1400.0
2014-11-12	ARKW	ETF	20.39	20.48	20.337	20.47	2000.0
2014-11-12	ASEA	ETF	17.0	17.0	16.64	16.64	111000.0
2014-11-12	ASHR	ETF	27.38	27.48	27.36	27.44	1080400.0
2014-11-12	ASHS	ETF	33.88	34.01	33.88	33.99	11600.0
2014-11-12	ATMP	ETF	31.64	31.66	31.57	31.6	8800.0
2014-11-12	AVIV	ETF	33.2	33.46	32.96	33.2	558399.0
2014-11-12	AWAY	ETF	30.63	31.28	30.4601	30.795	1419928.0
2014-11-12	BAB	ETF	29.97	29.9799	29.77	29.88	107151.0
2014-11-12	BAL	ETF	42.1739	42.1739	41.1701	41.1701	7070.0
2014-11-12	BALT	ETF	3.24	3.36	3.21	3.34	384047.0
2014-11-12	BAR	ETF	2.665	2.667	2.63	2.636	46120.0
2014-11-12	BBH	ETF	115.9	116.16	115.18	115.98	53500.0
2014-11-12	BCHP	ETF	18.41	18.4342	18.41	18.4342	1372.0
2014-11-12	BCM	ETF	35.476	35.476	35.476	35.476	1154.0
2014-11-12	BFOR	ETF	7.9025	7.96	7.8975	7.9525	41200.0
2014-11-12	BIB	ETF	59.74	60.63	59.295	60.4	285914.0
2014-11-12	BIL	ETF	91.5	91.5	91.48	91.5	645000.0

> showing 50 of 1,131 rows — these rows as CSV

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