PREVIEW / etf_daily / 2008-05-02

all etf daily files

  file:    by_date/etf_daily/2008/2008-05-02.parquet
  size:    26 KB
  rows:    588

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
2008-05-02	SPY	ETF	142.34	142.37	140.56	141.51	181585500.0
2008-05-02	QQQ	ETF	49.19	49.19	48.34	48.77	124989913.0
2008-05-02	IWM	ETF	73.41	73.5	72.24	72.55	58836700.0
2008-05-02	DIA	ETF	131.29	131.29	129.73	130.73	12615000.0
2008-05-02	GLD	ETF	83.96	84.79	83.96	84.58	8744400.0
2008-05-02	TLT	ETF	91.78	92.41	91.54	91.61	2730800.0
2008-05-02	ACWI	ETF	53.5	53.73	53.32	53.42	15400.0
2008-05-02	ACWX	ETF	54.53	55.9	54.13	54.16	74145.0
2008-05-02	ADRE	ETF	55.85	55.954	55.16	55.4901	342560.0
2008-05-02	AGG	ETF	101.6	102.09	101.53	101.93	462100.0
2008-05-02	AIA	ETF	49.42	49.42	47.92	48.37	116945.0
2008-05-02	AIQ	ETF	40.0	42.3	39.65	41.15	42458.0
2008-05-02	AIS	ETF	0.86	0.86	0.8	0.85	63010.0
2008-05-02	AIVI	ETF	67.87	67.87	67.28	67.53	20800.0
2008-05-02	ARB	ETF	48.04	48.42	47.17	47.62	202741.0
2008-05-02	BBH	ETF	55.5667	55.5667	54.3333	54.3333	629400.0
2008-05-02	BIL	ETF	91.6	91.7	91.58	91.6	29150.0
2008-05-02	BITS	ETF	23.8	24.08	23.6	24.0	3700.0
2008-05-02	BIV	ETF	78.1	78.1	77.71	77.94	32800.0
2008-05-02	BKF	ETF	58.35	58.35	57.342	57.77	120752.0
2008-05-02	BLV	ETF	75.66	76.29	75.66	75.98	19600.0
2008-05-02	BMVP	ETF	16.43	16.43	16.2098	16.2467	36529.0
2008-05-02	BND	ETF	77.01	77.3	76.77	77.09	280500.0
2008-05-02	BNE	ETF	16.96	17.23	16.7	16.78	238450.0
2008-05-02	BRF	ETF	14.67	14.67	14.66	14.66	6597.0
2008-05-02	BSV	ETF	77.61	77.8	77.51	77.7	108800.0
2008-05-02	BTF	ETF	105.89999999999999	106.64999999999999	105.35	105.39999999999999	4720.0
2008-05-02	BWX	ETF	27.71	27.85	27.625	27.82	275580.0
2008-05-02	CBON	ETF	11.22	11.63	10.27	10.29	166763.0
2008-05-02	CDL	ETF	1.48	1.51	1.4	1.4	1094515.0
2008-05-02	CEF	ETF	11.71	12.0	11.71	11.95	517400.0
2008-05-02	CGO	ETF	17.18	17.18	16.72	16.92	29991.0
2008-05-02	CGW	ETF	24.99	25.0	24.55	24.7	58213.0
2008-05-02	CHB	ETF	10.52	10.55	9.77	9.84	1485110.0
2008-05-02	CHI	ETF	15.58	15.7	15.47	15.52	92961.0
2008-05-02	CHIC	ETF	16.85	17.01	16.6	16.69	386463.0
2008-05-02	CHW	ETF	12.16	12.39	12.08	12.38	124570.0
2008-05-02	CHY	ETF	14.23	14.39	14.15	14.22	123808.0
2008-05-02	CMF	ETF	52.565	52.565	52.31	52.4575	3800.0
2008-05-02	CN	ETF	63.96	64.87	63.72	64.54	1055162.0
2008-05-02	CNXT	ETF	0.5	0.512	0.49	0.49	3550281.0
2008-05-02	COW	ETF	42.37	42.5699	42.19	42.48	54538.0
2008-05-02	CPI	ETF	18.36	18.36	17.95	18.0	1800.0
2008-05-02	CPST	ETF	2.84	2.87	2.7801	2.83	2151833.0
2008-05-02	CSA	ETF	17.5	17.57	17.17	17.24	24668.0
2008-05-02	CSB	ETF	22.52	22.9	22.52	22.74	14220.0
2008-05-02	CSD	ETF	24.08	24.08	23.86	23.87	12700.0
2008-05-02	CSQ	ETF	12.94	12.99	12.8	12.87	199474.0
2008-05-02	CUT	ETF	21.15	21.77	20.63	21.57	58200.0
2008-05-02	CVY	ETF	23.48	23.48	23.23	23.24	22300.0

> showing 50 of 588 rows — these rows as CSV

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