PREVIEW / etf_daily / 2010-03-11

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-11.parquet
  size:    31 KB
  rows:    727

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-11	SPY	ETF	114.7	115.48	114.35	115.45	160791100.0
2010-03-11	QQQ	ETF	47.07	47.35	46.98	47.35	67510282.0
2010-03-11	IWM	ETF	67.14	67.86	66.9	67.75	59964100.0
2010-03-11	DIA	ETF	105.64	106.29	105.24	106.28	7739600.0
2010-03-11	GLD	ETF	108.28	108.65	107.86	108.6	9513300.0
2010-03-11	TLT	ETF	89.39	90.14	89.37	89.92	2621000.0
2010-03-11	AAXJ	ETF	55.56	55.95	55.36	55.85	102400.0
2010-03-11	ACWI	ETF	42.51	42.9	42.49	42.9	151900.0
2010-03-11	ACWX	ETF	40.83	41.11	40.66	41.11	42916.0
2010-03-11	ADRE	ETF	43.67	43.826	43.31	43.8	77664.0
2010-03-11	AFK	ETF	29.97	30.43	29.66	30.42	7542.0
2010-03-11	AGG	ETF	104.47	104.6	104.42	104.51	540000.0
2010-03-11	AGQ	ETF	109.88	112.5	108.8	112.04	142700.0
2010-03-11	AGZ	ETF	108.3	108.49	108.155	108.3099	51850.0
2010-03-11	AIA	ETF	39.93	40.08	39.6301	40.08	8003.0
2010-03-11	AIQ	ETF	24.95	26.95	23.95	26.55	115503.0
2010-03-11	AIS	ETF	1.37	1.43	1.36	1.43	246462.0
2010-03-11	AIVI	ETF	42.09	42.41	42.0	42.41	5400.0
2010-03-11	AMJ	ETF	30.35	30.46	30.252	30.46	215760.0
2010-03-11	AOA	ETF	30.98	31.16	30.91	31.16	11800.0
2010-03-11	AOK	ETF	27.7	27.76	27.6201	27.753	7595.0
2010-03-11	AOM	ETF	28.5	28.57	28.5	28.5201	6612.0
2010-03-11	AOR	ETF	29.45	29.576	29.445	29.576	1096.0
2010-03-11	ARB	ETF	23.54	23.77	23.34	23.71	97937.0
2010-03-11	BAB	ETF	24.77	24.87	24.73	24.8	268489.0
2010-03-11	BAL	ETF	38.51	38.51	37.87	37.89	28547.0
2010-03-11	BALT	ETF	14.27	14.27	13.77	13.91	1119986.0
2010-03-11	BBH	ETF	34.6367	34.73	34.45	34.71	84900.0
2010-03-11	BIL	ETF	91.7	91.7	91.68	91.68	151050.0
2010-03-11	BITS	ETF	32.76	32.76	32.11	32.76	338.0
2010-03-11	BIV	ETF	80.42	80.52	80.3	80.42	91900.0
2010-03-11	BJK	ETF	24.45	24.79	24.45	24.6	13100.0
2010-03-11	BKF	ETF	45.39	46.07	45.39	46.07	110985.0
2010-03-11	BLV	ETF	76.46	76.8	76.34	76.53	29500.0
2010-03-11	BMVP	ETF	12.96	13.05	12.95	13.04	13667.0
2010-03-11	BND	ETF	79.29	79.35	79.23	79.32	337600.0
2010-03-11	BNE	ETF	11.28	11.31	11.25	11.29	1035874.0
2010-03-11	BRF	ETF	47.45	47.86	47.23	47.53	400500.0
2010-03-11	BSV	ETF	80.11	80.14	80.03	80.11	417300.0
2010-03-11	BTF	ETF	72.89999999999999	73.1	72.5	73.05	6341.200000000001
2010-03-11	BWX	ETF	28.04	28.125	27.9793	28.08	187354.0
2010-03-11	BWZ	ETF	35.6901	35.9	35.68	35.9	25974.0
2010-03-11	BZQ	ETF	3614.4	3680.0	3587.2	3596.8	305.0
2010-03-11	CEF	ETF	13.8	13.95	13.72	13.93	605900.0
2010-03-11	CEW	ETF	22.09	22.14	22.058	22.13	112754.0
2010-03-11	CGO	ETF	14.15	14.15	13.92	14.14	44530.0
2010-03-11	CGW	ETF	18.04	18.142	17.94	18.11	44375.0
2010-03-11	CHI	ETF	12.78	12.83	12.59	12.59	161286.0
2010-03-11	CHIE	ETF	14.5	14.5	14.4544	14.4544	200.0
2010-03-11	CHII	ETF	15.3	15.45	15.25	15.45	8003.0

> showing 50 of 727 rows — these rows as CSV

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