PREVIEW / etf_daily / 2011-06-10

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-10.parquet
  size:    36 KB
  rows:    844

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-10	SPY	ETF	128.85	128.93	127.26	127.6	238629400.0
2011-06-10	QQQ	ETF	55.23	55.34	54.59	54.64	53740540.0
2011-06-10	IWM	ETF	78.78	78.91	77.65	78.0	71823100.0
2011-06-10	DIA	ETF	120.65	120.74	119.21	119.37	7384800.0
2011-06-10	GLD	ETF	149.04	149.78	148.69	149.24	12344900.0
2011-06-10	TLT	ETF	96.91	97.39	96.8	97.14	7710800.0
2011-06-10	AADR	ETF	30.89	30.89	30.82	30.82	3300.0
2011-06-10	AAXJ	ETF	61.45	61.48	60.68	60.88	350200.0
2011-06-10	ACTV	ETF	19.08	19.7	17.82	18.64	266813.0
2011-06-10	ACWI	ETF	47.73	47.79	47.05	47.21	568800.0
2011-06-10	ACWX	ETF	44.65	44.725	44.04	44.2	58044.0
2011-06-10	ADRE	ETF	45.61	45.68	45.02	45.15	57789.0
2011-06-10	AFK	ETF	32.99	32.99	32.38	32.63	12435.0
2011-06-10	AGG	ETF	107.53	107.65	107.39	107.48	1160500.0
2011-06-10	AGQ	ETF	371.68	375.74	359.38	360.58	1090850.0
2011-06-10	AGZ	ETF	110.86	110.98	110.86	110.86	8371.0
2011-06-10	AIA	ETF	46.75	46.75	46.2	46.3301	31343.0
2011-06-10	AIQ	ETF	19.0	19.25	18.75	18.9	15818.0
2011-06-10	AIS	ETF	2.115	2.17	2.05	2.07	2151981.0
2011-06-10	AIVI	ETF	47.51	47.51	46.57	46.7	55600.0
2011-06-10	AMJ	ETF	36.02	36.36	35.95	36.35	1174680.0
2011-06-10	AMLP	ETF	78.9	79.4	78.8	79.4	153400.0
2011-06-10	AOA	ETF	35.08	35.08	34.71	34.77	16300.0
2011-06-10	AOK	ETF	29.3	29.3	29.1334	29.14	8782.0
2011-06-10	AOM	ETF	30.63	30.63	30.43	30.43	7731.0
2011-06-10	AOR	ETF	32.1499	32.16	32.01	32.02	8559.0
2011-06-10	ARB	ETF	39.33	39.33	37.88	38.85	203263.0
2011-06-10	ARGT	ETF	28.3	28.44	28.28	28.44	2950.0
2011-06-10	ASEA	ETF	16.0	16.03	15.91	16.0	6000.0
2011-06-10	BAB	ETF	26.74	26.819	26.69	26.7	187189.0
2011-06-10	BAL	ETF	82.35	82.99	81.77	82.85	14912.0
2011-06-10	BALT	ETF	6.26	6.26	5.9	6.04	188567.0
2011-06-10	BBH	ETF	34.3967	34.4033	33.8333	33.8333	85500.0
2011-06-10	BIB	ETF	9.2825	9.3	9.0225	9.05	103960.0
2011-06-10	BICK	ETF	31.52	31.5351	31.1063	31.12	46160.0
2011-06-10	BIL	ETF	91.7	91.72	91.7	91.72	79400.0
2011-06-10	BIS	ETF	6184.0	6411.2	6184.0	6411.2	10.7
2011-06-10	BITS	ETF	21.28	21.72	21.04	21.28	580.0
2011-06-10	BIV	ETF	84.87	84.95	84.69	84.8	147200.0
2011-06-10	BJK	ETF	32.8	32.8	32.14	32.39	5900.0
2011-06-10	BKF	ETF	47.54	47.54	46.81	47.01	115716.0
2011-06-10	BKLN	ETF	24.94	24.95	24.87	24.92	192700.0
2011-06-10	BLNG	ETF	48.6232	48.6232	48.6232	48.6232	100.0
2011-06-10	BLV	ETF	82.01	82.65	81.83	82.05	158400.0
2011-06-10	BMVP	ETF	15.0633	15.0633	14.8962	14.9267	5295.0
2011-06-10	BND	ETF	81.78	81.87	81.69	81.79	975900.0
2011-06-10	BNO	ETF	39.645	39.645	39.15	39.405	215800.0
2011-06-10	BRF	ETF	57.41	57.86	56.17	56.87	116658.0
2011-06-10	BSCE	ETF	21.16	21.24	21.16	21.23	13649.0
2011-06-10	BSV	ETF	81.15	81.25	81.15	81.21	439300.0

> showing 50 of 844 rows — these rows as CSV

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