PREVIEW / etf_daily / 2014-07-21

all etf daily files

  file:    by_date/etf_daily/2014/2014-07-21.parquet
  size:    45 KB
  rows:    1,097

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-07-21	SPY	ETF	197.09	197.5	196.43	197.34	67592000.0
2014-07-21	QQQ	ETF	95.92	96.16	95.55	96.0	29754810.0
2014-07-21	IWM	ETF	113.51	113.99	113.01	113.77	32720500.0
2014-07-21	DIA	ETF	170.1	170.38	169.36	170.18	2886600.0
2014-07-21	GLD	ETF	126.53	126.55	126.11	126.34	3296300.0
2014-07-21	TLT	ETF	115.01	115.63	115.01	115.09	5724100.0
2014-07-21	AADR	ETF	38.43	38.43	38.42	38.42	400.0
2014-07-21	AAXJ	ETF	63.71	64.1	63.55	64.0	118200.0
2014-07-21	ACWI	ETF	60.41	60.52	60.2	60.46	573900.0
2014-07-21	ACWV	ETF	67.26	67.37	67.0	67.3	73900.0
2014-07-21	ACWX	ETF	47.85	47.96	47.7	47.91	160655.0
2014-07-21	ADRE	ETF	40.54	40.86	40.46	40.8399	6095.0
2014-07-21	AFK	ETF	33.28	33.3186	33.089	33.11	20232.0
2014-07-21	AGG	ETF	109.35	109.45	109.26	109.26	585700.0
2014-07-21	AGQ	ETF	70.52	70.68	69.94	70.36	137700.0
2014-07-21	AGZ	ETF	112.44	112.6135	112.44	112.52	7100.0
2014-07-21	AGZD	ETF	24.99	24.99	24.99	24.99	200.0
2014-07-21	AIA	ETF	48.72	49.0832	48.72	49.03	13742.0
2014-07-21	AIQ	ETF	28.56	28.76	28.07	28.47	19600.0
2014-07-21	AIRR	ETF	18.5	18.59	18.46	18.57	11300.0
2014-07-21	AIVI	ETF	50.46	50.51	50.24	50.44	13000.0
2014-07-21	AMJ	ETF	51.97	52.14	51.732	52.11	235497.0
2014-07-21	AMLP	ETF	94.65	94.8	94.3	94.75	398680.0
2014-07-21	ANGL	ETF	28.05	28.14	28.05	28.13	1400.0
2014-07-21	AOA	ETF	46.66	46.69	46.48	46.62	42500.0
2014-07-21	AOK	ETF	32.84	32.86	32.8	32.82	47857.0
2014-07-21	AOM	ETF	35.32	35.41	35.31	35.35	186538.0
2014-07-21	AOR	ETF	40.12	40.1249	40.0114	40.05	43249.0
2014-07-21	ARGT	ETF	23.19	23.19	22.43	22.48	58000.0
2014-07-21	ASEA	ETF	17.25	17.4	17.25	17.4	6200.0
2014-07-21	ASHR	ETF	22.64	22.73	22.55	22.67	40100.0
2014-07-21	ASHS	ETF	27.12	27.12	27.12	27.12	200.0
2014-07-21	ATMP	ETF	31.41	31.6	31.38	31.59	36300.0
2014-07-21	AVIV	ETF	28.39	28.63	28.23	28.6	132182.0
2014-07-21	AWAY	ETF	33.02	33.29	32.11	32.41	1080645.0
2014-07-21	BAB	ETF	29.54	29.61	29.5184	29.5685	69689.0
2014-07-21	BAL	ETF	45.65	45.65	45.38	45.64	8849.0
2014-07-21	BALT	ETF	5.45	5.59	5.41	5.44	418136.0
2014-07-21	BBH	ETF	94.46	94.85	93.79	94.71	57900.0
2014-07-21	BCHP	ETF	20.62	20.62	20.62	20.62	2684.0
2014-07-21	BCM	ETF	40.37	40.48	40.33	40.47	21102.0
2014-07-21	BFOR	ETF	7.7625	7.765	7.72	7.75	127200.0
2014-07-21	BIB	ETF	43.54	44.3173	42.9001	44.09	323014.0
2014-07-21	BICK	ETF	26.651	26.712	26.651	26.712	2121.0
2014-07-21	BIL	ETF	91.5	91.52	91.5	91.52	190300.0
2014-07-21	BIS	ETF	599.6	604.2	585.688	588.8	12057.0
2014-07-21	BIV	ETF	84.73	84.83	84.66	84.72	218300.0
2014-07-21	BIZD	ETF	20.25	20.45	20.25	20.43	16300.0
2014-07-21	BJK	ETF	49.52	49.84	49.48	49.82	11100.0
2014-07-21	BKF	ETF	39.37	39.67	39.25	39.63	65722.0

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

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