PREVIEW / etf_daily / 2006-06-20

all etf daily files

  file:    by_date/etf_daily/2006/2006-06-20.parquet
  size:    17 KB
  rows:    340

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-06-20	SPY	ETF	124.01	124.81	123.72	124.09	65494700.0
2006-06-20	QQQ	ETF	38.09	38.48	37.94	38.08	102888558.0
2006-06-20	IWM	ETF	67.56	68.33	67.31	67.42	61105000.0
2006-06-20	DIA	ETF	109.47	110.23	109.27	109.86	7217400.0
2006-06-20	GLD	ETF	56.64	57.48	56.16	57.3	11072400.0
2006-06-20	TLT	ETF	84.13	84.19	83.88	84.05	611400.0
2006-06-20	AAA	ETF	54.96	55.08	54.79	54.95	4900.0
2006-06-20	ADRE	ETF	112.19	115.13	112.19	113.92	78084.0
2006-06-20	AFK	ETF	24.76	24.84	24.73	24.84	8100.0
2006-06-20	AGG	ETF	97.61	97.63	97.42	97.56	109200.0
2006-06-20	AIQ	ETF	29.3	30.45	29.3	29.9	15720.0
2006-06-20	AIS	ETF	1.19	1.19	1.12	1.15	76100.0
2006-06-20	AOM	ETF	6.28	6.29	6.2	6.21	6100.0
2006-06-20	ARB	ETF	36.97	37.03	36.77	36.78	313000.0
2006-06-20	BAB	ETF	65.86	66.87	65.8	66.67	61100.0
2006-06-20	BBC	ETF	10.3	10.7	10.11	10.35	159500.0
2006-06-20	BBH	ETF	57.6667	57.6667	56.41	56.5667	1694100.0
2006-06-20	BCM	ETF	68.9	69.2	67.77	68.09	20100.0
2006-06-20	BITS	ETF	22.36	22.36	19.96	20.0	50067.0
2006-06-20	BKF	ETF	6.17	6.27	6.08	6.08	40300.0
2006-06-20	BNE	ETF	13.55	13.85	13.52	13.59	131200.0
2006-06-20	BOSS	ETF	33.0	33.0	32.9	32.9	100.0
2006-06-20	BRF	ETF	14.0	14.05	13.95	13.99	10800.0
2006-06-20	BTF	ETF	90.29999999999998	90.29999999999998	88.75	88.75	1320.0
2006-06-20	CBON	ETF	29.55	29.93	29.53	29.54	27604.0
2006-06-20	CDL	ETF	8.71	8.83	8.65	8.7	271500.0
2006-06-20	CEF	ETF	8.26	8.63	8.25	8.61	530600.0
2006-06-20	CFO	ETF	9.64	9.64	9.63	9.63	3500.0
2006-06-20	CGO	ETF	14.0	14.17	13.93	14.11	27700.0
2006-06-20	CHB	ETF	9.36	9.6499	9.21	9.29	634000.0
2006-06-20	CHI	ETF	19.05	19.11	18.9701	19.0	84400.0
2006-06-20	CHIC	ETF	19.43	19.95	19.33	19.81	239551.0
2006-06-20	CHY	ETF	16.05	16.1	16.01	16.02	210800.0
2006-06-20	CIL	ETF	25.06	25.06	25.04	25.05	4200.0
2006-06-20	CN	ETF	32.15	32.55	32.0	32.22	21500.0
2006-06-20	CNXT	ETF	2.37	2.42	2.36	2.39	5608292.0
2006-06-20	COMB	ETF	9.7	9.85	9.6	9.6	6702.0
2006-06-20	CPI	ETF	32.55	32.8	32.15	32.8	1400.0
2006-06-20	CPST	ETF	2.27	2.45	2.25	2.43	1555636.0
2006-06-20	CSA	ETF	18.65	18.65	18.61	18.64	900.0
2006-06-20	CSB	ETF	26.82	26.98	26.73	26.86	3600.0
2006-06-20	CSQ	ETF	13.79	13.82	13.73	13.8	310400.0
2006-06-20	CTEC	ETF	61.3	63.63999999999999	61.1	62.24999999999999	21764.2
2006-06-20	CYB	ETF	5.5	5.69	5.46	5.55	4900.0
2006-06-20	DBC	ETF	24.01	24.14	23.9	24.1	318000.0
2006-06-20	DES	ETF	16.5367	16.56	16.5333	16.5367	18000.0
2006-06-20	DEW	ETF	49.71	50.12	49.71	49.91	400.0
2006-06-20	DFE	ETF	50.89	50.89	50.76	50.76	500.0
2006-06-20	DFJ	ETF	50.35	50.77	50.35	50.41	1300.0
2006-06-20	DGT	ETF	65.17	65.32	65.11	65.11	400.0

> showing 50 of 340 rows — these rows as CSV

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