PREVIEW / etf_daily / 2011-11-03

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-03.parquet
  size:    37 KB
  rows:    881

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-03	SPY	ETF	125.27	126.5	123.6	126.25	291174800.0
2011-11-03	QQQ	ETF	57.36	58.175	56.71	58.1	78994185.0
2011-11-03	IWM	ETF	74.27	75.2	72.29	74.97	74622200.0
2011-11-03	DIA	ETF	119.23	120.41	118.16	120.19	12007500.0
2011-11-03	GLD	ETF	171.17	172.04	169.9	171.72	17610400.0
2011-11-03	TLT	ETF	116.34	117.35	115.99	116.34	8386700.0
2011-11-03	AADR	ETF	28.88	28.94	28.88	28.94	400.0
2011-11-03	AAXJ	ETF	54.18	54.9	53.61	54.74	535800.0
2011-11-03	ACTV	ETF	13.19	13.19	12.96	13.11	111583.0
2011-11-03	ACWI	ETF	43.59	44.0	42.86	43.89	207400.0
2011-11-03	ACWV	ETF	50.93	51.14	50.83	51.14	900.0
2011-11-03	ACWX	ETF	38.93	39.26	38.27	39.15	117783.0
2011-11-03	ADRE	ETF	41.33	41.41	40.66	41.27	35197.0
2011-11-03	AFK	ETF	28.7	29.14	28.48	29.14	19715.0
2011-11-03	AGEM	ETF	22.78	22.91	22.75	22.89	3310.0
2011-11-03	AGG	ETF	109.97	110.18	109.88	110.03	1116000.0
2011-11-03	AGQ	ETF	274.48	274.68	259.92	271.24	441275.0
2011-11-03	AGZ	ETF	112.66	112.66	112.28	112.33	45304.0
2011-11-03	AIA	ETF	41.9	42.49	41.53	42.34	69941.0
2011-11-03	AIQ	ETF	5.95	6.25	5.8	6.25	17074.0
2011-11-03	AIS	ETF	2.29	2.31	2.24	2.29	502814.0
2011-11-03	AIVI	ETF	41.54	42.15	41.02	42.02	79300.0
2011-11-03	AMJ	ETF	37.43	37.43	36.8	37.3	1231602.0
2011-11-03	AMLP	ETF	80.55	80.75	79.9	80.6	307420.0
2011-11-03	AOA	ETF	33.35	33.66	33.07	33.59	10600.0
2011-11-03	AOK	ETF	29.35	29.45	29.3444	29.44	25053.0
2011-11-03	AOM	ETF	30.13	30.23	29.95	30.21	29495.0
2011-11-03	AOR	ETF	31.32	31.55	31.21	31.54	8039.0
2011-11-03	ARB	ETF	41.13	42.15	40.06	42.02	223613.0
2011-11-03	ARGT	ETF	22.52	23.02	22.52	22.98	2500.0
2011-11-03	ASEA	ETF	15.14	15.33	15.13	15.24	4500.0
2011-11-03	AWAY	ETF	34.29	34.58	33.57	34.3	69447.0
2011-11-03	BAB	ETF	28.32	28.38	28.116	28.34	89978.0
2011-11-03	BAL	ETF	60.71	61.37	60.15	60.72	37943.0
2011-11-03	BALT	ETF	5.6	5.8	5.48	5.75	86003.0
2011-11-03	BBH	ETF	34.6633	35.0033	34.6633	34.9967	9000.0
2011-11-03	BCM	ETF	45.061	45.07	45.061	45.07	360.0
2011-11-03	BIB	ETF	7.4575	7.6527	7.4575	7.625	16000.0
2011-11-03	BICK	ETF	26.33	26.3469	25.94	26.3469	12004.0
2011-11-03	BIL	ETF	91.7	91.7	91.66	91.66	326800.0
2011-11-03	BITS	ETF	22.72	23.2	22.0	22.8	2511.0
2011-11-03	BIV	ETF	87.73	87.96	87.7	87.84	166300.0
2011-11-03	BJK	ETF	32.87	33.12	32.52	33.06	12900.0
2011-11-03	BKF	ETF	40.68	40.984	40.11	40.85	236621.0
2011-11-03	BKLN	ETF	23.9	24.07	23.9	24.07	42900.0
2011-11-03	BLNG	ETF	53.45	53.45	53.45	53.45	200.0
2011-11-03	BLV	ETF	91.16	91.59	90.93	91.29	153500.0
2011-11-03	BMVP	ETF	13.89	14.03	13.68	14.03	10358.0
2011-11-03	BND	ETF	83.8	83.97	83.76	83.77	1275300.0
2011-11-03	BNO	ETF	37.865	38.095	37.385	37.945	590400.0

> showing 50 of 881 rows — these rows as CSV

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