PREVIEW / etf_daily / 2009-05-07

all etf daily files

  file:    by_date/etf_daily/2009/2009-05-07.parquet
  size:    29 KB
  rows:    657

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
2009-05-07	SPY	ETF	93.01	93.15	90.28	90.86	317728000.0
2009-05-07	QQQ	ETF	35.25	35.27	33.88	34.21	216484625.0
2009-05-07	IWM	ETF	51.25	51.4	48.89	49.3	67577300.0
2009-05-07	DIA	ETF	85.8	85.91	83.65	84.17	19835900.0
2009-05-07	GLD	ETF	90.13	90.3	89.24	89.44	14808900.0
2009-05-07	TLT	ETF	95.94	96.7	94.33	94.71	5755200.0
2009-05-07	AAXJ	ETF	42.91	43.0	40.96	41.34	184400.0
2009-05-07	ACWI	ETF	34.24	34.4	33.3	33.54	249900.0
2009-05-07	ACWX	ETF	32.8	32.82	31.78	31.96	91909.0
2009-05-07	ADRE	ETF	34.49	34.61	32.93	33.25	466981.0
2009-05-07	AFK	ETF	23.614	23.614	22.8	23.47	5715.0
2009-05-07	AGG	ETF	101.5	101.67	100.8	100.99	1418800.0
2009-05-07	AGQ	ETF	87.98	89.68	84.42	86.54	186350.0
2009-05-07	AGZ	ETF	107.51	107.8	107.3	107.52	19470.0
2009-05-07	AIA	ETF	32.89	33.46	31.15	31.33	46921.0
2009-05-07	AIQ	ETF	39.3	39.75	38.15	38.35	46522.0
2009-05-07	AIS	ETF	0.5	0.5301	0.49	0.52	191017.0
2009-05-07	AIVI	ETF	34.62	34.88	33.55	33.55	19000.0
2009-05-07	AMJ	ETF	22.19	22.32	21.479	21.64	70653.0
2009-05-07	AOA	ETF	25.27	25.49	24.54	24.64	14400.0
2009-05-07	AOK	ETF	25.61	25.61	25.21	25.444	9648.0
2009-05-07	AOM	ETF	26.28	26.29	25.2	25.254	12485.0
2009-05-07	AOR	ETF	25.45	25.99	25.0	25.04	23438.0
2009-05-07	ARB	ETF	21.09	21.72	20.35	20.51	192167.0
2009-05-07	BAL	ETF	33.39	33.42	32.88	33.108	7238.0
2009-05-07	BBH	ETF	29.08	29.66	29.0667	29.3133	856200.0
2009-05-07	BIL	ETF	91.66	91.72	91.66	91.66	133800.0
2009-05-07	BITS	ETF	18.44	18.44	17.64	18.32	275.0
2009-05-07	BIV	ETF	76.59	76.6	76.13	76.28	77800.0
2009-05-07	BJK	ETF	22.99	23.86	21.49	21.49	16100.0
2009-05-07	BKF	ETF	33.35	33.41	31.68	32.1	153313.0
2009-05-07	BLV	ETF	72.47	72.8	71.53	71.96	38400.0
2009-05-07	BMVP	ETF	10.87	10.88	10.614	10.643	20676.0
2009-05-07	BND	ETF	77.07	77.19	76.82	76.94	517100.0
2009-05-07	BNE	ETF	5.79	5.877	5.06	5.17	182973.0
2009-05-07	BOSS	ETF	16.64	16.64	15.5	16.64	600.0
2009-05-07	BSV	ETF	78.96	78.99	78.8	78.8	147300.0
2009-05-07	BTF	ETF	49.5	49.5	47.8	48.2	8958.0
2009-05-07	BWX	ETF	26.12	26.185	25.975	25.99	194242.0
2009-05-07	BWZ	ETF	33.86	33.86	33.55	33.556	2197.0
2009-05-07	CBON	ETF	1.84	1.99	1.6	1.6	40606.0
2009-05-07	CEF	ETF	11.56	11.77	11.41	11.41	1228600.0
2009-05-07	CEW	ETF	20.32	20.34	20.25	20.31	76844.0
2009-05-07	CGO	ETF	10.55	10.56	10.2572	10.29	32236.0
2009-05-07	CGW	ETF	14.61	14.82	14.27	14.45	51336.0
2009-05-07	CHB	ETF	0.6	0.6	0.55	0.56	574187.0
2009-05-07	CHI	ETF	10.0	10.15	9.91	10.1	247735.0
2009-05-07	CHIC	ETF	12.46	12.62	11.72	11.98	321266.0
2009-05-07	CHW	ETF	6.68	6.8	6.53	6.6	214150.0
2009-05-07	CHY	ETF	9.71	9.73	9.5	9.64	259082.0

> showing 50 of 657 rows — these rows as CSV

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