PREVIEW / etf_daily / 2008-02-20

all etf daily files

  file:    by_date/etf_daily/2008/2008-02-20.parquet
  size:    26 KB
  rows:    569

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-02-20	SPY	ETF	133.99	136.55	133.76	135.92	220085700.0
2008-02-20	QQQ	ETF	43.25	44.09	43.24	43.94	137338773.0
2008-02-20	IWM	ETF	69.54	70.91	69.17	70.77	71204100.0
2008-02-20	DIA	ETF	122.54	124.57	122.23	124.09	15681700.0
2008-02-20	GLD	ETF	90.84	93.31	90.75	93.24	10632400.0
2008-02-20	TLT	ETF	90.62	91.58	90.56	91.58	2550100.0
2008-02-20	ADRE	ETF	51.26	52.58	50.95	52.51	817971.0
2008-02-20	AGG	ETF	101.22	101.6	101.09	101.3	405300.0
2008-02-20	AIA	ETF	43.94	44.1	43.18	44.1	9800.0
2008-02-20	AIQ	ETF	51.5	53.65	50.6	53.15	89620.0
2008-02-20	AIS	ETF	0.97	1.02	0.97	1.02	56400.0
2008-02-20	AIVI	ETF	61.86	62.96	61.86	62.7	169300.0
2008-02-20	ARB	ETF	42.11	42.11	40.72	42.02	219400.0
2008-02-20	BBH	ETF	54.75	55.25	54.3233	55.1133	640500.0
2008-02-20	BIL	ETF	91.72	91.8	91.72	91.72	17450.0
2008-02-20	BITS	ETF	22.04	22.1124	21.24	21.24	5060.0
2008-02-20	BIV	ETF	77.73	77.92	77.57	77.7	53900.0
2008-02-20	BJK	ETF	42.0	42.1	42.0	42.1	600.0
2008-02-20	BKF	ETF	53.09	54.36	52.68	54.16	13700.0
2008-02-20	BLV	ETF	74.8	75.17	74.76	75.17	10500.0
2008-02-20	BMVP	ETF	15.7533	16.2333	15.7533	16.19	45300.0
2008-02-20	BND	ETF	76.39	76.77	76.39	76.56	197000.0
2008-02-20	BNE	ETF	13.03	13.65	13.03	13.6	145700.0
2008-02-20	BRF	ETF	14.68	14.682	14.68	14.68	12800.0
2008-02-20	BSV	ETF	78.35	78.39	78.12	78.21	129400.0
2008-02-20	BTF	ETF	110.95	111.44999999999999	108.6	110.8	5140.0
2008-02-20	BWX	ETF	27.075	27.2	27.05	27.19	173604.0
2008-02-20	CBON	ETF	14.12	14.59	14.12	14.45	30772.0
2008-02-20	CDL	ETF	1.36	1.42	1.32	1.32	1363817.0
2008-02-20	CEF	ETF	12.87	13.03	12.7	13.02	784500.0
2008-02-20	CGO	ETF	15.84	16.17	15.7	16.1	15628.0
2008-02-20	CGW	ETF	23.5	23.54	23.06	23.5	116600.0
2008-02-20	CHB	ETF	7.9	8.27	7.86	8.13	2305423.0
2008-02-20	CHI	ETF	14.51	14.5499	14.12	14.53	128550.0
2008-02-20	CHIC	ETF	19.32	19.5	19.17	19.5	913963.0
2008-02-20	CHW	ETF	11.57	11.8	11.4	11.64	148702.0
2008-02-20	CHY	ETF	13.26	13.38	12.91	13.38	228378.0
2008-02-20	CMF	ETF	52.025	52.24	52.025	52.19	13400.0
2008-02-20	CN	ETF	61.65	63.16	60.61	62.92	424900.0
2008-02-20	CNXT	ETF	0.57	0.59	0.57	0.5882	1267065.0
2008-02-20	COW	ETF	45.85	46.33	45.8	46.33	16500.0
2008-02-20	CPI	ETF	19.35	19.5	19.05	19.15	3300.0
2008-02-20	CPST	ETF	1.57	1.59	1.53	1.57	898390.0
2008-02-20	CSA	ETF	15.1	15.21	14.99	15.02	160900.0
2008-02-20	CSD	ETF	23.53	24.01	23.51	23.91	81000.0
2008-02-20	CSQ	ETF	12.58	13.18	12.58	13.07	434359.0
2008-02-20	CUT	ETF	21.28	21.63	21.16	21.6	42300.0
2008-02-20	CVY	ETF	22.63	23.05	22.63	23.0	9700.0
2008-02-20	CWI	ETF	24.7267	25.2533	24.6	25.1267	49800.0
2008-02-20	CZA	ETF	23.69	23.96	23.69	23.96	600.0

> showing 50 of 569 rows — these rows as CSV

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