PREVIEW / etf_daily / 2011-05-31

all etf daily files

  file:    by_date/etf_daily/2011/2011-05-31.parquet
  size:    36 KB
  rows:    856

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-31	SPY	ETF	134.77	134.92	133.84	134.9	164731200.0
2011-05-31	QQQ	ETF	57.97	58.36	57.67	58.36	47588058.0
2011-05-31	IWM	ETF	84.61	84.86	83.77	84.84	77456200.0
2011-05-31	DIA	ETF	125.33	125.55	124.6	125.5	5290000.0
2011-05-31	GLD	ETF	149.88	150.16	149.41	149.64	10499300.0
2011-05-31	TLT	ETF	96.18	96.76	96.09	96.69	7003900.0
2011-05-31	AADR	ETF	31.67	31.75	31.67	31.75	800.0
2011-05-31	AAXJ	ETF	63.56	63.89	63.41	63.89	479800.0
2011-05-31	ACTV	ETF	18.26	18.83	17.8	18.35	231624.0
2011-05-31	ACWI	ETF	49.6	49.7	49.17	49.7	1034000.0
2011-05-31	ACWX	ETF	46.19	46.27	45.904	46.27	242393.0
2011-05-31	ADRE	ETF	47.09	47.22	46.8	47.07	46384.0
2011-05-31	AFK	ETF	33.34	33.57	33.34	33.37	80740.0
2011-05-31	AGG	ETF	107.32	107.62	107.28	107.46	1047300.0
2011-05-31	AGQ	ETF	416.48	417.36	402.02	414.4	951850.0
2011-05-31	AGZ	ETF	110.82	111.05	110.5001	110.68	16557.0
2011-05-31	AIA	ETF	48.74	48.8	48.46	48.7676	42319.0
2011-05-31	AIQ	ETF	21.65	21.775	21.35	21.65	92722.0
2011-05-31	AIS	ETF	1.85	1.89	1.82	1.85	1873176.0
2011-05-31	AIVI	ETF	48.72	48.81	48.53	48.81	14800.0
2011-05-31	AMJ	ETF	36.99	37.09	36.649	36.74	418653.0
2011-05-31	AMLP	ETF	79.9	80.0	79.4	79.7	305780.0
2011-05-31	AOA	ETF	36.58	36.64	36.46	36.5	5300.0
2011-05-31	AOK	ETF	29.55	29.57	29.5	29.5492	28561.0
2011-05-31	AOM	ETF	31.04	31.04	30.9632	31.03	3817.0
2011-05-31	AOR	ETF	33.15	33.169	33.03	33.169	17836.0
2011-05-31	ARB	ETF	42.41	42.74	41.93	42.7	220391.0
2011-05-31	ARGT	ETF	29.52	29.62	29.46	29.52	5500.0
2011-05-31	ASEA	ETF	16.53	16.57	16.46	16.46	6600.0
2011-05-31	BAB	ETF	26.58	26.689	26.562	26.64	125477.0
2011-05-31	BAL	ETF	87.02	88.39	86.55	87.5525	109068.0
2011-05-31	BALT	ETF	6.49	6.51	6.25	6.36	282204.0
2011-05-31	BBH	ETF	34.8833	35.2967	34.8833	35.27	46800.0
2011-05-31	BIB	ETF	10.2212	10.2212	9.925	10.125	70984.0
2011-05-31	BICK	ETF	32.93	32.94	32.66	32.94	4213232.0
2011-05-31	BIL	ETF	91.7	91.72	91.7	91.72	133700.0
2011-05-31	BIS	ETF	5742.4	5883.2	5737.6	5779.2	29.45
2011-05-31	BITS	ETF	24.0	24.4	22.64	23.4	2970.0
2011-05-31	BIV	ETF	84.4	84.68	84.37	84.67	216400.0
2011-05-31	BJK	ETF	34.71	34.71	34.4	34.4	8100.0
2011-05-31	BKF	ETF	48.97	48.97	48.4501	48.84	205714.0
2011-05-31	BKLN	ETF	25.07	25.08	25.05	25.08	82200.0
2011-05-31	BLV	ETF	81.79	82.15	81.67	82.09	38800.0
2011-05-31	BMVP	ETF	15.95	15.95	15.88	15.95	4483.0
2011-05-31	BND	ETF	81.55	81.75	81.46	81.69	1267900.0
2011-05-31	BNO	ETF	38.81	39.0	38.71	38.775	55400.0
2011-05-31	BRF	ETF	57.08	58.11	57.07	58.11	523673.0
2011-05-31	BSCE	ETF	21.17	21.22	21.16	21.205	16878.0
2011-05-31	BSV	ETF	81.02	81.18	81.02	81.15	472300.0
2011-05-31	BTF	ETF	84.89999999999999	85.0	84.25	84.35	4400.8

> showing 50 of 856 rows — these rows as CSV

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