PREVIEW / etf_daily / 2006-06-26

all etf daily files

  file:    by_date/etf_daily/2006/2006-06-26.parquet
  size:    17 KB
  rows:    348

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-26	SPY	ETF	124.54	125.06	124.25	124.99	37899600.0
2006-06-26	QQQ	ETF	38.17	38.39	38.07	38.25	65157609.0
2006-06-26	IWM	ETF	69.02	69.5	68.95	69.5	39933200.0
2006-06-26	DIA	ETF	109.94	110.45	109.65	110.4	4298800.0
2006-06-26	GLD	ETF	58.25	58.33	57.42	58.28	3423700.0
2006-06-26	TLT	ETF	83.42	83.47	83.12	83.26	526100.0
2006-06-26	AAA	ETF	54.2	54.62	54.18	54.59	3200.0
2006-06-26	ADRE	ETF	117.3	117.709	116.85	117.4099	18480.0
2006-06-26	AFK	ETF	24.75	24.77	24.71	24.71	12100.0
2006-06-26	AGG	ETF	97.01	97.28	96.91	96.94	561200.0
2006-06-26	AIQ	ETF	31.25	31.8	29.5	30.5	17000.0
2006-06-26	AIS	ETF	1.25	1.25	1.12	1.15	104700.0
2006-06-26	AOM	ETF	6.1701	6.2	6.15	6.15	5200.0
2006-06-26	ARB	ETF	37.1	37.52	37.08	37.38	145200.0
2006-06-26	BAB	ETF	62.87	63.01	62.2	62.89	47200.0
2006-06-26	BBC	ETF	12.87	12.87	12.3	12.73	400700.0
2006-06-26	BBH	ETF	56.8667	57.2833	56.7	57.1667	1063200.0
2006-06-26	BCM	ETF	67.13	67.32	66.61	67.01	58400.0
2006-06-26	BITS	ETF	19.12	19.48	18.36	18.72	9717.0
2006-06-26	BKF	ETF	6.04	6.1	5.91	6.0	74500.0
2006-06-26	BNE	ETF	13.5	13.78	13.32	13.78	195600.0
2006-06-26	BRF	ETF	13.99	13.99	13.93	13.94	8500.0
2006-06-26	BTF	ETF	88.85	88.85	88.45	88.85	7640.0
2006-06-26	CBON	ETF	29.45	29.64	29.32	29.46	12288.0
2006-06-26	CDL	ETF	8.87	8.96	8.81	8.9	276200.0
2006-06-26	CEF	ETF	8.45	8.45	8.2	8.29	370700.0
2006-06-26	CFO	ETF	9.67	9.67	9.61	9.63	3200.0
2006-06-26	CGO	ETF	14.33	14.33	14.14	14.2	19200.0
2006-06-26	CHB	ETF	10.49	10.82	10.37	10.69	1101900.0
2006-06-26	CHI	ETF	19.11	19.15	19.0	19.01	71700.0
2006-06-26	CHIC	ETF	21.69	21.77	21.08	21.14	360663.0
2006-06-26	CHY	ETF	16.04	16.05	15.9	15.91	204100.0
2006-06-26	CIL	ETF	25.05	25.05	25.04	25.04	1000.0
2006-06-26	CIZ	ETF	22.75	22.75	22.75	22.75	500.0
2006-06-26	CN	ETF	33.0	33.25	32.5	32.81	73500.0
2006-06-26	CNXT	ETF	2.33	2.38	2.3	2.32	8962958.0
2006-06-26	COMB	ETF	9.75	9.95	9.7	9.92	14461.0
2006-06-26	CPST	ETF	2.6	2.6	2.46	2.52	1036228.0
2006-06-26	CSA	ETF	19.95	19.99	19.7	19.7	8100.0
2006-06-26	CSB	ETF	26.92	27.02	26.81	27.0	7900.0
2006-06-26	CSQ	ETF	13.85	13.95	13.81	13.89	249900.0
2006-06-26	CTEC	ETF	63.49999999999999	64.4	61.6	62.35	14370.0
2006-06-26	CYB	ETF	6.13	6.18	6.07	6.18	21100.0
2006-06-26	DBC	ETF	24.4	24.7	24.2	24.36	150400.0
2006-06-26	DDM	ETF	5.9125	5.94	5.8767	5.94	2295600.0
2006-06-26	DES	ETF	16.7	16.8833	16.7	16.8833	27900.0
2006-06-26	DFE	ETF	50.96	50.96	50.96	50.96	100.0
2006-06-26	DFJ	ETF	41.05	50.03	40.56	40.72	639200.0
2006-06-26	DGT	ETF	65.28	65.59	65.08	65.59	1900.0
2006-06-26	DHS	ETF	49.84	49.96	49.83	49.96	3300.0

> showing 50 of 348 rows — these rows as CSV

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