PREVIEW / etf_daily / 2008-09-23

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-23.parquet
  size:    27 KB
  rows:    610

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-23	SPY	ETF	120.85	122.02	118.28	118.55	327470400.0
2008-09-23	QQQ	ETF	41.18	41.75	40.44	40.57	185954509.0
2008-09-23	IWM	ETF	72.0	72.62	70.81	70.99	92894300.0
2008-09-23	DIA	ETF	110.26	111.38	108.26	108.5	25513500.0
2008-09-23	GLD	ETF	88.87	89.1	86.72	88.32	22342900.0
2008-09-23	TLT	ETF	93.61	94.1	93.13	93.6	2236000.0
2008-09-23	AAXJ	ETF	43.42	43.9	43.42	43.43	7000.0
2008-09-23	ACWI	ETF	43.9	44.09	43.04	43.17	53800.0
2008-09-23	ACWX	ETF	42.8224	42.86	41.85	42.04	18626.0
2008-09-23	ADRE	ETF	39.98	40.24	38.18	38.51	777441.0
2008-09-23	AFK	ETF	35.56	35.56	34.29	34.29	545.0
2008-09-23	AGG	ETF	99.32	99.6	99.0	99.27	435500.0
2008-09-23	AIA	ETF	35.59	35.59	34.26	34.26	26568.0
2008-09-23	AIQ	ETF	56.8	56.9	54.7	55.8	41157.0
2008-09-23	AIS	ETF	0.67	0.72	0.65	0.7	50800.0
2008-09-23	AIVI	ETF	54.42	54.76	53.16	53.39	30400.0
2008-09-23	ARB	ETF	47.14	48.09	47.07	47.43	336777.0
2008-09-23	BAL	ETF	39.039	39.039	39.039	39.039	100.0
2008-09-23	BBH	ETF	61.5	61.8833	60.8167	60.9333	202500.0
2008-09-23	BIL	ETF	91.8	92.1	91.78	92.1	238050.0
2008-09-23	BITS	ETF	22.88	23.16	20.64	22.0	7462.0
2008-09-23	BIV	ETF	74.96	75.23	74.33	75.2	45400.0
2008-09-23	BJK	ETF	27.15	27.15	26.73	26.73	400.0
2008-09-23	BKF	ETF	38.04	38.04	36.42	36.5574	32245.0
2008-09-23	BLV	ETF	73.1	73.17	71.5	72.04	14300.0
2008-09-23	BMVP	ETF	14.15	14.28	13.9	13.94	43935.0
2008-09-23	BND	ETF	76.18	76.8	76.05	76.65	195100.0
2008-09-23	BNE	ETF	11.77	11.98	11.57	11.73	90203.0
2008-09-23	BRF	ETF	14.68	14.72	14.68	14.72	5400.0
2008-09-23	BSV	ETF	76.91	78.16	76.91	77.29	183900.0
2008-09-23	BTF	ETF	79.89999999999999	80.55	78.35	78.94999999999999	2763.4
2008-09-23	BWX	ETF	26.62	26.775	26.26	26.625	180290.0
2008-09-23	CBON	ETF	6.6	6.9	6.28	6.68	57678.0
2008-09-23	CDL	ETF	0.78	0.819	0.77	0.77	1030851.0
2008-09-23	CEF	ETF	10.91	11.18	10.75	11.06	5415000.0
2008-09-23	CGO	ETF	12.0	12.05	11.53	11.75	38715.0
2008-09-23	CGW	ETF	21.02	21.9	21.02	21.15	73892.0
2008-09-23	CHB	ETF	6.25	6.34	5.5	5.75	1628497.0
2008-09-23	CHI	ETF	10.41	10.7	10.26	10.5	208974.0
2008-09-23	CHIC	ETF	11.37	11.83	11.37	11.55	335193.0
2008-09-23	CHW	ETF	8.54	8.604	8.159	8.53	274839.0
2008-09-23	CHY	ETF	10.26	10.433	9.9	10.29	246375.0
2008-09-23	CMF	ETF	50.625	50.805	50.26	50.785	12444.0
2008-09-23	CN	ETF	44.61	45.73	44.04	44.6	270377.0
2008-09-23	CNXT	ETF	3.75	3.75	3.44	3.48	511339.0
2008-09-23	COW	ETF	41.05	41.26	40.93	41.03	97051.0
2008-09-23	CPST	ETF	1.37	1.42	1.31	1.35	2486378.0
2008-09-23	CSA	ETF	17.41	18.04	17.09	17.8	65100.0
2008-09-23	CSB	ETF	16.39	16.39	13.83	13.83	20910.0
2008-09-23	CSD	ETF	19.78	19.78	19.14	19.14	5800.0

> showing 50 of 610 rows — these rows as CSV

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