PREVIEW / etf_daily / 2008-10-13

all etf daily files

  file:    by_date/etf_daily/2008/2008-10-13.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-10-13	SPY	ETF	93.87	101.35	89.95	101.35	455584000.0
2008-10-13	QQQ	ETF	32.86	35.25	32.4	35.13	277347002.0
2008-10-13	IWM	ETF	54.54	57.38	52.45	56.98	128725200.0
2008-10-13	DIA	ETF	88.04	95.03	87.46	95.03	44081200.0
2008-10-13	GLD	ETF	83.61	83.9	80.92	81.99	17028700.0
2008-10-13	TLT	ETF	95.11	95.95	94.26	94.72	1532100.0
2008-10-13	AAXJ	ETF	34.03	38.0	34.03	38.0	8100.0
2008-10-13	ACWI	ETF	32.74	35.68	32.74	35.68	64000.0
2008-10-13	ACWX	ETF	31.64	34.39	31.64	34.39	227588.0
2008-10-13	ADRE	ETF	30.25	32.69	28.65	32.69	546827.0
2008-10-13	AFK	ETF	27.49	27.5	26.57	26.57	675.0
2008-10-13	AGG	ETF	90.39	93.56	90.0	91.82	911000.0
2008-10-13	AIA	ETF	29.85	31.0	28.35	31.0	15672.0
2008-10-13	AIQ	ETF	43.6	43.8	42.0	43.7	46516.0
2008-10-13	AIS	ETF	0.49	0.55	0.4	0.46	44120.0
2008-10-13	AIVI	ETF	40.15	43.34	39.96	43.2	44200.0
2008-10-13	ARB	ETF	41.3	41.51	38.84	40.0	402628.0
2008-10-13	BAL	ETF	32.16	32.16	32.16	32.16	100.0
2008-10-13	BBH	ETF	51.6667	56.1633	51.6667	55.6667	827100.0
2008-10-13	BIL	ETF	92.0	92.04	91.64	91.7	204600.0
2008-10-13	BITS	ETF	17.16	17.16	15.16	16.24	18098.0
2008-10-13	BIV	ETF	66.09	68.17	64.75	68.17	155600.0
2008-10-13	BJK	ETF	17.57	19.75	17.57	19.75	500.0
2008-10-13	BKF	ETF	27.57	28.78	25.93	28.71	97863.0
2008-10-13	BLV	ETF	65.36	66.71	65.36	66.63	24600.0
2008-10-13	BMVP	ETF	10.28	11.46	10.28	11.46	93280.0
2008-10-13	BND	ETF	71.51	73.09	70.0	72.87	127000.0
2008-10-13	BNE	ETF	6.54	6.94	6.08	6.94	157629.0
2008-10-13	BOSS	ETF	13.6	14.15	13.6	14.15	100.0
2008-10-13	BRF	ETF	14.64	14.64	14.6	14.6	3000.0
2008-10-13	BSV	ETF	74.0	76.43	68.29	72.55	544300.0
2008-10-13	BTF	ETF	56.74999999999999	60.8	56.349999999999994	59.459999999999994	20142.0
2008-10-13	BWX	ETF	23.375	24.29	23.375	24.01	583584.0
2008-10-13	CBON	ETF	3.92	4.1081	3.61	3.62	63008.0
2008-10-13	CDL	ETF	0.38	0.43	0.35	0.37	885228.0
2008-10-13	CEF	ETF	10.92	10.92	10.21	10.55	1373400.0
2008-10-13	CGO	ETF	8.4	9.75	8.4	9.42	82598.0
2008-10-13	CGW	ETF	16.0	17.65	15.8	17.32	50393.0
2008-10-13	CHB	ETF	3.67	4.3	3.36	4.28	1671882.0
2008-10-13	CHI	ETF	7.18	8.46	7.05	8.05	451922.0
2008-10-13	CHIC	ETF	9.55	9.74	9.17	9.62	324819.0
2008-10-13	CHW	ETF	4.99	5.7	4.99	5.7	355106.0
2008-10-13	CHY	ETF	8.19	8.4	7.37	7.69	926550.0
2008-10-13	CMF	ETF	47.4999	47.4999	45.145	45.95	12438.0
2008-10-13	CNXT	ETF	2.5	2.8	2.45	2.77	796279.0
2008-10-13	COW	ETF	36.73	37.64	36.3	37.17	91373.0
2008-10-13	CPI	ETF	22.0	22.25	22.0	22.25	400.0
2008-10-13	CPST	ETF	1.26	1.36	1.26	1.36	3498118.0
2008-10-13	CSA	ETF	14.77	14.77	13.81	14.45	123674.0
2008-10-13	CSB	ETF	12.5	12.9999	11.25	12.2	22850.0

> showing 50 of 611 rows — these rows as CSV

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