PREVIEW / etf_daily / 2005-08-01

all etf daily files

  file:    by_date/etf_daily/2005/2005-08-01.parquet
  size:    15 KB
  rows:    276

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-08-01	SPY	ETF	123.83	124.04	123.45	123.65	40418200.0
2005-08-01	QQQ	ETF	39.64	39.83	39.52	39.65	59877291.0
2005-08-01	IWM	ETF	67.94	68.25	67.72	67.86	19025900.0
2005-08-01	DIA	ETF	106.72	106.72	106.1	106.19	4700800.0
2005-08-01	GLD	ETF	43.08	43.17	42.99	43.13	1493900.0
2005-08-01	TLT	ETF	92.5	92.6	92.02	92.42	1760300.0
2005-08-01	AAA	ETF	53.05	53.08	52.65	52.66	27000.0
2005-08-01	ADRE	ETF	99.0	99.9	96.95	97.98	13836.0
2005-08-01	AFK	ETF	25.85	25.85	25.73	25.8	4300.0
2005-08-01	AGG	ETF	101.59	101.65	101.38	101.59	220300.0
2005-08-01	AIQ	ETF	51.45	52.55	51.0	51.15	19720.0
2005-08-01	AIS	ETF	1.0615	1.1	1.0615	1.09	31800.0
2005-08-01	ARB	ETF	41.25	41.82	41.22	41.66	271200.0
2005-08-01	BAB	ETF	49.79	50.3	49.79	50.06	35300.0
2005-08-01	BBH	ETF	63.0533	65.4267	63.0533	65.1333	1439700.0
2005-08-01	BCM	ETF	65.55	66.19	65.55	66.12	15000.0
2005-08-01	BIS	ETF	657.6	657.6	657.6	657.6	6.25
2005-08-01	BITS	ETF	13.28	13.68	13.0	13.6	2838.0
2005-08-01	BKF	ETF	34.09	34.3	34.09	34.2	5700.0
2005-08-01	BNE	ETF	13.72	13.95	13.69	13.86	462700.0
2005-08-01	BRF	ETF	15.49	15.5	15.39	15.42	20300.0
2005-08-01	BTF	ETF	87.75	87.75	87.24999999999999	87.3	8400.0
2005-08-01	CBON	ETF	33.07	33.65	33.07	33.65	20582.0
2005-08-01	CDC	ETF	6.0	6.1	5.85	5.95	7100.0
2005-08-01	CDL	ETF	12.29	12.86	12.27	12.71	366900.0
2005-08-01	CEF	ETF	5.28	5.29	5.25	5.26	208600.0
2005-08-01	CHB	ETF	12.1	12.63	12.1	12.57	474100.0
2005-08-01	CHI	ETF	20.41	20.47	20.31	20.4	77500.0
2005-08-01	CHIC	ETF	14.59	14.96	14.48	14.72	120238.0
2005-08-01	CHIR	ETF	36.4599	36.9999	36.2001	36.51	864123.0
2005-08-01	CHY	ETF	16.76	16.78	16.621	16.68	131100.0
2005-08-01	CIL	ETF	25.98	25.98	25.88	25.88	500.0
2005-08-01	CN	ETF	31.3	32.18	31.3	31.75	34700.0
2005-08-01	CNXT	ETF	1.9	1.97	1.9	1.95	3606356.0
2005-08-01	CPI	ETF	23.42	23.42	23.42	23.42	100.0
2005-08-01	CPST	ETF	1.85	1.96	1.82	1.94	1071139.0
2005-08-01	CSB	ETF	30.3	30.36	30.15	30.15	4100.0
2005-08-01	CSQ	ETF	14.52	14.54	14.34	14.41	309600.0
2005-08-01	CTEC	ETF	56.25	56.9	55.99999999999999	56.199999999999996	3281.6000000000004
2005-08-01	CURE	ETF	0.2825	0.325	0.2812	0.315	2689512.0
2005-08-01	CYA	ETF	125.0	126.0	120.0	126.0	515.0
2005-08-01	CYB	ETF	3.6	3.8	3.6	3.7	55500.0
2005-08-01	DGT	ETF	64.27	64.61	64.25	64.46	32300.0
2005-08-01	DIG	ETF	12.2125	12.5	12.2125	12.5	160.0
2005-08-01	DIV	ETF	13.85	13.97	13.85	13.91	33200.0
2005-08-01	DRIV	ETF	39.4	40.32	39.36	39.461	1367554.0
2005-08-01	DSI	ETF	5.815	5.815	5.815	5.815	3000.0
2005-08-01	DUSA	ETF	9.34	9.5	9.245	9.245	174443.0
2005-08-01	DVY	ETF	64.15	64.15	63.66	63.75	963500.0
2005-08-01	EDEN	ETF	0.78	0.82	0.66	0.73	236467.0

> showing 50 of 276 rows — these rows as CSV

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