PREVIEW / etf_daily / 2005-08-17

all etf daily files

  file:    by_date/etf_daily/2005/2005-08-17.parquet
  size:    15 KB
  rows:    277

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-17	SPY	ETF	122.19	122.87	122.03	122.2	62275100.0
2005-08-17	QQQ	ETF	38.92	39.17	38.79	39.04	75633803.0
2005-08-17	IWM	ETF	65.0	65.59	64.84	64.98	21158800.0
2005-08-17	DIA	ETF	105.39	106.11	105.28	105.68	6394900.0
2005-08-17	GLD	ETF	44.26	44.3	43.72	43.91	1990300.0
2005-08-17	TLT	ETF	93.51	93.73	92.98	93.1	1278200.0
2005-08-17	AAA	ETF	55.81	56.16	55.81	56.1	3400.0
2005-08-17	ADRE	ETF	99.1	100.0	98.67	99.472	10076.0
2005-08-17	AFK	ETF	25.21	25.72	25.21	25.72	4800.0
2005-08-17	AGG	ETF	101.89	101.96	101.5	101.77	119100.0
2005-08-17	AIQ	ETF	47.4	47.4	46.25	46.6	5760.0
2005-08-17	AIS	ETF	0.93	0.95	0.91	0.92	54900.0
2005-08-17	ARB	ETF	41.9	42.7	41.64	42.56	244800.0
2005-08-17	BAB	ETF	51.7	52.0	51.61	51.94	20600.0
2005-08-17	BBH	ETF	63.2367	63.5067	62.8267	62.9667	987000.0
2005-08-17	BCM	ETF	58.1	58.25	57.75	57.86	20900.0
2005-08-17	BITS	ETF	13.12	13.2	12.4	12.84	6908.0
2005-08-17	BKF	ETF	31.42	31.74	31.3	31.66	9500.0
2005-08-17	BNE	ETF	13.68	13.9	13.66	13.85	106000.0
2005-08-17	BOSS	ETF	26.5	26.5	26.0	26.0	200.0
2005-08-17	BRF	ETF	15.49	15.6	15.49	15.57	11200.0
2005-08-17	BTF	ETF	85.85000000000001	85.85000000000001	85.64999999999999	85.74999999999999	480.0
2005-08-17	CBON	ETF	32.72	33.0	32.5	32.5	4033.0
2005-08-17	CDC	ETF	3.4	3.5	3.4	3.4	7500.0
2005-08-17	CDL	ETF	13.5	13.62	13.39	13.51	243300.0
2005-08-17	CEF	ETF	5.4	5.4	5.33	5.38	648700.0
2005-08-17	CEW	ETF	27.1	27.1	26.95	26.95	700.0
2005-08-17	CHB	ETF	11.91	11.97	11.66	11.86	375700.0
2005-08-17	CHI	ETF	20.4	20.44	20.19	20.2	61900.0
2005-08-17	CHIC	ETF	13.79	14.37	13.74	14.15	319550.0
2005-08-17	CHIR	ETF	36.0999	36.33	35.6301	35.9499	560110.0
2005-08-17	CHY	ETF	16.29	16.309	16.17	16.24	121900.0
2005-08-17	CIL	ETF	25.85	25.85	25.85	25.85	2400.0
2005-08-17	CIZ	ETF	23.55	23.55	23.55	23.55	400.0
2005-08-17	CN	ETF	34.85	34.85	34.17	34.3	8000.0
2005-08-17	CNXT	ETF	1.58	1.66	1.58	1.63	3558944.0
2005-08-17	CPST	ETF	2.9	3.11	2.9	3.1	1101080.0
2005-08-17	CSB	ETF	31.65	31.7	31.46	31.65	6200.0
2005-08-17	CSM	ETF	2.4175	2.4175	2.4175	2.4175	4000.0
2005-08-17	CSQ	ETF	14.1	14.14	14.03	14.14	257100.0
2005-08-17	CTEC	ETF	54.05	55.0	52.699999999999996	53.75	6465.200000000001
2005-08-17	CURE	ETF	0.25	0.2512	0.2375	0.2462	1126448.0
2005-08-17	CYA	ETF	63.0	68.0	63.0	68.0	1180.0
2005-08-17	CYB	ETF	3.5	3.55	3.45	3.55	8500.0
2005-08-17	DGT	ETF	64.77	64.77	64.59	64.62	1800.0
2005-08-17	DIG	ETF	13.325	13.325	13.1875	13.2	18240.0
2005-08-17	DIV	ETF	13.68	13.68	13.56	13.6	14800.0
2005-08-17	DRIV	ETF	38.06	38.68	37.76	38.41	578378.0
2005-08-17	DSI	ETF	5.725	5.755	5.725	5.755	2800.0
2005-08-17	DUSA	ETF	10.97	11.16	10.9	10.99	56347.0

> showing 50 of 277 rows — these rows as CSV

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