PREVIEW / etf_daily / 2005-12-29

all etf daily files

  file:    by_date/etf_daily/2005/2005-12-29.parquet
  size:    16 KB
  rows:    295

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-29	SPY	ETF	125.72	125.96	125.06	125.19	32788900.0
2005-12-29	QQQ	ETF	41.03	41.12	40.65	40.72	47308168.0
2005-12-29	IWM	ETF	67.5	67.72	67.15	67.15	20883600.0
2005-12-29	DIA	ETF	107.94	108.15	107.55	107.68	2907700.0
2005-12-29	GLD	ETF	51.48	51.58	50.92	51.47	3280200.0
2005-12-29	TLT	ETF	92.03	92.13	91.69	92.11	740600.0
2005-12-29	AAA	ETF	54.52	54.52	54.341	54.341	500.0
2005-12-29	ADRE	ETF	115.21	116.0	115.115	115.699	20044.0
2005-12-29	AFK	ETF	25.23	25.27	25.16	25.27	6600.0
2005-12-29	AGG	ETF	100.41	100.66	100.29	100.47	185200.0
2005-12-29	AIQ	ETF	28.45	29.35	28.4	29.05	16180.0
2005-12-29	AIS	ETF	1.44	1.51	1.4	1.47	212800.0
2005-12-29	AOM	ETF	4.05	4.07	4.05	4.07	2400.0
2005-12-29	ARB	ETF	38.52	38.62	38.32	38.48	74400.0
2005-12-29	BAB	ETF	58.1	58.3	57.93	58.09	20600.0
2005-12-29	BBC	ETF	15.15	15.25	14.3	14.4	217100.0
2005-12-29	BBH	ETF	67.6	67.7433	66.7167	66.8667	1155600.0
2005-12-29	BCM	ETF	65.75	65.95	65.6	65.95	12800.0
2005-12-29	BITS	ETF	14.688	15.4	14.64	15.28	7688.0
2005-12-29	BKF	ETF	19.91	20.0	19.85	19.87	31600.0
2005-12-29	BNE	ETF	15.04	15.08	14.84	14.87	76000.0
2005-12-29	BRF	ETF	15.1	15.21	15.04	15.21	20500.0
2005-12-29	BTF	ETF	85.0	85.0	83.75	83.75	1940.0
2005-12-29	CBON	ETF	31.71	32.01	31.34	31.92	12056.0
2005-12-29	CDL	ETF	13.32	13.72	13.31	13.61	407800.0
2005-12-29	CEF	ETF	6.71	6.75	6.65	6.73	639200.0
2005-12-29	CGO	ETF	13.6	13.78	13.51	13.72	92200.0
2005-12-29	CHB	ETF	13.65	13.98	13.55	13.8	264100.0
2005-12-29	CHI	ETF	20.09	20.1	19.8601	19.87	54100.0
2005-12-29	CHIC	ETF	20.55	20.6	20.0	20.53	282747.0
2005-12-29	CHIR	ETF	44.5599	44.7	44.1999	44.4501	663281.0
2005-12-29	CHY	ETF	15.72	15.82	15.66	15.69	114100.0
2005-12-29	CIZ	ETF	21.8	21.8	21.8	21.8	500.0
2005-12-29	CN	ETF	32.11	32.86	32.11	32.68	66400.0
2005-12-29	CNXT	ETF	2.295	2.3	2.21	2.22	6047958.0
2005-12-29	COMB	ETF	7.92	8.25	7.92	8.25	400.0
2005-12-29	CPI	ETF	27.88	27.95	27.88	27.95	1500.0
2005-12-29	CPST	ETF	3.21	3.32	3.06	3.08	6580017.0
2005-12-29	CSA	ETF	16.95	17.0199	16.92	16.92	39600.0
2005-12-29	CSB	ETF	31.99	32.36	31.99	32.25	20100.0
2005-12-29	CSM	ETF	2.45	2.45	2.45	2.45	1600.0
2005-12-29	CSQ	ETF	13.46	13.53	13.32	13.45	553000.0
2005-12-29	CTEC	ETF	47.15	48.16499999999999	46.449999999999996	47.9	6903.400000000001
2005-12-29	CURE	ETF	0.0288	0.0338	0.0286	0.0325	6168544.0
2005-12-29	CYB	ETF	3.46	3.5	3.45	3.5	8800.0
2005-12-29	DGT	ETF	65.33	65.36	65.09	65.09	1200.0
2005-12-29	DIG	ETF	16.0	16.2625	16.0	16.2625	1760.0
2005-12-29	DIV	ETF	12.04	12.11	12.03	12.11	42500.0
2005-12-29	DRIV	ETF	29.92	30.13	29.75	29.78	358071.0
2005-12-29	DSI	ETF	6.04	6.045	6.04	6.045	11000.0

> showing 50 of 295 rows — these rows as CSV

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