PREVIEW / etf_daily / 2013-04-18

all etf daily files

  file:    by_date/etf_daily/2013/2013-04-18.parquet
  size:    41 KB
  rows:    990

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-18	SPY	ETF	155.37	155.41	153.55	154.14	167583200.0
2013-04-18	QQQ	ETF	68.33	68.33	66.88	67.169	56798119.0
2013-04-18	IWM	ETF	90.15	90.37	89.13	89.58	58516600.0
2013-04-18	DIA	ETF	146.1	146.12	144.77	145.18	8277100.0
2013-04-18	GLD	ETF	134.12	135.31	133.62	134.3	20040500.0
2013-04-18	TLT	ETF	122.81	123.22	122.6	123.09	7009500.0
2013-04-18	AAXJ	ETF	57.7	57.7	57.17	57.31	272800.0
2013-04-18	ACTV	ETF	4.78	4.83	4.68	4.71	320801.0
2013-04-18	ACWI	ETF	50.28	50.28	49.78	49.91	899400.0
2013-04-18	ACWV	ETF	62.3	62.3	61.84	62.07	79000.0
2013-04-18	ACWX	ETF	42.25	42.25	41.92	42.09	609846.0
2013-04-18	ADRE	ETF	37.16	37.23	36.87	37.02	39140.0
2013-04-18	AFK	ETF	28.37	28.37	28.15	28.15	35542.0
2013-04-18	AGEM	ETF	21.46	21.48	21.46	21.46	3033.0
2013-04-18	AGG	ETF	111.29	111.35	111.21	111.23	1153800.0
2013-04-18	AGQ	ETF	98.0	99.96	97.12	97.72	401350.0
2013-04-18	AGZ	ETF	113.77	113.79	113.65	113.77	12042.0
2013-04-18	AIA	ETF	44.57	44.75	44.29	44.39	47713.0
2013-04-18	AIQ	ETF	9.56	9.74	9.55	9.67	19285.0
2013-04-18	AIVI	ETF	41.93	41.93	41.64	41.75	21000.0
2013-04-18	AMJ	ETF	45.19	45.374	44.942	45.3	566663.0
2013-04-18	AMLP	ETF	87.95	88.15	87.65	87.9	628060.0
2013-04-18	ANGL	ETF	26.7	27.35	26.63	27.35	2300.0
2013-04-18	AOA	ETF	39.24	39.24	39.0	39.06	19900.0
2013-04-18	AOK	ETF	31.14	31.14	31.046	31.094	21718.0
2013-04-18	AOM	ETF	32.62	32.62	32.4655	32.49	21793.0
2013-04-18	AOR	ETF	35.42	35.42	35.1455	35.279	28496.0
2013-04-18	ARB	ETF	46.71	46.77	46.64	46.66	311665.0
2013-04-18	ARGT	ETF	16.3	16.3	16.04	16.04	6150.0
2013-04-18	ASEA	ETF	17.95	17.95	17.82	17.87	8900.0
2013-04-18	ATMP	ETF	25.76	25.89	25.75	25.82	26900.0
2013-04-18	AVIV	ETF	24.4	24.4	24.04	24.15	136917.0
2013-04-18	AWAY	ETF	32.5	32.525	31.49	31.74	1407724.0
2013-04-18	BAB	ETF	30.81	30.89	30.81	30.82	109836.0
2013-04-18	BAL	ETF	54.36	54.6	53.74	54.0	57917.0
2013-04-18	BALT	ETF	3.4	3.4	3.1	3.23	191403.0
2013-04-18	BBH	ETF	68.32	68.32	66.39	66.81	84100.0
2013-04-18	BIB	ETF	21.5	21.51	20.35	20.6625	242888.0
2013-04-18	BICK	ETF	22.95	22.97	22.84	22.93	1605.0
2013-04-18	BIL	ETF	91.6	91.62	91.6	91.6	247100.0
2013-04-18	BIS	ETF	1780.8	1802.004	1780.8	1802.004	35.0
2013-04-18	BIV	ETF	88.51	88.55	88.41	88.42	191300.0
2013-04-18	BIZD	ETF	19.32	19.33	19.17	19.23	7400.0
2013-04-18	BJK	ETF	39.38	39.38	39.02	39.15	7800.0
2013-04-18	BKF	ETF	37.35	37.35	37.01	37.22	98837.0
2013-04-18	BKLN	ETF	25.11	25.11	25.09	25.1	1683700.0
2013-04-18	BLV	ETF	94.29	94.63	94.29	94.55	111800.0
2013-04-18	BMVP	ETF	18.0	18.0667	17.9367	17.9367	3940.0
2013-04-18	BND	ETF	84.01	84.07	83.98	84.05	744700.0
2013-04-18	BNO	ETF	37.25	37.815	37.055	37.81	58000.0

> showing 50 of 990 rows — these rows as CSV

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