PREVIEW / etf_daily / 2005-09-07

all etf daily files

  file:    by_date/etf_daily/2005/2005-09-07.parquet
  size:    15 KB
  rows:    275

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-09-07	SPY	ETF	123.63	124.13	123.46	123.91	41749700.0
2005-09-07	QQQ	ETF	39.3	39.479	39.21	39.409	57470407.0
2005-09-07	IWM	ETF	67.13	67.47	66.88	67.36	14230200.0
2005-09-07	DIA	ETF	105.81	106.37	105.71	106.23	7275000.0
2005-09-07	GLD	ETF	44.41	44.49	44.29	44.33	1300700.0
2005-09-07	TLT	ETF	94.18	94.18	93.36	93.6	1090200.0
2005-09-07	AAA	ETF	58.9	58.9	58.4	58.45	96800.0
2005-09-07	ADRE	ETF	102.99	102.99	102.4	102.74	25752.0
2005-09-07	AFK	ETF	25.86	25.95	25.85	25.92	6700.0
2005-09-07	AGG	ETF	102.29	102.33	102.1	102.23	96300.0
2005-09-07	AIQ	ETF	44.45	45.0	43.75	44.7	9540.0
2005-09-07	AIS	ETF	0.92	0.93	0.9	0.93	72300.0
2005-09-07	ARB	ETF	42.76	42.78	42.22	42.58	106100.0
2005-09-07	BAB	ETF	52.87	53.48	52.84	53.48	49500.0
2005-09-07	BBC	ETF	7.05	7.05	6.86	7.0	34400.0
2005-09-07	BBH	ETF	66.3667	66.3667	65.58	65.9167	1666200.0
2005-09-07	BCM	ETF	59.75	59.91	59.49	59.78	295100.0
2005-09-07	BIS	ETF	707.2	707.2	707.2	707.2	1.25
2005-09-07	BITS	ETF	12.52	12.52	12.0	12.16	2550.0
2005-09-07	BKF	ETF	32.5	34.2	32.5	33.43	72600.0
2005-09-07	BNE	ETF	14.86	14.86	14.67	14.74	79400.0
2005-09-07	BRF	ETF	15.5	15.51	15.5	15.51	12200.0
2005-09-07	BTF	ETF	86.05	86.05	85.89999999999999	85.89999999999999	440.0
2005-09-07	CBON	ETF	34.24	34.24	33.0	33.23	7750.0
2005-09-07	CDC	ETF	3.3	3.3	3.3	3.3	3600.0
2005-09-07	CDL	ETF	13.12	13.22	12.95	13.15	207300.0
2005-09-07	CEF	ETF	5.37	5.45	5.37	5.41	146400.0
2005-09-07	CEW	ETF	25.81	25.81	25.81	25.81	300.0
2005-09-07	CHB	ETF	13.1	13.17	12.91	13.1	544300.0
2005-09-07	CHI	ETF	20.72	20.72	20.55	20.64	61100.0
2005-09-07	CHIC	ETF	14.0	14.53	13.97	14.5	267969.0
2005-09-07	CHIR	ETF	43.4799	44.5401	43.4499	44.34	3734104.0
2005-09-07	CHY	ETF	16.62	16.62	16.56	16.62	72100.0
2005-09-07	CIL	ETF	25.89	25.89	25.89	25.89	300.0
2005-09-07	CN	ETF	33.9	33.91	33.63	33.68	83400.0
2005-09-07	CNXT	ETF	1.71	1.72	1.68	1.71	4804542.0
2005-09-07	CPI	ETF	23.75	23.75	23.75	23.75	300.0
2005-09-07	CPST	ETF	5.0	5.17	4.94	5.08	5571376.0
2005-09-07	CSB	ETF	31.73	31.86	31.54	31.74	47400.0
2005-09-07	CSM	ETF	2.43	2.43	2.43	2.43	800.0
2005-09-07	CSQ	ETF	14.39	14.4	14.29	14.38	294500.0
2005-09-07	CTEC	ETF	48.75	50.0	47.35	48.49999999999999	5382.400000000001
2005-09-07	CURE	ETF	0.2662	0.2925	0.2662	0.285	411856.0
2005-09-07	CYA	ETF	61.4	64.0	60.2	63.6	450.0
2005-09-07	CYB	ETF	3.65	3.7	3.62	3.68	2400.0
2005-09-07	DGT	ETF	65.25	65.54	65.25	65.43	4400.0
2005-09-07	DIG	ETF	13.3625	13.3625	13.3625	13.3625	400.0
2005-09-07	DIV	ETF	13.83	13.83	13.7	13.76	10300.0
2005-09-07	DRIV	ETF	39.38	39.69	39.01	39.57	389962.0
2005-09-07	DSI	ETF	5.82	5.82	5.82	5.82	4000.0

> showing 50 of 275 rows — these rows as CSV

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