PREVIEW / etf_daily / 2005-12-19

all etf daily files

  file:    by_date/etf_daily/2005/2005-12-19.parquet
  size:    16 KB
  rows:    296

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-12-19	SPY	ETF	126.73	126.87	125.69	125.71	48733000.0
2005-12-19	QQQ	ETF	41.68	41.71	40.9	40.92	75415030.0
2005-12-19	IWM	ETF	67.92	67.97	66.81	67.0	22938900.0
2005-12-19	DIA	ETF	108.8	109.05	108.05	108.21	7584100.0
2005-12-19	GLD	ETF	50.58	50.75	50.12	50.22	2077100.0
2005-12-19	TLT	ETF	90.6	91.1	90.56	90.79	469800.0
2005-12-19	AAA	ETF	55.34	55.5999	55.3	55.55	3700.0
2005-12-19	ADRE	ETF	114.99	117.99	113.0	113.0	40772.0
2005-12-19	AFK	ETF	25.17	25.28	25.17	25.25	4800.0
2005-12-19	AGG	ETF	100.44	100.6	100.26	100.37	196700.0
2005-12-19	AIQ	ETF	28.8	29.7	28.775	29.25	112460.0
2005-12-19	AIS	ETF	1.34	1.39	1.31	1.33	104000.0
2005-12-19	AOM	ETF	4.03	4.05	3.95	3.95	14700.0
2005-12-19	ARB	ETF	38.55	38.8	38.16	38.22	100200.0
2005-12-19	BAB	ETF	60.24	60.24	59.24	59.5	19600.0
2005-12-19	BBC	ETF	13.8	14.0	13.14	13.78	346600.0
2005-12-19	BBH	ETF	66.6667	66.7933	65.3767	65.4933	2425500.0
2005-12-19	BCM	ETF	65.74	65.97	65.49	65.59	30700.0
2005-12-19	BITS	ETF	12.88	13.24	12.6	13.24	1988.0
2005-12-19	BKF	ETF	20.08	20.2	20.0	20.07	62600.0
2005-12-19	BNE	ETF	14.82	14.92	14.52	14.74	117900.0
2005-12-19	BRF	ETF	15.03	15.09	15.02	15.09	4000.0
2005-12-19	BTF	ETF	88.1	88.24999999999999	87.5	87.75	2520.0
2005-12-19	CBON	ETF	32.1	32.12	31.25	31.96	31337.0
2005-12-19	CDL	ETF	13.07	13.09	12.85	12.86	298800.0
2005-12-19	CEF	ETF	6.35	6.37	6.29	6.29	362000.0
2005-12-19	CEW	ETF	25.95	25.98	25.95	25.98	18300.0
2005-12-19	CGO	ETF	13.42	13.48	13.4	13.45	82600.0
2005-12-19	CHB	ETF	14.06	14.27	13.9	13.93	453600.0
2005-12-19	CHI	ETF	20.1	20.1899	19.86	19.93	97600.0
2005-12-19	CHIC	ETF	19.9	20.0	19.72	19.78	131394.0
2005-12-19	CHIR	ETF	44.9001	44.9901	44.6799	44.76	1662702.0
2005-12-19	CHY	ETF	15.65	15.69	15.5	15.58	116400.0
2005-12-19	CIL	ETF	25.23	25.23	25.23	25.23	700.0
2005-12-19	CIZ	ETF	21.78	21.78	21.78	21.78	100.0
2005-12-19	CN	ETF	32.37	32.44	32.3	32.44	19500.0
2005-12-19	CNXT	ETF	2.385	2.3903	2.29	2.31	8244460.0
2005-12-19	COMB	ETF	8.55	8.55	8.55	8.55	2100.0
2005-12-19	CPST	ETF	3.2	3.31	3.15	3.15	2600205.0
2005-12-19	CSA	ETF	16.0	16.03	15.9	15.98	32900.0
2005-12-19	CSB	ETF	31.03	31.35	30.88	30.96	21600.0
2005-12-19	CSM	ETF	2.45	2.45	2.4475	2.4475	18400.0
2005-12-19	CSQ	ETF	13.04	13.08	12.93	12.97	674500.0
2005-12-19	CTEC	ETF	50.4	50.4	49.1	49.3	2370.2000000000003
2005-12-19	CURE	ETF	0.0375	0.0575	0.0362	0.0512	74885552.0
2005-12-19	CYB	ETF	3.5	3.53	3.45	3.45	19000.0
2005-12-19	DGT	ETF	66.13	66.13	65.71	65.71	3300.0
2005-12-19	DIG	ETF	15.625	15.8125	15.625	15.7	3760.0
2005-12-19	DIV	ETF	11.98	12.08	11.96	12.05	17600.0
2005-12-19	DRIV	ETF	30.23	30.75	29.48	29.53	854095.0

> showing 50 of 296 rows — these rows as CSV

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