PREVIEW / etf_daily / 2010-03-05

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-05.parquet
  size:    32 KB
  rows:    725

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-03-05	SPY	ETF	113.37	114.34	113.1	114.25	176118800.0
2010-03-05	QQQ	ETF	46.1	46.54	45.99	46.44	68136255.0
2010-03-05	IWM	ETF	65.71	66.72	65.5	66.62	52293900.0
2010-03-05	DIA	ETF	104.99	105.77	104.87	105.76	6753500.0
2010-03-05	GLD	ETF	111.13	111.75	110.8	110.81	11091400.0
2010-03-05	TLT	ETF	90.83	90.87	90.12	90.27	3823200.0
2010-03-05	AAXJ	ETF	54.64	54.94	54.2	54.94	149700.0
2010-03-05	ACWI	ETF	42.27	42.65	42.07	42.61	70400.0
2010-03-05	ACWX	ETF	40.39	40.84	40.3181	40.84	55741.0
2010-03-05	ADRE	ETF	42.69	43.1	42.47	43.1	85127.0
2010-03-05	AFK	ETF	29.9	30.19	29.77	30.19	9935.0
2010-03-05	AGG	ETF	104.5	104.5	104.25	104.39	1057500.0
2010-03-05	AGQ	ETF	114.16	117.1	113.72	114.88	241950.0
2010-03-05	AGZ	ETF	108.3984	108.496	108.3401	108.45	9406.0
2010-03-05	AIA	ETF	39.08	39.32	38.93	39.298	26295.0
2010-03-05	AIQ	ETF	24.55	24.7	24.0505	24.6	45701.0
2010-03-05	AIS	ETF	1.33	1.35	1.24	1.33	278974.0
2010-03-05	AIVI	ETF	41.31	41.98	41.31	41.9	12700.0
2010-03-05	AMJ	ETF	29.69	30.09	29.68	29.88	510260.0
2010-03-05	AOA	ETF	30.56	30.82	30.25	30.77	38300.0
2010-03-05	AOK	ETF	27.61	27.64	27.5405	27.58	17355.0
2010-03-05	AOM	ETF	28.37	28.47	28.3	28.46	9241.0
2010-03-05	AOR	ETF	29.23	29.38	29.19	29.37	29024.0
2010-03-05	ARB	ETF	22.32	22.96	22.29	22.87	208001.0
2010-03-05	BAB	ETF	24.94	24.99	24.84	24.89	159265.0
2010-03-05	BAL	ETF	39.85	39.9215	39.655	39.725	2910.0
2010-03-05	BBH	ETF	34.2133	34.6	34.2133	34.5767	143100.0
2010-03-05	BIL	ETF	91.68	91.7	91.68	91.68	285700.0
2010-03-05	BITS	ETF	33.96	33.96	32.6	33.04	446.0
2010-03-05	BIV	ETF	80.56	80.56	80.31	80.34	102900.0
2010-03-05	BJK	ETF	24.02	24.43	24.02	24.42	7300.0
2010-03-05	BKF	ETF	45.0	45.25	44.64	45.25	220143.0
2010-03-05	BLV	ETF	77.2	77.41	76.45	76.62	70400.0
2010-03-05	BMVP	ETF	12.8733	12.9892	12.8467	12.9733	15787.0
2010-03-05	BND	ETF	79.47	79.49	79.32	79.47	900200.0
2010-03-05	BNE	ETF	11.22	11.24	11.18	11.19	3415896.0
2010-03-05	BRF	ETF	47.16	47.18	46.79	46.96	496720.0
2010-03-05	BSV	ETF	80.2	80.2	80.11	80.19	554100.0
2010-03-05	BTF	ETF	70.1	72.14999999999999	70.05	72.14999999999999	12183.2
2010-03-05	BWX	ETF	28.01	28.025	27.862	27.93	276132.0
2010-03-05	BWZ	ETF	36.06	36.06	35.58	35.61	19536.0
2010-03-05	BZQ	ETF	3816.0	3857.6	3747.2	3756.8	554.5
2010-03-05	CEF	ETF	13.96	14.11	13.96	14.07	731300.0
2010-03-05	CEW	ETF	22.05	22.1	21.98	22.1	272074.0
2010-03-05	CGO	ETF	14.35	14.75	14.24	14.47	41889.0
2010-03-05	CGW	ETF	17.9	18.076	17.9	18.05	61315.0
2010-03-05	CHI	ETF	12.75	12.91	12.7	12.91	193872.0
2010-03-05	CHIE	ETF	14.28	14.44	14.28	14.44	2713.0
2010-03-05	CHII	ETF	15.23	15.37	15.2	15.33	31612.0
2010-03-05	CHIM	ETF	26.42	26.7	26.42	26.7	4221.0

> showing 50 of 725 rows — these rows as CSV

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