PREVIEW / etf_daily / 2011-02-10

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-10.parquet
  size:    35 KB
  rows:    826

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-02-10	SPY	ETF	131.6	132.47	131.3	132.32	162708500.0
2011-02-10	QQQ	ETF	57.61	58.1	57.49	58.021	70194657.0
2011-02-10	IWM	ETF	80.33	81.29	80.24	81.19	48001000.0
2011-02-10	DIA	ETF	121.77	122.25	121.43	122.17	7202200.0
2011-02-10	GLD	ETF	132.11	133.31	132.0	132.85	8105200.0
2011-02-10	TLT	ETF	88.9	89.14	88.18	88.19	10486800.0
2011-02-10	AADR	ETF	29.94	30.14	29.94	30.09	1000.0
2011-02-10	AAXJ	ETF	59.91	60.26	59.62	60.22	2240900.0
2011-02-10	ACWI	ETF	47.69	48.31	47.69	48.23	389300.0
2011-02-10	ACWX	ETF	44.7	44.99	44.5	44.95	97578.0
2011-02-10	ADRE	ETF	45.55	45.9008	45.4	45.76	142447.0
2011-02-10	AFK	ETF	33.44	33.907	33.37	33.5	47741.0
2011-02-10	AGG	ETF	104.11	104.17	103.85	103.89	520800.0
2011-02-10	AGQ	ETF	292.24	299.66	291.0	297.0	306300.0
2011-02-10	AGZ	ETF	108.586	108.6892	108.48	108.54	99239.0
2011-02-10	AIA	ETF	45.84	46.21	45.61	46.14	68628.0
2011-02-10	AIQ	ETF	20.8	20.9	20.2	20.75	15966.0
2011-02-10	AIS	ETF	1.83	1.88	1.76	1.77	1821043.0
2011-02-10	AIVI	ETF	46.06	46.27	46.02	46.18	14600.0
2011-02-10	AMJ	ETF	37.33	37.45	37.25	37.4	1609971.0
2011-02-10	AMLP	ETF	80.25	80.4	80.1	80.4	90340.0
2011-02-10	AOA	ETF	35.29	35.54	35.29	35.49	25900.0
2011-02-10	AOK	ETF	28.83	28.86	28.82	28.84	15748.0
2011-02-10	AOM	ETF	30.21	30.27	30.1508	30.2499	34902.0
2011-02-10	AOR	ETF	32.11	32.25	32.11	32.2	23726.0
2011-02-10	ARB	ETF	43.66	44.26	43.54	44.23	151709.0
2011-02-10	BAB	ETF	24.6	24.74	24.57	24.59	584878.0
2011-02-10	BAL	ETF	94.49	97.34	94.11	97.34	124807.0
2011-02-10	BALT	ETF	8.85	8.91	8.73	8.83	109199.0
2011-02-10	BBH	ETF	33.6	33.7567	33.6	33.65	27900.0
2011-02-10	BIB	ETF	7.5	7.5	7.5	7.5	2400.0
2011-02-10	BICK	ETF	29.66	30.55	29.66	30.538	280511.0
2011-02-10	BIL	ETF	91.7	91.72	91.7	91.7	148650.0
2011-02-10	BIS	ETF	8051.2	8051.2	8051.2	8051.2	1.25
2011-02-10	BITS	ETF	27.4	27.6	27.24	27.4	2483.0
2011-02-10	BIV	ETF	81.26	81.4	81.04	81.06	151300.0
2011-02-10	BJK	ETF	32.03	32.22	32.03	32.22	5100.0
2011-02-10	BKF	ETF	46.08	46.42	45.71	46.31	227616.0
2011-02-10	BLV	ETF	76.32	76.44	76.0	76.0	13200.0
2011-02-10	BMVP	ETF	15.26	15.38	15.26	15.36	10563.0
2011-02-10	BND	ETF	79.17	79.28	79.02	79.03	519000.0
2011-02-10	BNO	ETF	33.835	33.885	33.6	33.77	20000.0
2011-02-10	BOSS	ETF	49.06	49.06	48.055	48.055	200.0
2011-02-10	BRF	ETF	50.71	51.04	50.25	50.55	513977.0
2011-02-10	BSCE	ETF	20.7	20.71	20.6401	20.666	13725.0
2011-02-10	BSV	ETF	79.99	80.01	79.91	79.94	495200.0
2011-02-10	BTF	ETF	83.1505	83.64999999999999	82.85	83.64999999999999	2876.2000000000003
2011-02-10	BWX	ETF	28.935	29.065	28.81	28.86	691376.0
2011-02-10	BWZ	ETF	37.99	37.99	37.3201	37.334	9512.0
2011-02-10	BZQ	ETF	2867.2	2884.8	2808.0	2872.0	864.5

> showing 50 of 826 rows — these rows as CSV

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