PREVIEW / etf_daily / 2008-09-02

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-02.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-02	SPY	ETF	130.03	130.71	127.52	127.99	252364900.0
2008-09-02	QQQ	ETF	46.86	47.08	45.34	45.55	162403164.0
2008-09-02	IWM	ETF	75.01	75.5	73.0	73.85	112584000.0
2008-09-02	DIA	ETF	116.96	118.01	114.78	115.16	24105000.0
2008-09-02	GLD	ETF	78.16	79.79	77.98	79.2	12680900.0
2008-09-02	TLT	ETF	92.98	94.41	92.84	94.37	2916000.0
2008-09-02	AAXJ	ETF	49.0	49.0	49.0	49.0	100.0
2008-09-02	ACWI	ETF	46.96	47.11	46.27	46.42	17600.0
2008-09-02	ACWX	ETF	45.16	45.56	44.89	44.98	81936.0
2008-09-02	ADRE	ETF	44.06	44.21	43.18	43.42	378665.0
2008-09-02	AFK	ETF	38.8	38.8	37.15	37.15	8555.0
2008-09-02	AGG	ETF	100.31	100.72	100.04	100.69	1275500.0
2008-09-02	AIA	ETF	38.02	38.02	36.88	37.16	122761.0
2008-09-02	AIQ	ETF	58.75	60.15	57.6	58.6	96644.0
2008-09-02	AIS	ETF	0.77	0.78	0.7281	0.73	31214.0
2008-09-02	AIVI	ETF	57.0	57.27	56.2	56.23	43000.0
2008-09-02	ARB	ETF	48.49	48.94	47.82	48.41	248664.0
2008-09-02	BAL	ETF	42.7	43.69	42.7	43.69	3800.0
2008-09-02	BBH	ETF	67.1067	67.1067	65.55	65.8333	413100.0
2008-09-02	BIL	ETF	91.7	91.78	91.66	91.74	603900.0
2008-09-02	BITS	ETF	23.76	23.96	22.76	23.4	2484.0
2008-09-02	BIV	ETF	76.55	76.83	76.19	76.83	34200.0
2008-09-02	BJK	ETF	29.99	30.29	29.99	30.29	300.0
2008-09-02	BKF	ETF	44.09	44.19	43.2078	43.34	33237.0
2008-09-02	BLV	ETF	74.82	74.99	74.1	74.93	24200.0
2008-09-02	BMVP	ETF	15.33	15.43	15.09	15.141	29538.0
2008-09-02	BND	ETF	76.34	76.34	75.76	76.26	149000.0
2008-09-02	BNE	ETF	12.26	12.45	11.75	12.05	219783.0
2008-09-02	BSV	ETF	77.26	77.57	77.25	77.55	73000.0
2008-09-02	BTF	ETF	84.49999999999999	85.74999999999999	84.04999999999998	84.2505	7962.400000000001
2008-09-02	BWX	ETF	26.5	26.575	26.39	26.527	213066.0
2008-09-02	CBON	ETF	5.79	5.79	4.9	5.27	170399.0
2008-09-02	CDL	ETF	1.06	1.06	0.9	0.9	419000.0
2008-09-02	CEF	ETF	10.3	10.45	10.05	10.26	655600.0
2008-09-02	CGO	ETF	14.93	14.93	14.54	14.54	11709.0
2008-09-02	CGW	ETF	23.34	23.56	22.99	23.1	56861.0
2008-09-02	CHB	ETF	4.91	5.24	4.88	4.94	1252459.0
2008-09-02	CHI	ETF	13.57	13.57	13.27	13.32	164732.0
2008-09-02	CHIC	ETF	12.15	12.37	11.93	12.03	430983.0
2008-09-02	CHW	ETF	10.73	10.7746	10.55	10.61	112719.0
2008-09-02	CHY	ETF	13.19	13.29	13.01	13.08	150711.0
2008-09-02	CMF	ETF	51.7101	51.805	51.685	51.685	26332.0
2008-09-02	CN	ETF	47.5	48.7	47.5	47.65	359281.0
2008-09-02	CNXT	ETF	6.0	6.13	5.86	5.91	353799.0
2008-09-02	COW	ETF	41.83	42.3028	41.72	42.0	291190.0
2008-09-02	CPI	ETF	25.0	25.188	24.88	24.88	4114.0
2008-09-02	CPST	ETF	2.66	2.7	2.46	2.47	2917814.0
2008-09-02	CSA	ETF	19.82	19.91	19.27	19.39	21671.0
2008-09-02	CSB	ETF	18.14	19.06	18.14	18.73	13850.0
2008-09-02	CSD	ETF	22.0	22.02	21.59	21.59	3800.0

> showing 50 of 611 rows — these rows as CSV

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