PREVIEW / etf_daily / 2011-07-15

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-15.parquet
  size:    36 KB
  rows:    856

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-15	SPY	ETF	131.66	131.87	130.77	131.69	220012800.0
2011-07-15	QQQ	ETF	57.72	57.85	57.31	57.85	68287687.0
2011-07-15	IWM	ETF	82.61	82.91	82.18	82.81	75496200.0
2011-07-15	DIA	ETF	124.71	124.77	123.78	124.56	7853000.0
2011-07-15	GLD	ETF	154.34	155.29	154.22	155.2	18448400.0
2011-07-15	TLT	ETF	95.29	96.2	95.24	96.17	7086200.0
2011-07-15	AAXJ	ETF	61.82	61.85	61.24	61.64	212000.0
2011-07-15	ACTV	ETF	18.54	18.95	18.42	18.49	128027.0
2011-07-15	ACWI	ETF	47.74	47.74	47.21	47.58	291200.0
2011-07-15	ACWX	ETF	43.84	43.89	43.478	43.71	66744.0
2011-07-15	ADRE	ETF	45.56	45.6	45.1898	45.37	33386.0
2011-07-15	AFK	ETF	31.56	31.82	31.4336	31.79	9366.0
2011-07-15	AGEM	ETF	25.75	25.75	25.56	25.64	11395.0
2011-07-15	AGG	ETF	107.39	107.69	107.32	107.59	638300.0
2011-07-15	AGQ	ETF	400.54	416.0	400.0	415.56	839850.0
2011-07-15	AGZ	ETF	110.8	111.0	110.8	110.91	4622.0
2011-07-15	AIA	ETF	45.9968	45.9968	45.86	45.9888	3370.0
2011-07-15	AIQ	ETF	18.1	18.1	17.8	18.0	16417.0
2011-07-15	AIS	ETF	2.36	2.39	2.23	2.34	1589105.0
2011-07-15	AIVI	ETF	44.98	45.04	44.59	44.77	59500.0
2011-07-15	AMJ	ETF	37.02	37.38	37.02	37.31	311295.0
2011-07-15	AMLP	ETF	80.0	80.35	80.0	80.35	82200.0
2011-07-15	AOA	ETF	35.53	35.63	35.46	35.63	5600.0
2011-07-15	AOK	ETF	29.34	29.422	29.34	29.422	4245.0
2011-07-15	AOM	ETF	30.51	30.628	30.51	30.628	13566.0
2011-07-15	AOR	ETF	32.465	32.5	32.41	32.5	4941.0
2011-07-15	ARB	ETF	40.09	40.62	39.82	40.41	110552.0
2011-07-15	ARGT	ETF	29.78	29.78	29.64	29.64	4150.0
2011-07-15	ASEA	ETF	16.84	16.96	16.79	16.96	4300.0
2011-07-15	AWAY	ETF	41.4	43.0	41.111	42.0	224551.0
2011-07-15	BAB	ETF	26.49	26.642	26.401	26.63	207910.0
2011-07-15	BAL	ETF	61.93	61.93	60.4	61.05	174461.0
2011-07-15	BALT	ETF	4.95	5.03	4.91	4.93	213832.0
2011-07-15	BBH	ETF	34.7333	34.8467	34.5467	34.72	47700.0
2011-07-15	BCM	ETF	48.24	48.24	48.24	48.24	800.0
2011-07-15	BIB	ETF	9.8125	9.8125	9.6263	9.716	63904.0
2011-07-15	BICK	ETF	31.58	31.65	31.437	31.4858	3338.0
2011-07-15	BIL	ETF	91.7	91.72	91.7	91.72	496050.0
2011-07-15	BIS	ETF	5872.0	5926.4	5872.0	5888.0	7.5
2011-07-15	BITS	ETF	21.72	22.0	21.6	22.0	263.0
2011-07-15	BIV	ETF	84.78	85.25	84.75	85.11	116800.0
2011-07-15	BJK	ETF	35.15	35.17	35.0	35.0	5100.0
2011-07-15	BKF	ETF	46.69	46.73	46.29	46.53	65008.0
2011-07-15	BKLN	ETF	24.84	24.86	24.81	24.83	90600.0
2011-07-15	BLV	ETF	80.82	81.49	80.82	81.25	23900.0
2011-07-15	BMVP	ETF	15.61	15.61	15.5	15.61	12709.0
2011-07-15	BND	ETF	81.58	81.87	81.57	81.82	574100.0
2011-07-15	BNO	ETF	39.04	39.32	38.985	39.31	125800.0
2011-07-15	BRF	ETF	53.58	53.58	52.85	53.01	136479.0
2011-07-15	BSCE	ETF	21.21	21.21	21.18	21.21	7375.0

> showing 50 of 856 rows — these rows as CSV

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