PREVIEW / etf_daily / 2008-08-21

all etf daily files

  file:    by_date/etf_daily/2008/2008-08-21.parquet
  size:    27 KB
  rows:    602

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-08-21	SPY	ETF	126.75	128.44	126.6	127.8	180609800.0
2008-08-21	QQQ	ETF	46.73	47.08	46.38	46.87	118920908.0
2008-08-21	IWM	ETF	72.54	72.95	72.05	72.16	83526000.0
2008-08-21	DIA	ETF	113.23	114.78	113.07	114.05	16820600.0
2008-08-21	GLD	ETF	82.01	84.54	81.75	82.3	17031100.0
2008-08-21	TLT	ETF	93.63	93.63	92.75	93.14	2267000.0
2008-08-21	ACWI	ETF	46.44	46.87	46.37	46.78	76600.0
2008-08-21	ACWX	ETF	45.26	45.68	45.1	45.53	119295.0
2008-08-21	ADRE	ETF	45.04	45.36	44.85	45.22	337408.0
2008-08-21	AFK	ETF	36.69	37.5	36.69	37.3899	6575.0
2008-08-21	AGG	ETF	100.45	100.57	100.23	100.49	361800.0
2008-08-21	AIA	ETF	38.13	38.52	38.13	38.506	29680.0
2008-08-21	AIQ	ETF	54.75	55.75	54.2	54.95	29535.0
2008-08-21	AIS	ETF	0.74	0.76	0.7305	0.76	58140.0
2008-08-21	AIVI	ETF	55.3	55.83	55.28	55.76	21200.0
2008-08-21	ARB	ETF	47.96	48.1	47.56	47.83	159331.0
2008-08-21	BAL	ETF	43.48	43.6	43.48	43.5699	1800.0
2008-08-21	BBH	ETF	66.9133	67.1733	66.6667	66.9067	268800.0
2008-08-21	BIL	ETF	91.78	91.82	91.78	91.82	28300.0
2008-08-21	BITS	ETF	23.32	24.32	23.32	23.84	3150.0
2008-08-21	BIV	ETF	76.63	76.84	76.47	76.67	33200.0
2008-08-21	BJK	ETF	29.15	29.15	27.63	28.87	5000.0
2008-08-21	BKF	ETF	43.49	44.67	43.49	44.29	69938.0
2008-08-21	BLV	ETF	74.4	74.48	74.2	74.4	4900.0
2008-08-21	BMVP	ETF	15.16	15.337	15.16	15.296	20721.0
2008-08-21	BND	ETF	76.06	76.23	75.91	76.16	105400.0
2008-08-21	BNE	ETF	13.2	13.2	12.71	12.71	226666.0
2008-08-21	BRF	ETF	14.76	14.76	14.74	14.74	2500.0
2008-08-21	BSV	ETF	77.63	77.63	77.49	77.55	45800.0
2008-08-21	BTF	ETF	81.4	82.24999999999999	80.74999999999999	82.2495	4582.0
2008-08-21	BWX	ETF	26.93	27.06	26.86	26.95	309850.0
2008-08-21	CBON	ETF	6.09	6.28	5.66	5.85	119427.0
2008-08-21	CDL	ETF	0.89	0.95	0.85	0.88	594603.0
2008-08-21	CEF	ETF	10.81	11.05	10.59	10.96	1268000.0
2008-08-21	CGO	ETF	14.38	14.38	14.21	14.21	16933.0
2008-08-21	CGW	ETF	23.03	23.33	23.03	23.23	41695.0
2008-08-21	CHB	ETF	4.43	4.71	4.36	4.61	981740.0
2008-08-21	CHI	ETF	13.27	13.36	13.17	13.31	105050.0
2008-08-21	CHIC	ETF	11.93	12.7	11.78	12.02	292574.0
2008-08-21	CHW	ETF	10.45	10.52	10.29	10.52	152837.0
2008-08-21	CHY	ETF	12.93	12.96	12.81	12.9	85183.0
2008-08-21	CMF	ETF	51.745	51.9	51.625	51.74	4110.0
2008-08-21	CN	ETF	51.73	53.01	51.73	52.73	148778.0
2008-08-21	CNXT	ETF	5.81	6.03	5.8	5.84	286649.0
2008-08-21	COW	ETF	43.5	44.0	43.5	43.97	147934.0
2008-08-21	CPI	ETF	24.2	24.2	24.05	24.05	2350.0
2008-08-21	CPST	ETF	2.58	2.61	2.5	2.59	1678262.0
2008-08-21	CSA	ETF	17.81	18.07	17.68	17.96	106326.0
2008-08-21	CSB	ETF	18.035	19.24	18.035	19.2399	16726.0
2008-08-21	CSD	ETF	21.13	21.28	21.13	21.27	3000.0

> showing 50 of 602 rows — these rows as CSV

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