PREVIEW / etf_daily / 2014-11-24

all etf daily files

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

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-24	SPY	ETF	207.17	207.39	206.91	207.26	65880800.0
2014-11-24	QQQ	ETF	104.15	104.73	104.06	104.68	17928289.0
2014-11-24	IWM	ETF	116.74	118.05	116.58	117.97	24573200.0
2014-11-24	DIA	ETF	178.13	178.22	177.59	177.8	2408700.0
2014-11-24	GLD	ETF	115.15	115.37	114.79	115.11	4695000.0
2014-11-24	TLT	ETF	119.67	120.27	119.55	120.2	4033900.0
2014-11-24	AADR	ETF	38.4	38.49	38.03	38.03	1300.0
2014-11-24	AAXJ	ETF	62.55	62.87	62.52	62.78	527900.0
2014-11-24	ACWI	ETF	60.63	60.63	60.46	60.59	969000.0
2014-11-24	ACWV	ETF	69.98	69.98	69.67	69.69	200000.0
2014-11-24	ACWX	ETF	45.55	45.66	45.48	45.57	463685.0
2014-11-24	ADRE	ETF	40.01	40.01	39.66	39.69	8718.0
2014-11-24	AFK	ETF	29.42	29.44	29.08	29.09	23681.0
2014-11-24	AGG	ETF	109.85	110.04	109.84	109.94	1355100.0
2014-11-24	AGQ	ETF	42.32	42.45	41.66	42.22	132100.0
2014-11-24	AGZ	ETF	113.16	113.22	112.8915	113.0626	14678.0
2014-11-24	AGZD	ETF	24.7	24.77	24.7	24.755	5400.0
2014-11-24	AIA	ETF	48.0	48.0	47.8401	47.87	52458.0
2014-11-24	AIQ	ETF	23.07	23.66	23.06	23.55	18951.0
2014-11-24	AIRR	ETF	18.86	18.88	18.75	18.88	24600.0
2014-11-24	AIVI	ETF	46.25	46.25	46.11	46.25	26400.0
2014-11-24	AMJ	ETF	52.32	52.679	51.56	51.73	827699.0
2014-11-24	AMLP	ETF	94.05	94.15	92.9	93.1	823380.0
2014-11-24	AMZA	ETF	248.19	248.2	248.05	248.05	60.0
2014-11-24	ANGL	ETF	27.38	27.45	27.37	27.37	1000.0
2014-11-24	AOA	ETF	47.09	47.12	47.03	47.12	30700.0
2014-11-24	AOK	ETF	32.84	32.91	32.84	32.91	29130.0
2014-11-24	AOM	ETF	35.47	35.57	35.47	35.57	46557.0
2014-11-24	AOR	ETF	40.56	40.58	40.51	40.55	94497.0
2014-11-24	ARGT	ETF	21.45	21.47	21.21	21.25	13000.0
2014-11-24	ARKG	ETF	20.09	20.19	20.09	20.19	2600.0
2014-11-24	ARKK	ETF	20.35	20.49	20.35	20.49	2000.0
2014-11-24	ARKQ	ETF	20.37	20.47	20.37	20.468	500.0
2014-11-24	ARKW	ETF	20.49	20.57	20.45	20.57	2500.0
2014-11-24	ASEA	ETF	16.98	16.98	16.83	16.9	4100.0
2014-11-24	ASHR	ETF	28.8	29.27	28.72	29.2	1091400.0
2014-11-24	ASHS	ETF	35.29	35.33	34.94	35.09	27700.0
2014-11-24	ATMP	ETF	33.35	33.35	32.28	32.31	18900.0
2014-11-24	AVIV	ETF	33.0	33.33	32.92	33.06	597212.0
2014-11-24	AWAY	ETF	30.75	31.145	30.09	30.66	1135091.0
2014-11-24	BAB	ETF	29.86	29.88	29.77	29.86	91762.0
2014-11-24	BAL	ETF	40.3	40.41	39.9	40.11	3000.0
2014-11-24	BALT	ETF	3.66	3.72	3.56	3.66	486506.0
2014-11-24	BAR	ETF	2.899	2.911	2.865	2.888	14260.0
2014-11-24	BBH	ETF	114.88	116.39	114.88	116.35	95100.0
2014-11-24	BCM	ETF	35.496	35.5	35.42	35.42	1588.0
2014-11-24	BFOR	ETF	7.9675	8.0125	7.9675	8.0125	243600.0
2014-11-24	BIB	ETF	60.27	61.925	60.13	61.925	513486.0
2014-11-24	BICK	ETF	25.2123	25.2123	25.1901	25.1901	726.0
2014-11-24	BIL	ETF	91.48	91.5	91.48	91.5	891550.0

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

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