PREVIEW / etf_daily / 2006-12-19

all etf daily files

  file:    by_date/etf_daily/2006/2006-12-19.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-19	SPY	ETF	141.55	142.56	141.19	142.22	65023600.0
2006-12-19	QQQ	ETF	43.65	44.06	43.38	43.85	136551811.0
2006-12-19	IWM	ETF	77.45	78.11	77.1	77.86	54066400.0
2006-12-19	DIA	ETF	123.9	124.64	123.7	124.38	6186200.0
2006-12-19	GLD	ETF	61.2	61.83	61.18	61.8	4254900.0
2006-12-19	TLT	ETF	89.51	89.81	89.51	89.64	930700.0
2006-12-19	AAA	ETF	61.17	61.2	61.03	61.1	5000.0
2006-12-19	ADRE	ETF	37.31	37.63	36.5	37.63	442419.0
2006-12-19	AGG	ETF	100.32	100.45	100.29	100.44	252900.0
2006-12-19	AIQ	ETF	31.15	32.75	30.55	31.5	83580.0
2006-12-19	AIS	ETF	1.21	1.21	1.16	1.2	262500.0
2006-12-19	ARB	ETF	43.8	44.2	43.62	44.07	98200.0
2006-12-19	BAB	ETF	102.44	103.69	101.96	103.55	93200.0
2006-12-19	BBC	ETF	4.2	4.5	4.2	4.3	185800.0
2006-12-19	BBH	ETF	61.3	61.92	60.94	61.7167	857400.0
2006-12-19	BITS	ETF	33.68	33.88	32.3572	32.72	30993.0
2006-12-19	BNE	ETF	15.55	15.81	15.51	15.51	86700.0
2006-12-19	BRF	ETF	14.28	14.28	14.28	14.28	16200.0
2006-12-19	BTF	ETF	112.5	113.39999999999999	111.69999999999999	112.3415	3280.0
2006-12-19	CBON	ETF	29.78	30.26	29.7	29.72	31517.0
2006-12-19	CDL	ETF	9.52	9.7	9.47	9.67	482700.0
2006-12-19	CEF	ETF	9.07	9.28	9.07	9.24	591100.0
2006-12-19	CFO	ETF	11.12	11.12	11.12	11.12	1800.0
2006-12-19	CGO	ETF	16.65	16.67	16.52	16.66	11100.0
2006-12-19	CHB	ETF	9.63	9.6388	9.32	9.53	858500.0
2006-12-19	CHI	ETF	20.19	20.24	20.08	20.1	71300.0
2006-12-19	CHIC	ETF	31.75	31.82	30.74	31.1	468020.0
2006-12-19	CHY	ETF	17.1	17.13	17.0	17.03	117600.0
2006-12-19	CIL	ETF	25.34	25.35	25.28	25.28	2500.0
2006-12-19	CN	ETF	47.05	47.66	46.57	47.49	51400.0
2006-12-19	CNXT	ETF	2.115	2.12	2.08	2.09	5878447.0
2006-12-19	CPI	ETF	23.11	23.11	23.11	23.11	100.0
2006-12-19	CPST	ETF	1.26	1.33	1.25	1.29	1546616.0
2006-12-19	CSA	ETF	20.24	20.29	19.97	20.09	31500.0
2006-12-19	CSB	ETF	33.42	33.74	33.42	33.69	11600.0
2006-12-19	CSD	ETF	24.74	24.98	24.74	24.98	3800.0
2006-12-19	CSM	ETF	1.3125	1.315	1.3125	1.3125	16800.0
2006-12-19	CSQ	ETF	15.59	15.67	15.47	15.59	354900.0
2006-12-19	CTEC	ETF	91.6	93.75	91.5005	93.75	24455.600000000002
2006-12-19	CVY	ETF	26.83	26.89	26.72	26.85	16600.0
2006-12-19	DBC	ETF	24.39	24.78	24.1912	24.76	294800.0
2006-12-19	DBV	ETF	25.63	25.69	25.5588	25.58	269600.0
2006-12-19	DDM	ETF	7.38	7.4958	7.38	7.4775	1004400.0
2006-12-19	DEF	ETF	24.9499	25.03	24.93	25.03	2300.0
2006-12-19	DES	ETF	19.0	19.1	18.9833	19.0867	70500.0
2006-12-19	DEW	ETF	61.56	62.31	61.56	62.25	9400.0
2006-12-19	DFE	ETF	64.7	65.29	64.65	65.29	9200.0
2006-12-19	DFJ	ETF	50.3	50.53	50.27	50.37	5300.0
2006-12-19	DGT	ETF	75.8	76.35	75.8	76.34	5400.0
2006-12-19	DHS	ETF	58.1	58.2	57.83	58.15	133200.0

> showing 50 of 386 rows — these rows as CSV

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