PREVIEW / etf_daily / 2008-08-20

all etf daily files

  file:    by_date/etf_daily/2008/2008-08-20.parquet
  size:    27 KB
  rows:    612

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-20	SPY	ETF	127.39	127.95	126.34	127.58	225498200.0
2008-08-20	QQQ	ETF	47.36	47.56	46.74	47.09	155466659.0
2008-08-20	IWM	ETF	73.17	73.82	72.28	73.0	101308300.0
2008-08-20	DIA	ETF	113.87	114.54	112.89	114.04	21415300.0
2008-08-20	GLD	ETF	80.15	80.66	78.81	80.06	14714000.0
2008-08-20	TLT	ETF	93.38	93.71	93.15	93.31	2500000.0
2008-08-20	AAXJ	ETF	49.05	49.05	49.02	49.02	4000.0
2008-08-20	ACWI	ETF	46.18	46.53	46.05	46.31	7900.0
2008-08-20	ACWX	ETF	45.01	45.09	44.8	45.0	22032.0
2008-08-20	ADRE	ETF	44.46	45.087	44.45	45.03	506362.0
2008-08-20	AFK	ETF	37.0	37.0	36.09	36.34	1150.0
2008-08-20	AGG	ETF	100.46	100.72	100.27	100.47	277400.0
2008-08-20	AIA	ETF	38.94	39.064	38.94	39.06	4139.0
2008-08-20	AIQ	ETF	55.7	56.1	54.45	55.05	30679.0
2008-08-20	AIS	ETF	0.7205	0.75	0.7205	0.74	36523.0
2008-08-20	AIVI	ETF	55.57	55.94	55.41	55.94	17800.0
2008-08-20	ARB	ETF	49.29	49.29	47.75	48.26	153839.0
2008-08-20	BAL	ETF	41.93	42.17	41.93	42.17	1700.0
2008-08-20	BBH	ETF	67.6333	67.8167	67.0467	67.2667	343800.0
2008-08-20	BIL	ETF	91.74	91.82	91.74	91.8	60750.0
2008-08-20	BITS	ETF	22.96	25.04	22.76	23.6	5571.0
2008-08-20	BIV	ETF	76.58	76.9	76.5	76.78	42800.0
2008-08-20	BJK	ETF	29.56	29.56	29.4	29.47	1600.0
2008-08-20	BKF	ETF	43.26	44.32	43.26	44.3	28563.0
2008-08-20	BLV	ETF	74.65	74.74	74.34	74.74	5900.0
2008-08-20	BMVP	ETF	15.1667	15.2506	15.1233	15.2467	23021.0
2008-08-20	BND	ETF	75.92	76.25	75.92	76.18	120800.0
2008-08-20	BNE	ETF	13.17	13.39	12.63	13.31	279607.0
2008-08-20	BOSS	ETF	22.4	22.4	22.14	22.14	400.0
2008-08-20	BRF	ETF	14.76	14.76	14.76	14.76	1200.0
2008-08-20	BSV	ETF	77.55	77.69	77.4	77.67	83900.0
2008-08-20	BTF	ETF	84.04999999999998	84.25	81.5	82.39999999999999	11156.800000000001
2008-08-20	BWX	ETF	26.81	26.85	26.6254	26.735	335074.0
2008-08-20	CBON	ETF	6.75	6.75	6.06	6.16	129206.0
2008-08-20	CDL	ETF	0.95	0.95	0.9	0.91	954507.0
2008-08-20	CEF	ETF	10.35	10.47	10.1	10.43	802800.0
2008-08-20	CGO	ETF	14.53	14.53	14.34	14.46	9726.0
2008-08-20	CGW	ETF	23.1	23.25	22.91	23.25	63472.0
2008-08-20	CHB	ETF	4.57	4.64	4.29	4.43	678047.0
2008-08-20	CHI	ETF	13.34	13.35	13.21	13.27	100808.0
2008-08-20	CHIC	ETF	12.51	12.86	11.95	12.04	438662.0
2008-08-20	CHW	ETF	10.47	10.51	10.3	10.49	183430.0
2008-08-20	CHY	ETF	12.99	13.0	12.8	12.9	94226.0
2008-08-20	CMF	ETF	51.935	52.025	51.9	51.9	15700.0
2008-08-20	CN	ETF	52.87	53.41	52.19	53.28	339285.0
2008-08-20	CNXT	ETF	5.92	6.05	5.81	5.97	368114.0
2008-08-20	COW	ETF	43.39	43.7499	43.26	43.55	46407.0
2008-08-20	CPI	ETF	24.4	24.5	24.25	24.3	8500.0
2008-08-20	CPST	ETF	2.47	2.64	2.44	2.62	2244561.0
2008-08-20	CSA	ETF	17.98	18.266	17.69	17.84	25404.0

> showing 50 of 612 rows — these rows as CSV

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