PREVIEW / etf_daily / 2013-04-08

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-08.parquet
  size:    40 KB
  rows:    981

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
2013-04-08	SPY	ETF	155.27	156.22	154.75	156.21	86571200.0
2013-04-08	QQQ	ETF	67.88	68.24	67.69	68.22	17898516.0
2013-04-08	IWM	ETF	91.99	92.52	91.33	92.49	28886500.0
2013-04-08	DIA	ETF	145.32	145.95	144.76	145.95	3865000.0
2013-04-08	GLD	ETF	152.39	152.59	151.6	152.16	6246000.0
2013-04-08	TLT	ETF	122.67	122.87	121.78	121.88	8020300.0
2013-04-08	AADR	ETF	32.72	32.72	32.72	32.72	200.0
2013-04-08	AAXJ	ETF	57.04	57.3	56.83	57.27	384200.0
2013-04-08	ACTV	ETF	4.27	4.27	4.1	4.17	421458.0
2013-04-08	ACWI	ETF	50.3	50.51	50.17	50.51	457700.0
2013-04-08	ACWV	ETF	61.69	61.95	61.53	61.95	58200.0
2013-04-08	ACWX	ETF	42.33	42.4	42.16	42.39	67398.0
2013-04-08	ADRE	ETF	37.58	37.77	37.481	37.71	29174.0
2013-04-08	AFK	ETF	30.1	30.5	30.04	30.45	55471.0
2013-04-08	AGEM	ETF	21.9596	22.1162	21.9596	22.067	1687.0
2013-04-08	AGG	ETF	111.15	111.23	111.01	111.01	1027000.0
2013-04-08	AGQ	ETF	139.04	139.6	137.84	138.96	162300.0
2013-04-08	AGZ	ETF	113.64	113.74	113.64	113.68	7784.0
2013-04-08	AIA	ETF	44.57	44.86	44.55	44.85	27295.0
2013-04-08	AIQ	ETF	8.68	8.68	8.37	8.5	9071.0
2013-04-08	AIVI	ETF	41.95	42.12	41.86	42.08	17000.0
2013-04-08	ALTL	ETF	28.792	28.792	28.792	28.792	347.0
2013-04-08	AMJ	ETF	45.25	46.16	45.2201	45.64	3380359.0
2013-04-08	AMLP	ETF	87.3	88.3	87.2	88.1	945480.0
2013-04-08	ANGL	ETF	26.76	27.13	26.76	27.13	600.0
2013-04-08	AOA	ETF	39.31	39.5	39.25	39.5	12600.0
2013-04-08	AOK	ETF	31.14	31.27	31.1116	31.27	12205.0
2013-04-08	AOM	ETF	32.65	32.72	32.6128	32.71	12436.0
2013-04-08	AOR	ETF	35.36	35.53	35.32	35.53	44149.0
2013-04-08	ARB	ETF	46.84	46.85	46.665	46.84	253085.0
2013-04-08	ARGT	ETF	17.02	17.04	17.0	17.04	7350.0
2013-04-08	ASEA	ETF	17.52	17.54	17.4	17.49	40000.0
2013-04-08	ATMP	ETF	25.79	25.95	25.55	25.95	29400.0
2013-04-08	AVIV	ETF	24.65	25.45	24.46	25.31	510119.0
2013-04-08	AWAY	ETF	30.12	30.75	30.04	30.54	469338.0
2013-04-08	BAB	ETF	30.7	30.8	30.64	30.65	198886.0
2013-04-08	BAL	ETF	56.13	56.22	54.91	55.0	38013.0
2013-04-08	BALT	ETF	3.57	3.57	3.45	3.5	56294.0
2013-04-08	BBH	ETF	65.62	65.62	64.06	64.87	89800.0
2013-04-08	BCM	ETF	41.989	42.04	41.85	42.02	3091.0
2013-04-08	BIB	ETF	19.72	19.72	19.1775	19.5625	30948.0
2013-04-08	BICK	ETF	22.95	23.07	22.95	23.07	3069.0
2013-04-08	BIL	ETF	91.62	91.62	91.6	91.62	113900.0
2013-04-08	BIS	ETF	1906.4	1937.6	1897.6	1897.6	29.25
2013-04-08	BIV	ETF	88.25	88.31	88.1	88.12	250400.0
2013-04-08	BIZD	ETF	19.84	20.22	19.84	20.08	3400.0
2013-04-08	BJK	ETF	38.8	39.24	38.8	39.24	12100.0
2013-04-08	BKF	ETF	37.75	38.01	37.69	37.98	69410.0
2013-04-08	BKLN	ETF	25.13	25.13	25.1	25.13	2628100.0
2013-04-08	BLNG	ETF	45.85	45.85	45.85	45.85	284.0

> showing 50 of 981 rows — these rows as CSV

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