PREVIEW / etf_daily / 2014-09-10

all etf daily files

  file:    by_date/etf_daily/2014/2014-09-10.parquet
  size:    45 KB
  rows:    1,111

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-09-10	SPY	ETF	199.43	200.2	198.77	200.07	67251000.0
2014-09-10	QQQ	ETF	99.38	100.11	99.1	100.07	31080115.0
2014-09-10	IWM	ETF	115.16	115.93	114.71	115.86	23060600.0
2014-09-10	DIA	ETF	170.17	170.81	169.71	170.67	4595400.0
2014-09-10	GLD	ETF	120.13	120.54	119.64	120.26	7021500.0
2014-09-10	TLT	ETF	114.97	115.12	114.79	114.96	8729400.0
2014-09-10	AADR	ETF	38.06	38.88	38.06	38.87	1400.0
2014-09-10	AAXJ	ETF	64.95	65.35	64.68	65.28	460100.0
2014-09-10	ACWI	ETF	60.44	60.62	60.22	60.59	823800.0
2014-09-10	ACWV	ETF	67.87	67.96	67.6	67.93	67300.0
2014-09-10	ACWX	ETF	47.25	47.52	47.22	47.51	229426.0
2014-09-10	ADRE	ETF	42.85	42.85	42.42	42.71	23533.0
2014-09-10	AFK	ETF	33.0	33.0	32.55	32.655	227320.0
2014-09-10	AGG	ETF	108.98	109.01	108.91	108.96	974400.0
2014-09-10	AGQ	ETF	57.61	57.86	56.9	57.48	149600.0
2014-09-10	AGZ	ETF	112.4	112.494	112.272	112.272	4672.0
2014-09-10	AGZD	ETF	24.905	24.915	24.855	24.915	3400.0
2014-09-10	AIA	ETF	50.0	50.27	49.89	50.22	20904.0
2014-09-10	AIQ	ETF	26.4	27.12	26.4	26.44	14609.0
2014-09-10	AIRR	ETF	19.38	19.46	19.28	19.44	25300.0
2014-09-10	AIVI	ETF	48.88	49.06	48.76	49.0	14700.0
2014-09-10	AMJ	ETF	53.74	53.91	53.5	53.62	414786.0
2014-09-10	AMLP	ETF	96.4	96.4	95.95	96.2	474720.0
2014-09-10	ANGL	ETF	28.04	28.04	27.86	27.97	4600.0
2014-09-10	AOA	ETF	46.68	46.85	46.62	46.84	55200.0
2014-09-10	AOK	ETF	32.7	32.79	32.69	32.79	13419.0
2014-09-10	AOM	ETF	35.43	35.44	35.339	35.42	24212.0
2014-09-10	AOR	ETF	40.24	40.25	40.07	40.25	39808.0
2014-09-10	ARGT	ETF	21.38	21.46	21.25	21.46	40700.0
2014-09-10	ASEA	ETF	17.28	17.34	17.28	17.34	2100.0
2014-09-10	ASHR	ETF	25.75	25.76	25.64	25.72	337500.0
2014-09-10	ASHS	ETF	32.21	32.3	32.19	32.3	6300.0
2014-09-10	ATMP	ETF	32.55	32.55	32.46	32.52	13400.0
2014-09-10	AVIV	ETF	28.74	28.74	28.03	28.1	144467.0
2014-09-10	AWAY	ETF	33.68	33.97	33.32	33.55	819207.0
2014-09-10	BAB	ETF	29.6	29.64	29.6	29.629	64685.0
2014-09-10	BAL	ETF	43.95	45.24	43.95	45.07	31146.0
2014-09-10	BALT	ETF	5.85	6.09	5.77	5.99	560280.0
2014-09-10	BAR	ETF	3.363	3.363	3.337	3.355	32040.0
2014-09-10	BBH	ETF	104.66	106.93	104.61	106.79	48900.0
2014-09-10	BCHP	ETF	19.9856	20.008	19.9856	20.008	616.0
2014-09-10	BCM	ETF	38.28	38.28	38.12	38.2	7770.0
2014-09-10	BFOR	ETF	7.8075	7.845	7.7775	7.8425	69600.0
2014-09-10	BIB	ETF	50.64	52.52	50.53	52.435	386040.0
2014-09-10	BICK	ETF	27.21	27.21	27.039	27.039	8655.0
2014-09-10	BIL	ETF	91.5	91.52	91.5	91.52	78350.0
2014-09-10	BIS	ETF	504.0	504.0	482.0	482.0	11815.5
2014-09-10	BIV	ETF	84.14	84.23	84.07	84.12	290000.0
2014-09-10	BIZD	ETF	20.53	20.53	20.46	20.5	10100.0
2014-09-10	BJK	ETF	45.75	45.94	45.63	45.89	9900.0

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

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