PREVIEW / etf_daily / 2011-02-24

all etf daily files

  file:    by_date/etf_daily/2011/2011-02-24.parquet
  size:    35 KB
  rows:    828

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-24	SPY	ETF	130.88	131.44	129.7	130.93	260431400.0
2011-02-24	QQQ	ETF	56.7	57.03	56.14	56.855	98715925.0
2011-02-24	IWM	ETF	79.96	80.72	79.36	80.32	85126500.0
2011-02-24	DIA	ETF	120.77	121.04	119.56	120.42	12247300.0
2011-02-24	GLD	ETF	138.04	138.14	135.73	136.48	18781700.0
2011-02-24	TLT	ETF	91.63	92.04	91.44	91.74	12110900.0
2011-02-24	AADR	ETF	29.96	29.96	29.96	29.96	500.0
2011-02-24	AAXJ	ETF	59.36	59.38	58.8	59.25	409900.0
2011-02-24	ACWI	ETF	47.9	47.99	47.43	47.81	145200.0
2011-02-24	ACWX	ETF	44.78	44.84	44.35	44.72	54441.0
2011-02-24	ADRE	ETF	46.31	46.48	45.989	46.21	63038.0
2011-02-24	AFK	ETF	32.59	32.7999	32.29	32.61	30592.0
2011-02-24	AGG	ETF	105.24	105.34	105.16	105.17	1135300.0
2011-02-24	AGQ	ETF	360.06	362.34	325.26	331.96	937850.0
2011-02-24	AGZ	ETF	109.25	109.25	108.94	108.97	10301.0
2011-02-24	AIA	ETF	44.95	45.1	44.63	44.97	74786.0
2011-02-24	AIQ	ETF	20.65	21.1	20.65	20.9	30797.0
2011-02-24	AIS	ETF	1.54	1.64	1.54	1.58	399879.0
2011-02-24	AIVI	ETF	45.9	45.96	45.43	45.88	94200.0
2011-02-24	AMJ	ETF	38.04	38.2	37.95	38.09	829766.0
2011-02-24	AMLP	ETF	81.75	81.9	81.5	81.55	145880.0
2011-02-24	AOA	ETF	35.19	35.35	34.94	35.25	25900.0
2011-02-24	AOK	ETF	29.04	29.05	28.9801	29.04	11710.0
2011-02-24	AOM	ETF	30.34	30.3544	30.2525	30.3	11295.0
2011-02-24	AOR	ETF	32.11	32.18	31.99	32.1499	16472.0
2011-02-24	ARB	ETF	39.89	40.31	39.26	39.78	234219.0
2011-02-24	ASEA	ETF	15.04	15.04	14.8	14.86	6400.0
2011-02-24	BAB	ETF	25.08	25.1999	25.08	25.1	172589.0
2011-02-24	BAL	ETF	91.36	92.0	90.89	91.15	108818.0
2011-02-24	BALT	ETF	9.07	9.47	8.88	9.16	253248.0
2011-02-24	BBH	ETF	33.1033	33.3367	33.0533	33.24	41400.0
2011-02-24	BIB	ETF	7.325	7.325	7.325	7.325	1800.0
2011-02-24	BICK	ETF	30.2	30.4045	30.1	30.3401	80757.0
2011-02-24	BIL	ETF	91.72	91.72	91.7	91.72	126750.0
2011-02-24	BIS	ETF	8185.6	8242.8	8118.4	8118.4	63.5
2011-02-24	BITS	ETF	27.48	27.48	26.8	26.8	1888.0
2011-02-24	BIV	ETF	82.37	82.64	82.28	82.31	111100.0
2011-02-24	BJK	ETF	31.12	31.21	30.73	31.06	37000.0
2011-02-24	BKF	ETF	46.86	47.0781	46.48	46.75	355648.0
2011-02-24	BLV	ETF	78.03	78.46	78.03	78.23	75100.0
2011-02-24	BMVP	ETF	15.3667	15.43	15.2467	15.3739	13934.0
2011-02-24	BND	ETF	80.01	80.14	79.98	80.02	939000.0
2011-02-24	BNO	ETF	38.18	38.2	36.355	36.615	306200.0
2011-02-24	BOSS	ETF	47.11	47.11	44.76	44.76	100.0
2011-02-24	BRF	ETF	51.72	51.949	51.32	51.88	378940.0
2011-02-24	BSCE	ETF	20.86	20.9	20.8462	20.9	39974.0
2011-02-24	BSV	ETF	80.31	80.41	80.28	80.28	481900.0
2011-02-24	BTF	ETF	85.35	85.44999999999999	83.3	84.25	3727.6000000000004
2011-02-24	BWX	ETF	29.535	29.66	29.5	29.5	323902.0
2011-02-24	BWZ	ETF	37.75	37.75	37.5284	37.62	14808.0

> showing 50 of 828 rows — these rows as CSV

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