PREVIEW / etf_daily / 2005-08-31

all etf daily files

  file:    by_date/etf_daily/2005/2005-08-31.parquet
  size:    15 KB
  rows:    280

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-31	SPY	ETF	121.19	122.66	120.74	122.58	102945200.0
2005-08-31	QQQ	ETF	38.64	39.01	38.478	38.98	93451985.0
2005-08-31	IWM	ETF	65.15	66.53	64.92	66.53	25306700.0
2005-08-31	DIA	ETF	104.08	104.98	103.54	104.89	9550100.0
2005-08-31	GLD	ETF	43.1	43.4	43.03	43.4	2416500.0
2005-08-31	TLT	ETF	95.31	96.0	95.3	95.99	1310800.0
2005-08-31	AAA	ETF	56.2	56.95	56.2	56.93	3900.0
2005-08-31	ADRE	ETF	98.68	99.4	97.934	99.4	525144.0
2005-08-31	AFK	ETF	25.9	25.96	25.9	25.9	5400.0
2005-08-31	AGG	ETF	102.69	102.91	102.43	102.85	112200.0
2005-08-31	AIQ	ETF	45.35	46.15	44.3	46.15	15460.0
2005-08-31	AIS	ETF	0.9	0.91	0.85	0.91	131700.0
2005-08-31	ARB	ETF	41.95	42.0	41.33	42.0	220400.0
2005-08-31	BAB	ETF	50.3	50.37	49.61	50.11	41600.0
2005-08-31	BBC	ETF	6.87	6.9	6.78	6.8	54000.0
2005-08-31	BBH	ETF	64.0067	65.4333	64.0	65.3333	2964900.0
2005-08-31	BCM	ETF	58.75	59.12	58.75	59.06	176900.0
2005-08-31	BIS	ETF	675.2	688.0	670.4	688.0	40.6
2005-08-31	BITS	ETF	12.2	12.52	12.0	12.4224	4820.0
2005-08-31	BKF	ETF	31.85	32.4	31.63	32.38	51700.0
2005-08-31	BNE	ETF	13.65	14.23	13.57	14.2	143800.0
2005-08-31	BRF	ETF	15.55	15.56	15.55	15.56	1100.0
2005-08-31	BTF	ETF	85.39999999999999	85.5	84.94999999999999	85.39999999999999	1080.0
2005-08-31	CBON	ETF	33.45	34.25	33.24	34.25	41620.0
2005-08-31	CDC	ETF	3.45	3.7	3.45	3.45	9800.0
2005-08-31	CDL	ETF	13.6	13.6	13.18	13.5	431500.0
2005-08-31	CEF	ETF	5.25	5.29	5.23	5.25	403500.0
2005-08-31	CEW	ETF	26.18	26.18	26.08	26.08	700.0
2005-08-31	CHB	ETF	11.77	13.47	11.7	13.33	2881700.0
2005-08-31	CHI	ETF	20.15	20.3	20.11	20.17	106400.0
2005-08-31	CHIC	ETF	13.94	13.99	13.6	13.73	280070.0
2005-08-31	CHIR	ETF	36.8799	37.2	35.9001	36.4401	3935256.0
2005-08-31	CHY	ETF	16.4	16.46	16.35	16.43	69600.0
2005-08-31	CIL	ETF	25.84	25.84	25.84	25.84	300.0
2005-08-31	CIZ	ETF	23.15	23.15	22.75	22.75	1800.0
2005-08-31	CN	ETF	34.05	34.05	33.8	34.01	9000.0
2005-08-31	CNXT	ETF	1.66	1.751	1.65	1.72	4560360.0
2005-08-31	CPI	ETF	23.6	23.9	23.6	23.7	2400.0
2005-08-31	CPST	ETF	5.15	5.15	4.7	4.83	20899475.0
2005-08-31	CSB	ETF	30.0	30.58	30.0	30.57	10600.0
2005-08-31	CSM	ETF	2.42	2.42	2.42	2.42	1200.0
2005-08-31	CSQ	ETF	14.27	14.43	14.17	14.4	432300.0
2005-08-31	CTEC	ETF	51.95	52.9	50.7	51.5	6662.200000000001
2005-08-31	CURE	ETF	0.2888	0.2888	0.2762	0.2825	917376.0
2005-08-31	CYA	ETF	64.0	67.0	63.0	66.0	1085.0
2005-08-31	CYB	ETF	3.45	3.75	3.44	3.75	353200.0
2005-08-31	DGT	ETF	63.65	64.09	63.65	64.09	262700.0
2005-08-31	DIV	ETF	13.55	13.64	13.54	13.62	6500.0
2005-08-31	DRIV	ETF	37.72	38.09	37.25	37.98	427197.0
2005-08-31	DSI	ETF	5.725	5.76	5.725	5.76	1800.0

> showing 50 of 280 rows — these rows as CSV

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