PREVIEW / etf_daily / 2007-03-26

all etf daily files

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

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-26	SPY	ETF	143.5	143.65	142.09	143.2	113787500.0
2007-03-26	QQQ	ETF	44.14	44.32	43.63	44.3	114263682.0
2007-03-26	IWM	ETF	80.32	80.48	79.48	80.07	46665700.0
2007-03-26	DIA	ETF	124.75	124.75	123.57	124.36	7972500.0
2007-03-26	GLD	ETF	65.36	65.97	65.36	65.84	3928800.0
2007-03-26	TLT	ETF	88.62	89.27	88.5	88.9	763600.0
2007-03-26	AAA	ETF	64.24	64.73	64.17	64.73	10700.0
2007-03-26	ADRE	ETF	39.93	39.93	39.1201	39.73	110637.0
2007-03-26	AGG	ETF	100.4	100.65	100.28	100.35	444100.0
2007-03-26	AIQ	ETF	39.65	41.0	39.35	40.75	47100.0
2007-03-26	AIS	ETF	1.2	1.2001	1.16	1.18	82800.0
2007-03-26	ARB	ETF	47.5	47.73	47.13	47.73	108900.0
2007-03-26	BAB	ETF	100.39	100.45	98.92	99.6	116000.0
2007-03-26	BBH	ETF	59.1667	60.6667	59.0067	59.3333	389700.0
2007-03-26	BITS	ETF	33.6	33.72	33.08	33.2	24974.0
2007-03-26	BNE	ETF	15.87	15.93	15.67	15.89	144100.0
2007-03-26	BOSS	ETF	44.8	44.98	44.8	44.98	100.0
2007-03-26	BRF	ETF	14.51	14.51	14.5	14.5	5500.0
2007-03-26	BTF	ETF	108.69999999999999	108.75	108.55	108.75	2640.0
2007-03-26	CBON	ETF	30.92	31.13	30.31	31.1	85828.0
2007-03-26	CDL	ETF	9.72	9.72	9.62	9.66	137800.0
2007-03-26	CEF	ETF	9.41	9.51	9.41	9.46	171700.0
2007-03-26	CGO	ETF	16.92	17.05	16.92	17.05	16400.0
2007-03-26	CHB	ETF	9.82	9.93	9.23	9.66	2648793.0
2007-03-26	CHI	ETF	20.11	20.21	20.08	20.15	66700.0
2007-03-26	CHIC	ETF	28.81	29.01	28.7	28.93	200461.0
2007-03-26	CHY	ETF	16.98	17.0	16.79	17.0	138700.0
2007-03-26	CIL	ETF	25.67	25.67	25.67	25.67	100.0
2007-03-26	CN	ETF	47.25	47.3	46.49	46.95	46600.0
2007-03-26	CNXT	ETF	1.69	1.73	1.67	1.72	10057518.0
2007-03-26	CPI	ETF	22.24	22.24	22.1	22.11	1600.0
2007-03-26	CPST	ETF	1.03	1.05	0.96	0.97	6916546.0
2007-03-26	CSA	ETF	21.01	21.25	20.61	20.81	97300.0
2007-03-26	CSB	ETF	32.55	32.6	32.32	32.56	14500.0
2007-03-26	CSD	ETF	27.2	27.2	26.97	27.2	11200.0
2007-03-26	CSQ	ETF	15.19	15.2	15.06	15.15	309900.0
2007-03-26	CTEC	ETF	88.75	90.35	88.55	89.3	11568.800000000001
2007-03-26	CVY	ETF	26.9	26.9	26.58	26.78	41000.0
2007-03-26	CWI	ETF	25.5067	25.54	25.3267	25.52	12750.0
2007-03-26	DBA	ETF	26.01	26.15	25.64	25.8	194700.0
2007-03-26	DBB	ETF	24.95	24.95	24.51	24.87	7200.0
2007-03-26	DBC	ETF	24.92	25.0	24.8	24.96	182800.0
2007-03-26	DBE	ETF	26.71	26.82	26.6	26.79	25900.0
2007-03-26	DBO	ETF	26.21	26.25	25.85	26.05	24500.0
2007-03-26	DBP	ETF	26.21	26.25	26.17	26.25	7800.0
2007-03-26	DBS	ETF	26.22	26.31	26.16	26.31	5600.0
2007-03-26	DBV	ETF	26.97	27.05	26.88	27.0	78600.0
2007-03-26	DDM	ETF	6.8667	6.8667	6.7458	6.8417	1032000.0
2007-03-26	DEF	ETF	26.2	26.2	25.96	26.04	23600.0
2007-03-26	DES	ETF	19.37	19.39	19.1967	19.2967	82200.0

> showing 50 of 443 rows — these rows as CSV

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