PREVIEW / etf_daily / 2006-01-23

all etf daily files

  file:    by_date/etf_daily/2006/2006-01-23.parquet
  size:    16 KB
  rows:    305

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-23	SPY	ETF	126.21	126.82	126.13	126.42	67017400.0
2006-01-23	QQQ	ETF	41.37	41.45	41.08	41.26	111432050.0
2006-01-23	IWM	ETF	70.25	70.56	69.99	70.41	30482700.0
2006-01-23	DIA	ETF	106.64	107.28	106.56	106.86	7596300.0
2006-01-23	GLD	ETF	55.59	55.9	55.26	55.77	4968500.0
2006-01-23	TLT	ETF	91.8	92.5	91.73	92.35	720400.0
2006-01-23	AAA	ETF	54.6	54.76	54.6	54.71	1100.0
2006-01-23	ADRE	ETF	123.95	124.0	122.57	123.52	22312.0
2006-01-23	AFK	ETF	25.45	25.45	25.32	25.32	3000.0
2006-01-23	AGG	ETF	101.02	101.2	100.9	101.1	221900.0
2006-01-23	AIQ	ETF	26.5	27.05	25.55	25.8	21820.0
2006-01-23	AIS	ETF	1.45	1.49	1.44	1.49	194300.0
2006-01-23	AOM	ETF	5.5	5.67	5.49	5.52	30500.0
2006-01-23	ARB	ETF	40.15	40.25	39.66	40.04	170000.0
2006-01-23	BAB	ETF	56.1	56.46	55.64	56.23	29400.0
2006-01-23	BBC	ETF	16.5	16.5	15.7	15.94	222500.0
2006-01-23	BBH	ETF	65.1233	65.1233	63.3333	64.3333	2853300.0
2006-01-23	BCM	ETF	69.21	69.61	69.0	69.41	27700.0
2006-01-23	BITS	ETF	15.24	15.36	14.8004	15.28	1667.0
2006-01-23	BKF	ETF	14.45	14.59	14.15	14.17	38000.0
2006-01-23	BNE	ETF	14.32	14.59	14.29	14.51	236200.0
2006-01-23	BOSS	ETF	30.25	30.6	30.25	30.6	100.0
2006-01-23	BRF	ETF	15.4	15.4	15.35	15.39	9000.0
2006-01-23	BTF	ETF	85.15	85.15	84.74999999999999	84.89999999999999	2260.0
2006-01-23	CBON	ETF	30.89	30.92	29.93	29.99	31884.0
2006-01-23	CDL	ETF	12.93	12.93	12.22	12.25	818000.0
2006-01-23	CEF	ETF	7.25	7.31	7.15	7.29	443900.0
2006-01-23	CFO	ETF	10.05	10.15	10.05	10.1	23300.0
2006-01-23	CGO	ETF	14.2	14.36	14.08	14.27	47300.0
2006-01-23	CHB	ETF	13.92	13.97	13.53	13.63	788300.0
2006-01-23	CHI	ETF	20.1	20.3	20.1	20.29	94700.0
2006-01-23	CHIC	ETF	15.73	15.85	15.28	15.41	695478.0
2006-01-23	CHIR	ETF	44.7399	44.7801	44.64	44.7099	651359.0
2006-01-23	CHY	ETF	16.12	16.22	16.11	16.19	83900.0
2006-01-23	CIL	ETF	25.37	25.37	25.36	25.36	1000.0
2006-01-23	CIZ	ETF	23.6	23.75	23.6	23.75	4200.0
2006-01-23	CN	ETF	33.87	34.42	33.81	34.27	19900.0
2006-01-23	CNXT	ETF	3.26	3.29	3.17	3.19	13939755.0
2006-01-23	COMB	ETF	8.2	8.35	8.2	8.35	709.0
2006-01-23	CPI	ETF	30.0	30.15	30.0	30.15	1600.0
2006-01-23	CPST	ETF	3.22	3.55	3.16	3.45	4261191.0
2006-01-23	CSA	ETF	17.75	17.77	17.6	17.6	13300.0
2006-01-23	CSB	ETF	32.89	32.99	32.66	32.82	15700.0
2006-01-23	CSM	ETF	2.4675	2.4675	2.4675	2.4675	6000.0
2006-01-23	CSQ	ETF	13.94	13.99	13.83	13.86	396700.0
2006-01-23	CTEC	ETF	51.9	52.5	51.1	51.95	17229.4
2006-01-23	CURE	ETF	0.035	0.0362	0.0325	0.035	3002376.0
2006-01-23	CYB	ETF	4.27	4.27	4.11	4.19	12200.0
2006-01-23	DGT	ETF	65.77	65.99	65.68	65.75	1500.0
2006-01-23	DIG	ETF	17.1875	17.1875	17.1875	17.1875	160.0

> showing 50 of 305 rows — these rows as CSV

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