PREVIEW / etf_daily / 2007-02-05

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-05.parquet
  size:    21 KB
  rows:    432

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
2007-02-05	SPY	ETF	144.7	144.94	144.34	144.85	45705300.0
2007-02-05	QQQ	ETF	44.14	44.36	43.96	44.12	96394787.0
2007-02-05	IWM	ETF	80.22	80.47	79.87	80.24	30893400.0
2007-02-05	DIA	ETF	126.44	126.74	126.25	126.68	4625000.0
2007-02-05	GLD	ETF	64.68	64.69	64.24	64.31	2553500.0
2007-02-05	TLT	ETF	87.4	87.46	87.16	87.32	395500.0
2007-02-05	AAA	ETF	60.86	61.28	60.86	61.27	4100.0
2007-02-05	ADRE	ETF	39.77	39.77	39.46	39.69	136857.0
2007-02-05	AGG	ETF	99.57	99.61	99.47	99.59	248000.0
2007-02-05	AIQ	ETF	35.85	35.9	34.8	35.3	84820.0
2007-02-05	AIS	ETF	1.22	1.28	1.22	1.249	158500.0
2007-02-05	ARB	ETF	47.33	47.51	46.97	47.21	137500.0
2007-02-05	BAB	ETF	107.74	107.9	106.69	107.62	117900.0
2007-02-05	BBC	ETF	4.92	4.989	4.83	4.83	103400.0
2007-02-05	BBH	ETF	63.42	63.6933	63.2067	63.43	457200.0
2007-02-05	BITS	ETF	40.84	41.9712	40.84	41.2	21577.0
2007-02-05	BNE	ETF	15.42	15.47	15.18	15.23	79900.0
2007-02-05	BRF	ETF	14.46	14.47	14.46	14.46	1400.0
2007-02-05	BTF	ETF	108.0	109.04999999999998	107.955	109.04999999999998	1720.0
2007-02-05	CBON	ETF	33.5	33.5	33.05	33.25	23095.0
2007-02-05	CDL	ETF	10.76	10.77	10.56	10.61	650300.0
2007-02-05	CEF	ETF	9.56	9.64	9.52	9.58	234700.0
2007-02-05	CGO	ETF	17.23	17.34	17.11	17.34	25600.0
2007-02-05	CHB	ETF	8.38	8.42	8.18	8.25	725500.0
2007-02-05	CHI	ETF	20.39	20.39	20.35	20.37	87900.0
2007-02-05	CHIC	ETF	30.17	30.17	29.24	29.71	941019.0
2007-02-05	CHY	ETF	17.45	17.49	17.37	17.43	107300.0
2007-02-05	CN	ETF	51.35	51.6	50.96	51.39	95500.0
2007-02-05	CNXT	ETF	1.97	1.97	1.94	1.96	4258850.0
2007-02-05	CPI	ETF	23.85	23.85	23.85	23.85	200.0
2007-02-05	CPST	ETF	0.92	0.92	0.8511	0.863	1797713.0
2007-02-05	CSA	ETF	22.54	22.6	22.45	22.5	6200.0
2007-02-05	CSB	ETF	33.38	33.6	33.37	33.48	7800.0
2007-02-05	CSD	ETF	26.11	26.11	26.0	26.04	9900.0
2007-02-05	CSM	ETF	1.3325	1.3325	1.3325	1.3325	36000.0
2007-02-05	CSQ	ETF	15.49	15.71	15.49	15.71	282700.0
2007-02-05	CTEC	ETF	87.6	88.05	86.5	87.2	27437.2
2007-02-05	CVY	ETF	27.06	27.15	27.06	27.12	41700.0
2007-02-05	CWI	ETF	24.7467	24.8533	24.7333	24.8533	8700.0
2007-02-05	DBA	ETF	26.05	26.14	25.92	26.08	214500.0
2007-02-05	DBB	ETF	22.48	22.48	22.26	22.3	19500.0
2007-02-05	DBC	ETF	24.37	24.4	24.0	24.129	271500.0
2007-02-05	DBE	ETF	25.61	25.75	25.2	25.26	21600.0
2007-02-05	DBO	ETF	25.1	25.23	24.74	24.81	22100.0
2007-02-05	DBP	ETF	25.93	25.97	25.9	25.91	2500.0
2007-02-05	DBS	ETF	26.59	26.72	26.5799	26.59	4300.0
2007-02-05	DBV	ETF	26.25	26.28	26.17	26.26	147000.0
2007-02-05	DDM	ETF	7.07	7.1042	7.0517	7.0817	445200.0
2007-02-05	DEF	ETF	26.14	26.15	26.0405	26.15	36000.0
2007-02-05	DES	ETF	19.6167	19.6167	19.5	19.5	66000.0

> showing 50 of 432 rows — these rows as CSV

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