PREVIEW / etf_daily / 2007-02-21

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-21.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-21	SPY	ETF	145.61	146.07	145.35	145.98	63971600.0
2007-02-21	QQQ	ETF	44.92	45.21	44.83	45.19	95941147.0
2007-02-21	IWM	ETF	81.65	82.49	81.53	82.1	39549600.0
2007-02-21	DIA	ETF	127.3	127.59	126.98	127.37	5303800.0
2007-02-21	GLD	ETF	65.31	67.71	65.2	67.35	11076700.0
2007-02-21	TLT	ETF	88.53	88.7	88.48	88.69	379800.0
2007-02-21	AAA	ETF	60.98	61.09	60.81	60.9	2300.0
2007-02-21	ADRE	ETF	40.42	40.72	40.21	40.72	223828.0
2007-02-21	AGG	ETF	100.16	100.27	100.02	100.25	223600.0
2007-02-21	AIQ	ETF	38.25	39.25	36.75	39.25	52860.0
2007-02-21	AIS	ETF	1.23	1.25	1.2236	1.23	178700.0
2007-02-21	ARB	ETF	46.0	46.34	45.9	46.2	218100.0
2007-02-21	BAB	ETF	111.41	111.78	111.05	111.78	54500.0
2007-02-21	BBC	ETF	4.3	4.35	4.26	4.32	109100.0
2007-02-21	BBH	ETF	62.7333	63.3967	62.62	63.3133	599700.0
2007-02-21	BITS	ETF	45.2	45.32	43.0	44.6	12522.0
2007-02-21	BNE	ETF	15.78	15.85	15.72	15.77	51100.0
2007-02-21	BRF	ETF	14.44	14.495	14.42	14.44	18500.0
2007-02-21	BTF	ETF	113.2	113.64999999999999	113.14999999999999	113.2	1360.0
2007-02-21	CBON	ETF	33.5	33.77	33.492	33.6	27583.0
2007-02-21	CDL	ETF	10.44	10.49	10.4	10.43	251000.0
2007-02-21	CEF	ETF	9.45	9.8	9.45	9.73	547700.0
2007-02-21	CGO	ETF	16.8801	16.95	16.71	16.75	34300.0
2007-02-21	CHB	ETF	7.51	7.62	7.45	7.55	1631300.0
2007-02-21	CHI	ETF	20.14	20.24	20.1	20.2	78900.0
2007-02-21	CHIC	ETF	30.24	30.47	30.05	30.32	253860.0
2007-02-21	CHY	ETF	17.03	17.05	16.94	16.97	189200.0
2007-02-21	CIL	ETF	25.5	25.5	25.5	25.5	700.0
2007-02-21	CN	ETF	52.8	53.0	52.07	52.91	97200.0
2007-02-21	CNXT	ETF	2.08	2.08	2.04	2.06	4746954.0
2007-02-21	CPI	ETF	23.98	23.98	22.92	23.12	1200.0
2007-02-21	CPST	ETF	0.88	1.04	0.8768	0.99	26987338.0
2007-02-21	CSA	ETF	22.45	22.68	22.13	22.52	18400.0
2007-02-21	CSB	ETF	33.09	33.12	32.8	32.93	18500.0
2007-02-21	CSD	ETF	26.69	26.83	26.66	26.81	11100.0
2007-02-21	CSM	ETF	1.3625	1.3625	1.3625	1.3625	3200.0
2007-02-21	CSQ	ETF	15.25	15.3	15.15	15.25	459400.0
2007-02-21	CTEC	ETF	87.5	87.75	86.83	87.3	19468.8
2007-02-21	CVY	ETF	27.25	27.29	27.19	27.28	25000.0
2007-02-21	CWI	ETF	25.3333	25.4333	25.3333	25.4333	16650.0
2007-02-21	DBA	ETF	26.56	27.05	26.45	26.96	269700.0
2007-02-21	DBB	ETF	23.49	24.7	23.44	23.72	22700.0
2007-02-21	DBC	ETF	24.27	24.83	24.15	24.74	332500.0
2007-02-21	DBE	ETF	25.15	25.72	25.04	25.62	12300.0
2007-02-21	DBO	ETF	24.56	25.11	24.5	24.95	7800.0
2007-02-21	DBP	ETF	26.33	27.23	26.33	27.07	19400.0
2007-02-21	DBS	ETF	27.32	28.23	27.32	27.98	7900.0
2007-02-21	DBV	ETF	26.7	26.81	26.69	26.77	152800.0
2007-02-21	DDM	ETF	7.1692	7.1983	7.1325	7.175	919200.0
2007-02-21	DEF	ETF	26.51	26.54	26.49	26.52	6000.0

> showing 50 of 432 rows — these rows as CSV

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