PREVIEW / etf_daily / 2008-10-31

all etf daily files

  file:    by_date/etf_daily/2008/2008-10-31.parquet
  size:    27 KB
  rows:    606

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
2008-10-31	SPY	ETF	95.08	98.57	94.48	96.83	411394000.0
2008-10-31	QQQ	ETF	32.36	33.43	32.09	32.89	224280329.0
2008-10-31	IWM	ETF	51.3	54.09	50.48	53.75	113060500.0
2008-10-31	DIA	ETF	91.57	94.53	91.13	93.5	39474400.0
2008-10-31	GLD	ETF	72.62	72.87	70.6	71.34	9517800.0
2008-10-31	TLT	ETF	94.64	94.92	92.65	92.83	2282500.0
2008-10-31	AAXJ	ETF	32.24	33.32	31.82	32.89	280400.0
2008-10-31	ACWI	ETF	32.79	33.83	32.36	33.69	134100.0
2008-10-31	ACWX	ETF	29.85	31.19	29.85	30.73	31715.0
2008-10-31	ADRE	ETF	27.58	27.79	26.57	27.34	670494.0
2008-10-31	AFK	ETF	24.4299	24.4299	23.2204	24.2499	748.0
2008-10-31	AGG	ETF	95.54	96.3	95.11	95.96	732700.0
2008-10-31	AIA	ETF	25.92	26.312	25.5	26.31	6983.0
2008-10-31	AIQ	ETF	37.8	41.25	37.2	40.75	96256.0
2008-10-31	AIS	ETF	0.4699	0.48	0.4501	0.48	79025.0
2008-10-31	AIVI	ETF	35.77	37.54	35.77	36.88	18400.0
2008-10-31	ARB	ETF	31.05	32.59	30.59	32.58	453713.0
2008-10-31	BAL	ETF	27.5	27.71	27.4701	27.4701	400.0
2008-10-31	BBH	ETF	57.5567	58.11	56.9133	57.6333	891900.0
2008-10-31	BIL	ETF	91.9	91.94	91.8	91.8	175250.0
2008-10-31	BITS	ETF	16.04	17.72	16.0	17.28	4058.0
2008-10-31	BIV	ETF	71.02	71.25	70.56	70.77	29900.0
2008-10-31	BJK	ETF	19.01	19.95	17.35	18.6	12900.0
2008-10-31	BKF	ETF	25.05	26.4799	24.52	25.5	170206.0
2008-10-31	BLV	ETF	66.7	66.78	65.88	66.11	11900.0
2008-10-31	BMVP	ETF	10.66	11.27	10.66	11.08	39173.0
2008-10-31	BND	ETF	73.18	73.68	72.65	73.13	282300.0
2008-10-31	BNE	ETF	6.77	8.1	6.5	7.79	188236.0
2008-10-31	BOSS	ETF	13.8	14.21	13.8	13.95	100.0
2008-10-31	BRF	ETF	14.83	14.83	14.8299	14.83	1500.0
2008-10-31	BSV	ETF	75.43	75.99	75.12	75.38	85900.0
2008-10-31	BTF	ETF	60.0	63.3	59.05	63.09949999999999	13635.0
2008-10-31	BWX	ETF	24.69	24.725	24.425	24.575	110630.0
2008-10-31	CBON	ETF	3.33	3.33	3.1	3.22	105659.0
2008-10-31	CDL	ETF	0.3	0.3	0.24	0.28	1586824.0
2008-10-31	CEF	ETF	8.92	9.08	8.75	8.76	610500.0
2008-10-31	CGO	ETF	9.27	9.67	9.27	9.54	18654.0
2008-10-31	CGW	ETF	15.855	16.22	15.01	15.727	76534.0
2008-10-31	CHB	ETF	1.77	1.92	1.72	1.87	1307903.0
2008-10-31	CHI	ETF	9.49	9.5	8.95	9.1	215214.0
2008-10-31	CHIC	ETF	7.39	8.45	7.3	8.45	412021.0
2008-10-31	CHW	ETF	6.04	6.35	6.02	6.35	137164.0
2008-10-31	CHY	ETF	9.0	9.09	8.71	8.74	251798.0
2008-10-31	CMF	ETF	49.48	49.505	48.8925	49.475	10750.0
2008-10-31	CNXT	ETF	1.75	1.78	1.55	1.55	1481740.0
2008-10-31	COW	ETF	35.6	35.96	35.6	35.81	29690.0
2008-10-31	CPST	ETF	1.31	1.35	1.25	1.35	1462535.0
2008-10-31	CSA	ETF	10.32	12.0	10.17	12.0	202269.0
2008-10-31	CSB	ETF	16.5	16.79	15.6	16.35	23290.0
2008-10-31	CSD	ETF	13.19	13.72	13.19	13.72	3000.0

> showing 50 of 606 rows — these rows as CSV

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