PREVIEW / etf_daily / 2005-04-18

all etf daily files

  file:    by_date/etf_daily/2005/2005-04-18.parquet
  size:    14 KB
  rows:    259

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-04-18	SPY	ETF	114.12	114.96	113.96	114.5	100035200.0
2005-04-18	QQQ	ETF	34.73	35.1	34.64	34.75	110713926.0
2005-04-18	IWM	ETF	57.71	58.38	57.31	58.19	35293400.0
2005-04-18	DIA	ETF	100.62	101.01	100.11	100.55	13000100.0
2005-04-18	GLD	ETF	42.55	42.78	42.52	42.69	909800.0
2005-04-18	TLT	ETF	91.37	91.39	90.94	91.02	3510800.0
2005-04-18	AAA	ETF	67.78	68.93	67.78	68.85	10300.0
2005-04-18	ADRE	ETF	80.3	80.99	79.37	80.82	12532.0
2005-04-18	AFK	ETF	25.8	25.8	25.67	25.67	4300.0
2005-04-18	AGG	ETF	102.09	102.1	101.73	101.94	153400.0
2005-04-18	AIQ	ETF	48.6	49.5	47.0	48.55	31420.0
2005-04-18	ARB	ETF	42.73	42.98	42.27	42.5	362200.0
2005-04-18	BAB	ETF	47.75	47.86	47.34	47.7	26400.0
2005-04-18	BBH	ETF	51.03	51.1067	50.4033	51.0333	2445000.0
2005-04-18	BCM	ETF	58.29	59.11	58.29	58.92	13600.0
2005-04-18	BIS	ETF	596.8	596.8	595.2	596.8	32.5
2005-04-18	BITS	ETF	11.92	11.92	10.64	11.56	15760.0
2005-04-18	BKF	ETF	37.5	37.7	37.32	37.7	15400.0
2005-04-18	BNE	ETF	14.3	14.33	14.1	14.25	327200.0
2005-04-18	BRF	ETF	15.44	15.44	15.32	15.41	6500.0
2005-04-18	BTF	ETF	86.25	86.5	85.74999999999999	86.35	1080.0
2005-04-18	CBON	ETF	25.25	25.3	25.02	25.02	9160.0
2005-04-18	CDC	ETF	7.75	7.9	7.75	7.9	900.0
2005-04-18	CDL	ETF	13.34	13.41	13.22	13.29	182400.0
2005-04-18	CEF	ETF	5.29	5.35	5.24	5.27	263600.0
2005-04-18	CEW	ETF	26.6	26.6	26.41	26.41	900.0
2005-04-18	CHB	ETF	8.65	8.68	8.33	8.38	1135300.0
2005-04-18	CHIC	ETF	11.3	11.45	11.27	11.33	204712.0
2005-04-18	CHIR	ETF	35.4501	36.0501	35.3901	35.67	1183086.0
2005-04-18	CID	ETF	9.52	9.52	9.46	9.5	3300.0
2005-04-18	CIL	ETF	26.01	26.01	26.01	26.01	300.0
2005-04-18	CIZ	ETF	20.4	20.4	20.4	20.4	200.0
2005-04-18	CN	ETF	25.75	25.92	25.41	25.71	36900.0
2005-04-18	CNXT	ETF	1.21	1.24	1.17	1.21	6156346.0
2005-04-18	CSB	ETF	32.42	32.75	32.38	32.5	18700.0
2005-04-18	CSM	ETF	2.385	2.385	2.3825	2.385	24000.0
2005-04-18	CTEC	ETF	52.15	55.35	51.5	52.949999999999996	11387.2
2005-04-18	CURE	ETF	0.3275	0.3463	0.3187	0.3262	647968.0
2005-04-18	CYA	ETF	160.0	162.8	160.0	161.8	300.0
2005-04-18	CYB	ETF	4.34	4.34	4.17	4.28	3500.0
2005-04-18	DGT	ETF	62.01	62.55	62.01	62.38	26400.0
2005-04-18	DIG	ETF	11.45	11.45	11.45	11.45	800.0
2005-04-18	DIV	ETF	12.95	13.06	12.91	12.92	12600.0
2005-04-18	DJP	ETF	27.11	27.11	27.11	27.11	400.0
2005-04-18	DRIV	ETF	28.17	28.93	27.64	28.53	847426.0
2005-04-18	DSI	ETF	5.855	5.855	5.85	5.85	2800.0
2005-04-18	DUSA	ETF	8.84	8.84	8.66	8.73	53801.0
2005-04-18	DVY	ETF	57.81	58.69	57.8	58.62	1162000.0
2005-04-18	EDEN	ETF	0.53	0.58	0.53	0.57	4800.0
2005-04-18	EDV	ETF	25.78	25.88	25.77	25.84	12300.0

> showing 50 of 259 rows — these rows as CSV

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