PREVIEW / etf_daily / 2011-06-01

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-01.parquet
  size:    36 KB
  rows:    852

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-06-01	SPY	ETF	134.51	134.92	131.76	131.87	233094300.0
2011-06-01	QQQ	ETF	58.22	58.36	57.04	57.09	51792337.0
2011-06-01	IWM	ETF	84.71	84.82	82.03	82.11	80933800.0
2011-06-01	DIA	ETF	125.13	125.18	122.62	122.7	8218900.0
2011-06-01	GLD	ETF	149.66	151.13	149.43	149.91	18365400.0
2011-06-01	TLT	ETF	96.92	97.72	96.89	97.64	12746400.0
2011-06-01	AAXJ	ETF	63.91	63.91	62.9	63.0	305500.0
2011-06-01	ACTV	ETF	18.0	18.5	17.8	18.28	259911.0
2011-06-01	ACWI	ETF	49.54	49.54	48.51	48.56	535700.0
2011-06-01	ACWX	ETF	46.11	46.11	45.23	45.27	161019.0
2011-06-01	ADRE	ETF	47.0	47.08	46.31	46.38	60651.0
2011-06-01	AFK	ETF	33.42	33.48	32.95	32.98	23741.0
2011-06-01	AGG	ETF	107.31	107.63	107.31	107.61	1139400.0
2011-06-01	AGQ	ETF	402.88	412.12	368.46	374.24	1504700.0
2011-06-01	AGZ	ETF	110.6899	110.7	110.64	110.69	8406.0
2011-06-01	AIA	ETF	48.77	48.77	48.06	48.17	30655.0
2011-06-01	AIQ	ETF	21.65	21.65	20.7	20.7	22518.0
2011-06-01	AIS	ETF	1.85	1.92	1.81	1.81	1065468.0
2011-06-01	AIVI	ETF	48.74	48.74	47.71	47.71	12200.0
2011-06-01	AMJ	ETF	36.69	36.8	36.32	36.39	506160.0
2011-06-01	AMLP	ETF	79.7	79.7	79.0	79.0	431300.0
2011-06-01	AOA	ETF	36.59	36.59	35.95	35.95	6400.0
2011-06-01	AOK	ETF	29.51	29.56	29.468	29.49	98200.0
2011-06-01	AOM	ETF	30.99	31.0164	30.8344	30.84	22688.0
2011-06-01	AOR	ETF	33.1	33.1	32.79	32.79	11755.0
2011-06-01	ARB	ETF	42.62	42.63	41.33	41.33	230419.0
2011-06-01	ARGT	ETF	29.46	29.46	28.98	28.98	9250.0
2011-06-01	ASEA	ETF	16.5	16.5	16.18	16.18	17600.0
2011-06-01	BAB	ETF	26.71	26.84	26.71	26.7876	172749.0
2011-06-01	BAL	ETF	89.45	90.25	87.92	89.31	85983.0
2011-06-01	BALT	ETF	6.35	6.4	6.21	6.24	164113.0
2011-06-01	BBH	ETF	35.22	35.2533	34.7867	34.7867	50700.0
2011-06-01	BIB	ETF	10.22	10.22	9.7212	9.7575	136400.0
2011-06-01	BICK	ETF	32.81	32.97	32.3104	32.3301	120714.0
2011-06-01	BIL	ETF	91.7	91.72	91.7	91.7	471900.0
2011-06-01	BIS	ETF	5836.8	5956.16	5836.8	5956.16	1.25
2011-06-01	BITS	ETF	22.96	23.32	22.5204	22.84	579.0
2011-06-01	BIV	ETF	84.6	84.89	84.56	84.89	367700.0
2011-06-01	BJK	ETF	34.55	34.6	34.25	34.25	5900.0
2011-06-01	BKF	ETF	48.68	48.812	47.89	48.04	131631.0
2011-06-01	BKLN	ETF	25.09	25.1	25.07	25.1	80200.0
2011-06-01	BLNG	ETF	49.28	49.28	49.28	49.28	1000.0
2011-06-01	BLV	ETF	82.19	82.7	82.12	82.65	103000.0
2011-06-01	BMVP	ETF	15.93	15.95	15.62	15.62	5127.0
2011-06-01	BND	ETF	81.63	81.86	81.6	81.86	1058300.0
2011-06-01	BNO	ETF	38.755	38.78	37.825	38.08	42800.0
2011-06-01	BRF	ETF	57.76	57.879	56.91	57.05	163804.0
2011-06-01	BSCE	ETF	21.17	21.21	21.12	21.2	18298.0
2011-06-01	BSV	ETF	81.09	81.15	81.06	81.13	321700.0
2011-06-01	BTF	ETF	83.85	84.49999999999999	83.49999999999999	83.9	1795.6000000000001

> showing 50 of 852 rows — these rows as CSV

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