PREVIEW / etf_daily / 2005-07-08

all etf daily files

  file:    by_date/etf_daily/2005/2005-07-08.parquet
  size:    15 KB
  rows:    272

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-07-08	SPY	ETF	119.97	121.32	119.72	121.32	64491200.0
2005-07-08	QQQ	ETF	37.08	37.81	36.993	37.77	101469272.0
2005-07-08	IWM	ETF	64.64	66.02	64.55	65.97	24967200.0
2005-07-08	DIA	ETF	103.22	104.63	103.06	104.56	8886100.0
2005-07-08	GLD	ETF	42.32	42.4	42.12	42.26	824200.0
2005-07-08	TLT	ETF	95.25	95.25	94.32	94.63	1259300.0
2005-07-08	AAA	ETF	50.01	50.57	49.98	50.5	15400.0
2005-07-08	ADRE	ETF	99.25	99.25	91.86	92.36	9752.0
2005-07-08	AFK	ETF	25.99	25.99	25.9	25.9	44700.0
2005-07-08	AGG	ETF	102.59	102.7	102.39	102.42	231100.0
2005-07-08	AIQ	ETF	53.9	57.2	53.5	55.45	50260.0
2005-07-08	AIS	ETF	1.19	1.2	1.16	1.2	261200.0
2005-07-08	ARB	ETF	42.9	43.5	42.76	43.5	120300.0
2005-07-08	BAB	ETF	46.55	47.15	46.32	47.15	55100.0
2005-07-08	BBH	ETF	58.1067	59.36	57.93	59.1667	2128500.0
2005-07-08	BCM	ETF	62.27	62.58	62.22	62.58	45100.0
2005-07-08	BIS	ETF	617.6	620.8	604.8	604.8	20.0
2005-07-08	BITS	ETF	14.6	14.64	13.8	13.84	15086.0
2005-07-08	BKF	ETF	37.37	37.5	37.18	37.5	26700.0
2005-07-08	BNE	ETF	14.31	14.56	14.25	14.3	414000.0
2005-07-08	BRF	ETF	15.5	15.54	15.45	15.5	10100.0
2005-07-08	BTF	ETF	86.3	87.89999999999999	86.1	87.79999999999998	3260.0
2005-07-08	CBON	ETF	31.37	31.47	30.99	31.25	64612.0
2005-07-08	CDC	ETF	6.7	6.9	6.7	6.8	900.0
2005-07-08	CDL	ETF	11.75	11.8	11.6	11.75	370800.0
2005-07-08	CEF	ETF	5.24	5.25	5.19	5.24	251500.0
2005-07-08	CEW	ETF	26.62	26.62	26.55	26.55	5000.0
2005-07-08	CHB	ETF	10.12	10.55	10.06	10.38	325000.0
2005-07-08	CHI	ETF	20.0	20.15	19.95	20.11	73700.0
2005-07-08	CHIC	ETF	12.97	12.97	12.46	12.76	153491.0
2005-07-08	CHIR	ETF	35.1699	36.3099	34.74	36.2199	888774.0
2005-07-08	CHY	ETF	16.76	16.84	16.64	16.76	140200.0
2005-07-08	CIL	ETF	25.8	25.8	25.8	25.8	100.0
2005-07-08	CN	ETF	28.76	29.5	28.76	29.17	12400.0
2005-07-08	CNXT	ETF	1.64	1.72	1.63	1.72	6504625.0
2005-07-08	CPST	ETF	1.52	1.64	1.52	1.63	887892.0
2005-07-08	CSB	ETF	28.5	28.8	28.45	28.78	16100.0
2005-07-08	CSM	ETF	2.4075	2.4125	2.4075	2.4125	6400.0
2005-07-08	CSQ	ETF	14.05	14.25	14.05	14.16	630900.0
2005-07-08	CTEC	ETF	55.8	55.8	54.9	55.14999999999999	6530.0
2005-07-08	CURE	ETF	0.2975	0.3075	0.2925	0.305	662304.0
2005-07-08	CYA	ETF	136.0	139.0	136.0	139.0	50.0
2005-07-08	CYB	ETF	2.95	3.1	2.9	3.1	6700.0
2005-07-08	DGT	ETF	63.24	63.71	63.2	63.68	7900.0
2005-07-08	DIG	ETF	12.325	12.325	12.3125	12.3125	800.0
2005-07-08	DIV	ETF	13.85	13.92	13.85	13.88	11500.0
2005-07-08	DRIV	ETF	33.1	34.2	33.01	34.01	625281.0
2005-07-08	DUSA	ETF	9.37	9.63	9.25	9.48	247580.0
2005-07-08	DVY	ETF	62.1	62.79	62.01	62.78	357800.0
2005-07-08	EDEN	ETF	1.1	1.13	0.99	1.09	181114.0

> showing 50 of 272 rows — these rows as CSV

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