PREVIEW / etf_daily / 2005-01-06

all etf daily files

  file:    by_date/etf_daily/2005/2005-01-06.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-06	SPY	ETF	118.44	119.15	118.26	118.61	47814700.0
2005-01-06	QQQ	ETF	38.62	38.71	38.34	38.347	103981120.0
2005-01-06	IWM	ETF	61.67	62.2	61.225	61.615	23061200.0
2005-01-06	DIA	ETF	106.13	106.66	105.83	106.04	8238900.0
2005-01-06	GLD	ETF	42.48	42.56	42.07	42.15	2556400.0
2005-01-06	TLT	ETF	88.29	88.54	88.22	88.34	1057400.0
2005-01-06	AAA	ETF	60.76	60.76	60.28	60.53	4100.0
2005-01-06	ADRE	ETF	79.34	79.39	78.89	79.11	8560.0
2005-01-06	AFK	ETF	26.51	26.51	26.41	26.43	4900.0
2005-01-06	AGG	ETF	102.29	102.37	102.18	102.33	75400.0
2005-01-06	AIQ	ETF	59.5	59.95	56.5	58.55	96080.0
2005-01-06	ARB	ETF	37.93	38.31	37.5	37.5	187800.0
2005-01-06	BAB	ETF	44.97	46.09	44.8	45.45	152500.0
2005-01-06	BBH	ETF	49.6667	50.65	49.6667	50.0	2022600.0
2005-01-06	BCM	ETF	58.56	58.56	57.85	57.98	19300.0
2005-01-06	BIS	ETF	960.0	961.6	960.0	961.6	3.75
2005-01-06	BITS	ETF	9.04	10.472	9.04	9.68	49638.0
2005-01-06	BKF	ETF	36.19	36.74	36.06	36.49	39000.0
2005-01-06	BNE	ETF	15.08	15.37	15.08	15.22	171400.0
2005-01-06	BRF	ETF	15.88	15.94	15.88	15.88	4300.0
2005-01-06	BTF	ETF	91.25	91.25	90.15	90.74999999999999	1040.0
2005-01-06	CBON	ETF	29.4	29.7	29.05	29.06	8358.0
2005-01-06	CDC	ETF	11.75	11.75	11.45	11.54	14300.0
2005-01-06	CDL	ETF	15.05	15.12	14.95	15.0	423000.0
2005-01-06	CEF	ETF	5.26	5.28	5.2	5.26	312200.0
2005-01-06	CEW	ETF	27.35	27.35	27.32	27.32	1200.0
2005-01-06	CHB	ETF	11.82	11.88	11.48	11.51	536200.0
2005-01-06	CHIC	ETF	10.1	10.44	10.04	10.1	202649.0
2005-01-06	CHIR	ETF	35.0001	36.2301	35.0001	35.9601	3002219.0
2005-01-06	CID	ETF	9.57	9.6	9.57	9.6	400.0
2005-01-06	CIL	ETF	26.23	26.33	26.23	26.33	400.0
2005-01-06	CIZ	ETF	20.75	20.75	20.75	20.75	100.0
2005-01-06	CN	ETF	27.05	27.2	26.91	27.1	598700.0
2005-01-06	CNXT	ETF	1.82	1.84	1.75	1.77	6070173.0
2005-01-06	CSB	ETF	36.04	36.26	36.0	36.24	4600.0
2005-01-06	CSM	ETF	2.3775	2.3825	2.3775	2.38	10400.0
2005-01-06	CTEC	ETF	38.949999999999996	40.8	38.949999999999996	40.05	6970.0
2005-01-06	CURE	ETF	0.7863	0.7963	0.755	0.755	1442216.0
2005-01-06	CYA	ETF	237.2	237.2	231.2	233.0	1150.0
2005-01-06	CYB	ETF	4.09	4.28	4.09	4.28	2300.0
2005-01-06	CZA	ETF	10.38	10.38	10.38	10.38	1400.0
2005-01-06	DGT	ETF	63.42	63.58	63.27	63.52	8900.0
2005-01-06	DIG	ETF	12.1875	12.375	12.1875	12.375	2640.0
2005-01-06	DIV	ETF	14.2	14.22	13.95	13.98	31000.0
2005-01-06	DRIV	ETF	36.41	36.8	34.32	34.38	1372962.0
2005-01-06	DSI	ETF	5.88	5.915	5.87	5.9	17200.0
2005-01-06	DTH	ETF	25.37	25.37	25.37	25.37	800.0
2005-01-06	DUSA	ETF	14.4	14.7	14.27	14.55	158404.0
2005-01-06	DVY	ETF	59.94	60.02	59.62	59.86	654100.0
2005-01-06	EDEN	ETF	1.35	1.35	1.12	1.21	188844.0

> showing 50 of 251 rows — these rows as CSV

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