PREVIEW / etf_daily / 2010-09-28

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-28.parquet
  size:    34 KB
  rows:    785

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-09-28	SPY	ETF	114.42	115.04	113.18	114.67	209207500.0
2010-09-28	QQQ	ETF	49.51	49.54	48.59	49.37	104922874.0
2010-09-28	IWM	ETF	66.97	67.63	65.75	67.48	66176700.0
2010-09-28	DIA	ETF	108.36	108.87	107.3	108.56	7872700.0
2010-09-28	GLD	ETF	126.42	128.03	126.11	127.85	19857200.0
2010-09-28	TLT	ETF	105.38	106.32	105.34	106.02	8262900.0
2010-09-28	AADR	ETF	28.08	28.26	28.08	28.22	7200.0
2010-09-28	AAXJ	ETF	59.78	60.0	59.31	59.9	321600.0
2010-09-28	ACWI	ETF	43.08	43.35	42.77	43.26	446900.0
2010-09-28	ACWX	ETF	41.33	41.535	41.02	41.52	74323.0
2010-09-28	ADRE	ETF	44.16	44.57	43.8	44.5	145334.0
2010-09-28	AFK	ETF	31.745	32.2	31.7	32.2	8244.0
2010-09-28	AGG	ETF	108.49	108.87	108.49	108.77	980300.0
2010-09-28	AGQ	ETF	159.46	166.48	157.96	166.42	231850.0
2010-09-28	AGZ	ETF	111.54	111.56	111.37	111.4	22262.0
2010-09-28	AIA	ETF	41.75	42.08	41.53	42.08	183551.0
2010-09-28	AIQ	ETF	22.65	23.6	22.25	23.5	16549.0
2010-09-28	AIS	ETF	1.45	1.45	1.33	1.42	302498.0
2010-09-28	AIVI	ETF	43.25	43.4	42.77	43.23	8200.0
2010-09-28	AMJ	ETF	33.39	33.44	33.1601	33.42	640038.0
2010-09-28	AMLP	ETF	76.7	76.9	76.35	76.75	84780.0
2010-09-28	AOA	ETF	31.44	31.57	31.36	31.44	4500.0
2010-09-28	AOK	ETF	28.38	28.46	28.38	28.4401	14839.0
2010-09-28	AOM	ETF	29.1	29.1799	29.07	29.1799	4640.0
2010-09-28	AOR	ETF	29.97	30.04	29.83	29.9444	6686.0
2010-09-28	ARB	ETF	27.12	27.17	26.52	27.04	134606.0
2010-09-28	BAB	ETF	26.81	26.92	26.78	26.88	189968.0
2010-09-28	BAL	ETF	51.9	52.05	51.13	51.77	47051.0
2010-09-28	BALT	ETF	11.18	11.18	11.02	11.08	155672.0
2010-09-28	BBH	ETF	32.16	32.43	31.8733	32.2667	41700.0
2010-09-28	BIB	ETF	6.3438	6.4713	6.3438	6.4713	8456.0
2010-09-28	BICK	ETF	31.2	31.33	30.878	31.33	15267.0
2010-09-28	BIL	ETF	91.7	91.72	91.7	91.7	113200.0
2010-09-28	BIS	ETF	9878.4	9878.4	9785.6	9785.6	3.125
2010-09-28	BITS	ETF	27.0	27.0	25.536	26.88	2100.0
2010-09-28	BIV	ETF	86.51	86.9	86.51	86.87	97700.0
2010-09-28	BJK	ETF	28.04	28.11	27.62	28.08	20800.0
2010-09-28	BKF	ETF	47.01	47.35	46.653	47.28	134382.0
2010-09-28	BLV	ETF	85.87	86.51	85.83	86.13	31100.0
2010-09-28	BMVP	ETF	13.017	13.12	12.889	13.12	16183.0
2010-09-28	BND	ETF	82.61	82.83	82.61	82.79	818200.0
2010-09-28	BNE	ETF	11.03	11.03	10.99	11.02	572767.0
2010-09-28	BRF	ETF	56.03	56.03	55.44	55.87	508536.0
2010-09-28	BSCE	ETF	20.93	20.96	20.93	20.96	8013.0
2010-09-28	BSV	ETF	81.73	81.8	81.69	81.79	351100.0
2010-09-28	BTF	ETF	75.55	75.99999999999999	74.89999999999999	75.8	5354.400000000001
2010-09-28	BWX	ETF	29.96	30.0745	29.8175	29.995	141682.0
2010-09-28	BWZ	ETF	36.69	37.022	36.69	36.8901	17014.0
2010-09-28	BZQ	ETF	2892.8	2964.8	2836.8	2848.0	995.0
2010-09-28	CEF	ETF	16.36	16.73	16.26	16.62	1583400.0

> showing 50 of 785 rows — these rows as CSV

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