PREVIEW / etf_daily / 2006-01-17

all etf daily files

  file:    by_date/etf_daily/2006/2006-01-17.parquet
  size:    16 KB
  rows:    300

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-17	SPY	ETF	128.2	128.42	127.81	128.33	52066600.0
2006-01-17	QQQ	ETF	42.66	42.79	42.5	42.7	78109615.0
2006-01-17	IWM	ETF	69.98	70.05	69.54	70.03	26979900.0
2006-01-17	DIA	ETF	109.15	109.27	108.74	109.01	3914400.0
2006-01-17	GLD	ETF	55.25	55.87	55.03	55.26	5130400.0
2006-01-17	TLT	ETF	92.0	92.5	91.93	92.44	454300.0
2006-01-17	AAA	ETF	54.15	54.73	54.1015	54.73	3000.0
2006-01-17	ADRE	ETF	123.65	123.65	120.9	121.26	66332.0
2006-01-17	AFK	ETF	25.34	25.48	25.27	25.48	7200.0
2006-01-17	AGG	ETF	101.05	101.13	100.79	101.08	253000.0
2006-01-17	AIQ	ETF	26.9	26.9	24.5	25.3	47740.0
2006-01-17	AIS	ETF	1.4	1.4	1.36	1.38	110200.0
2006-01-17	AOM	ETF	5.08	5.59	5.01	5.34	83800.0
2006-01-17	ARB	ETF	39.15	39.19	38.84	39.18	109400.0
2006-01-17	BAB	ETF	57.3	57.33	56.7	57.15	52200.0
2006-01-17	BBC	ETF	16.12	17.0	14.85	16.2	346200.0
2006-01-17	BBH	ETF	66.3667	67.0567	66.02	67.05	1399500.0
2006-01-17	BCM	ETF	69.65	69.78	69.49	69.58	33700.0
2006-01-17	BITS	ETF	15.4	15.76	14.6	15.76	7871.0
2006-01-17	BKF	ETF	18.36	18.37	17.0	17.0	124900.0
2006-01-17	BNE	ETF	14.35	14.39	14.2	14.23	156300.0
2006-01-17	BRF	ETF	15.26	15.41	15.26	15.41	4300.0
2006-01-17	BTF	ETF	85.6	85.95	85.0	85.0	21020.0
2006-01-17	CBON	ETF	32.835	33.0	32.72	32.91	6700.0
2006-01-17	CDL	ETF	13.07	13.08	12.95	12.98	110200.0
2006-01-17	CEF	ETF	7.47	7.5	7.26	7.31	1075500.0
2006-01-17	CFO	ETF	9.91	9.91	9.91	9.91	5000.0
2006-01-17	CGO	ETF	14.4	14.69	14.17	14.3	60500.0
2006-01-17	CHB	ETF	13.07	13.2299	13.03	13.13	626100.0
2006-01-17	CHI	ETF	20.21	20.5	20.21	20.39	84400.0
2006-01-17	CHIC	ETF	20.19	20.52	19.37	19.8	487528.0
2006-01-17	CHIR	ETF	44.6901	44.79	44.67	44.7699	646010.0
2006-01-17	CHY	ETF	16.25	16.29	16.1	16.15	95800.0
2006-01-17	CIL	ETF	25.38	25.38	25.37	25.37	2500.0
2006-01-17	CIZ	ETF	23.1	23.1	23.1	23.1	2000.0
2006-01-17	CN	ETF	34.7	34.94	34.7	34.9	36200.0
2006-01-17	CNXT	ETF	3.25	3.2601	3.15	3.1799	16566619.0
2006-01-17	CPI	ETF	29.1	30.0	29.1	29.4	2800.0
2006-01-17	CPST	ETF	3.685	3.83	3.52	3.53	6505141.0
2006-01-17	CSA	ETF	17.63	17.7	17.63	17.65	10600.0
2006-01-17	CSB	ETF	32.01	32.01	31.7	31.92	18600.0
2006-01-17	CSM	ETF	2.4725	2.4725	2.465	2.465	15200.0
2006-01-17	CSQ	ETF	14.04	14.15	14.0	14.05	448800.0
2006-01-17	CTEC	ETF	48.2	50.65	47.8	50.099999999999994	11513.2
2006-01-17	CURE	ETF	0.0312	0.0325	0.0288	0.0312	2752112.0
2006-01-17	CYB	ETF	3.98	3.99	3.85	3.98	10600.0
2006-01-17	DGT	ETF	66.8	66.96	66.7	66.96	5300.0
2006-01-17	DIG	ETF	16.875	17.3125	16.875	16.8875	12320.0
2006-01-17	DIV	ETF	12.5	12.54	12.44	12.5	26900.0
2006-01-17	DRIV	ETF	32.93	33.57	32.86	33.46	761578.0

> showing 50 of 300 rows — these rows as CSV

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