PREVIEW / etf_daily / 2010-01-06

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-06.parquet
  size:    31 KB
  rows:    714

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-01-06	SPY	ETF	113.52	113.99	113.43	113.71	116074400.0
2010-01-06	QQQ	ETF	46.39	46.55	46.07	46.14	96033002.0
2010-01-06	IWM	ETF	63.76	64.1	63.54	63.7	59708600.0
2010-01-06	DIA	ETF	105.5	105.85	105.36	105.56	6797200.0
2010-01-06	GLD	ETF	110.71	111.77	110.41	111.51	24981900.0
2010-01-06	TLT	ETF	90.17	90.26	89.12	89.18	4099600.0
2010-01-06	AAXJ	ETF	58.16	58.19	57.67	57.76	2536000.0
2010-01-06	ACWI	ETF	43.32	43.56	43.28	43.51	346600.0
2010-01-06	ACWX	ETF	42.2	42.4195	42.14	42.36	59631.0
2010-01-06	ADRE	ETF	45.69	45.96	45.54	45.8	174463.0
2010-01-06	AFK	ETF	29.15	29.6	29.0	29.52	6510.0
2010-01-06	AGG	ETF	103.82	103.82	103.41	103.72	714300.0
2010-01-06	AGQ	ETF	127.78	131.04	127.22	130.48	209700.0
2010-01-06	AGZ	ETF	107.75	107.9381	107.6908	107.73	13372.0
2010-01-06	AIA	ETF	41.53	41.68	41.25	41.29	43996.0
2010-01-06	AIQ	ETF	27.8	28.15	26.5	26.85	83671.0
2010-01-06	AIS	ETF	1.15	1.17	1.15	1.16	421912.0
2010-01-06	AIVI	ETF	44.35	44.71	44.35	44.63	33600.0
2010-01-06	AMJ	ETF	29.6	29.69	29.25	29.62	385348.0
2010-01-06	AOA	ETF	30.56	30.61	30.54	30.6	11100.0
2010-01-06	AOK	ETF	27.5899	27.6099	27.5001	27.56	7582.0
2010-01-06	AOM	ETF	28.52	28.54	28.455	28.52	10846.0
2010-01-06	AOR	ETF	29.42	29.47	29.35	29.43	8556.0
2010-01-06	ARB	ETF	25.98	29.06	25.98	26.32	935276.0
2010-01-06	BAB	ETF	24.3	24.31	24.1499	24.19	259704.0
2010-01-06	BAL	ETF	36.2	36.2	35.85	36.16	27076.0
2010-01-06	BBH	ETF	32.74	33.0467	32.74	32.9667	172200.0
2010-01-06	BIL	ETF	91.68	91.7	91.68	91.68	450300.0
2010-01-06	BITS	ETF	31.76	31.8	31.16	31.44	3042.0
2010-01-06	BIV	ETF	79.77	79.79	79.46	79.6	111000.0
2010-01-06	BJK	ETF	25.18	25.18	24.82	25.07	17800.0
2010-01-06	BKF	ETF	47.64	48.5	47.64	47.87	485458.0
2010-01-06	BLV	ETF	76.72	76.73	75.9	76.01	25000.0
2010-01-06	BMVP	ETF	12.927	12.977	12.91	12.96	16856.0
2010-01-06	BND	ETF	78.97	78.98	78.7	78.88	981300.0
2010-01-06	BNE	ETF	7.18	7.27	7.11	7.2	179162.0
2010-01-06	BOSS	ETF	21.14	21.14	21.14	21.14	100.0
2010-01-06	BRF	ETF	50.08	50.59	49.81	50.39	240845.0
2010-01-06	BSV	ETF	79.88	79.9	79.69	79.75	349600.0
2010-01-06	BTF	ETF	64.14999999999999	64.6975	64.14999999999999	64.5475	2085.0
2010-01-06	BWX	ETF	28.545	28.625	28.45	28.58	357168.0
2010-01-06	BWZ	ETF	36.69	36.78	36.39	36.77	30906.0
2010-01-06	BZQ	ETF	3465.6	3465.6	3363.2	3409.6	297.5
2010-01-06	CEF	ETF	14.28	14.53	14.25	14.52	1256100.0
2010-01-06	CEW	ETF	22.24	22.3	22.18	22.29	138302.0
2010-01-06	CGO	ETF	14.71	14.83	14.606	14.64	13062.0
2010-01-06	CGW	ETF	18.75	18.81	18.62	18.67	1130026.0
2010-01-06	CHI	ETF	12.58	12.6665	12.47	12.49	239350.0
2010-01-06	CHIE	ETF	16.17	16.21	16.06	16.19	26204.0
2010-01-06	CHII	ETF	16.29	16.31	16.2406	16.31	14285.0

> showing 50 of 714 rows — these rows as CSV

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