PREVIEW / etf_daily / 2013-04-16

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-16.parquet
  size:    40 KB
  rows:    986

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-16	SPY	ETF	156.29	157.49	155.91	157.41	147507800.0
2013-04-16	QQQ	ETF	68.99	69.55	68.81	69.47	27682570.0
2013-04-16	IWM	ETF	90.81	91.8	90.49	91.67	58061700.0
2013-04-16	DIA	ETF	146.98	147.39	146.37	147.36	6974100.0
2013-04-16	GLD	ETF	134.9	135.11	131.76	132.8	45650800.0
2013-04-16	TLT	ETF	121.92	122.52	121.88	121.98	6553500.0
2013-04-16	AADR	ETF	32.78	32.78	32.78	32.78	200.0
2013-04-16	AAXJ	ETF	57.75	57.9	57.52	57.84	263300.0
2013-04-16	ACTV	ETF	4.63	4.63	4.35	4.45	299086.0
2013-04-16	ACWI	ETF	50.82	51.03	50.6	51.01	392100.0
2013-04-16	ACWV	ETF	62.19	62.64	62.11	62.64	87200.0
2013-04-16	ACWX	ETF	42.79	42.9586	42.64	42.95	92291.0
2013-04-16	ADRE	ETF	37.55	37.64	37.35	37.62	29424.0
2013-04-16	AFK	ETF	29.29	29.31	28.938	29.13	327282.0
2013-04-16	AGEM	ETF	21.8228	22.06	21.8228	22.06	931.0
2013-04-16	AGG	ETF	111.22	111.28	111.16	111.25	593000.0
2013-04-16	AGQ	ETF	102.8	103.2	98.0	100.0	888525.0
2013-04-16	AGZ	ETF	113.75	113.75	113.57	113.7	5222.0
2013-04-16	AIA	ETF	45.01	45.25	44.89	45.1295	26686.0
2013-04-16	AIQ	ETF	9.57	9.6	9.36	9.39	10043.0
2013-04-16	AIVI	ETF	42.68	42.81	42.45	42.81	47400.0
2013-04-16	ALTL	ETF	29.15	29.15	29.15	29.15	694.0
2013-04-16	AMJ	ETF	44.64	45.5	44.64	45.5	1352360.0
2013-04-16	AMLP	ETF	87.25	88.25	87.25	88.05	709980.0
2013-04-16	AOA	ETF	39.53	39.77	39.49	39.72	35600.0
2013-04-16	AOK	ETF	31.22	31.31	31.2101	31.31	22352.0
2013-04-16	AOM	ETF	32.77	32.86	32.72	32.86	20553.0
2013-04-16	AOR	ETF	35.53	35.69	35.511	35.69	51556.0
2013-04-16	ARB	ETF	46.78	46.86	46.64	46.74	348143.0
2013-04-16	ARGT	ETF	16.54	16.54	16.46	16.46	950.0
2013-04-16	ASEA	ETF	17.75	17.85	17.72	17.84	96900.0
2013-04-16	ATMP	ETF	25.87	25.92	25.66	25.92	19700.0
2013-04-16	AVIV	ETF	24.35	24.69	24.01	24.4	286486.0
2013-04-16	AWAY	ETF	33.6	34.3	33.51	33.59	1574383.0
2013-04-16	BAB	ETF	30.73	30.77	30.69	30.7	118827.0
2013-04-16	BAL	ETF	54.3	54.31	53.72	53.72	52901.0
2013-04-16	BALT	ETF	3.63	3.7	3.55	3.59	125684.0
2013-04-16	BBH	ETF	67.9	68.6	67.39	68.54	119800.0
2013-04-16	BCM	ETF	40.01	40.01	40.01	40.01	100.0
2013-04-16	BIB	ETF	21.3425	21.525	20.7625	21.525	167128.0
2013-04-16	BICK	ETF	23.15	23.27	23.105	23.26	6318.0
2013-04-16	BIL	ETF	91.62	91.62	91.6	91.62	90350.0
2013-04-16	BIS	ETF	1758.8	1758.8	1732.796	1732.8	10.0
2013-04-16	BIV	ETF	88.38	88.44	88.31	88.39	154000.0
2013-04-16	BIZD	ETF	19.49	19.64	19.49	19.6	15700.0
2013-04-16	BJK	ETF	39.63	39.78	39.52	39.74	3100.0
2013-04-16	BKF	ETF	37.79	37.88	37.5275	37.82	61534.0
2013-04-16	BKLN	ETF	25.11	25.12	25.1	25.12	2734400.0
2013-04-16	BLNG	ETF	38.8	40.28	38.8	40.28	400.0
2013-04-16	BLV	ETF	94.0	94.21	93.9	94.11	72500.0

> showing 50 of 986 rows — these rows as CSV

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