PREVIEW / etf_daily / 2006-01-26

all etf daily files

  file:    by_date/etf_daily/2006/2006-01-26.parquet
  size:    16 KB
  rows:    298

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
2006-01-26	SPY	ETF	127.25	127.67	126.76	127.36	71294000.0
2006-01-26	QQQ	ETF	41.5	41.69	41.23	41.55	112779786.0
2006-01-26	IWM	ETF	71.62	72.45	71.41	72.41	38990300.0
2006-01-26	DIA	ETF	107.63	108.2	107.45	108.01	8234300.0
2006-01-26	GLD	ETF	55.53	55.91	55.27	55.88	4306500.0
2006-01-26	TLT	ETF	90.55	90.6	90.05	90.51	764100.0
2006-01-26	AAA	ETF	54.45	55.33	54.45	55.29	2000.0
2006-01-26	ADRE	ETF	126.97	128.76	126.38	128.68	25864.0
2006-01-26	AFK	ETF	25.32	25.41	25.28	25.41	7500.0
2006-01-26	AGG	ETF	100.55	100.6	100.16	100.37	183800.0
2006-01-26	AIQ	ETF	25.1	25.1	22.65	23.0	50780.0
2006-01-26	AIS	ETF	1.59	1.59	1.4401	1.5	291800.0
2006-01-26	AOM	ETF	5.77	5.79	5.6811	5.72	37000.0
2006-01-26	ARB	ETF	39.7	40.11	39.28	40.11	236200.0
2006-01-26	BAB	ETF	58.54	59.29	58.54	58.65	19700.0
2006-01-26	BBC	ETF	18.3	19.03	17.73	18.58	167000.0
2006-01-26	BBH	ETF	64.95	65.0567	64.1767	64.5167	1325400.0
2006-01-26	BCM	ETF	68.2	68.9	67.94	68.9	25900.0
2006-01-26	BITS	ETF	15.664	15.76	15.6	15.6	2188.0
2006-01-26	BKF	ETF	13.58	13.8	13.5	13.65	100000.0
2006-01-26	BNE	ETF	14.67	15.0	14.63	14.81	196900.0
2006-01-26	BRF	ETF	15.34	15.34	15.26	15.29	3600.0
2006-01-26	BTF	ETF	85.15	85.55	84.8	85.55	3060.0
2006-01-26	CBON	ETF	30.3	30.4	30.19	30.29	5302.0
2006-01-26	CDL	ETF	12.0	12.13	12.0	12.06	503100.0
2006-01-26	CEF	ETF	7.25	7.36	7.13	7.36	823900.0
2006-01-26	CFO	ETF	10.1	10.2	10.07	10.08	7600.0
2006-01-26	CGO	ETF	14.35	14.5	14.11	14.12	58900.0
2006-01-26	CHB	ETF	13.62	13.95	13.36	13.48	666600.0
2006-01-26	CHI	ETF	20.47	20.6	20.3701	20.55	94800.0
2006-01-26	CHIC	ETF	16.22	16.94	16.22	16.64	949041.0
2006-01-26	CHIR	ETF	44.8599	45.3201	44.7501	45.3201	2420814.0
2006-01-26	CHY	ETF	16.29	16.5	16.29	16.31	142100.0
2006-01-26	CIL	ETF	25.43	25.43	25.43	25.43	500.0
2006-01-26	CIZ	ETF	24.1	24.1	23.35	23.8	3200.0
2006-01-26	CN	ETF	33.46	33.55	33.18	33.45	32900.0
2006-01-26	CNXT	ETF	3.54	3.6	3.38	3.49	49141146.0
2006-01-26	CPST	ETF	3.62	3.64	3.46	3.6	2897250.0
2006-01-26	CSA	ETF	17.94	18.0	17.75	18.0	33800.0
2006-01-26	CSB	ETF	32.81	32.82	32.5	32.71	9100.0
2006-01-26	CSQ	ETF	13.97	13.99	13.87	13.91	433300.0
2006-01-26	CTEC	ETF	52.99999999999999	54.55	52.8	52.85	17958.2
2006-01-26	CURE	ETF	0.035	0.035	0.0312	0.0312	1098848.0
2006-01-26	CYB	ETF	4.44	4.45	4.4	4.44	11300.0
2006-01-26	DGT	ETF	66.25	66.25	66.0	66.0	500.0
2006-01-26	DIG	ETF	17.05	17.1875	17.0	17.1875	400.0
2006-01-26	DIV	ETF	12.48	12.48	12.28	12.41	23000.0
2006-01-26	DRIV	ETF	32.97	34.19	32.97	33.92	943868.0
2006-01-26	DSI	ETF	5.99	6.035	5.99	6.0	28000.0
2006-01-26	DUSA	ETF	10.08	10.45	9.98	10.32	77066.0

> showing 50 of 298 rows — these rows as CSV

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