PREVIEW / etf_daily / 2007-06-06

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-06.parquet
  size:    22 KB
  rows:    479

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-06-06	SPY	ETF	152.86	152.95	151.75	151.84	164096800.0
2007-06-06	QQQ	ETF	47.37	47.38	46.9614	47.07	183210704.0
2007-06-06	IWM	ETF	83.8	83.81	83.0	83.51	95052800.0
2007-06-06	DIA	ETF	135.5	135.5	134.32	134.49	15041600.0
2007-06-06	GLD	ETF	66.11	66.55	65.88	66.41	3596600.0
2007-06-06	TLT	ETF	85.36	85.54	85.26	85.4	1129200.0
2007-06-06	ADRE	ETF	44.7884	44.7884	43.88	44.0	207482.0
2007-06-06	AGG	ETF	98.52	98.54	98.3	98.51	1001300.0
2007-06-06	AIQ	ETF	44.9	45.0	44.0	45.0	51920.0
2007-06-06	AIS	ETF	2.05	2.05	1.95	1.96	503800.0
2007-06-06	ARB	ETF	52.3	52.3	51.5	51.97	215900.0
2007-06-06	BBH	ETF	60.14	60.1467	59.6833	59.8133	890100.0
2007-06-06	BIL	ETF	91.64	91.68	91.64	91.68	9750.0
2007-06-06	BITS	ETF	32.24	32.88	32.0	32.56	8343.0
2007-06-06	BIV	ETF	73.97	74.05	73.95	74.02	18700.0
2007-06-06	BLV	ETF	73.46	73.57	73.46	73.53	10400.0
2007-06-06	BMVP	ETF	18.12	18.137	18.058	18.11	31000.0
2007-06-06	BND	ETF	74.27	74.39	74.26	74.37	185900.0
2007-06-06	BNE	ETF	19.19	19.25	18.82	18.85	414415.0
2007-06-06	BOSS	ETF	47.73	48.36	47.73	48.36	100.0
2007-06-06	BRF	ETF	14.52	14.5201	14.52	14.5201	8700.0
2007-06-06	BSV	ETF	74.63	74.72	74.63	74.69	26700.0
2007-06-06	BTF	ETF	109.74999999999999	109.74999999999999	109.0	109.60000000000001	1220.0
2007-06-06	CBON	ETF	29.7	29.87	29.44	29.52	26228.0
2007-06-06	CDL	ETF	8.33	8.55	8.32	8.5	2426522.0
2007-06-06	CEF	ETF	9.23	9.34	9.22	9.25	232300.0
2007-06-06	CGO	ETF	18.1	18.12	18.0	18.04	37600.0
2007-06-06	CGW	ETF	25.68	25.68	25.3	25.35	255200.0
2007-06-06	CHB	ETF	10.84	10.85	10.38	10.58	2207600.0
2007-06-06	CHI	ETF	20.35	20.35	20.15	20.18	106900.0
2007-06-06	CHIC	ETF	28.91	29.31	28.48	29.16	1039768.0
2007-06-06	CHY	ETF	17.18	17.23	17.01	17.08	105000.0
2007-06-06	CN	ETF	51.3	51.39	50.35	50.95	85200.0
2007-06-06	CNXT	ETF	1.25	1.27	1.23	1.27	5572602.0
2007-06-06	CPST	ETF	1.04	1.05	0.96	1.0	3166376.0
2007-06-06	CSA	ETF	20.45	20.46	20.32	20.32	10000.0
2007-06-06	CSB	ETF	32.17	32.17	31.85	32.07	11300.0
2007-06-06	CSD	ETF	30.96	31.02	30.79	30.84	23500.0
2007-06-06	CSQ	ETF	15.63	15.63	15.48	15.56	371600.0
2007-06-06	CTEC	ETF	96.99999999999999	102.5	96.25	101.89999999999999	569026.8
2007-06-06	CVY	ETF	28.31	28.32	28.08	28.12	30500.0
2007-06-06	CWI	ETF	27.2133	27.2133	27.0067	27.04	30600.0
2007-06-06	CZA	ETF	27.03	27.04	26.98	26.98	3800.0
2007-06-06	DBA	ETF	26.41	26.41	25.96	26.11	131700.0
2007-06-06	DBB	ETF	26.96	26.99	26.55	26.96	28200.0
2007-06-06	DBC	ETF	25.85	25.89	25.61	25.82	208200.0
2007-06-06	DBE	ETF	28.34	28.53	28.31	28.53	8200.0
2007-06-06	DBO	ETF	26.49	26.75	26.17	26.57	30200.0
2007-06-06	DBP	ETF	26.51	26.54	26.34	26.5	10300.0
2007-06-06	DBS	ETF	27.03	27.06	26.8799	26.95	8700.0

> showing 50 of 479 rows — these rows as CSV

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