PREVIEW / etf_daily / 2014-06-06

all etf daily files

  file:    by_date/etf_daily/2014/2014-06-06.parquet
  size:    44 KB
  rows:    1,090

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-06-06	SPY	ETF	194.87	195.43	194.78	195.38	78696000.0
2014-06-06	QQQ	ETF	92.66	92.82	92.45	92.82	22680643.0
2014-06-06	IWM	ETF	115.27	116.24	115.11	115.88	45854000.0
2014-06-06	DIA	ETF	168.58	169.12	168.46	169.08	4118900.0
2014-06-06	GLD	ETF	120.68	120.77	119.94	120.61	4807700.0
2014-06-06	TLT	ETF	112.13	112.41	111.49	111.59	7832800.0
2014-06-06	AADR	ETF	38.47	38.47	38.36	38.36	700.0
2014-06-06	AAXJ	ETF	62.75	62.87	62.67	62.74	215700.0
2014-06-06	ACWI	ETF	60.64	60.85	60.64	60.84	343900.0
2014-06-06	ACWV	ETF	67.04	67.06	66.96	67.05	23300.0
2014-06-06	ACWX	ETF	48.71	48.8113	48.61	48.81	462805.0
2014-06-06	ADRE	ETF	38.35	38.62	38.35	38.5	17526.0
2014-06-06	AFK	ETF	32.93	33.4856	32.93	33.36	68287.0
2014-06-06	AGG	ETF	109.1	109.12	108.88	108.88	839500.0
2014-06-06	AGQ	ETF	58.74	58.74	57.7	58.48	190600.0
2014-06-06	AGZ	ETF	112.54	112.54	112.27	112.27	12438.0
2014-06-06	AIA	ETF	48.7999	48.7999	48.68	48.68	4806.0
2014-06-06	AIQ	ETF	29.57	30.91	29.36	30.13	14008.0
2014-06-06	AIRR	ETF	19.33	19.4	19.25	19.4	46300.0
2014-06-06	AIVI	ETF	51.71	51.74	51.39	51.69	29200.0
2014-06-06	AMJ	ETF	50.3	50.39	50.01	50.39	389132.0
2014-06-06	AMLP	ETF	92.0	92.5	92.0	92.4	694580.0
2014-06-06	ANGL	ETF	28.24	28.25	28.2	28.25	1400.0
2014-06-06	AOA	ETF	46.87	46.92	46.81	46.89	31700.0
2014-06-06	AOK	ETF	32.87	32.94	32.87	32.93	32653.0
2014-06-06	AOM	ETF	35.48	35.58	35.48	35.56	26606.0
2014-06-06	AOR	ETF	40.23	40.26	40.1933	40.24	53238.0
2014-06-06	ARGT	ETF	20.67	20.9	20.67	20.81	11800.0
2014-06-06	ASEA	ETF	16.74	16.86	16.74	16.83	4100.0
2014-06-06	ASHR	ETF	21.91	21.97	21.9	21.95	46800.0
2014-06-06	ASHS	ETF	25.58	25.6	25.58	25.6	900.0
2014-06-06	ATMP	ETF	30.13	30.24	30.13	30.23	31900.0
2014-06-06	AVIV	ETF	29.19	29.32	29.0	29.18	262824.0
2014-06-06	AWAY	ETF	30.8	30.91	29.2	29.31	2795403.0
2014-06-06	BAB	ETF	29.29	29.34	29.19	29.194	96139.0
2014-06-06	BAL	ETF	52.55	52.6	52.14	52.14	20761.0
2014-06-06	BALT	ETF	6.45	6.45	6.29	6.35	317896.0
2014-06-06	BBH	ETF	93.81	93.81	92.75	93.45	61800.0
2014-06-06	BCM	ETF	40.63	40.63	40.6003	40.6003	785.0
2014-06-06	BFOR	ETF	7.6825	7.745	7.6825	7.7325	113200.0
2014-06-06	BIB	ETF	42.685	42.695	41.835	42.525	432568.0
2014-06-06	BICK	ETF	26.183	26.183	26.183	26.183	821.0
2014-06-06	BIL	ETF	91.54	91.54	91.52	91.52	142950.0
2014-06-06	BIS	ETF	626.4	634.0	620.0	623.2	4795.0
2014-06-06	BIV	ETF	84.4	84.42	84.16	84.24	295000.0
2014-06-06	BIZD	ETF	19.77	20.06	19.77	20.02	9600.0
2014-06-06	BJK	ETF	49.31	49.31	49.01	49.03	28900.0
2014-06-06	BKF	ETF	38.54	38.6301	38.5	38.58	28310.0
2014-06-06	BKLN	ETF	24.88	24.91	24.88	24.91	1497500.0
2014-06-06	BLV	ETF	88.81	88.93	88.49	88.61	64300.0

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

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