PREVIEW / etf_daily / 2010-11-09

all etf daily files

  file:    by_date/etf_daily/2010/2010-11-09.parquet
  size:    34 KB
  rows:    804

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
2010-11-09	SPY	ETF	122.82	122.95	121.12	121.61	186621600.0
2010-11-09	QQQ	ETF	53.97	54.0401	53.21	53.45	66969722.0
2010-11-09	IWM	ETF	73.91	74.05	72.33	72.73	48438600.0
2010-11-09	DIA	ETF	114.38	114.41	113.23	113.69	5838500.0
2010-11-09	GLD	ETF	138.7	139.15	135.05	135.59	39445200.0
2010-11-09	TLT	ETF	98.49	98.52	96.19	96.25	15061700.0
2010-11-09	AADR	ETF	29.14	29.3	29.06	29.06	1200.0
2010-11-09	AAXJ	ETF	65.61	65.8	64.7	64.91	397300.0
2010-11-09	ACWI	ETF	46.74	46.74	45.72	45.95	307700.0
2010-11-09	ACWX	ETF	44.69	44.75	43.73	43.96	57316.0
2010-11-09	ADRE	ETF	48.54	48.66	47.38	47.551	73330.0
2010-11-09	AFK	ETF	34.82	34.88	34.04	34.116	36158.0
2010-11-09	AGG	ETF	108.55	108.6	108.0	108.04	686800.0
2010-11-09	AGQ	ETF	276.9	295.1	238.0	245.22	2390150.0
2010-11-09	AGZ	ETF	111.645	111.645	111.25	111.3	14144.0
2010-11-09	AIA	ETF	46.51	46.65	45.92	46.01	63033.0
2010-11-09	AIQ	ETF	21.35	21.55	21.15	21.25	14473.0
2010-11-09	AIS	ETF	1.56	1.58	1.5	1.51	358207.0
2010-11-09	AIVI	ETF	46.4	46.4	45.33	45.48	169700.0
2010-11-09	AMJ	ETF	36.74	36.98	36.63	36.95	2378153.0
2010-11-09	AMLP	ETF	80.35	80.4	79.8	80.35	232800.0
2010-11-09	AOA	ETF	33.86	33.87	33.3	33.41	12300.0
2010-11-09	AOK	ETF	29.04	29.07	28.57	28.85	18844.0
2010-11-09	AOM	ETF	30.11	30.15	29.8255	29.83	15326.0
2010-11-09	AOR	ETF	31.4184	31.47	31.07	31.14	18440.0
2010-11-09	ARB	ETF	26.95	26.95	25.98	26.14	226895.0
2010-11-09	BAB	ETF	25.98	26.02	25.65	25.73	712321.0
2010-11-09	BAL	ETF	74.56	77.0	73.4	74.0	202319.0
2010-11-09	BALT	ETF	12.43	12.47	12.01	12.1	146609.0
2010-11-09	BBH	ETF	33.2967	33.34	33.0667	33.1133	41400.0
2010-11-09	BIB	ETF	6.6125	6.6162	6.5655	6.5887	31944.0
2010-11-09	BICK	ETF	34.3	34.3	33.57	33.57	43553.0
2010-11-09	BIL	ETF	91.7	91.72	91.7	91.7	223200.0
2010-11-09	BITS	ETF	28.88	28.88	28.2	28.72	2087.0
2010-11-09	BIV	ETF	87.37	87.47	86.58	86.68	458900.0
2010-11-09	BJK	ETF	33.06	33.06	32.23	32.33	14800.0
2010-11-09	BKF	ETF	51.89	51.964	50.71	50.84	173298.0
2010-11-09	BLV	ETF	82.91	82.91	81.4	81.48	164500.0
2010-11-09	BMVP	ETF	14.36	14.36	14.17	14.21	7708.0
2010-11-09	BND	ETF	82.63	82.65	82.19	82.21	502300.0
2010-11-09	BNE	ETF	11.35	11.38	11.34	11.34	272977.0
2010-11-09	BNO	ETF	29.625	29.665	29.345	29.345	9000.0
2010-11-09	BRF	ETF	62.7	62.83	60.58	60.84	510299.0
2010-11-09	BSCE	ETF	21.06	21.06	21.0	21.004	2818.0
2010-11-09	BSV	ETF	81.9	81.9	81.7	81.71	822400.0
2010-11-09	BTF	ETF	80.95	81.1495	79.45	79.45	3813.0
2010-11-09	BWX	ETF	30.8	30.824	30.2909	30.36	181104.0
2010-11-09	BWZ	ETF	38.13	38.13	37.515	37.63	19992.0
2010-11-09	BZQ	ETF	2412.8	2568.0	2403.2	2526.4	731.0
2010-11-09	CEF	ETF	19.36	19.67	18.24	18.42	3794300.0

> showing 50 of 804 rows — these rows as CSV

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