PREVIEW / etf_daily / 2006-12-12

all etf daily files

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

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-12	SPY	ETF	141.69	141.87	140.89	141.72	77451600.0
2006-12-12	QQQ	ETF	44.03	44.13	43.56	43.8	111266848.0
2006-12-12	IWM	ETF	78.94	79.02	77.89	78.55	47917600.0
2006-12-12	DIA	ETF	123.27	123.33	122.54	123.19	8976800.0
2006-12-12	GLD	ETF	62.41	62.56	62.17	62.52	3017900.0
2006-12-12	TLT	ETF	90.73	90.97	90.45	90.82	802800.0
2006-12-12	AAA	ETF	60.26	60.68	60.2	60.55	4800.0
2006-12-12	ADRE	ETF	37.42	37.42	36.79	37.05	122665.0
2006-12-12	AGG	ETF	100.7	100.8	100.6	100.78	222000.0
2006-12-12	AIQ	ETF	31.35	32.3	30.75	31.9	86880.0
2006-12-12	AIS	ETF	1.16	1.18	1.12	1.16	171900.0
2006-12-12	ARB	ETF	44.26	44.6	44.2	44.49	115600.0
2006-12-12	BAB	ETF	98.75	99.0	97.91	98.62	42000.0
2006-12-12	BBC	ETF	4.6	4.76	4.33	4.37	572100.0
2006-12-12	BBH	ETF	62.6333	62.7933	62.24	62.54	363900.0
2006-12-12	BITS	ETF	34.24	34.32	33.8	34.2	14418.0
2006-12-12	BNE	ETF	15.45	15.69	15.32	15.69	116000.0
2006-12-12	BRF	ETF	14.27	14.32	14.24	14.24	37300.0
2006-12-12	BTF	ETF	112.10000000000001	112.10000000000001	111.4995	111.95	1220.0
2006-12-12	CBON	ETF	30.22	30.45	30.21	30.34	16752.0
2006-12-12	CDL	ETF	9.7	9.7	9.5	9.52	953300.0
2006-12-12	CEF	ETF	9.52	9.57	9.5	9.56	590000.0
2006-12-12	CFO	ETF	11.12	11.1225	11.12	11.12	19500.0
2006-12-12	CGO	ETF	16.4	16.58	16.24	16.58	32600.0
2006-12-12	CHB	ETF	9.78	9.8	9.42	9.58	831200.0
2006-12-12	CHI	ETF	20.18	20.21	20.07	20.15	78300.0
2006-12-12	CHIC	ETF	31.22	31.47	30.36	30.7	427830.0
2006-12-12	CHY	ETF	17.01	17.06	16.97	17.01	135600.0
2006-12-12	CIL	ETF	25.29	25.29	25.29	25.29	1000.0
2006-12-12	CN	ETF	46.94	47.05	46.14	46.52	88000.0
2006-12-12	CNXT	ETF	2.22	2.23	2.17	2.19	8550677.0
2006-12-12	CPI	ETF	23.45	23.45	23.45	23.45	100.0
2006-12-12	CPST	ETF	1.3	1.31	1.27	1.3	1043811.0
2006-12-12	CSA	ETF	22.28	22.33	22.05	22.05	13600.0
2006-12-12	CSB	ETF	33.0	33.17	32.91	33.14	19700.0
2006-12-12	CSM	ETF	1.315	1.3175	1.315	1.315	100000.0
2006-12-12	CSQ	ETF	15.5	15.55	15.43	15.48	496300.0
2006-12-12	CTEC	ETF	93.8	93.8	91.19999999999999	92.75	35720.0
2006-12-12	CVY	ETF	26.8	26.8	26.62	26.73	23900.0
2006-12-12	DBC	ETF	25.12	25.29	25.0	25.1	114500.0
2006-12-12	DBV	ETF	25.35	25.35	25.25	25.31	15600.0
2006-12-12	DDM	ETF	7.3058	7.3092	7.2225	7.2967	792000.0
2006-12-12	DES	ETF	19.2667	19.36	19.1633	19.2467	27600.0
2006-12-12	DEW	ETF	61.31	61.49	60.93	61.46	7200.0
2006-12-12	DFE	ETF	64.23	64.54	64.0	64.53	8500.0
2006-12-12	DFJ	ETF	50.75	50.86	50.55	50.86	15500.0
2006-12-12	DGT	ETF	75.25	75.5	75.0	75.48	34500.0
2006-12-12	DHS	ETF	57.3	57.37	57.06	57.37	15900.0
2006-12-12	DIM	ETF	62.72	63.02	62.54	62.98	18700.0
2006-12-12	DIV	ETF	13.35	13.47	13.33	13.47	41200.0

> showing 50 of 386 rows — these rows as CSV

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