PREVIEW / etf_daily / 2007-11-06

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-06.parquet
  size:    24 KB
  rows:    535

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-11-06	SPY	ETF	150.86	152.11	149.9	152.07	177800500.0
2007-11-06	QQQ	ETF	54.33	54.69	53.78	54.68	131884651.0
2007-11-06	IWM	ETF	78.99	80.0	78.03	79.96	94974000.0
2007-11-06	DIA	ETF	135.83	136.62	135.05	136.51	11092400.0
2007-11-06	GLD	ETF	81.03	81.52	80.7	81.43	7692500.0
2007-11-06	TLT	ETF	90.6	91.15	90.48	90.56	575800.0
2007-11-06	ADRE	ETF	56.41	57.29	56.0	57.29	284126.0
2007-11-06	AGG	ETF	100.4	100.51	100.17	100.33	418000.0
2007-11-06	AIQ	ETF	44.1	46.5	43.2	45.9	107600.0
2007-11-06	AIS	ETF	1.22	1.22	1.12	1.16	504700.0
2007-11-06	AIVI	ETF	76.0	76.24	75.18	76.24	120100.0
2007-11-06	ARB	ETF	49.72	50.59	48.86	50.52	294900.0
2007-11-06	BBH	ETF	60.1333	60.7133	59.9867	60.6667	232500.0
2007-11-06	BIL	ETF	91.66	91.66	91.58	91.66	16800.0
2007-11-06	BITS	ETF	26.0	26.4	25.76	26.12	7486.0
2007-11-06	BIV	ETF	76.12	76.29	76.02	76.07	17800.0
2007-11-06	BLV	ETF	76.01	76.33	75.95	76.05	22500.0
2007-11-06	BMVP	ETF	17.32	17.46	17.21	17.46	73400.0
2007-11-06	BND	ETF	76.2	76.2	75.95	76.0	55800.0
2007-11-06	BNE	ETF	16.29	17.25	16.13	17.2	189300.0
2007-11-06	BRF	ETF	14.7	14.7	14.6	14.6	7000.0
2007-11-06	BSV	ETF	76.27	76.43	76.25	76.33	39800.0
2007-11-06	BTF	ETF	113.55	116.8	113.55	116.8	2160.0
2007-11-06	BWX	ETF	26.74	26.775	26.74	26.755	399000.0
2007-11-06	CBON	ETF	19.11	19.52	18.76	19.43	82405.0
2007-11-06	CDL	ETF	4.05	4.2	4.05	4.08	2646288.0
2007-11-06	CEF	ETF	10.91	11.03	10.8	10.92	881000.0
2007-11-06	CGO	ETF	19.4	19.61	19.24	19.61	13100.0
2007-11-06	CGW	ETF	26.21	26.38	25.98	26.38	119500.0
2007-11-06	CHB	ETF	11.515	11.57	11.19	11.54	1623500.0
2007-11-06	CHI	ETF	15.86	16.06	15.75	15.95	174600.0
2007-11-06	CHIC	ETF	13.88	14.0	13.59	13.72	386077.0
2007-11-06	CHW	ETF	12.91	13.0	12.64	12.99	211100.0
2007-11-06	CHY	ETF	14.04	14.05	13.74	13.92	327043.0
2007-11-06	CMF	ETF	51.665	51.7	51.575	51.575	4000.0
2007-11-06	CN	ETF	55.51	55.88	54.25	55.38	178300.0
2007-11-06	CNXT	ETF	1.28	1.28	1.24	1.26	5526003.0
2007-11-06	COW	ETF	48.38	48.38	48.26	48.27	500.0
2007-11-06	CPI	ETF	24.6	24.6	24.0	24.0	400.0
2007-11-06	CPST	ETF	1.28	1.29	1.24	1.28	5066265.0
2007-11-06	CSA	ETF	16.31	16.45	16.22	16.25	48900.0
2007-11-06	CSD	ETF	28.26	28.46	28.13	28.42	26700.0
2007-11-06	CSM	ETF	1.47	1.47	1.47	1.47	8400.0
2007-11-06	CSQ	ETF	14.48	14.6	14.42	14.52	230601.0
2007-11-06	CVY	ETF	25.08	25.29	25.04	25.29	12300.0
2007-11-06	CWI	ETF	29.42	29.68	29.3267	29.68	44250.0
2007-11-06	CZA	ETF	26.25	26.25	26.25	26.25	500.0
2007-11-06	DBA	ETF	29.75	30.5	29.6	30.29	712000.0
2007-11-06	DBB	ETF	25.59	25.79	25.53	25.75	30200.0
2007-11-06	DBC	ETF	31.52	31.52	30.77	31.36	447620.0

> showing 50 of 535 rows — these rows as CSV

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