PREVIEW / etf_daily / 2007-03-21

all etf daily files

  file:    by_date/etf_daily/2007/2007-03-21.parquet
  size:    21 KB
  rows:    442

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-03-21	SPY	ETF	141.1	143.65	140.82	143.29	152368700.0
2007-03-21	QQQ	ETF	43.63	44.44	43.35	44.42	173967511.0
2007-03-21	IWM	ETF	78.96	81.12	78.73	80.27	77517600.0
2007-03-21	DIA	ETF	122.8	124.74	122.32	124.29	9723600.0
2007-03-21	GLD	ETF	65.54	65.9	65.12	65.82	5059000.0
2007-03-21	TLT	ETF	89.38	90.09	88.69	89.75	1513400.0
2007-03-21	AAA	ETF	63.18	64.57	63.07	64.31	38200.0
2007-03-21	ADRE	ETF	38.81	39.96	38.6999	39.79	206797.0
2007-03-21	AGG	ETF	100.55	100.82	100.48	100.74	664300.0
2007-03-21	AIQ	ETF	40.85	41.2	39.05	40.4	30420.0
2007-03-21	AIS	ETF	1.2	1.25	1.17	1.19	113100.0
2007-03-21	ARB	ETF	46.95	47.93	46.89	47.69	135200.0
2007-03-21	BAB	ETF	102.25	103.93	101.67	103.57	96100.0
2007-03-21	BBH	ETF	59.6	60.49	59.39	60.49	1442700.0
2007-03-21	BITS	ETF	33.96	34.2	33.64	33.96	14368.0
2007-03-21	BNE	ETF	15.56	15.95	15.51	15.94	100300.0
2007-03-21	BRF	ETF	14.54	14.59	14.5	14.5	8200.0
2007-03-21	BTF	ETF	108.1	109.1	107.6	109.0	3840.0
2007-03-21	CBON	ETF	31.24	31.25	30.46	31.15	75104.0
2007-03-21	CDL	ETF	9.81	9.9	9.7	9.88	246200.0
2007-03-21	CEF	ETF	9.45	9.48	9.37	9.46	164500.0
2007-03-21	CGO	ETF	16.89	17.1	16.75	17.02	18700.0
2007-03-21	CHB	ETF	9.46	10.01	9.38	9.92	1633500.0
2007-03-21	CHI	ETF	19.97	20.1155	19.92	20.09	69500.0
2007-03-21	CHIC	ETF	27.86	28.35	27.55	28.21	339706.0
2007-03-21	CHY	ETF	16.46	16.6	16.44	16.6	89700.0
2007-03-21	CIL	ETF	25.7	25.7	25.7	25.7	1000.0
2007-03-21	CN	ETF	45.51	47.24	45.49	47.12	103600.0
2007-03-21	CNXT	ETF	1.71	1.76	1.7	1.74	9993303.0
2007-03-21	CPI	ETF	22.7	22.7001	21.58	22.39	3600.0
2007-03-21	CPST	ETF	0.86	0.87	0.85	0.8631	1079423.0
2007-03-21	CSA	ETF	20.86	21.0	20.51	20.87	106700.0
2007-03-21	CSB	ETF	32.42	33.04	32.01	33.02	19600.0
2007-03-21	CSD	ETF	26.59	27.0	26.53	27.0	22700.0
2007-03-21	CSM	ETF	1.325	1.3375	1.3125	1.3375	12800.0
2007-03-21	CSQ	ETF	15.17	15.26	15.07	15.26	305500.0
2007-03-21	CTEC	ETF	85.0	86.25	84.1	85.74999999999999	8719.4
2007-03-21	CVY	ETF	26.7	27.0	26.61	26.99	18000.0
2007-03-21	CWI	ETF	24.9667	25.5	24.94	25.4933	51600.0
2007-03-21	DBA	ETF	26.29	26.34	26.16	26.32	148100.0
2007-03-21	DBB	ETF	24.35	24.47	24.14	24.18	11700.0
2007-03-21	DBC	ETF	24.28	24.46	24.15	24.44	156200.0
2007-03-21	DBE	ETF	25.36	25.61	25.28	25.61	48600.0
2007-03-21	DBO	ETF	24.54	24.75	24.5	24.75	2500.0
2007-03-21	DBP	ETF	26.17	26.2	25.98	26.17	4900.0
2007-03-21	DBS	ETF	26.31	26.31	25.9	26.29	7900.0
2007-03-21	DBV	ETF	26.71	26.71	26.6	26.71	68500.0
2007-03-21	DDM	ETF	6.6808	6.8658	6.6367	6.8258	2094000.0
2007-03-21	DEF	ETF	25.78	26.13	25.7301	26.1	26700.0
2007-03-21	DES	ETF	19.1833	19.5067	19.14	19.4433	117300.0

> showing 50 of 442 rows — these rows as CSV

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