PREVIEW / etf_daily / 2010-02-23

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-23.parquet
  size:    32 KB
  rows:    729

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-02-23	SPY	ETF	110.86	111.2	109.52	109.81	207497000.0
2010-02-23	QQQ	ETF	44.69	44.74	43.95	44.16	95814331.0
2010-02-23	IWM	ETF	63.16	63.25	62.33	62.51	58965400.0
2010-02-23	DIA	ETF	103.61	104.14	102.69	102.87	10810200.0
2010-02-23	GLD	ETF	108.84	108.91	107.65	107.89	13629600.0
2010-02-23	TLT	ETF	89.34	90.54	89.3	90.47	5474500.0
2010-02-23	AAXJ	ETF	53.26	53.26	52.18	52.57	184300.0
2010-02-23	ACWI	ETF	41.25	41.25	40.54	40.78	90300.0
2010-02-23	ACWX	ETF	39.27	39.27	38.62	38.79	154229.0
2010-02-23	ADRE	ETF	41.19	41.23	40.426	40.58	78159.0
2010-02-23	AFK	ETF	28.77	28.83	28.4058	28.46	9213.0
2010-02-23	AGG	ETF	103.92	104.25	103.92	104.19	539400.0
2010-02-23	AGQ	ETF	98.44	98.76	95.76	96.38	215950.0
2010-02-23	AGZ	ETF	108.44	108.6	108.3685	108.59	28340.0
2010-02-23	AIA	ETF	38.37	38.37	37.63	37.84	34853.0
2010-02-23	AIQ	ETF	25.6	25.85	24.8	25.6	13225.0
2010-02-23	AIS	ETF	1.28	1.34	1.23	1.34	410826.0
2010-02-23	AIVI	ETF	40.47	40.49	39.95	40.0	7200.0
2010-02-23	AMJ	ETF	29.6	29.7	29.4	29.51	583580.0
2010-02-23	AOA	ETF	29.76	29.76	29.39	29.44	18300.0
2010-02-23	AOK	ETF	27.3348	27.4	27.2501	27.31	35841.0
2010-02-23	AOM	ETF	27.93	28.0299	27.87	27.88	18608.0
2010-02-23	AOR	ETF	28.58	28.58	28.4932	28.54	6502.0
2010-02-23	ARB	ETF	22.31	22.48	21.95	22.04	285421.0
2010-02-23	BAB	ETF	24.58	24.775	24.55	24.765	246808.0
2010-02-23	BAL	ETF	38.3	38.52	38.28	38.4	5271.0
2010-02-23	BBH	ETF	34.23	34.3	33.8167	33.8433	262200.0
2010-02-23	BIL	ETF	91.72	91.72	91.68	91.68	86850.0
2010-02-23	BITS	ETF	31.9996	31.9996	31.7696	31.96	242.0
2010-02-23	BIV	ETF	79.92	80.38	79.89	80.33	98200.0
2010-02-23	BJK	ETF	23.53	23.53	23.11	23.23	11100.0
2010-02-23	BKF	ETF	42.95	42.98	41.91	42.17	170093.0
2010-02-23	BLV	ETF	76.16	76.76	76.16	76.66	23900.0
2010-02-23	BMVP	ETF	12.63	12.63	12.48	12.492	16369.0
2010-02-23	BND	ETF	79.13	79.32	79.1	79.31	516000.0
2010-02-23	BNE	ETF	6.95	7.03	6.85	6.97	250965.0
2010-02-23	BRF	ETF	45.42	45.66	44.46	44.86	745964.0
2010-02-23	BSV	ETF	80.16	80.24	80.09	80.24	363700.0
2010-02-23	BTF	ETF	67.351	67.5	66.55	66.9	4250.0
2010-02-23	BWX	ETF	27.955	28.015	27.885	27.94	444688.0
2010-02-23	BWZ	ETF	35.08	35.49	35.08	35.42	57019.0
2010-02-23	BZQ	ETF	4190.4	4400.0	4160.0	4326.4	1311.0
2010-02-23	CEF	ETF	13.3	13.31	13.08	13.21	1170300.0
2010-02-23	CEW	ETF	21.7201	21.76	21.59	21.67	110612.0
2010-02-23	CGO	ETF	14.23	14.34	14.18	14.22	19877.0
2010-02-23	CGW	ETF	17.8	17.82	17.52	17.56	56749.0
2010-02-23	CHI	ETF	12.19	12.31	12.1	12.3	197787.0
2010-02-23	CHIE	ETF	13.75	13.75	13.4501	13.4501	1400.0
2010-02-23	CHII	ETF	14.4	14.42	14.2	14.2225	8410.0
2010-02-23	CHIM	ETF	25.22	25.22	24.9998	24.9998	946.0

> showing 50 of 729 rows — these rows as CSV

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