PREVIEW / etf_daily / 2011-05-11

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-11.parquet
  size:    36 KB
  rows:    854

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-05-11	SPY	ETF	135.67	135.69	133.82	134.44	193564200.0
2011-05-11	QQQ	ETF	59.1	59.31	58.36	58.755	61908940.0
2011-05-11	IWM	ETF	85.24	85.36	83.55	83.95	81313700.0
2011-05-11	DIA	ETF	127.2	127.25	125.74	126.31	7813600.0
2011-05-11	GLD	ETF	147.24	147.35	145.77	146.54	21378300.0
2011-05-11	TLT	ETF	94.32	95.09	94.18	94.83	6078700.0
2011-05-11	AADR	ETF	31.29	31.29	31.09	31.09	1500.0
2011-05-11	AAXJ	ETF	64.06	64.13	62.94	63.23	1094300.0
2011-05-11	ACWI	ETF	49.67	49.76	48.99	49.24	516800.0
2011-05-11	ACWX	ETF	46.42	46.42	45.51	45.78	84929.0
2011-05-11	ADRE	ETF	46.97	47.0	46.1149	46.37	41562.0
2011-05-11	AFK	ETF	33.35	33.35	32.5301	32.56	13359.0
2011-05-11	AGG	ETF	106.5	106.81	106.5	106.78	538800.0
2011-05-11	AGQ	ETF	415.12	417.58	360.34	365.2	2828700.0
2011-05-11	AGZ	ETF	110.02	110.18	109.95	110.09	4921.0
2011-05-11	AIA	ETF	48.52	48.52	47.71	47.935	36288.0
2011-05-11	AIQ	ETF	21.85	21.9	21.5	21.75	18312.0
2011-05-11	AIS	ETF	1.82	1.85	1.7399	1.77	605651.0
2011-05-11	AIVI	ETF	49.0	49.0	48.09	48.21	25700.0
2011-05-11	AMJ	ETF	37.75	37.75	36.81	37.08	901224.0
2011-05-11	AMLP	ETF	80.4	80.45	79.25	79.6	189640.0
2011-05-11	AOA	ETF	36.84	36.84	36.38	36.43	19200.0
2011-05-11	AOK	ETF	29.55	29.55	29.45	29.4584	5450.0
2011-05-11	AOM	ETF	31.01	31.06	30.89	30.91	8706.0
2011-05-11	AOR	ETF	33.2175	33.2175	32.93	33.03	6837.0
2011-05-11	ARB	ETF	42.11	42.4	40.69	41.12	119584.0
2011-05-11	ARGT	ETF	30.32	30.34	30.0	30.0	2850.0
2011-05-11	ASEA	ETF	16.5	16.53	16.41	16.45	8000.0
2011-05-11	BAB	ETF	26.16	26.36	26.14	26.32	139670.0
2011-05-11	BAL	ETF	84.93	84.9399	81.86	83.8	63867.0
2011-05-11	BALT	ETF	7.2	7.31	6.96	6.97	229571.0
2011-05-11	BBH	ETF	35.12	35.2	34.7367	35.1267	40200.0
2011-05-11	BCM	ETF	48.27	48.27	45.08	45.08	6000.0
2011-05-11	BIB	ETF	10.1387	10.1387	9.745	9.9238	136392.0
2011-05-11	BICK	ETF	33.27	33.49	32.87	33.0635	28581.0
2011-05-11	BIL	ETF	91.72	91.74	91.72	91.74	76150.0
2011-05-11	BIS	ETF	5899.2	5950.4	5883.2	5950.4	7.5
2011-05-11	BITS	ETF	22.56	23.88	22.36	23.368	2581.0
2011-05-11	BIV	ETF	83.52	83.78	83.43	83.74	68500.0
2011-05-11	BJK	ETF	34.93	35.14	34.54	34.78	10100.0
2011-05-11	BKF	ETF	48.41	48.4771	47.57	47.78	111202.0
2011-05-11	BKLN	ETF	25.3	25.3	25.25	25.27	83700.0
2011-05-11	BLV	ETF	80.29	80.86	80.27	80.72	14300.0
2011-05-11	BMVP	ETF	16.0033	16.0033	15.8158	15.9027	12975.0
2011-05-11	BND	ETF	81.02	81.21	80.98	81.15	570800.0
2011-05-11	BNO	ETF	38.625	38.64	37.09	37.57	216200.0
2011-05-11	BRF	ETF	57.44	57.57	56.06	56.52	440746.0
2011-05-11	BSCE	ETF	21.1	21.13	21.0844	21.13	30185.0
2011-05-11	BSV	ETF	80.72	80.83	80.67	80.8	309500.0
2011-05-11	BTF	ETF	83.35000000000001	83.4505	82.765	83.3	2691.6000000000004

> showing 50 of 854 rows — these rows as CSV

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