PREVIEW / etf_daily / 2005-01-18

all etf daily files

  file:    by_date/etf_daily/2005/2005-01-18.parquet
  size:    14 KB
  rows:    256

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-18	SPY	ETF	118.05	119.62	117.95	119.47	57391700.0
2005-01-18	QQQ	ETF	38.28	38.79	38.22	38.72	92042101.0
2005-01-18	IWM	ETF	61.3	62.405	61.21	62.175	16787600.0
2005-01-18	DIA	ETF	105.25	106.29	105.0	106.16	6601700.0
2005-01-18	GLD	ETF	42.22	42.38	42.15	42.32	666800.0
2005-01-18	TLT	ETF	89.8	90.49	89.73	90.47	1251600.0
2005-01-18	AAA	ETF	57.5	58.0	57.5	57.82	2300.0
2005-01-18	ADRE	ETF	81.8	81.8	80.1	80.87	22820.0
2005-01-18	AFK	ETF	26.54	26.61	26.54	26.61	1900.0
2005-01-18	AGG	ETF	102.54	102.7	102.27	102.69	86600.0
2005-01-18	AIQ	ETF	69.1	69.35	68.55	68.75	47700.0
2005-01-18	ARB	ETF	37.33	38.18	37.05	38.11	240600.0
2005-01-18	BAB	ETF	46.8	47.12	46.49	46.94	26300.0
2005-01-18	BBH	ETF	49.1	49.96	49.0967	49.7633	1711500.0
2005-01-18	BCM	ETF	57.03	57.1	56.82	57.02	219700.0
2005-01-18	BIS	ETF	960.0	984.0	960.0	984.0	6.9
2005-01-18	BITS	ETF	10.52	10.68	9.84	10.08	11744.0
2005-01-18	BKF	ETF	34.75	35.86	34.75	35.85	35100.0
2005-01-18	BNE	ETF	15.11	15.25	15.04	15.1	204500.0
2005-01-18	BOSS	ETF	24.51	24.53	24.51	24.53	100.0
2005-01-18	BRF	ETF	15.7	15.72	15.65	15.72	19700.0
2005-01-18	BTF	ETF	89.85	90.05	89.25	90.05	1260.0
2005-01-18	CBON	ETF	28.25	28.825	28.11	28.45	42466.0
2005-01-18	CDC	ETF	10.35	10.55	10.35	10.5	2000.0
2005-01-18	CDL	ETF	14.15	14.31	14.0	14.23	225800.0
2005-01-18	CEF	ETF	5.24	5.26	5.19	5.26	334100.0
2005-01-18	CEW	ETF	27.46	27.46	27.46	27.46	2400.0
2005-01-18	CHB	ETF	11.65	11.66	11.3	11.34	403900.0
2005-01-18	CHIC	ETF	10.0	10.07	9.58	10.01	230345.0
2005-01-18	CHIR	ETF	34.71	35.1099	33.9099	35.0001	1773883.0
2005-01-18	CID	ETF	9.38	9.42	9.38	9.42	1100.0
2005-01-18	CIL	ETF	26.23	26.4	26.23	26.4	600.0
2005-01-18	CIZ	ETF	20.15	20.15	20.1	20.1	600.0
2005-01-18	CN	ETF	28.25	28.25	27.92	28.2	46400.0
2005-01-18	CNXT	ETF	1.67	1.7	1.62	1.68	5599930.0
2005-01-18	CPI	ETF	18.4	18.4	18.4	18.4	1000.0
2005-01-18	CSB	ETF	35.26	35.86	35.26	35.63	9300.0
2005-01-18	CSM	ETF	2.38	2.38	2.38	2.38	4800.0
2005-01-18	CTEC	ETF	47.55	47.55	43.75	45.949999999999996	27909.0
2005-01-18	CURE	ETF	0.675	0.6813	0.6637	0.6737	1229840.0
2005-01-18	CYA	ETF	207.0	209.6	207.0	209.6	290.0
2005-01-18	CYB	ETF	4.63	4.63	4.5	4.59	13100.0
2005-01-18	CZA	ETF	10.45	10.45	10.45	10.45	2900.0
2005-01-18	DGT	ETF	62.57	63.35	62.57	63.35	5900.0
2005-01-18	DIG	ETF	11.8875	11.9375	11.875	11.925	2720.0
2005-01-18	DIV	ETF	14.25	14.4	14.06	14.06	53900.0
2005-01-18	DJP	ETF	26.66	26.7	26.65	26.7	2400.0
2005-01-18	DRIV	ETF	34.29	34.9	33.01	34.3	892225.0
2005-01-18	DSI	ETF	5.875	5.875	5.875	5.875	1000.0
2005-01-18	DTH	ETF	25.3	25.49	25.3	25.45	4400.0

> showing 50 of 256 rows — these rows as CSV

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