PREVIEW / etf_daily / 2008-09-17

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-17.parquet
  size:    27 KB
  rows:    619

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-17	SPY	ETF	119.64	121.85	116.0	116.61	624095600.0
2008-09-17	QQQ	ETF	41.84	42.4219	40.19	40.21	340087946.0
2008-09-17	IWM	ETF	69.95	70.07	67.45	67.8	266078500.0
2008-09-17	DIA	ETF	109.23	109.59	105.5	106.76	54988700.0
2008-09-17	GLD	ETF	77.11	85.6	77.09	85.46	65774700.0
2008-09-17	TLT	ETF	98.92	99.38	97.73	98.49	4371300.0
2008-09-17	AAXJ	ETF	40.28	40.3	40.25	40.25	1700.0
2008-09-17	ACWI	ETF	42.6	42.6	41.05	41.08	62400.0
2008-09-17	ACWX	ETF	39.84	39.84	38.64	39.11	24960.0
2008-09-17	ADRE	ETF	37.08	37.37	35.49	35.66	1114567.0
2008-09-17	AFK	ETF	32.98	33.01	32.16	33.01	1320.0
2008-09-17	AGG	ETF	100.77	101.27	100.6	100.83	707900.0
2008-09-17	AIA	ETF	32.84	32.86	31.74	32.35	42958.0
2008-09-17	AIQ	ETF	54.45	54.45	51.3	51.75	71290.0
2008-09-17	AIS	ETF	0.66	0.66	0.61	0.65	29575.0
2008-09-17	AIVI	ETF	50.04	50.42	48.56	49.1	49100.0
2008-09-17	ARB	ETF	46.0	46.6	45.18	45.86	578033.0
2008-09-17	BAL	ETF	37.97	37.97	37.92	37.92	700.0
2008-09-17	BBH	ETF	63.5367	64.15	61.6833	62.0	722400.0
2008-09-17	BIL	ETF	92.0	92.76	91.86	92.34	451300.0
2008-09-17	BITS	ETF	20.24	20.56	19.24	20.56	6199.0
2008-09-17	BIV	ETF	76.64	77.05	75.89	76.72	80500.0
2008-09-17	BJK	ETF	25.0	25.5	25.0	25.22	600.0
2008-09-17	BKF	ETF	33.57	34.08	32.01	32.26	106297.0
2008-09-17	BLV	ETF	75.26	75.61	74.08	74.54	13200.0
2008-09-17	BMVP	ETF	14.1	14.15	13.61	13.62	32274.0
2008-09-17	BND	ETF	76.62	77.07	76.5	76.77	294400.0
2008-09-17	BNE	ETF	11.92	12.28	11.62	11.96	269901.0
2008-09-17	BRF	ETF	14.77	14.77	14.73	14.77	3200.0
2008-09-17	BSV	ETF	77.56	79.39	77.32	77.86	223500.0
2008-09-17	BTF	ETF	79.35	80.05	73.05	73.75	20249.4
2008-09-17	BWX	ETF	26.3	26.31	25.665	25.7	250862.0
2008-09-17	CBON	ETF	4.68	4.7514	4.41	4.53	83816.0
2008-09-17	CDL	ETF	0.82	0.83	0.77	0.7778	808418.0
2008-09-17	CEF	ETF	9.46	10.92	9.38	10.88	3479500.0
2008-09-17	CGO	ETF	11.26	11.41	10.79	10.88	43742.0
2008-09-17	CGW	ETF	20.16	20.9699	20.066	20.85	125380.0
2008-09-17	CHB	ETF	5.58	5.58	4.61	5.02	1788776.0
2008-09-17	CHI	ETF	10.0	10.17	9.14	9.5	635509.0
2008-09-17	CHIC	ETF	11.86	12.06	11.27	11.39	442642.0
2008-09-17	CHW	ETF	7.92	8.12	7.35	7.55	402409.0
2008-09-17	CHY	ETF	10.27	10.37	9.4	9.57	667669.0
2008-09-17	CMF	ETF	51.3425	51.695	51.275	51.3235	9060.0
2008-09-17	CN	ETF	38.91	39.63	37.78	37.8	642691.0
2008-09-17	CNXT	ETF	4.41	4.5	3.79	3.86	911621.0
2008-09-17	COW	ETF	41.27	41.56	40.8	41.07	808810.0
2008-09-17	CPI	ETF	23.5	23.5	23.07	23.3	1700.0
2008-09-17	CPST	ETF	1.87	1.88	1.73	1.75	1818769.0
2008-09-17	CSA	ETF	17.34	17.34	16.0	16.56	129695.0
2008-09-17	CSB	ETF	14.2	15.5	11.03	14.9999	70300.0

> showing 50 of 619 rows — these rows as CSV

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