PREVIEW / etf_daily / 2011-06-08

all etf daily files

  file:    by_date/etf_daily/2011/2011-06-08.parquet
  size:    36 KB
  rows:    853

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-08	SPY	ETF	128.76	129.19	128.18	128.42	198696400.0
2011-06-08	QQQ	ETF	55.67	55.77	55.23	55.39	46426380.0
2011-06-08	IWM	ETF	79.47	79.72	78.71	78.85	67740400.0
2011-06-08	DIA	ETF	120.41	120.83	120.08	120.3	6860100.0
2011-06-08	GLD	ETF	150.02	150.38	149.3	149.81	9612500.0
2011-06-08	TLT	ETF	96.26	96.84	96.17	96.79	7401800.0
2011-06-08	AAXJ	ETF	62.39	62.43	61.82	61.97	211500.0
2011-06-08	ACTV	ETF	19.27	19.49	19.0	19.41	199379.0
2011-06-08	ACWI	ETF	47.93	47.93	47.52	47.61	622200.0
2011-06-08	ACWX	ETF	45.06	45.061	44.65	44.73	34154.0
2011-06-08	ADRE	ETF	45.84	46.05	45.61	45.69	27101.0
2011-06-08	AFK	ETF	33.11	33.23	32.7901	32.7901	19386.0
2011-06-08	AGG	ETF	107.54	107.8	107.54	107.65	1085200.0
2011-06-08	AGQ	ETF	368.1	377.16	365.48	377.08	659350.0
2011-06-08	AGZ	ETF	110.95	110.95	110.87	110.93	7224.0
2011-06-08	AIA	ETF	47.58	47.58	47.21	47.321	14499.0
2011-06-08	AIQ	ETF	19.55	19.8	19.25	19.25	19150.0
2011-06-08	AIS	ETF	1.9	1.97	1.89	1.94	1256893.0
2011-06-08	AIVI	ETF	47.8	47.82	47.39	47.4	14300.0
2011-06-08	AMJ	ETF	35.65	35.894	35.34	35.51	1847152.0
2011-06-08	AMLP	ETF	78.15	78.55	77.75	78.15	127080.0
2011-06-08	AOA	ETF	35.23	35.24	35.03	35.04	11900.0
2011-06-08	AOK	ETF	29.26	29.27	29.2	29.24	14893.0
2011-06-08	AOM	ETF	30.62	30.62	30.55	30.55	1953.0
2011-06-08	AOR	ETF	32.31	32.37	32.21	32.26	14973.0
2011-06-08	ARB	ETF	37.91	39.9	36.96	37.26	132082.0
2011-06-08	ARGT	ETF	28.48	28.48	28.22	28.22	1050.0
2011-06-08	ASEA	ETF	16.21	16.26	16.11	16.13	24100.0
2011-06-08	BAB	ETF	26.64	26.75	26.6	26.75	142377.0
2011-06-08	BAL	ETF	81.82	82.17	79.81	81.66	72381.0
2011-06-08	BALT	ETF	6.13	6.56	6.05	6.26	350448.0
2011-06-08	BBH	ETF	34.4667	34.5333	34.3633	34.51	30600.0
2011-06-08	BCM	ETF	48.06	48.22	48.06	48.12	900.0
2011-06-08	BIB	ETF	9.4825	9.5674	9.3764	9.4625	42152.0
2011-06-08	BICK	ETF	31.94	31.98	31.7179	31.74	22693.0
2011-06-08	BIL	ETF	91.7	91.72	91.7	91.72	64950.0
2011-06-08	BIS	ETF	6097.6	6177.6	6040.0	6108.8	17.5
2011-06-08	BITS	ETF	22.52	22.52	20.8	21.28	10866.0
2011-06-08	BIV	ETF	84.91	85.08	84.79	84.93	1265000.0
2011-06-08	BJK	ETF	33.17	33.23	32.89	32.89	14900.0
2011-06-08	BKF	ETF	47.74	48.0015	47.5301	47.65	98084.0
2011-06-08	BKLN	ETF	25.01	25.01	24.96	24.98	51100.0
2011-06-08	BLV	ETF	81.74	81.98	81.57	81.95	67000.0
2011-06-08	BMVP	ETF	15.16	15.187	15.04	15.084	11856.0
2011-06-08	BND	ETF	81.77	81.97	81.75	81.88	825100.0
2011-06-08	BNO	ETF	39.165	39.43	39.125	39.23	51400.0
2011-06-08	BOSS	ETF	55.26	55.39	54.99	55.22	700.0
2011-06-08	BRF	ETF	57.7	57.84	57.24	57.44	161750.0
2011-06-08	BSCE	ETF	21.2	21.269	21.18	21.21	27037.0
2011-06-08	BSV	ETF	81.25	81.27	81.18	81.27	473200.0

> showing 50 of 853 rows — these rows as CSV

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