PREVIEW / etf_daily / 2005-01-21

all etf daily files

  file:    by_date/etf_daily/2005/2005-01-21.parquet
  size:    14 KB
  rows:    249

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-21	SPY	ETF	117.79	118.0	116.65	116.78	63160400.0
2005-01-21	QQQ	ETF	37.49	37.55	36.99	37.05	115496664.0
2005-01-21	IWM	ETF	61.025	61.49	60.575	60.78	22309800.0
2005-01-21	DIA	ETF	104.95	105.03	103.78	103.84	7901200.0
2005-01-21	GLD	ETF	42.32	42.82	42.29	42.74	889800.0
2005-01-21	TLT	ETF	90.6	91.05	90.52	91.01	606300.0
2005-01-21	AAA	ETF	56.77	57.16	56.77	57.04	1600.0
2005-01-21	ADRE	ETF	81.75	81.75	79.73	79.73	3208.0
2005-01-21	AFK	ETF	26.52	26.56	26.46	26.48	5200.0
2005-01-21	AGG	ETF	102.89	103.05	102.86	103.03	85200.0
2005-01-21	AIQ	ETF	64.8	66.1	63.25	64.75	63660.0
2005-01-21	ARB	ETF	37.8	37.89	37.45	37.54	213900.0
2005-01-21	BAB	ETF	47.11	47.11	46.0	46.15	46700.0
2005-01-21	BBH	ETF	48.8	49.0367	48.2067	48.26	3494400.0
2005-01-21	BCM	ETF	56.02	56.06	55.57	55.74	25300.0
2005-01-21	BIS	ETF	958.4	960.0	958.4	960.0	48.75
2005-01-21	BITS	ETF	9.68	10.6	9.68	10.6	27760.0
2005-01-21	BKF	ETF	36.95	37.0	36.75	36.85	7200.0
2005-01-21	BNE	ETF	15.0	15.02	14.83	14.91	96400.0
2005-01-21	BRF	ETF	15.69	15.69	15.64	15.64	500.0
2005-01-21	BTF	ETF	90.0	90.25	89.7	90.19999999999999	2460.0
2005-01-21	CBON	ETF	27.9	28.5	27.6	28.0	74125.0
2005-01-21	CDC	ETF	9.67	9.68	9.0	9.06	11100.0
2005-01-21	CDL	ETF	14.08	14.29	13.99	14.16	412200.0
2005-01-21	CEF	ETF	5.23	5.3	5.21	5.29	221100.0
2005-01-21	CEW	ETF	27.46	27.46	27.45	27.45	1100.0
2005-01-21	CHB	ETF	11.11	11.18	10.7	10.76	450400.0
2005-01-21	CHIC	ETF	9.7	9.8	9.44	9.48	319760.0
2005-01-21	CHIR	ETF	34.53	34.8999	33.84	34.0899	1893130.0
2005-01-21	CID	ETF	9.67	9.67	9.45	9.47	41900.0
2005-01-21	CIL	ETF	26.23	26.23	26.21	26.21	500.0
2005-01-21	CN	ETF	28.75	28.79	28.55	28.65	96300.0
2005-01-21	CNXT	ETF	1.66	1.681	1.6	1.61	5835711.0
2005-01-21	CPI	ETF	18.75	22.0	18.75	22.0	3900.0
2005-01-21	CSB	ETF	35.79	35.8	35.79	35.8	200.0
2005-01-21	CSM	ETF	2.3825	2.3875	2.3825	2.3825	6800.0
2005-01-21	CTEC	ETF	48.65	50.0	47.9	49.45	7577.400000000001
2005-01-21	CURE	ETF	0.6763	0.6763	0.6438	0.6637	1097512.0
2005-01-21	CYA	ETF	192.0	192.0	179.6	180.0	1075.0
2005-01-21	CYB	ETF	4.26	4.4	4.25	4.25	6000.0
2005-01-21	CZA	ETF	10.4	10.4	10.18	10.4	8900.0
2005-01-21	DGT	ETF	62.6	62.76	62.32	62.32	10400.0
2005-01-21	DIG	ETF	11.9875	12.075	11.9875	12.075	880.0
2005-01-21	DIV	ETF	14.08	14.15	14.08	14.11	14900.0
2005-01-21	DJP	ETF	26.7	26.7	26.7	26.7	200.0
2005-01-21	DRIV	ETF	32.64	32.85	31.73	32.32	748467.0
2005-01-21	DSI	ETF	5.91	5.915	5.91	5.915	1800.0
2005-01-21	DTH	ETF	25.35	25.35	25.3	25.3	1800.0
2005-01-21	DUSA	ETF	14.77	15.0	14.18	14.41	134420.0
2005-01-21	DVY	ETF	59.55	59.61	58.96	59.1	464100.0

> showing 50 of 249 rows — these rows as CSV

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