PREVIEW / etf_daily / 2015-02-26

all etf daily files

  file:    by_date/etf_daily/2015/2015-02-26.parquet
  size:    47 KB
  rows:    1,159

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
2015-02-26	SPY	ETF	211.52	211.71	210.65	211.38	72697900.0
2015-02-26	QQQ	ETF	108.44	108.94	108.135	108.88	22255476.0
2015-02-26	IWM	ETF	122.69	123.3	122.33	123.25	24379000.0
2015-02-26	DIA	ETF	181.92	182.24	181.4	182.01	3045800.0
2015-02-26	GLD	ETF	116.54	116.55	115.83	116.07	4025400.0
2015-02-26	TLT	ETF	129.7	130.3	128.4	128.45	11020500.0
2015-02-26	AADR	ETF	39.07	39.07	38.96	39.07	1800.0
2015-02-26	AAXJ	ETF	64.1	64.13	63.83	63.94	606600.0
2015-02-26	ACWI	ETF	61.06	61.16	60.89	61.06	500400.0
2015-02-26	ACWV	ETF	71.93	72.28	71.75	71.9	94200.0
2015-02-26	ACWX	ETF	45.28	45.39	45.21	45.27	308259.0
2015-02-26	ADRE	ETF	36.56	36.722	36.5	36.68	15218.0
2015-02-26	AFK	ETF	26.06	26.13	25.761	25.89	37727.0
2015-02-26	AGG	ETF	111.21	111.28	110.86	110.92	1837300.0
2015-02-26	AGQ	ETF	42.39	42.5	41.34	41.39	197300.0
2015-02-26	AGZ	ETF	114.41	114.62	114.07	114.19	29811.0
2015-02-26	AGZD	ETF	24.51	24.645	24.505	24.635	19200.0
2015-02-26	AIA	ETF	49.68	49.68	49.546	49.56	17965.0
2015-02-26	AIQ	ETF	24.7	24.86	24.19	24.655	15329.0
2015-02-26	AIRR	ETF	18.43	18.45	18.32	18.43	22900.0
2015-02-26	AIVI	ETF	45.62	45.66	45.46	45.52	24800.0
2015-02-26	AMJ	ETF	44.97	45.229	44.19	44.33	745291.0
2015-02-26	AMLP	ETF	85.8	85.8	84.5	84.65	815140.0
2015-02-26	AMZA	ETF	221.0	221.7	220.6	220.6	180.0
2015-02-26	ANGL	ETF	27.38	27.72	27.2	27.33	38600.0
2015-02-26	AOA	ETF	48.0	48.02	47.75	47.82	25200.0
2015-02-26	AOK	ETF	33.04	33.11	32.9	32.97	55991.0
2015-02-26	AOM	ETF	35.82	35.83	35.65	35.65	71140.0
2015-02-26	AOR	ETF	41.2	41.37	41.01	41.06	130543.0
2015-02-26	ARGT	ETF	20.42	20.42	19.93	19.93	5900.0
2015-02-26	ARKG	ETF	23.49	23.49	23.3	23.45	3900.0
2015-02-26	ARKK	ETF	21.7	21.7	21.58	21.64	1300.0
2015-02-26	ARKQ	ETF	20.37	20.37	20.37	20.37	300.0
2015-02-26	ARKW	ETF	22.37	22.53	22.35	22.37	7800.0
2015-02-26	ASEA	ETF	15.83	15.85	15.82	15.82	2300.0
2015-02-26	ASHR	ETF	36.5	36.77	36.46	36.54	1008000.0
2015-02-26	ASHS	ETF	39.43	39.69	39.32	39.51	80200.0
2015-02-26	ATMP	ETF	29.94	29.95	29.48	29.54	32600.0
2015-02-26	AVIV	ETF	36.65	36.71	35.86	35.91	95706.0
2015-02-26	AWAY	ETF	32.53	32.65	31.23	31.285	4404836.0
2015-02-26	BAB	ETF	30.2	30.365	30.11	30.17	145055.0
2015-02-26	BAL	ETF	44.75	45.17	44.4505	44.53	23322.0
2015-02-26	BALT	ETF	1.77	1.88	1.77	1.84	578568.0
2015-02-26	BAR	ETF	2.849	2.8652	2.848	2.85	46450.0
2015-02-26	BBC	ETF	31.07	31.635	30.74	31.635	21531.0
2015-02-26	BBH	ETF	129.18	129.46	127.43	129.2	71300.0
2015-02-26	BBP	ETF	30.25	30.42	29.8	30.42	8200.0
2015-02-26	BCHP	ETF	19.28	19.28	19.28	19.28	375.0
2015-02-26	BCM	ETF	31.919	31.92	31.78	31.86	20571.0
2015-02-26	BFOR	ETF	8.2175	8.2375	8.2025	8.2175	92000.0

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

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