PREVIEW / etf_daily / 2005-01-20

all etf daily files

  file:    by_date/etf_daily/2005/2005-01-20.parquet
  size:    14 KB
  rows:    251

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-01-20	SPY	ETF	117.89	118.2	117.29	117.5	72049300.0
2005-01-20	QQQ	ETF	37.65	37.811	37.32	37.35	121107333.0
2005-01-20	IWM	ETF	61.07	61.485	60.815	60.92	29061600.0
2005-01-20	DIA	ETF	105.06	105.48	104.58	104.76	8661700.0
2005-01-20	GLD	ETF	42.12	42.32	42.11	42.25	1276200.0
2005-01-20	TLT	ETF	90.42	91.02	90.35	90.91	1064200.0
2005-01-20	AAA	ETF	56.35	56.7	56.29	56.4	6000.0
2005-01-20	ADRE	ETF	78.5	79.81	78.5	79.513	4192.0
2005-01-20	AFK	ETF	26.5	26.61	26.49	26.61	4600.0
2005-01-20	AGG	ETF	102.79	103.01	102.6	102.98	98400.0
2005-01-20	AIQ	ETF	64.0	64.5	60.0	63.95	122180.0
2005-01-20	ARB	ETF	37.56	37.68	37.15	37.51	149600.0
2005-01-20	BAB	ETF	46.43	46.59	46.02	46.23	23500.0
2005-01-20	BBH	ETF	49.46	49.65	48.6667	48.8	1957800.0
2005-01-20	BCM	ETF	56.19	56.19	55.78	55.88	27300.0
2005-01-20	BIS	ETF	960.0	971.2	960.0	971.2	56.0
2005-01-20	BITS	ETF	10.52	10.68	9.4	9.4	17260.0
2005-01-20	BKF	ETF	36.0	37.05	36.0	36.81	24600.0
2005-01-20	BNE	ETF	14.9	15.09	14.88	14.9	205800.0
2005-01-20	BOSS	ETF	24.51	24.51	24.45	24.45	100.0
2005-01-20	BRF	ETF	15.61	15.69	15.59	15.61	7800.0
2005-01-20	BTF	ETF	90.25	90.25	89.25	90.0	820.0
2005-01-20	CBON	ETF	28.0	28.28	27.2	28.28	172831.0
2005-01-20	CDC	ETF	10.15	10.15	9.62	9.78	5900.0
2005-01-20	CDL	ETF	14.07	14.3	13.94	14.09	244400.0
2005-01-20	CEF	ETF	5.24	5.24	5.19	5.23	211000.0
2005-01-20	CEW	ETF	27.46	27.46	27.46	27.46	400.0
2005-01-20	CHB	ETF	11.08	11.16	10.85	10.89	374400.0
2005-01-20	CHIC	ETF	9.6	9.95	9.39	9.56	992936.0
2005-01-20	CHIR	ETF	34.4601	34.8099	34.1199	34.5	1397949.0
2005-01-20	CID	ETF	9.45	9.5	9.45	9.5	13100.0
2005-01-20	CIL	ETF	26.28	26.38	26.16	26.16	1200.0
2005-01-20	CN	ETF	28.35	28.6	28.3	28.4	442000.0
2005-01-20	CNXT	ETF	1.575	1.85	1.549	1.64	24806934.0
2005-01-20	CPI	ETF	18.45	18.45	18.45	18.45	200.0
2005-01-20	CSB	ETF	35.99	36.02	35.8	35.8	2900.0
2005-01-20	CTEC	ETF	50.949999999999996	52.199999999999996	48.89999999999999	49.05	18587.8
2005-01-20	CURE	ETF	0.6562	0.6813	0.6475	0.6663	1169608.0
2005-01-20	CYA	ETF	202.0	202.0	193.0	196.0	895.0
2005-01-20	CYB	ETF	4.45	4.45	4.26	4.35	11100.0
2005-01-20	DGT	ETF	62.53	62.74	62.5	62.58	2400.0
2005-01-20	DIV	ETF	14.15	14.19	14.06	14.08	19300.0
2005-01-20	DJP	ETF	26.7	26.71	26.7	26.71	500.0
2005-01-20	DRIV	ETF	32.86	33.6	32.521	32.58	813926.0
2005-01-20	DSI	ETF	5.92	5.92	5.905	5.905	4200.0
2005-01-20	DTH	ETF	25.36	25.45	25.35	25.37	1400.0
2005-01-20	DUSA	ETF	15.0	15.35	14.82	14.88	126725.0
2005-01-20	DVY	ETF	59.49	59.55	59.11	59.31	418500.0
2005-01-20	EDEN	ETF	1.2	1.29	1.2	1.2	74410.0
2005-01-20	EDV	ETF	26.3	26.4	26.3	26.38	14400.0

> showing 50 of 251 rows — these rows as CSV

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