PREVIEW / etf_daily / 2011-04-06

all etf daily files

  file:    by_date/etf_daily/2011/2011-04-06.parquet
  size:    36 KB
  rows:    834

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-04-06	SPY	ETF	133.88	134.0	133.12	133.66	120411600.0
2011-04-06	QQQ	ETF	57.54	57.73	56.93	57.26	49532055.0
2011-04-06	IWM	ETF	85.63	85.88	84.91	85.38	59035700.0
2011-04-06	DIA	ETF	124.21	124.36	123.8	124.17	4246000.0
2011-04-06	GLD	ETF	142.4	142.62	141.77	142.38	10710300.0
2011-04-06	TLT	ETF	91.77	91.79	90.54	90.54	9090900.0
2011-04-06	AADR	ETF	31.45	31.45	31.15	31.18	1300.0
2011-04-06	AAXJ	ETF	64.95	65.21	64.63	64.86	2819800.0
2011-04-06	ACWI	ETF	49.23	49.39	49.01	49.16	77300.0
2011-04-06	ACWX	ETF	46.34	46.38	46.1448	46.24	98719.0
2011-04-06	ADRE	ETF	49.76	49.89	49.43	49.45	46353.0
2011-04-06	AFK	ETF	34.15	34.449	34.15	34.301	5595.0
2011-04-06	AGG	ETF	104.9	104.91	104.6	104.6	980400.0
2011-04-06	AGQ	ETF	496.14	499.94	485.82	494.64	801200.0
2011-04-06	AGZ	ETF	109.29	109.29	109.05	109.061	59189.0
2011-04-06	AIA	ETF	49.15	49.31	49.0812	49.16	13835.0
2011-04-06	AIQ	ETF	22.5	22.6	22.1	22.45	11754.0
2011-04-06	AIS	ETF	1.7	1.73	1.65	1.65	257086.0
2011-04-06	AIVI	ETF	47.99	48.23	47.91	48.17	18000.0
2011-04-06	AMJ	ETF	38.35	38.39	38.1219	38.2	608775.0
2011-04-06	AMLP	ETF	82.35	82.5	82.05	82.2	61920.0
2011-04-06	AOA	ETF	36.46	36.48	36.25	36.38	13300.0
2011-04-06	AOK	ETF	29.22	29.27	29.216	29.216	6584.0
2011-04-06	AOM	ETF	30.71	30.71	30.6101	30.66	15507.0
2011-04-06	AOR	ETF	32.84	32.84	32.716	32.79	8032.0
2011-04-06	ARB	ETF	39.44	39.56	38.8	39.44	83089.0
2011-04-06	ARGT	ETF	31.74	31.74	31.18	31.38	5200.0
2011-04-06	ASEA	ETF	16.3	16.3	16.22	16.25	9100.0
2011-04-06	BAB	ETF	25.38	25.38	25.16	25.17	135709.0
2011-04-06	BAL	ETF	110.61	110.89	107.91	109.16	202756.0
2011-04-06	BALT	ETF	9.1	9.329	9.02	9.21	228657.0
2011-04-06	BBH	ETF	35.61	35.67	35.48	35.48	340200.0
2011-04-06	BIB	ETF	9.1738	9.1738	8.8975	8.9288	14920.0
2011-04-06	BICK	ETF	34.42	34.6	34.21	34.22	10367.0
2011-04-06	BIL	ETF	91.7	91.72	91.7	91.7	116900.0
2011-04-06	BITS	ETF	25.04	25.04	24.404	24.8	600.0
2011-04-06	BIV	ETF	81.68	81.69	81.49	81.54	63000.0
2011-04-06	BJK	ETF	33.54	33.54	33.17	33.35	9000.0
2011-04-06	BKF	ETF	52.06	52.19	51.66	51.72	195786.0
2011-04-06	BKLN	ETF	25.16	25.25	25.16	25.24	91900.0
2011-04-06	BLV	ETF	78.26	78.31	77.62	77.67	24200.0
2011-04-06	BMVP	ETF	15.88	15.91	15.78	15.82	3347.0
2011-04-06	BND	ETF	79.77	79.79	79.69	79.69	476600.0
2011-04-06	BNO	ETF	40.78	40.9	40.3	40.47	83400.0
2011-04-06	BRF	ETF	59.34	59.49	57.88	57.96	437377.0
2011-04-06	BSCE	ETF	20.81	20.86	20.81	20.81	11001.0
2011-04-06	BSV	ETF	80.04	80.04	79.93	79.94	639100.0
2011-04-06	BTF	ETF	83.49999999999999	83.55	83.3	83.39999999999999	1460.0
2011-04-06	BWX	ETF	29.86	30.015	29.86	29.95	217806.0
2011-04-06	BWZ	ETF	38.42	38.5	38.3	38.4004	145522.0

> showing 50 of 834 rows — these rows as CSV

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