PREVIEW / etf_daily / 2010-03-09

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-09.parquet
  size:    31 KB
  rows:    724

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-09	SPY	ETF	113.93	114.99	113.87	114.46	154556700.0
2010-03-09	QQQ	ETF	46.4	47.05	46.4	46.79	98002744.0
2010-03-09	IWM	ETF	66.55	67.49	66.53	66.98	70685800.0
2010-03-09	DIA	ETF	105.44	106.23	105.41	105.71	8672300.0
2010-03-09	GLD	ETF	109.16	110.16	109.04	109.72	12650800.0
2010-03-09	TLT	ETF	89.98	90.0	89.4	89.82	2573700.0
2010-03-09	AAXJ	ETF	55.27	55.9	55.22	55.64	338000.0
2010-03-09	ACWI	ETF	42.4	42.76	42.3	42.51	243900.0
2010-03-09	ACWX	ETF	40.6	40.9	40.55	40.75	552821.0
2010-03-09	ADRE	ETF	43.09	43.74	42.99	43.57	94728.0
2010-03-09	AFK	ETF	29.71	30.19	29.71	30.19	4694.0
2010-03-09	AGG	ETF	104.62	104.64	104.48	104.58	1140200.0
2010-03-09	AGQ	ETF	110.76	115.72	110.52	114.06	182700.0
2010-03-09	AGZ	ETF	108.46	108.46	108.33	108.46	11410.0
2010-03-09	AIA	ETF	39.51	40.0	39.51	39.7834	15843.0
2010-03-09	AIQ	ETF	24.55	25.05	24.4	25.05	59300.0
2010-03-09	AIS	ETF	1.37	1.4	1.35	1.4	274134.0
2010-03-09	AIVI	ETF	41.54	41.98	41.5	41.7	24900.0
2010-03-09	AMJ	ETF	30.0	30.2	29.8901	30.14	533042.0
2010-03-09	AOA	ETF	30.65	31.0	30.65	30.95	11300.0
2010-03-09	AOK	ETF	27.68	27.73	27.65	27.7	5325.0
2010-03-09	AOM	ETF	28.46	28.544	28.46	28.488	15904.0
2010-03-09	AOR	ETF	29.24	29.49	29.24	29.41	17796.0
2010-03-09	ARB	ETF	23.0	23.33	22.88	23.17	174136.0
2010-03-09	BAB	ETF	24.87	24.87	24.82	24.86	742102.0
2010-03-09	BAL	ETF	39.3	39.3358	38.6501	38.75	7400.0
2010-03-09	BBH	ETF	34.6	34.86	34.53	34.7067	178200.0
2010-03-09	BIL	ETF	91.68	91.7	91.66	91.68	824200.0
2010-03-09	BITS	ETF	32.84	33.68	32.4	32.64	441.0
2010-03-09	BIV	ETF	80.45	80.66	80.45	80.64	78700.0
2010-03-09	BJK	ETF	24.49	24.62	24.38	24.43	14400.0
2010-03-09	BKF	ETF	45.1	45.86	44.85	45.65	166256.0
2010-03-09	BLV	ETF	76.85	76.85	76.47	76.65	12900.0
2010-03-09	BMVP	ETF	12.89	13.02	12.89	12.96	20527.0
2010-03-09	BND	ETF	79.39	79.42	79.3	79.39	577300.0
2010-03-09	BNE	ETF	11.21	11.26	11.21	11.26	950133.0
2010-03-09	BRF	ETF	46.3	47.33	46.28	47.09	654466.0
2010-03-09	BSV	ETF	80.2	80.24	80.15	80.2	429900.0
2010-03-09	BTF	ETF	72.14999999999999	73.1	71.64999999999999	72.8	5201.400000000001
2010-03-09	BWX	ETF	27.995	28.035	27.905	27.91	483770.0
2010-03-09	BWZ	ETF	35.66	35.87	35.66	35.78	36990.0
2010-03-09	BZQ	ETF	3881.6	3881.6	3604.8	3670.4	466.0
2010-03-09	CEF	ETF	13.9	14.08	13.83	13.99	721100.0
2010-03-09	CEW	ETF	22.05	22.09	22.01	22.08	106292.0
2010-03-09	CGO	ETF	14.64	14.64	14.46	14.6	34696.0
2010-03-09	CGW	ETF	18.02	18.1148	17.94	18.04	33259.0
2010-03-09	CHI	ETF	12.92	12.97	12.81	12.94	202240.0
2010-03-09	CHIE	ETF	14.41	14.41	14.41	14.41	1500.0
2010-03-09	CHII	ETF	15.33	15.56	15.33	15.44	15146.0
2010-03-09	CHIM	ETF	26.82	27.08	26.82	27.08	583.0

> showing 50 of 724 rows — these rows as CSV

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