PREVIEW / etf_daily / 2011-10-24

all etf daily files

  file:    by_date/etf_daily/2011/2011-10-24.parquet
  size:    37 KB
  rows:    882

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-10-24	SPY	ETF	124.17	125.8	124.06	125.49	203215600.0
2011-10-24	QQQ	ETF	57.52	58.65	57.3105	58.49	61449356.0
2011-10-24	IWM	ETF	71.45	73.58	71.16	73.42	81399100.0
2011-10-24	DIA	ETF	118.17	119.16	118.01	118.88	8407500.0
2011-10-24	GLD	ETF	160.55	161.33	160.22	161.02	10199800.0
2011-10-24	TLT	ETF	113.93	114.08	113.05	113.32	6344500.0
2011-10-24	AADR	ETF	28.3	28.38	28.3	28.38	800.0
2011-10-24	AAXJ	ETF	52.1	53.34	51.96	52.96	456900.0
2011-10-24	ACTV	ETF	14.44	14.45	14.12	14.32	76775.0
2011-10-24	ACWI	ETF	42.96	43.82	42.96	43.7	680000.0
2011-10-24	ACWX	ETF	38.37	39.13	38.37	38.98	690174.0
2011-10-24	ADRE	ETF	38.65	39.91	38.65	39.91	27921.0
2011-10-24	AFK	ETF	27.55	27.9999	27.53	27.92	12209.0
2011-10-24	AGEM	ETF	21.48	22.202	21.48	22.202	2246.0
2011-10-24	AGG	ETF	109.46	109.46	109.16	109.24	867600.0
2011-10-24	AGQ	ETF	227.12	236.0	226.68	230.64	368375.0
2011-10-24	AGZ	ETF	112.4	112.4	112.1	112.17	11342.0
2011-10-24	AIA	ETF	40.39	41.4	40.37	41.17	53901.0
2011-10-24	AIQ	ETF	5.65	5.75	5.55	5.75	28832.0
2011-10-24	AIS	ETF	2.24	2.3	2.23	2.3	690243.0
2011-10-24	AIVI	ETF	41.95	42.8	41.95	42.75	96400.0
2011-10-24	AMJ	ETF	36.73	37.0	36.42	36.86	1418402.0
2011-10-24	AMLP	ETF	79.75	80.05	79.45	79.8	165820.0
2011-10-24	AOA	ETF	33.06	33.41	33.01	33.37	4700.0
2011-10-24	AOK	ETF	29.07	29.26	29.07	29.26	8566.0
2011-10-24	AOM	ETF	29.85	30.02	29.84	30.02	75544.0
2011-10-24	AOR	ETF	31.0	31.31	31.0	31.29	9967.0
2011-10-24	ARB	ETF	37.87	39.81	37.71	39.3	188519.0
2011-10-24	ARGT	ETF	21.98	22.38	21.98	22.34	1200.0
2011-10-24	ASEA	ETF	14.91	15.19	14.91	15.05	5000.0
2011-10-24	AWAY	ETF	36.5	36.68	35.3	36.63	130836.0
2011-10-24	BAB	ETF	27.94	27.94	27.64	27.76	148082.0
2011-10-24	BAL	ETF	60.24	60.8	59.91	60.57	21726.0
2011-10-24	BALT	ETF	5.85	6.0	5.74	5.82	103338.0
2011-10-24	BBH	ETF	35.3033	35.6433	35.2333	35.61	18600.0
2011-10-24	BCM	ETF	43.93	43.93	43.93	43.93	240.0
2011-10-24	BIB	ETF	7.6063	7.8513	7.6063	7.8513	32672.0
2011-10-24	BICK	ETF	24.78	25.54	24.78	25.54	22571.0
2011-10-24	BIL	ETF	91.68	91.7	91.68	91.68	8779750.0
2011-10-24	BITS	ETF	23.2	23.2	22.6	22.6	413.0
2011-10-24	BIV	ETF	87.0	87.0	86.66	86.89	171600.0
2011-10-24	BJK	ETF	30.62	31.69	30.62	31.69	17800.0
2011-10-24	BKF	ETF	37.66	38.7302	37.47	38.6	146870.0
2011-10-24	BKLN	ETF	23.75	24.0	23.44	24.0	368200.0
2011-10-24	BLNG	ETF	50.37	50.4	50.37	50.4	470.0
2011-10-24	BLV	ETF	89.68	89.74	89.24	89.43	17900.0
2011-10-24	BMVP	ETF	13.57	13.8	13.57	13.76	4716.0
2011-10-24	BND	ETF	83.13	83.22	83.08	83.16	1261000.0
2011-10-24	BNO	ETF	37.765	38.265	37.765	38.155	141400.0
2011-10-24	BRF	ETF	43.41	44.89	43.38	44.8	169622.0

> showing 50 of 882 rows — these rows as CSV

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