PREVIEW / etf_daily / 2013-05-29

all etf daily files

  file:    by_date/etf_daily/2013/2013-05-29.parquet
  size:    41 KB
  rows:    993

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-05-29	SPY	ETF	165.42	165.8	164.34	165.22	160363400.0
2013-05-29	QQQ	ETF	73.59	73.8	73.12	73.54	32095595.0
2013-05-29	IWM	ETF	98.55	99.18	97.37	98.23	40491500.0
2013-05-29	DIA	ETF	153.02	153.25	152.02	152.84	7906200.0
2013-05-29	GLD	ETF	134.09	134.91	133.64	134.83	8762200.0
2013-05-29	TLT	ETF	114.62	115.18	114.46	115.12	11298600.0
2013-05-29	AAXJ	ETF	59.36	59.46	59.07	59.14	1160400.0
2013-05-29	ACTV	ETF	6.3	6.95	6.3	6.84	623731.0
2013-05-29	ACWI	ETF	52.81	53.0	52.44	52.73	761100.0
2013-05-29	ACWV	ETF	62.33	62.33	61.66	62.0	61600.0
2013-05-29	ACWX	ETF	43.85	43.85	43.55	43.68	844487.0
2013-05-29	ADRE	ETF	37.95	38.08	37.74	37.76	31532.0
2013-05-29	AFK	ETF	30.0	30.11	29.96	30.06	10834.0
2013-05-29	AGEM	ETF	21.95	22.05	21.95	22.05	301.0
2013-05-29	AGG	ETF	109.26	109.38	109.18	109.35	1369400.0
2013-05-29	AGQ	ETF	89.8	91.08	89.16	90.68	197050.0
2013-05-29	AGZ	ETF	112.57	112.76	112.57	112.65	14632.0
2013-05-29	AIA	ETF	45.99	46.03	45.72	45.88	17636.0
2013-05-29	AIQ	ETF	13.13	13.55	12.91	13.54	51836.0
2013-05-29	AIVI	ETF	43.57	43.61	43.39	43.55	27800.0
2013-05-29	ALTL	ETF	28.99	28.99	28.92	28.92	3600.0
2013-05-29	AMJ	ETF	47.58	47.7299	46.38	46.38	2117860.0
2013-05-29	AMLP	ETF	89.75	89.8	88.55	88.75	817680.0
2013-05-29	ANGL	ETF	27.74	27.94	27.71	27.74	26000.0
2013-05-29	AOA	ETF	41.01	41.03	40.75	40.96	17900.0
2013-05-29	AOK	ETF	31.4	31.41	31.31	31.38	24078.0
2013-05-29	AOM	ETF	33.19	33.19	33.05	33.131	10036.0
2013-05-29	AOR	ETF	36.46	36.46	36.28	36.39	32023.0
2013-05-29	ARB	ETF	47.0	47.14	46.95	46.97	419288.0
2013-05-29	ARGT	ETF	17.74	17.84	17.74	17.74	2100.0
2013-05-29	ASEA	ETF	18.23	18.23	18.06	18.08	34600.0
2013-05-29	ATMP	ETF	26.48	26.48	25.9	26.01	474200.0
2013-05-29	AVIV	ETF	27.02	27.06	25.62	26.2	788386.0
2013-05-29	AWAY	ETF	29.45	29.8	29.25	29.66	434943.0
2013-05-29	BAB	ETF	30.19	30.25	30.0501	30.15	283002.0
2013-05-29	BAL	ETF	51.04	51.04	50.6501	50.708	30652.0
2013-05-29	BALT	ETF	3.91	3.91	3.67	3.7	318147.0
2013-05-29	BBH	ETF	73.35	73.35	72.19	72.76	70100.0
2013-05-29	BCM	ETF	40.67	40.67	40.53	40.5699	585.0
2013-05-29	BIB	ETF	25.0025	25.2025	24.12	24.85	117948.0
2013-05-29	BICK	ETF	23.867	23.867	23.61	23.61	450.0
2013-05-29	BIL	ETF	91.62	91.62	91.6	91.62	230750.0
2013-05-29	BIS	ETF	1430.52	1470.8	1430.52	1442.16	135.0
2013-05-29	BIV	ETF	86.26	86.41	86.15	86.37	460700.0
2013-05-29	BIZD	ETF	20.35	20.35	19.92	20.14	16600.0
2013-05-29	BJK	ETF	42.6	42.68	42.24	42.33	22100.0
2013-05-29	BKF	ETF	38.88	38.88	38.4	38.42	92889.0
2013-05-29	BKLN	ETF	25.16	25.16	25.11	25.14	3027200.0
2013-05-29	BLV	ETF	89.48	89.87	89.41	89.75	56900.0
2013-05-29	BMVP	ETF	19.32	19.4633	19.32	19.4256	3531.0

> showing 50 of 993 rows — these rows as CSV

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