PREVIEW / etf_daily / 2005-01-31

all etf daily files

  file:    by_date/etf_daily/2005/2005-01-31.parquet
  size:    14 KB
  rows:    256

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
2005-01-31	SPY	ETF	117.95	118.25	117.71	118.16	52532700.0
2005-01-31	QQQ	ETF	37.36	37.53	37.26	37.4	89381338.0
2005-01-31	IWM	ETF	61.76	62.25	61.57	62.12	21879000.0
2005-01-31	DIA	ETF	104.98	105.05	104.48	104.8	5333900.0
2005-01-31	GLD	ETF	42.21	42.3	41.96	42.22	1692400.0
2005-01-31	TLT	ETF	91.33	91.75	91.29	91.71	1313900.0
2005-01-31	AAA	ETF	58.21	58.89	58.21	58.75	7100.0
2005-01-31	ADRE	ETF	82.0	83.1	82.0	83.1	8144.0
2005-01-31	AFK	ETF	26.35	26.4	26.35	26.39	14300.0
2005-01-31	AGG	ETF	103.02	103.02	102.75	102.9	113800.0
2005-01-31	AIQ	ETF	66.1	67.55	66.0	66.8	61900.0
2005-01-31	ARB	ETF	40.25	41.0	40.25	40.9	218000.0
2005-01-31	BAB	ETF	50.53	50.72	49.89	50.25	53400.0
2005-01-31	BBH	ETF	47.6967	47.9267	47.52	47.7	2003100.0
2005-01-31	BCM	ETF	55.26	55.45	55.16	55.17	18500.0
2005-01-31	BIS	ETF	952.0	960.0	952.0	960.0	13.1
2005-01-31	BITS	ETF	8.2	8.8	8.2	8.2	18554.0
2005-01-31	BKF	ETF	36.61	37.78	36.61	37.78	17100.0
2005-01-31	BNE	ETF	14.25	14.88	14.21	14.85	187100.0
2005-01-31	BRF	ETF	15.6	15.61	15.57	15.6	5500.0
2005-01-31	BTF	ETF	91.8	91.8	90.99999999999999	91.6	2140.0
2005-01-31	CBON	ETF	27.6	28.31	27.6	28.02	59045.0
2005-01-31	CDC	ETF	10.25	10.64	10.25	10.3	3900.0
2005-01-31	CDL	ETF	13.96	14.01	13.8	14.01	359400.0
2005-01-31	CEF	ETF	5.29	5.29	5.21	5.23	205500.0
2005-01-31	CEW	ETF	27.55	27.55	27.51	27.51	2000.0
2005-01-31	CGW	ETF	28.0	28.75	28.0	28.75	12200.0
2005-01-31	CHB	ETF	10.55	10.84	10.46	10.79	372600.0
2005-01-31	CHIC	ETF	10.35	10.76	10.34	10.72	666748.0
2005-01-31	CHIR	ETF	33.15	33.21	32.58	32.85	1526168.0
2005-01-31	CID	ETF	9.0	9.02	8.99	9.02	22700.0
2005-01-31	CIL	ETF	26.11	26.11	26.1	26.1	1900.0
2005-01-31	CIZ	ETF	20.3	20.3	20.3	20.3	300.0
2005-01-31	CN	ETF	28.56	28.8	28.56	28.71	121000.0
2005-01-31	CNXT	ETF	1.66	1.691	1.63	1.64	4647852.0
2005-01-31	CPI	ETF	19.55	19.55	19.55	19.55	200.0
2005-01-31	CSB	ETF	35.91	36.16	35.86	36.16	4100.0
2005-01-31	CSM	ETF	2.38	2.3825	2.38	2.3825	1200.0
2005-01-31	CTEC	ETF	66.69999999999999	66.9	61.39999999999999	62.75	64201.4
2005-01-31	CURE	ETF	0.61	0.6162	0.6075	0.6125	823144.0
2005-01-31	CYA	ETF	201.0	212.2	201.0	208.6	760.0
2005-01-31	CYB	ETF	4.15	4.15	3.9	4.05	12900.0
2005-01-31	CZA	ETF	10.32	10.32	10.3	10.3	5200.0
2005-01-31	DGT	ETF	63.01	63.16	62.98	63.14	6500.0
2005-01-31	DIG	ETF	11.9375	11.95	11.9375	11.9375	1680.0
2005-01-31	DIV	ETF	14.23	14.33	14.21	14.3	16000.0
2005-01-31	DJP	ETF	26.72	26.72	26.72	26.72	200.0
2005-01-31	DRIV	ETF	38.96	39.64	38.32	39.11	893202.0
2005-01-31	DSI	ETF	5.905	5.95	5.905	5.925	11600.0
2005-01-31	DTH	ETF	25.39	25.42	25.39	25.42	800.0

> showing 50 of 256 rows — these rows as CSV

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