PREVIEW / etf_daily / 2011-08-11

all etf daily files

  file:    by_date/etf_daily/2011/2011-08-11.parquet
  size:    37 KB
  rows:    873

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
2011-08-11	SPY	ETF	113.26	118.92	112.32	117.33	487979700.0
2011-08-11	QQQ	ETF	51.58	53.69	51.34	53.1	143824473.0
2011-08-11	IWM	ETF	66.51	70.44	66.07	69.36	121880100.0
2011-08-11	DIA	ETF	108.2	112.82	107.83	111.25	17393500.0
2011-08-11	GLD	ETF	172.28	172.34	168.65	170.75	49888300.0
2011-08-11	TLT	ETF	107.34	107.81	103.2	103.52	37790100.0
2011-08-11	AADR	ETF	28.05	28.36	28.03	28.36	500.0
2011-08-11	AAXJ	ETF	53.86	56.31	53.78	55.66	725500.0
2011-08-11	ACTV	ETF	23.58	23.58	13.11	14.72	873744.0
2011-08-11	ACWI	ETF	40.85	42.79	40.67	42.35	995100.0
2011-08-11	ACWX	ETF	37.55	39.31	37.478	38.98	525497.0
2011-08-11	ADRE	ETF	39.31	40.7529	38.91	40.44	217368.0
2011-08-11	AFK	ETF	27.92	29.06	27.88	29.006	42972.0
2011-08-11	AGEM	ETF	21.78	22.72	21.78	22.72	3782.0
2011-08-11	AGG	ETF	109.94	109.94	108.73	108.76	2596300.0
2011-08-11	AGQ	ETF	394.28	405.0	380.92	398.94	644050.0
2011-08-11	AGZ	ETF	112.18	112.48	112.0	112.0001	9124.0
2011-08-11	AIA	ETF	39.56	41.09	39.47	40.8976	66869.0
2011-08-11	AIQ	ETF	5.8	9.25	5.6	7.9	282115.0
2011-08-11	AIS	ETF	1.94	2.13	1.94	2.09	1126512.0
2011-08-11	AIVI	ETF	39.02	41.05	39.02	40.76	36300.0
2011-08-11	AMJ	ETF	34.92	36.23	34.92	35.96	2719434.0
2011-08-11	AMLP	ETF	77.5	79.0	77.4	77.75	470240.0
2011-08-11	AOA	ETF	30.84	32.18	30.84	31.96	21200.0
2011-08-11	AOK	ETF	28.8	28.9	28.743	28.9	36065.0
2011-08-11	AOM	ETF	29.29	29.6106	29.2	29.48	34607.0
2011-08-11	AOR	ETF	29.9	30.5764	29.9	30.37	13463.0
2011-08-11	ARB	ETF	32.72	35.03	32.52	34.41	169626.0
2011-08-11	ARGT	ETF	25.04	25.78	25.04	25.78	1550.0
2011-08-11	ASEA	ETF	15.78	16.13	15.78	16.13	12300.0
2011-08-11	AWAY	ETF	36.48	37.44	35.141	36.8	137721.0
2011-08-11	BAB	ETF	27.13	27.14	26.6	26.6	306215.0
2011-08-11	BAL	ETF	60.7	61.4	59.35	60.02	157508.0
2011-08-11	BALT	ETF	3.73	4.24	3.64	4.23	419026.0
2011-08-11	BBH	ETF	29.6833	30.7133	29.4667	30.4	50400.0
2011-08-11	BIB	ETF	6.0	6.6208	5.9562	6.5175	150696.0
2011-08-11	BICK	ETF	26.06	27.38	26.06	27.1903	13909.0
2011-08-11	BIL	ETF	91.7	91.72	91.68	91.72	224700.0
2011-08-11	BIS	ETF	8630.4	8630.4	7926.4	7979.2	11.35
2011-08-11	BITS	ETF	20.32	20.44	20.32	20.44	13984.0
2011-08-11	BIV	ETF	87.64	88.25	86.72	86.85	173400.0
2011-08-11	BJK	ETF	31.25	32.94	31.15	32.68	65400.0
2011-08-11	BKF	ETF	39.23	40.77	39.1	40.44	286908.0
2011-08-11	BKLN	ETF	22.95	23.18	22.73	23.18	78400.0
2011-08-11	BLV	ETF	87.32	87.5	84.75	84.87	124000.0
2011-08-11	BMVP	ETF	12.72	13.37	12.71	13.27	34806.0
2011-08-11	BND	ETF	83.52	83.72	83.14	83.2	1863900.0
2011-08-11	BNO	ETF	35.42	36.105	35.315	36.07	184200.0
2011-08-11	BOSS	ETF	63.0	65.0	63.0	65.0	300.0
2011-08-11	BRF	ETF	44.85	46.84	44.5	46.26	525382.0

> showing 50 of 873 rows — these rows as CSV

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