PREVIEW / etf_daily / 2014-11-10

all etf daily files

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

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-10	SPY	ETF	203.38	204.04	203.13	203.98	66319000.0
2014-11-10	QQQ	ETF	101.65	102.09	101.38	101.96	20360007.0
2014-11-10	IWM	ETF	116.68	117.31	116.46	117.29	29371800.0
2014-11-10	DIA	ETF	175.62	176.06	175.33	175.95	2941900.0
2014-11-10	GLD	ETF	112.24	112.24	110.28	110.46	8548500.0
2014-11-10	TLT	ETF	119.58	119.58	118.56	118.65	4787300.0
2014-11-10	AADR	ETF	39.54	39.55	37.64	37.71	1500.0
2014-11-10	AAXJ	ETF	62.73	62.73	62.31	62.34	538600.0
2014-11-10	ACWI	ETF	59.53	59.61	59.39	59.53	338800.0
2014-11-10	ACWV	ETF	69.12	69.29	68.99	69.2	48000.0
2014-11-10	ACWX	ETF	44.93	44.93	44.74	44.83	801064.0
2014-11-10	ADRE	ETF	38.78	39.0	38.78	38.81	52742.0
2014-11-10	AFK	ETF	29.24	29.35	29.24	29.34	10292.0
2014-11-10	AGG	ETF	109.9	109.91	109.65	109.65	846900.0
2014-11-10	AGQ	ETF	38.72	38.75	37.75	38.08	237400.0
2014-11-10	AGZ	ETF	113.02	113.07	112.59	112.8199	19737.0
2014-11-10	AGZD	ETF	24.795	24.83	24.765	24.83	10600.0
2014-11-10	AIA	ETF	48.11	48.12	47.938	47.9945	20553.0
2014-11-10	AIQ	ETF	22.33	23.48	22.33	22.8	20371.0
2014-11-10	AIRR	ETF	19.35	19.35	19.01	19.12	56400.0
2014-11-10	AIVI	ETF	45.61	45.75	45.61	45.73	10200.0
2014-11-10	AMJ	ETF	51.13	51.46	50.57	50.58	748522.0
2014-11-10	AMLP	ETF	92.5	92.85	91.75	91.95	546540.0
2014-11-10	AMZA	ETF	244.6	245.2	241.1	242.8	3520.0
2014-11-10	ANGL	ETF	27.8	27.84	27.76	27.84	7600.0
2014-11-10	AOA	ETF	46.46	46.57	46.46	46.52	40900.0
2014-11-10	AOK	ETF	32.68	32.76	32.68	32.72	81774.0
2014-11-10	AOM	ETF	35.23	35.34	35.23	35.32	59340.0
2014-11-10	AOR	ETF	40.2	40.21	40.11	40.19	39296.0
2014-11-10	ARGT	ETF	20.91	20.96	20.71	20.71	9700.0
2014-11-10	ARKG	ETF	19.71	19.91	19.71	19.9	3500.0
2014-11-10	ARKK	ETF	20.16	20.3	20.16	20.3	3900.0
2014-11-10	ARKQ	ETF	19.9	19.95	19.87	19.93	3400.0
2014-11-10	ARKW	ETF	20.39	20.45	20.39	20.45	2600.0
2014-11-10	ASEA	ETF	16.8	16.8	16.57	16.57	1400.0
2014-11-10	ASHR	ETF	27.22	27.29	27.05	27.08	1119200.0
2014-11-10	ASHS	ETF	34.34	34.41	34.28	34.28	22900.0
2014-11-10	ATMP	ETF	30.26	31.88	30.26	31.43	10300.0
2014-11-10	AVIV	ETF	33.18	33.375	33.16	33.29	692295.0
2014-11-10	AWAY	ETF	29.25	29.73	29.03	29.66	1575763.0
2014-11-10	BAB	ETF	29.91	29.97	29.7732	29.856	139279.0
2014-11-10	BAL	ETF	42.8901	43.9	41.51	41.56	16656.0
2014-11-10	BALT	ETF	3.3	3.38	3.25	3.27	939366.0
2014-11-10	BAR	ETF	2.699	2.699	2.576	2.576	43010.0
2014-11-10	BBH	ETF	115.87	116.21	114.63	116.0	63800.0
2014-11-10	BCHP	ETF	18.47	18.5	18.46	18.5	3306.0
2014-11-10	BCM	ETF	35.56	35.56	35.56	35.56	100.0
2014-11-10	BFOR	ETF	7.8775	7.92	7.8775	7.9125	119200.0
2014-11-10	BIB	ETF	58.69	60.04	58.0	60.04	613462.0
2014-11-10	BICK	ETF	24.99	24.99	24.84	24.84	11098.0

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

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