PREVIEW / etf_daily / 2006-01-20

all etf daily files

  file:    by_date/etf_daily/2006/2006-01-20.parquet
  size:    16 KB
  rows:    302

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-20	SPY	ETF	128.28	128.31	125.97	125.97	114957800.0
2006-01-20	QQQ	ETF	42.44	42.49	41.15	41.25	188671125.0
2006-01-20	IWM	ETF	71.03	71.12	69.83	70.19	43301200.0
2006-01-20	DIA	ETF	108.46	108.5	106.45	106.47	16440200.0
2006-01-20	GLD	ETF	56.12	56.6	55.02	55.2	7270600.0
2006-01-20	TLT	ETF	92.32	92.48	92.05	92.38	842600.0
2006-01-20	AAA	ETF	54.59	54.59	54.25	54.25	1500.0
2006-01-20	ADRE	ETF	124.34	125.0	121.15	122.36	43824.0
2006-01-20	AFK	ETF	25.33	25.45	25.31	25.44	4900.0
2006-01-20	AGG	ETF	101.09	101.19	100.8	101.1	134100.0
2006-01-20	AIQ	ETF	27.3	27.3	25.8	26.25	20940.0
2006-01-20	AIS	ETF	1.45	1.47	1.4	1.42	313600.0
2006-01-20	AOM	ETF	5.7	5.71	5.48	5.49	85300.0
2006-01-20	ARB	ETF	40.5	40.5	40.0	40.08	179100.0
2006-01-20	BAB	ETF	55.87	55.96	54.69	54.71	88100.0
2006-01-20	BBC	ETF	17.22	17.22	16.21	16.56	148300.0
2006-01-20	BBH	ETF	67.0	67.1733	65.08	65.26	3391200.0
2006-01-20	BCM	ETF	68.9	69.66	68.9	69.22	26700.0
2006-01-20	BITS	ETF	15.6	15.6	15.0	15.4	2280.0
2006-01-20	BKF	ETF	14.7	14.7	14.1	14.45	218200.0
2006-01-20	BNE	ETF	14.9	14.9	14.22	14.26	93100.0
2006-01-20	BRF	ETF	15.49	15.49	15.4	15.4	2100.0
2006-01-20	BTF	ETF	85.6	85.64999999999999	84.89999999999999	84.9005	10820.0
2006-01-20	CBON	ETF	32.07	32.07	30.7	30.78	24454.0
2006-01-20	CDL	ETF	13.19	13.19	12.9	12.9	171300.0
2006-01-20	CEF	ETF	7.41	7.46	7.21	7.21	482100.0
2006-01-20	CFO	ETF	10.05	10.1	10.0	10.1	40700.0
2006-01-20	CGO	ETF	14.2	14.3	14.0501	14.3	14800.0
2006-01-20	CHB	ETF	15.23	15.23	13.73	13.86	1270400.0
2006-01-20	CHI	ETF	20.3	20.4	20.05	20.2	141900.0
2006-01-20	CHIC	ETF	15.98	15.98	15.39	15.47	1060369.0
2006-01-20	CHIR	ETF	44.82	44.8299	44.6499	44.6799	1536219.0
2006-01-20	CHY	ETF	16.1	16.161	16.09	16.15	91200.0
2006-01-20	CIZ	ETF	23.25	23.75	23.25	23.75	19200.0
2006-01-20	CN	ETF	34.28	34.29	33.7	33.86	30000.0
2006-01-20	CNXT	ETF	3.32	3.35	3.21	3.23	22805712.0
2006-01-20	COMB	ETF	8.35	8.35	8.35	8.35	700.0
2006-01-20	CPI	ETF	29.89	29.89	29.84	29.84	500.0
2006-01-20	CPST	ETF	3.35	3.45	3.16	3.2001	3486055.0
2006-01-20	CSA	ETF	17.7	17.81	17.7	17.8	27400.0
2006-01-20	CSB	ETF	32.8	32.88	32.32	32.39	11300.0
2006-01-20	CSQ	ETF	13.98	14.08	13.84	13.92	476600.0
2006-01-20	CTEC	ETF	50.05	51.699999999999996	50.0	51.5	14649.0
2006-01-20	CURE	ETF	0.0362	0.0362	0.0338	0.034	1115816.0
2006-01-20	CYB	ETF	4.35	4.37	4.3	4.37	3100.0
2006-01-20	DGT	ETF	66.65	66.65	65.51	65.51	2600.0
2006-01-20	DIG	ETF	17.1875	17.1875	17.0625	17.075	720.0
2006-01-20	DIV	ETF	12.45	12.452	12.4	12.4	8500.0
2006-01-20	DRIV	ETF	31.99	32.14	31.04	31.46	1534894.0
2006-01-20	DSI	ETF	6.04	6.04	5.955	5.97	46400.0

> showing 50 of 302 rows — these rows as CSV

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