PREVIEW / etf_daily / 2011-07-26

all etf daily files

  file:    by_date/etf_daily/2011/2011-07-26.parquet
  size:    36 KB
  rows:    866

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-07-26	SPY	ETF	133.74	133.96	133.03	133.33	131278200.0
2011-07-26	QQQ	ETF	59.44	59.83	59.32	59.625	40918829.0
2011-07-26	IWM	ETF	82.88	83.09	82.21	82.43	52205500.0
2011-07-26	DIA	ETF	125.36	125.53	124.67	124.83	7202900.0
2011-07-26	GLD	ETF	156.97	157.79	156.6	157.77	11735500.0
2011-07-26	TLT	ETF	95.3	95.87	95.24	95.65	7682800.0
2011-07-26	AADR	ETF	31.37	31.43	31.37	31.42	3600.0
2011-07-26	AAXJ	ETF	63.01	63.15	62.67	62.94	158200.0
2011-07-26	ACTV	ETF	17.95	18.46	17.91	18.27	125712.0
2011-07-26	ACWI	ETF	48.68	48.71	48.38	48.54	297500.0
2011-07-26	ACWX	ETF	44.91	45.084	44.74	44.87	59780.0
2011-07-26	ADRE	ETF	46.57	46.7446	46.39	46.52	49072.0
2011-07-26	AFK	ETF	32.1	32.25	32.01	32.1	92314.0
2011-07-26	AGG	ETF	107.35	107.59	107.31	107.49	832200.0
2011-07-26	AGQ	ETF	436.6	449.22	428.56	448.7	854450.0
2011-07-26	AGZ	ETF	110.71	110.9	110.71	110.89	9134.0
2011-07-26	AIA	ETF	47.27	47.402	47.07	47.2001	29948.0
2011-07-26	AIQ	ETF	16.8	17.2	16.5	16.85	61900.0
2011-07-26	AIS	ETF	2.53	2.53	2.41	2.42	1082934.0
2011-07-26	AIVI	ETF	46.66	46.76	46.42	46.57	22100.0
2011-07-26	AMJ	ETF	37.0	37.05	36.58	36.61	2543804.0
2011-07-26	AMLP	ETF	80.2	80.3	79.5	79.55	127120.0
2011-07-26	AOA	ETF	36.12	36.15	36.0	36.11	9600.0
2011-07-26	AOK	ETF	29.52	29.53	29.5	29.5	6126.0
2011-07-26	AOM	ETF	30.82	30.89	30.8045	30.8045	17134.0
2011-07-26	AOR	ETF	32.86	32.88	32.72	32.76	60113.0
2011-07-26	ARB	ETF	42.51	42.63	41.66	42.03	68395.0
2011-07-26	ARGT	ETF	29.82	30.1	29.82	30.1	1200.0
2011-07-26	ASEA	ETF	17.28	17.39	17.25	17.34	7400.0
2011-07-26	AWAY	ETF	40.98	43.98	40.98	42.93	106323.0
2011-07-26	BAB	ETF	26.59	26.73	26.56	26.65	334418.0
2011-07-26	BAL	ETF	59.36	62.85	57.85	62.82	222117.0
2011-07-26	BALT	ETF	5.0	5.86	4.82	5.56	523456.0
2011-07-26	BBH	ETF	35.0	35.07	34.9133	34.98	18300.0
2011-07-26	BCM	ETF	48.62	48.77	48.62	48.77	700.0
2011-07-26	BIB	ETF	9.7363	9.7363	9.4838	9.485	92600.0
2011-07-26	BICK	ETF	31.84	32.04	31.8115	31.918	9706.0
2011-07-26	BIL	ETF	91.7	91.72	91.7	91.72	85800.0
2011-07-26	BIS	ETF	5932.8	6004.8	5932.8	6004.8	10.6
2011-07-26	BITS	ETF	22.2	22.2	21.32	21.64	750.0
2011-07-26	BIV	ETF	84.95	85.17	84.89	84.96	243800.0
2011-07-26	BJK	ETF	36.45	36.62	36.44	36.53	24800.0
2011-07-26	BKF	ETF	47.51	47.58	47.22	47.32	80947.0
2011-07-26	BKLN	ETF	24.86	24.86	24.8	24.85	46500.0
2011-07-26	BLV	ETF	80.98	81.44	80.98	81.35	23800.0
2011-07-26	BMVP	ETF	15.71	15.71	15.62	15.62	5140.0
2011-07-26	BND	ETF	81.68	81.86	81.63	81.77	605900.0
2011-07-26	BNO	ETF	39.235	39.775	39.105	39.565	36000.0
2011-07-26	BRF	ETF	55.08	55.15	54.3	54.56	125883.0
2011-07-26	BSCE	ETF	21.2	21.22	21.155	21.192	32494.0

> showing 50 of 866 rows — these rows as CSV

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