PREVIEW / etf_daily / 2008-09-09

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-09.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-09-09	SPY	ETF	127.1	127.36	122.8	123.22	377326800.0
2008-09-09	QQQ	ETF	43.35	43.79	42.35	42.45	214180573.0
2008-09-09	IWM	ETF	73.24	73.85	70.56	70.81	132381100.0
2008-09-09	DIA	ETF	115.16	115.98	112.43	112.53	31926100.0
2008-09-09	GLD	ETF	77.39	77.82	76.24	76.49	20197500.0
2008-09-09	TLT	ETF	95.83	96.88	95.54	96.83	3890200.0
2008-09-09	AAXJ	ETF	46.87	46.87	45.88	45.88	11400.0
2008-09-09	ACWI	ETF	44.9	45.05	43.59	43.59	9900.0
2008-09-09	ACWX	ETF	43.11	43.122	41.82	41.82	36665.0
2008-09-09	ADRE	ETF	40.62	40.72	38.74	38.74	494593.0
2008-09-09	AFK	ETF	35.25	35.4	35.0	35.055	2142.0
2008-09-09	AGG	ETF	101.47	101.88	101.31	101.82	540400.0
2008-09-09	AIA	ETF	36.63	36.63	35.45	35.65	35592.0
2008-09-09	AIQ	ETF	57.75	58.5	57.25	57.4	73702.0
2008-09-09	AIS	ETF	0.72	0.76	0.72	0.75	39946.0
2008-09-09	AIVI	ETF	55.06	55.29	53.27	53.29	90200.0
2008-09-09	ARB	ETF	48.71	49.19	48.57	48.57	272227.0
2008-09-09	BBH	ETF	62.5567	63.6733	62.5467	62.9	274200.0
2008-09-09	BIL	ETF	91.76	91.78	91.72	91.74	61950.0
2008-09-09	BITS	ETF	25.0	25.0	22.36	22.36	1195.0
2008-09-09	BIV	ETF	77.16	77.48	76.97	77.38	101200.0
2008-09-09	BJK	ETF	28.72	28.72	28.72	28.72	100.0
2008-09-09	BKF	ETF	39.77	39.77	37.41	37.41	121999.0
2008-09-09	BLV	ETF	75.7	76.16	75.6	75.84	9600.0
2008-09-09	BMVP	ETF	14.71	14.71	14.18	14.18	18380.0
2008-09-09	BND	ETF	76.97	77.24	76.89	77.14	225100.0
2008-09-09	BNE	ETF	12.5	12.94	11.81	11.9	275444.0
2008-09-09	BRF	ETF	14.88	14.88	14.82	14.83	4400.0
2008-09-09	BSV	ETF	77.61	77.82	77.5	77.74	89900.0
2008-09-09	BTF	ETF	85.89999999999999	86.64999999999999	83.35000000000001	83.35000000000001	11180.400000000001
2008-09-09	BWX	ETF	25.96	26.225	25.96	26.16	227820.0
2008-09-09	CBON	ETF	5.18	5.32	4.95	5.0	104536.0
2008-09-09	CDL	ETF	0.89	0.94	0.87	0.9	459090.0
2008-09-09	CEF	ETF	9.98	9.98	9.26	9.3	1914300.0
2008-09-09	CGO	ETF	13.48	13.75	13.2	13.27	30475.0
2008-09-09	CGW	ETF	20.98	22.03	20.59	20.9	183962.0
2008-09-09	CHB	ETF	5.82	5.83	5.25	5.36	1602788.0
2008-09-09	CHI	ETF	12.6	12.77	12.38	12.42	137680.0
2008-09-09	CHIC	ETF	13.17	13.69	12.78	12.78	446471.0
2008-09-09	CHW	ETF	10.14	10.2	9.71	9.85	155382.0
2008-09-09	CHY	ETF	12.58	12.64	12.28	12.32	144473.0
2008-09-09	CMF	ETF	52.095	52.174	52.0	52.092	2808.0
2008-09-09	CN	ETF	47.54	47.96	45.81	45.81	224003.0
2008-09-09	CNXT	ETF	5.4	5.58	5.17	5.22	679446.0
2008-09-09	COW	ETF	41.53	41.532	41.02	41.02	87268.0
2008-09-09	CPI	ETF	24.05	24.05	24.0	24.0006	800.0
2008-09-09	CPST	ETF	1.97	2.03	1.65	1.69	6074280.0
2008-09-09	CSA	ETF	18.9	19.12	18.75	18.75	25894.0
2008-09-09	CSB	ETF	18.25	18.89	17.71	18.38	23457.0
2008-09-09	CSD	ETF	20.71	21.17	20.51	20.51	20600.0

> showing 50 of 612 rows — these rows as CSV

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