PREVIEW / etf_daily / 2005-06-21

all etf daily files

  file:    by_date/etf_daily/2005/2005-06-21.parquet
  size:    15 KB
  rows:    264

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-06-21	SPY	ETF	121.5	121.65	121.03	121.47	39879800.0
2005-06-21	QQQ	ETF	37.84	38.011	37.7	37.85	97916236.0
2005-06-21	IWM	ETF	63.85	63.99	63.53	63.86	13798200.0
2005-06-21	DIA	ETF	105.98	106.2	105.69	106.0	3861400.0
2005-06-21	GLD	ETF	43.58	43.82	43.42	43.81	672600.0
2005-06-21	TLT	ETF	94.38	94.86	94.32	94.86	503100.0
2005-06-21	AAA	ETF	57.7	57.7	57.32	57.46	1600.0
2005-06-21	ADRE	ETF	92.69	92.69	91.28	91.399	6560.0
2005-06-21	AFK	ETF	26.09	26.33	25.91	26.26	5100.0
2005-06-21	AGG	ETF	102.67	102.82	102.41	102.82	75100.0
2005-06-21	AIQ	ETF	52.85	52.85	51.5	51.9	8600.0
2005-06-21	AIS	ETF	0.98	1.06	0.94	1.04	190300.0
2005-06-21	ARB	ETF	43.79	44.0	43.66	43.84	121200.0
2005-06-21	BAB	ETF	49.89	50.81	49.89	50.43	25100.0
2005-06-21	BBH	ETF	57.3	57.4567	56.39	56.5	1414800.0
2005-06-21	BCM	ETF	61.5	61.71	61.5	61.6	9000.0
2005-06-21	BIS	ETF	601.6	622.4	600.0	622.4	25.0
2005-06-21	BITS	ETF	13.24	13.28	12.6	13.0	7360.0
2005-06-21	BKF	ETF	38.91	38.92	38.3	38.4	16200.0
2005-06-21	BNE	ETF	13.88	13.99	13.8	13.9	85700.0
2005-06-21	BRF	ETF	15.41	15.49	15.41	15.49	9100.0
2005-06-21	BTF	ETF	86.64999999999999	86.75	86.54999999999998	86.69999999999999	340.0
2005-06-21	CBON	ETF	31.1	31.95	31.08	31.94	25652.0
2005-06-21	CDC	ETF	7.0	7.2	6.92	7.05	10400.0
2005-06-21	CDL	ETF	12.05	12.1	11.9	11.91	560400.0
2005-06-21	CEF	ETF	5.32	5.37	5.31	5.36	255600.0
2005-06-21	CEW	ETF	26.5	26.576	26.47	26.47	2500.0
2005-06-21	CHB	ETF	9.99	10.08	9.81	9.93	312100.0
2005-06-21	CHI	ETF	19.62	19.67	19.47	19.53	123700.0
2005-06-21	CHIC	ETF	12.46	12.92	12.17	12.8	144078.0
2005-06-21	CHIR	ETF	35.7999	35.97	34.86	35.1501	1147488.0
2005-06-21	CHY	ETF	16.25	16.33	16.2	16.21	128800.0
2005-06-21	CN	ETF	27.72	27.97	27.65	27.76	34400.0
2005-06-21	CNXT	ETF	1.55	1.62	1.52	1.56	5351829.0
2005-06-21	CPI	ETF	23.81	23.81	23.81	23.81	2200.0
2005-06-21	CPST	ETF	1.35	1.4	1.29	1.31	1051168.0
2005-06-21	CSB	ETF	30.2	30.6	30.17	30.59	23700.0
2005-06-21	CSQ	ETF	13.85	13.9	13.8	13.86	369300.0
2005-06-21	CTEC	ETF	50.49999999999999	51.25	50.0	50.99999999999999	14898.800000000001
2005-06-21	CURE	ETF	0.265	0.2662	0.2587	0.2587	1050784.0
2005-06-21	CYA	ETF	141.0	143.6	138.2	143.0	70.0
2005-06-21	CYB	ETF	3.3	3.34	3.17	3.19	9000.0
2005-06-21	DGT	ETF	64.09	64.4	64.09	64.24	1100.0
2005-06-21	DIV	ETF	13.8	13.88	13.7	13.71	24200.0
2005-06-21	DRIV	ETF	29.5	31.63	29.41	31.63	1825963.0
2005-06-21	DSI	ETF	5.925	5.925	5.925	5.925	6200.0
2005-06-21	DUSA	ETF	9.86	9.91	9.33	9.46	265900.0
2005-06-21	DVY	ETF	62.35	62.49	62.16	62.3	369800.0
2005-06-21	EDEN	ETF	0.66	0.69	0.66	0.68	2584.0
2005-06-21	EDV	ETF	25.84	25.97	25.84	25.93	35700.0

> showing 50 of 264 rows — these rows as CSV

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