PREVIEW / etf_daily / 2005-12-20

all etf daily files

  file:    by_date/etf_daily/2005/2005-12-20.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-20	SPY	ETF	125.86	126.59	125.48	125.83	46603200.0
2005-12-20	QQQ	ETF	40.95	41.15	40.75	40.95	70257635.0
2005-12-20	IWM	ETF	66.92	67.53	66.54	66.98	28762600.0
2005-12-20	DIA	ETF	108.24	108.42	107.7	107.89	5050500.0
2005-12-20	GLD	ETF	50.35	50.4	49.0	49.04	4317900.0
2005-12-20	TLT	ETF	90.58	90.8	90.4	90.68	236000.0
2005-12-20	AAA	ETF	55.18	55.18	54.9	54.98	3300.0
2005-12-20	ADRE	ETF	112.06	113.66	101.48	113.66	64208.0
2005-12-20	AFK	ETF	25.34	25.34	25.17	25.27	7400.0
2005-12-20	AGG	ETF	100.4	100.51	100.23	100.4	142200.0
2005-12-20	AIQ	ETF	29.75	31.0	29.3	29.35	23060.0
2005-12-20	AIS	ETF	1.32	1.38	1.31	1.38	105100.0
2005-12-20	AOM	ETF	3.97	4.0	3.97	4.0	8100.0
2005-12-20	ARB	ETF	38.25	38.55	37.89	37.96	136600.0
2005-12-20	BAB	ETF	59.16	59.34	58.81	59.05	18700.0
2005-12-20	BBC	ETF	13.55	14.69	13.55	13.85	263000.0
2005-12-20	BBH	ETF	65.9467	66.5833	65.3333	66.4133	2032200.0
2005-12-20	BCM	ETF	65.53	65.8	65.3	65.6	27900.0
2005-12-20	BITS	ETF	12.84	12.924	12.8	12.8	375.0
2005-12-20	BKF	ETF	20.05	20.41	19.99	20.01	43800.0
2005-12-20	BNE	ETF	14.75	15.0	14.55	14.63	130900.0
2005-12-20	BRF	ETF	15.01	15.09	15.0	15.09	17100.0
2005-12-20	BTF	ETF	87.75	88.39999999999999	87.50049999999999	88.3	2820.0
2005-12-20	CBON	ETF	31.85	32.13	31.85	32.0	11648.0
2005-12-20	CDL	ETF	12.86	13.04	12.8	12.85	212900.0
2005-12-20	CEF	ETF	6.34	6.34	6.09	6.11	406900.0
2005-12-20	CEW	ETF	26.05	26.05	26.0	26.0	2900.0
2005-12-20	CFO	ETF	10.0	10.0	10.0	10.0	1200.0
2005-12-20	CGO	ETF	13.46	13.75	13.4	13.7	56900.0
2005-12-20	CHB	ETF	13.93	14.04	13.44	13.77	579800.0
2005-12-20	CHI	ETF	19.9	19.9	19.77	19.88	110400.0
2005-12-20	CHIC	ETF	19.76	19.78	18.66	19.46	615662.0
2005-12-20	CHIR	ETF	44.8401	44.94	44.55	44.6799	1296885.0
2005-12-20	CHY	ETF	15.6	15.66	15.4	15.55	170600.0
2005-12-20	CIL	ETF	25.24	25.2501	25.24	25.2501	1000.0
2005-12-20	CIZ	ETF	21.63	21.63	21.53	21.53	200.0
2005-12-20	CN	ETF	32.09	32.34	32.07	32.29	33600.0
2005-12-20	CNXT	ETF	2.31	2.37	2.3	2.35	6465651.0
2005-12-20	COMB	ETF	8.25	8.34	7.77	8.072	231618.0
2005-12-20	CPI	ETF	27.35	27.35	27.35	27.35	400.0
2005-12-20	CPST	ETF	3.16	3.26	3.11	3.12	1800131.0
2005-12-20	CSA	ETF	15.94	16.1	15.86	16.1	30600.0
2005-12-20	CSB	ETF	30.71	30.83	30.7	30.75	10300.0
2005-12-20	CSQ	ETF	12.97	12.98	12.8	12.92	755300.0
2005-12-20	CTEC	ETF	49.699999999999996	49.699999999999996	47.5	48.25	10968.6
2005-12-20	CURE	ETF	0.0462	0.0525	0.0375	0.0387	26349184.0
2005-12-20	CYB	ETF	3.5199	3.5199	3.44	3.44	3500.0
2005-12-20	DGT	ETF	65.85	65.93	65.45	65.45	5000.0
2005-12-20	DIG	ETF	15.6625	15.6625	15.6625	15.6625	8000.0
2005-12-20	DIV	ETF	12.04	12.05	11.96	11.99	20900.0

> showing 50 of 296 rows — these rows as CSV

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