PREVIEW / etf_daily / 2006-01-31

all etf daily files

  file:    by_date/etf_daily/2006/2006-01-31.parquet
  size:    16 KB
  rows:    298

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-31	SPY	ETF	128.32	128.54	127.49	127.5	72937000.0
2006-01-31	QQQ	ETF	42.14	42.27	41.81	42.0	101424250.0
2006-01-31	IWM	ETF	72.48	72.96	72.13	72.35	38124600.0
2006-01-31	DIA	ETF	108.79	109.19	108.24	108.27	5224700.0
2006-01-31	GLD	ETF	56.57	57.05	56.53	56.7	5011700.0
2006-01-31	TLT	ETF	90.35	90.73	90.2	90.67	676100.0
2006-01-31	AAA	ETF	55.75	55.81	55.51	55.75	5700.0
2006-01-31	ADRE	ETF	131.5	131.94	130.0	131.773	32992.0
2006-01-31	AFK	ETF	25.3	25.35	25.3	25.35	4300.0
2006-01-31	AGG	ETF	100.51	100.6	100.25	100.53	174300.0
2006-01-31	AIQ	ETF	23.8	24.025	23.25	23.6	15280.0
2006-01-31	AIS	ETF	1.43	1.43	1.39	1.4	372600.0
2006-01-31	AOM	ETF	5.65	5.65	5.56	5.56	15600.0
2006-01-31	ARB	ETF	39.37	39.89	39.01	39.7	248600.0
2006-01-31	BAB	ETF	57.81	58.3	57.59	58.15	28700.0
2006-01-31	BBC	ETF	21.35	21.97	20.17	20.651	359200.0
2006-01-31	BBH	ETF	64.5	65.2467	64.2633	64.8333	663000.0
2006-01-31	BCM	ETF	69.7	70.4	69.47	69.95	65200.0
2006-01-31	BITS	ETF	16.8	17.8	16.8	17.56	19429.0
2006-01-31	BKF	ETF	13.09	13.12	12.98	12.98	73200.0
2006-01-31	BNE	ETF	14.83	15.09	14.76	15.06	103100.0
2006-01-31	BOSS	ETF	33.68	34.4	33.68	34.4	100.0
2006-01-31	BRF	ETF	15.3	15.39	15.3	15.3299	6600.0
2006-01-31	BTF	ETF	86.14999999999999	86.44999999999999	85.8505	86.35	2080.0
2006-01-31	CBON	ETF	30.88	31.95	30.75	31.19	20806.0
2006-01-31	CDL	ETF	12.27	12.36	12.21	12.3	409000.0
2006-01-31	CEF	ETF	7.6	7.76	7.59	7.66	987900.0
2006-01-31	CEW	ETF	26.26	26.26	26.26	26.26	2000.0
2006-01-31	CFO	ETF	10.14	10.14	10.07	10.09	3600.0
2006-01-31	CGO	ETF	14.3	14.36	14.23	14.36	26700.0
2006-01-31	CHB	ETF	13.66	13.93	13.54	13.71	304300.0
2006-01-31	CHI	ETF	20.01	20.31	20.0	20.31	102800.0
2006-01-31	CHIC	ETF	16.48	16.65	16.19	16.38	510512.0
2006-01-31	CHIR	ETF	45.03	45.6099	44.9301	45.6	1620371.0
2006-01-31	CHY	ETF	15.88	16.04	15.86	15.99	81600.0
2006-01-31	CIL	ETF	25.45	25.45	25.45	25.45	800.0
2006-01-31	CN	ETF	34.0	34.08	33.81	33.99	25400.0
2006-01-31	CNXT	ETF	3.35	3.36	3.25	3.36	15341891.0
2006-01-31	CPST	ETF	3.89	3.95	3.7	3.79	5987243.0
2006-01-31	CSA	ETF	18.25	18.85	18.2	18.65	40900.0
2006-01-31	CSB	ETF	31.73	32.14	31.52	31.9	19600.0
2006-01-31	CSM	ETF	2.47	2.47	2.47	2.47	12000.0
2006-01-31	CSQ	ETF	13.99	14.07	13.95	14.04	392900.0
2006-01-31	CTEC	ETF	53.49999999999999	54.15	53.15	54.05	11890.2
2006-01-31	CURE	ETF	0.0312	0.0312	0.03	0.03	1729960.0
2006-01-31	CYB	ETF	4.5	4.52	4.4	4.4	8000.0
2006-01-31	DGT	ETF	66.85	66.85	66.54	66.54	2000.0
2006-01-31	DIG	ETF	17.3125	17.3125	17.05	17.1375	4000.0
2006-01-31	DIV	ETF	12.48	12.51	12.45	12.5	19800.0
2006-01-31	DRIV	ETF	33.94	34.4	33.47	33.58	1201411.0

> showing 50 of 298 rows — these rows as CSV

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