PREVIEW / etf_daily / 2011-06-28

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-28.parquet
  size:    36 KB
  rows:    859

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-28	SPY	ETF	128.45	129.63	128.27	129.61	165556300.0
2011-06-28	QQQ	ETF	55.38	56.08	55.29	56.07	47028637.0
2011-06-28	IWM	ETF	80.83	81.85	80.67	81.81	54021800.0
2011-06-28	DIA	ETF	120.63	121.65	120.49	121.61	4085500.0
2011-06-28	GLD	ETF	146.16	146.77	145.67	146.24	8813800.0
2011-06-28	TLT	ETF	95.48	95.68	94.72	94.88	12634300.0
2011-06-28	AAXJ	ETF	60.21	60.67	59.99	60.64	135800.0
2011-06-28	ACTV	ETF	17.17	17.35	16.65	17.05	126466.0
2011-06-28	ACWI	ETF	46.57	47.07	46.53	47.07	360200.0
2011-06-28	ACWX	ETF	43.3	43.72	43.27	43.72	86292.0
2011-06-28	ADRE	ETF	44.92	45.6696	44.92	45.65	38449.0
2011-06-28	AFK	ETF	31.69	31.7905	31.59	31.6	32610.0
2011-06-28	AGEM	ETF	25.73	25.8313	25.73	25.8313	815.0
2011-06-28	AGG	ETF	107.34	107.38	106.95	107.01	1038500.0
2011-06-28	AGQ	ETF	312.0	317.32	307.78	313.98	662500.0
2011-06-28	AGZ	ETF	110.97	110.97	110.6	110.6904	3608.0
2011-06-28	AIA	ETF	45.57	45.945	45.4552	45.93	11998.0
2011-06-28	AIQ	ETF	19.25	19.25	19.0	19.15	15865.0
2011-06-28	AIS	ETF	2.14	2.14	2.08	2.14	514927.0
2011-06-28	AIVI	ETF	45.27	45.62	45.23	45.55	13100.0
2011-06-28	AMJ	ETF	36.57	36.66	36.42	36.63	1293245.0
2011-06-28	AMLP	ETF	79.55	79.65	79.25	79.5	112440.0
2011-06-28	AOA	ETF	35.07	35.24	35.07	35.24	5800.0
2011-06-28	AOK	ETF	29.25	29.28	29.24	29.2599	6636.0
2011-06-28	AOM	ETF	30.31	30.3652	30.31	30.343	21785.0
2011-06-28	AOR	ETF	32.05	32.18	32.05	32.1303	16870.0
2011-06-28	ARB	ETF	39.12	40.36	39.0	40.34	108626.0
2011-06-28	ARGT	ETF	28.96	29.26	28.96	29.26	2700.0
2011-06-28	ASEA	ETF	16.17	16.29	16.14	16.14	2000.0
2011-06-28	BAB	ETF	26.39	26.426	26.22	26.23	182355.0
2011-06-28	BAL	ETF	75.68	76.1	74.9	75.78	22884.0
2011-06-28	BALT	ETF	6.05	6.05	5.91	6.0	72122.0
2011-06-28	BBH	ETF	35.11	35.8933	35.0733	35.8633	119400.0
2011-06-28	BIB	ETF	9.1263	9.5198	9.0162	9.4925	46512.0
2011-06-28	BICK	ETF	31.27	31.4	31.0365	31.3899	10152.0
2011-06-28	BIL	ETF	91.72	91.72	91.7	91.7	289650.0
2011-06-28	BIS	ETF	6244.8	6244.8	6033.6	6054.384	6.9
2011-06-28	BITS	ETF	21.0	21.44	20.94	21.2	2588.0
2011-06-28	BIV	ETF	85.04	85.04	84.4	84.52	203000.0
2011-06-28	BJK	ETF	32.85	33.49	32.85	33.4	7500.0
2011-06-28	BKF	ETF	46.41	47.13	46.37	47.08	63850.0
2011-06-28	BKLN	ETF	24.73	24.73	24.69	24.72	34700.0
2011-06-28	BLNG	ETF	47.26	47.26	47.26	47.26	267.0
2011-06-28	BLV	ETF	80.88	80.92	80.17	80.3	36000.0
2011-06-28	BMVP	ETF	15.32	15.43	15.31	15.43	9473.0
2011-06-28	BND	ETF	81.71	81.72	81.39	81.51	2249600.0
2011-06-28	BNO	ETF	36.07	36.36	36.01	36.26	66000.0
2011-06-28	BRF	ETF	55.5	56.47	55.36	56.33	219495.0
2011-06-28	BSCE	ETF	21.16	21.21	21.1401	21.16	33601.0
2011-06-28	BSV	ETF	81.25	81.27	81.08	81.13	301100.0

> showing 50 of 859 rows — these rows as CSV

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