PREVIEW / etf_daily / 2006-12-08

all etf daily files

  file:    by_date/etf_daily/2006/2006-12-08.parquet
  size:    19 KB
  rows:    387

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-12-08	SPY	ETF	141.13	141.9	140.78	141.42	79625500.0
2006-12-08	QQQ	ETF	43.57	44.26	43.47	43.9	133817409.0
2006-12-08	IWM	ETF	78.62	79.34	78.16	78.78	43109600.0
2006-12-08	DIA	ETF	122.68	123.38	122.32	123.0	7319600.0
2006-12-08	GLD	ETF	63.08	63.34	61.87	62.05	6080900.0
2006-12-08	TLT	ETF	90.85	90.97	90.19	90.24	2090300.0
2006-12-08	AAA	ETF	60.3	60.4	59.9	59.9	11100.0
2006-12-08	ADRE	ETF	37.47	37.57	37.23	37.4	68419.0
2006-12-08	AGG	ETF	100.68	100.73	100.49	100.52	364200.0
2006-12-08	AIQ	ETF	31.65	31.9	30.65	31.75	61960.0
2006-12-08	AIS	ETF	1.19	1.2	1.18	1.19	96100.0
2006-12-08	ARB	ETF	44.22	44.6	43.76	44.44	152900.0
2006-12-08	BAB	ETF	97.98	99.33	97.91	98.94	45700.0
2006-12-08	BBC	ETF	4.96	5.02	4.85	4.91	147400.0
2006-12-08	BBH	ETF	61.67	63.1567	61.67	62.5333	1404600.0
2006-12-08	BITS	ETF	33.8	33.8	32.92	33.6	24624.0
2006-12-08	BNE	ETF	15.69	15.91	15.62	15.88	67100.0
2006-12-08	BRF	ETF	14.35	14.35	14.25	14.28	18100.0
2006-12-08	BTF	ETF	111.85	113.24999999999999	111.5	112.44999999999999	3460.0
2006-12-08	CBON	ETF	30.38	30.54	30.2	30.25	50844.0
2006-12-08	CDL	ETF	9.69	9.8	9.54	9.76	300100.0
2006-12-08	CEF	ETF	9.6	9.63	9.46	9.5	552100.0
2006-12-08	CEW	ETF	25.65	25.65	25.65	25.65	100.0
2006-12-08	CFO	ETF	11.1	11.11	11.1	11.11	17300.0
2006-12-08	CGO	ETF	16.35	16.56	16.31	16.5	26500.0
2006-12-08	CHB	ETF	9.72	10.1	9.3	9.49	2848200.0
2006-12-08	CHI	ETF	20.04	20.1999	20.0	20.03	89500.0
2006-12-08	CHIC	ETF	31.26	31.35	30.77	31.0	316954.0
2006-12-08	CHY	ETF	16.91	17.0	16.9	16.91	73400.0
2006-12-08	CIL	ETF	25.2001	25.2001	25.2001	25.2001	400.0
2006-12-08	CN	ETF	43.5	43.5	42.7	42.78	86000.0
2006-12-08	CNXT	ETF	2.29	2.31	2.25	2.25	6268649.0
2006-12-08	CPI	ETF	23.64	23.65	23.5	23.5	1100.0
2006-12-08	CPST	ETF	1.37	1.38	1.34	1.36	1033335.0
2006-12-08	CSA	ETF	22.29	22.3	22.23	22.27	30300.0
2006-12-08	CSB	ETF	32.95	33.11	32.77	32.87	18700.0
2006-12-08	CSM	ETF	1.3225	1.3225	1.3225	1.3225	8000.0
2006-12-08	CSQ	ETF	15.33	15.39	15.3	15.37	302300.0
2006-12-08	CTEC	ETF	90.89999999999999	92.75	90.6	92.2	12051.0
2006-12-08	CVY	ETF	26.65	26.79	26.64	26.7	21400.0
2006-12-08	DBC	ETF	25.4	25.5	25.1	25.1	231100.0
2006-12-08	DBV	ETF	25.11	25.31	25.1	25.28	83000.0
2006-12-08	DDM	ETF	7.2583	7.32	7.2167	7.2842	590400.0
2006-12-08	DES	ETF	19.21	19.3	19.1233	19.25	52500.0
2006-12-08	DEW	ETF	60.98	61.2	60.65	60.65	206900.0
2006-12-08	DFE	ETF	64.11	64.33	63.7	63.7	39300.0
2006-12-08	DFJ	ETF	51.1	51.15	50.63	50.78	9100.0
2006-12-08	DGT	ETF	75.1	75.45	74.84	75.01	13400.0
2006-12-08	DHS	ETF	56.85	57.02	56.64	56.9	11400.0
2006-12-08	DIM	ETF	62.55	62.79	62.23	62.26	18600.0

> showing 50 of 387 rows — these rows as CSV

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