PREVIEW / etf_daily / 2011-07-11

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-11.parquet
  size:    36 KB
  rows:    864

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-07-11	SPY	ETF	132.75	133.18	131.66	131.97	195918600.0
2011-07-11	QQQ	ETF	58.41	58.71	57.76	57.96	52080762.0
2011-07-11	IWM	ETF	84.06	84.53	83.09	83.32	59769800.0
2011-07-11	DIA	ETF	125.17	125.46	124.54	124.95	6931200.0
2011-07-11	GLD	ETF	151.33	151.69	150.2	151.59	20447200.0
2011-07-11	TLT	ETF	96.04	96.8	95.75	96.8	9760800.0
2011-07-11	AADR	ETF	31.17	31.17	31.17	31.17	100.0
2011-07-11	AAXJ	ETF	61.89	62.21	61.34	61.52	585800.0
2011-07-11	ACTV	ETF	18.78	19.0	18.45	18.74	76078.0
2011-07-11	ACWI	ETF	47.76	47.86	47.29	47.4	233800.0
2011-07-11	ACWX	ETF	44.01	44.054	43.51	43.56	312470.0
2011-07-11	ADRE	ETF	45.89	45.8901	45.4	45.49	32577.0
2011-07-11	AFK	ETF	31.96	31.96	31.21	31.258	42465.0
2011-07-11	AGEM	ETF	25.84	25.86	25.71	25.812	13418.0
2011-07-11	AGG	ETF	107.34	107.54	107.25	107.41	615000.0
2011-07-11	AGQ	ETF	367.22	369.06	344.34	350.4	840800.0
2011-07-11	AGZ	ETF	110.96	110.99	110.79	110.88	9515.0
2011-07-11	AIA	ETF	46.56	46.57	46.0731	46.1	9276.0
2011-07-11	AIQ	ETF	18.6	18.65	18.2	18.35	17002.0
2011-07-11	AIS	ETF	2.45	2.49	2.35	2.42	2178744.0
2011-07-11	AIVI	ETF	45.34	45.4	44.84	44.92	28500.0
2011-07-11	AMJ	ETF	37.21	37.4	37.07	37.25	802107.0
2011-07-11	AMLP	ETF	80.1	80.45	80.05	80.3	94200.0
2011-07-11	AOA	ETF	36.0	36.0	35.69	35.7	11800.0
2011-07-11	AOK	ETF	29.45	29.45	29.36	29.37	27158.0
2011-07-11	AOM	ETF	30.69	30.71	30.57	30.6002	37949.0
2011-07-11	AOR	ETF	32.7199	32.7199	32.51	32.52	17409.0
2011-07-11	ARB	ETF	41.33	41.48	40.8	41.0	85572.0
2011-07-11	ARGT	ETF	29.7	30.0	29.7	29.76	10550.0
2011-07-11	ASEA	ETF	16.74	16.74	16.57	16.65	32400.0
2011-07-11	AWAY	ETF	42.2	42.74	41.216	41.83	141025.0
2011-07-11	BAB	ETF	26.41	26.64	26.4	26.624	272004.0
2011-07-11	BAL	ETF	67.31	67.62	65.568	65.88	102238.0
2011-07-11	BALT	ETF	5.34	5.38	5.26	5.29	164085.0
2011-07-11	BBH	ETF	35.5233	35.6333	35.1167	35.2167	82500.0
2011-07-11	BIB	ETF	10.1037	10.1037	9.69	9.7863	233168.0
2011-07-11	BICK	ETF	31.91	31.91	31.45	31.49	5281.0
2011-07-11	BIL	ETF	91.72	91.72	91.68	91.68	147850.0
2011-07-11	BIS	ETF	5832.0	5913.44	5782.4	5867.2	73.5
2011-07-11	BITS	ETF	21.24	21.44	21.2	21.44	9372.0
2011-07-11	BIV	ETF	84.73	85.14	84.73	85.02	119300.0
2011-07-11	BJK	ETF	35.51	35.51	34.85	34.88	17900.0
2011-07-11	BKF	ETF	47.08	47.31	46.44	46.47	90332.0
2011-07-11	BKLN	ETF	24.89	24.91	24.84	24.9	35900.0
2011-07-11	BLNG	ETF	49.61	54.02	49.61	54.02	805.0
2011-07-11	BLV	ETF	81.04	81.59	81.04	81.57	43700.0
2011-07-11	BMVP	ETF	15.98	15.98	15.76	15.7792	8077.0
2011-07-11	BND	ETF	81.71	81.86	81.68	81.79	592200.0
2011-07-11	BNO	ETF	38.61	39.255	38.325	38.86	116800.0
2011-07-11	BRF	ETF	54.0	54.34	53.3	53.37	205251.0

> showing 50 of 864 rows — these rows as CSV

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