PREVIEW / etf_daily / 2008-09-08

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-08.parquet
  size:    27 KB
  rows:    611

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-09-08	SPY	ETF	128.04	128.24	124.42	126.99	364075300.0
2008-09-08	QQQ	ETF	44.04	44.22	42.68	43.31	311074015.0
2008-09-08	IWM	ETF	74.02	74.35	71.64	72.48	148091600.0
2008-09-08	DIA	ETF	115.53	115.93	112.4	115.16	37982500.0
2008-09-08	GLD	ETF	80.1	80.35	78.47	78.86	10016900.0
2008-09-08	TLT	ETF	94.9	95.88	94.56	95.88	5426200.0
2008-09-08	AAXJ	ETF	46.88	47.23	46.63	47.23	3800.0
2008-09-08	ACWI	ETF	45.8	46.03	44.69	44.88	28200.0
2008-09-08	ACWX	ETF	43.73	43.73	42.79	43.55	5709.0
2008-09-08	ADRE	ETF	42.88	42.95	40.85	41.3	540369.0
2008-09-08	AFK	ETF	36.9	37.42	35.78	35.78	1400.0
2008-09-08	AGG	ETF	100.96	101.51	100.84	101.37	873300.0
2008-09-08	AIA	ETF	37.82	37.82	36.15	36.5	428670.0
2008-09-08	AIQ	ETF	58.25	58.5	56.45	57.4	60991.0
2008-09-08	AIS	ETF	0.73	0.77	0.72	0.75	19100.0
2008-09-08	AIVI	ETF	55.4	56.62	54.06	54.7	36900.0
2008-09-08	ARB	ETF	48.73	50.04	48.73	49.0	202321.0
2008-09-08	BAL	ETF	42.31	42.31	41.0	41.0	2400.0
2008-09-08	BBH	ETF	63.7667	64.4667	63.0333	63.2167	501600.0
2008-09-08	BIL	ETF	91.74	91.76	91.72	91.76	31000.0
2008-09-08	BITS	ETF	22.8	25.0	22.0	24.0	3235.0
2008-09-08	BIV	ETF	76.9	77.2	76.6	77.2	40800.0
2008-09-08	BJK	ETF	28.97	28.97	28.0	28.09	1700.0
2008-09-08	BKF	ETF	40.99	41.77	39.79	40.16	51270.0
2008-09-08	BLV	ETF	74.8	75.65	74.5	75.35	12400.0
2008-09-08	BMVP	ETF	14.523	14.74	14.519	14.65	30449.0
2008-09-08	BND	ETF	76.83	77.0	76.38	77.0	148900.0
2008-09-08	BNE	ETF	12.16	12.46	11.97	12.44	151474.0
2008-09-08	BRF	ETF	14.81	14.81	14.74	14.8	15510.0
2008-09-08	BSV	ETF	77.62	77.77	77.46	77.74	66700.0
2008-09-08	BTF	ETF	86.64999999999999	88.8	84.04999999999998	85.74999999999999	13266.6
2008-09-08	BWX	ETF	26.255	26.255	25.94	26.13	179428.0
2008-09-08	CBON	ETF	5.85	5.87	5.08	5.09	144105.0
2008-09-08	CDL	ETF	0.97	0.97	0.87	0.9	346323.0
2008-09-08	CEF	ETF	10.28	10.28	9.92	10.07	729900.0
2008-09-08	CGO	ETF	14.23	14.23	13.4	13.77	53377.0
2008-09-08	CGW	ETF	21.61	22.19	21.61	21.85	129980.0
2008-09-08	CHB	ETF	5.04	6.32	5.04	5.81	3982783.0
2008-09-08	CHI	ETF	13.09	13.255	12.41	12.6	197814.0
2008-09-08	CHIC	ETF	12.99	13.26	12.67	13.19	395562.0
2008-09-08	CHW	ETF	10.46	10.46	9.99	10.11	140080.0
2008-09-08	CHY	ETF	12.77	12.96	12.37	12.58	132595.0
2008-09-08	CMF	ETF	52.05	52.105	51.9125	52.105	1976.0
2008-09-08	CN	ETF	48.94	49.05	46.8	47.77	239168.0
2008-09-08	CNXT	ETF	5.54	5.72	5.38	5.45	586154.0
2008-09-08	COW	ETF	41.68	42.01	41.67	41.69	39110.0
2008-09-08	CPI	ETF	24.3	24.3	24.3	24.3	231.0
2008-09-08	CPST	ETF	2.22	2.22	1.96	1.96	3361381.0
2008-09-08	CSA	ETF	18.75	19.11	18.75	18.97	30525.0
2008-09-08	CSB	ETF	19.11	19.54	18.35	18.35	13748.0

> showing 50 of 611 rows — these rows as CSV

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