PREVIEW / etf_daily / 2008-08-28

all etf daily files

  file:    by_date/etf_daily/2008/2008-08-28.parquet
  size:    27 KB
  rows:    607

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-28	SPY	ETF	129.28	130.34	129.11	130.19	167537100.0
2008-08-28	QQQ	ETF	46.92	47.28	46.83	47.11	112808575.0
2008-08-28	IWM	ETF	73.37	74.65	73.03	74.51	75512600.0
2008-08-28	DIA	ETF	115.72	117.18	115.66	117.13	16556500.0
2008-08-28	GLD	ETF	83.06	83.13	81.27	82.18	9351600.0
2008-08-28	TLT	ETF	93.91	94.41	93.69	94.26	1886500.0
2008-08-28	AAXJ	ETF	49.61	49.67	49.61	49.67	6000.0
2008-08-28	ACWI	ETF	46.93	47.28	46.93	47.28	13600.0
2008-08-28	ACWX	ETF	45.99	46.05	45.807	45.99	36557.0
2008-08-28	ADRE	ETF	45.21	45.58	44.98	45.28	260849.0
2008-08-28	AFK	ETF	37.95	37.95	37.83	37.87	8821.0
2008-08-28	AGG	ETF	100.81	100.97	100.63	100.78	372600.0
2008-08-28	AIA	ETF	38.23	39.13	38.23	39.1	32453.0
2008-08-28	AIQ	ETF	55.0	57.1	54.3005	57.1	38673.0
2008-08-28	AIS	ETF	0.72	0.74	0.72	0.74	7400.0
2008-08-28	AIVI	ETF	56.66	56.99	56.57	56.74	18700.0
2008-08-28	ARB	ETF	48.64	49.17	48.46	48.96	147081.0
2008-08-28	BAL	ETF	43.52	43.58	43.07	43.07	3600.0
2008-08-28	BBH	ETF	66.2967	66.9733	66.2967	66.88	82200.0
2008-08-28	BIL	ETF	91.84	91.86	91.8	91.84	51950.0
2008-08-28	BITS	ETF	22.68	23.76	22.68	23.76	3829.0
2008-08-28	BIV	ETF	76.83	76.94	76.68	76.92	37200.0
2008-08-28	BJK	ETF	29.41	29.49	28.5	28.5	11500.0
2008-08-28	BKF	ETF	45.1	45.1	44.34	44.65	49378.0
2008-08-28	BLV	ETF	74.8	75.03	74.55	74.98	10100.0
2008-08-28	BMVP	ETF	15.367	15.477	15.358	15.477	15011.0
2008-08-28	BND	ETF	76.3	76.62	76.19	76.4	341400.0
2008-08-28	BNE	ETF	12.24	12.6	12.2	12.59	142622.0
2008-08-28	BRF	ETF	14.74	14.77	14.74	14.77	1000.0
2008-08-28	BSV	ETF	77.55	77.64	77.51	77.61	74600.0
2008-08-28	BTF	ETF	82.75	84.04999999999998	82.75	83.55	7137.8
2008-08-28	BWX	ETF	26.84	26.911	26.665	26.75	157154.0
2008-08-28	CBON	ETF	5.51	5.82	5.35	5.55	82036.0
2008-08-28	CDL	ETF	0.89	0.98	0.89	0.96	482672.0
2008-08-28	CEF	ETF	10.91	10.97	10.66	10.75	532000.0
2008-08-28	CGO	ETF	14.5	14.64	14.48	14.6	9084.0
2008-08-28	CGW	ETF	23.47	23.47	23.19	23.4028	23101.0
2008-08-28	CHB	ETF	4.73	5.02	4.7	4.97	927151.0
2008-08-28	CHI	ETF	13.32	13.4199	13.3	13.4	108491.0
2008-08-28	CHIC	ETF	12.38	12.4	12.04	12.15	359354.0
2008-08-28	CHW	ETF	10.5	10.6	10.47	10.6	127998.0
2008-08-28	CHY	ETF	13.03	13.13	12.99	13.01	87241.0
2008-08-28	CMF	ETF	51.92	51.92	51.74	51.855	9000.0
2008-08-28	CN	ETF	47.72	48.19	47.59	47.9	432065.0
2008-08-28	CNXT	ETF	5.84	6.05	5.83	6.0	248832.0
2008-08-28	COW	ETF	41.92	42.0	41.7	41.73	370734.0
2008-08-28	CPI	ETF	24.2	24.2	24.2	24.2	202.0
2008-08-28	CPST	ETF	2.53	2.79	2.52	2.76	3847261.0
2008-08-28	CSA	ETF	19.25	19.95	19.12	19.93	34611.0
2008-08-28	CSB	ETF	18.68	19.14	18.59	18.63	14800.0

> showing 50 of 607 rows — these rows as CSV

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