PREVIEW / etf_daily / 2011-11-09

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-09.parquet
  size:    37 KB
  rows:    894

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-11-09	SPY	ETF	124.89	125.8	122.86	123.16	337982000.0
2011-11-09	QQQ	ETF	57.72	57.83	56.63	56.81	69538736.0
2011-11-09	IWM	ETF	73.32	73.92	71.82	71.94	78806400.0
2011-11-09	DIA	ETF	119.33	119.67	117.24	117.69	12096200.0
2011-11-09	GLD	ETF	174.28	174.81	171.61	172.07	12313900.0
2011-11-09	TLT	ETF	118.26	119.13	117.07	118.12	13004500.0
2011-11-09	AAXJ	ETF	53.1	53.36	51.96	52.11	564000.0
2011-11-09	ACTV	ETF	13.0	13.2	12.75	12.91	75364.0
2011-11-09	ACWI	ETF	42.99	43.03	42.1	42.24	456500.0
2011-11-09	ACWV	ETF	49.87	49.87	49.75	49.75	600.0
2011-11-09	ACWX	ETF	37.87	38.043	37.29	37.3154	333008.0
2011-11-09	ADRE	ETF	40.66	40.88	40.0	40.04	53592.0
2011-11-09	AFK	ETF	28.53	28.53	27.955	28.03	13722.0
2011-11-09	AGEM	ETF	22.76	22.76	22.09	22.25	3861.0
2011-11-09	AGG	ETF	110.17	110.34	110.02	110.13	780000.0
2011-11-09	AGQ	ETF	273.28	275.0	258.64	263.12	531075.0
2011-11-09	AGZ	ETF	112.51	112.82	112.4076	112.81	32504.0
2011-11-09	AIA	ETF	41.36	41.41	40.33	40.5	76711.0
2011-11-09	AIQ	ETF	6.15	6.8	6.05	6.3	81581.0
2011-11-09	AIS	ETF	2.35	2.4	2.26	2.31	771159.0
2011-11-09	AIVI	ETF	40.55	40.55	39.54	39.54	126900.0
2011-11-09	AMJ	ETF	36.92	36.97	36.44	36.52	2812702.0
2011-11-09	AMLP	ETF	78.6	79.25	78.0	78.1	201280.0
2011-11-09	AOA	ETF	33.12	33.23	32.69	32.69	22600.0
2011-11-09	AOK	ETF	29.38	29.409	29.25	29.25	29798.0
2011-11-09	AOM	ETF	30.04	30.04	29.79	29.81	32745.0
2011-11-09	AOR	ETF	31.26	31.3	30.94	30.95	73144.0
2011-11-09	ARB	ETF	41.16	41.2	39.65	39.79	277125.0
2011-11-09	ARGT	ETF	23.12	23.12	22.52	22.52	1350.0
2011-11-09	ASEA	ETF	15.11	15.14	14.75	14.78	6500.0
2011-11-09	AWAY	ETF	33.24	33.83	32.73	32.91	58062.0
2011-11-09	BAB	ETF	28.74	28.8	28.571	28.75	171235.0
2011-11-09	BAL	ETF	59.92	60.46	59.74	60.46	18455.0
2011-11-09	BALT	ETF	5.28	5.6	5.28	5.43	80743.0
2011-11-09	BBH	ETF	35.0267	35.2333	34.7767	34.8067	19500.0
2011-11-09	BCM	ETF	45.1	45.3999	45.1	45.16	1218.0
2011-11-09	BIB	ETF	7.235	7.265	7.0038	7.0325	25632.0
2011-11-09	BICK	ETF	26.02	26.12	25.15	25.23	20649.0
2011-11-09	BIL	ETF	91.7	91.7	91.68	91.68	174200.0
2011-11-09	BIS	ETF	6729.6	6729.6	6729.6	6729.6	0.94
2011-11-09	BITS	ETF	21.96	22.4	21.68	22.12	6270.0
2011-11-09	BIV	ETF	88.05	88.18	87.69	88.02	115600.0
2011-11-09	BJK	ETF	31.96	31.98	31.3	31.33	9300.0
2011-11-09	BKF	ETF	40.01	40.17	38.88	39.06	215927.0
2011-11-09	BKLN	ETF	23.96	24.16	23.94	23.94	67300.0
2011-11-09	BLNG	ETF	54.62	54.68	53.86	53.86	3000.0
2011-11-09	BLV	ETF	92.11	92.35	91.29	91.92	48900.0
2011-11-09	BMVP	ETF	13.8279	13.884	13.61	13.61	5011.0
2011-11-09	BND	ETF	83.93	83.93	83.67	83.75	1346800.0
2011-11-09	BNO	ETF	38.855	39.48	38.435	38.495	130600.0

> showing 50 of 894 rows — these rows as CSV

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