PREVIEW / etf_daily / 2007-02-08

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-08.parquet
  size:    21 KB
  rows:    428

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-08	SPY	ETF	144.78	145.12	144.27	145.02	70641000.0
2007-02-08	QQQ	ETF	44.39	44.6	44.23	44.45	89559666.0
2007-02-08	IWM	ETF	80.87	81.14	80.58	81.05	25417000.0
2007-02-08	DIA	ETF	126.55	126.58	125.78	126.47	6289600.0
2007-02-08	GLD	ETF	64.92	65.61	64.83	65.52	4769900.0
2007-02-08	TLT	ETF	87.99	88.31	87.91	88.13	980200.0
2007-02-08	AAA	ETF	60.69	61.0	60.69	60.87	1700.0
2007-02-08	ADRE	ETF	39.92	40.13	39.69	40.09	382689.0
2007-02-08	AGG	ETF	99.87	100.0	99.81	99.96	353800.0
2007-02-08	AIQ	ETF	35.5	36.4	35.45	36.05	40380.0
2007-02-08	AIS	ETF	1.27	1.27	1.25	1.27	94900.0
2007-02-08	ARB	ETF	47.19	47.4	47.11	47.24	135600.0
2007-02-08	BAB	ETF	111.75	112.25	110.7	111.63	99900.0
2007-02-08	BBC	ETF	4.73	4.73	4.5	4.5	279500.0
2007-02-08	BBH	ETF	63.2	63.93	63.2	63.7	249300.0
2007-02-08	BITS	ETF	40.12	40.76	39.0	39.6	18131.0
2007-02-08	BNE	ETF	15.35	15.61	15.34	15.52	68700.0
2007-02-08	BRF	ETF	14.49	14.52	14.46	14.46	10100.0
2007-02-08	BTF	ETF	112.44999999999999	113.24999999999999	112.44999999999999	113.24999999999999	2200.0
2007-02-08	CBON	ETF	33.33	33.5	33.21	33.46	32288.0
2007-02-08	CDL	ETF	10.74	10.81	10.66	10.81	378900.0
2007-02-08	CEF	ETF	9.55	9.61	9.53	9.57	463300.0
2007-02-08	CGO	ETF	17.08	17.2399	17.06	17.08	28900.0
2007-02-08	CHB	ETF	8.4	8.4	7.82	7.92	2206000.0
2007-02-08	CHI	ETF	20.16	20.25	20.1	20.25	79400.0
2007-02-08	CHIC	ETF	30.16	31.0	30.05	30.8	404339.0
2007-02-08	CHY	ETF	17.2	17.2	17.12	17.14	130100.0
2007-02-08	CIL	ETF	25.49	25.53	25.49	25.53	3700.0
2007-02-08	CN	ETF	50.8	51.29	50.63	50.99	85300.0
2007-02-08	CNXT	ETF	1.97	1.99	1.93	1.96	4545351.0
2007-02-08	CPI	ETF	24.21	24.21	24.21	24.21	400.0
2007-02-08	CPST	ETF	0.88	0.89	0.8792	0.89	1883216.0
2007-02-08	CSA	ETF	22.49	22.49	21.63	22.3	25500.0
2007-02-08	CSB	ETF	33.5	33.66	33.39	33.64	16500.0
2007-02-08	CSD	ETF	26.21	26.22	26.08	26.22	27300.0
2007-02-08	CSM	ETF	1.3475	1.3475	1.3475	1.3475	400.0
2007-02-08	CSQ	ETF	15.47	15.48	15.35	15.48	316800.0
2007-02-08	CTEC	ETF	87.35	87.65	86.99999999999999	87.24999999999999	19529.2
2007-02-08	CVY	ETF	27.15	27.16	27.01	27.16	64300.0
2007-02-08	CWI	ETF	24.84	24.9667	24.8267	24.96	21600.0
2007-02-08	DBA	ETF	25.66	25.92	25.56	25.88	65200.0
2007-02-08	DBB	ETF	22.07	22.49	22.07	22.4	37200.0
2007-02-08	DBC	ETF	23.65	24.3	23.65	24.27	178200.0
2007-02-08	DBE	ETF	24.96	25.61	24.81	25.61	7600.0
2007-02-08	DBO	ETF	24.53	25.16	24.23	25.13	27900.0
2007-02-08	DBP	ETF	26.16	26.4	26.15	26.38	50200.0
2007-02-08	DBS	ETF	27.04	27.27	27.0	27.18	5900.0
2007-02-08	DBV	ETF	26.3	26.31	26.22	26.27	149900.0
2007-02-08	DDM	ETF	7.0742	7.0833	6.9908	7.0567	1432800.0
2007-02-08	DEF	ETF	26.31	26.31	26.22	26.25	9400.0

> showing 50 of 428 rows — these rows as CSV

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