PREVIEW / etf_daily / 2006-06-08

all etf daily files

  file:    by_date/etf_daily/2006/2006-06-08.parquet
  size:    17 KB
  rows:    330

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-08	SPY	ETF	125.58	126.5	123.87	125.75	204957200.0
2006-06-08	QQQ	ETF	38.27	38.56	37.49	38.4	280562157.0
2006-06-08	IWM	ETF	69.78	70.42	68.0	70.16	140237700.0
2006-06-08	DIA	ETF	109.12	109.67	107.52	109.0	26005000.0
2006-06-08	GLD	ETF	61.5	61.53	60.43	60.91	14228500.0
2006-06-08	TLT	ETF	85.24	85.78	85.11	85.27	3496700.0
2006-06-08	AAA	ETF	56.5	56.75	56.1001	56.75	10800.0
2006-06-08	ADRE	ETF	115.01	116.438	111.74	116.37	251648.0
2006-06-08	AFK	ETF	25.28	25.37	25.26	25.26	7500.0
2006-06-08	AGG	ETF	98.18	98.44	98.01	98.23	205100.0
2006-06-08	AIQ	ETF	27.5	28.7	26.95	28.4	18200.0
2006-06-08	AIS	ETF	1.29	1.31	1.22	1.3	211600.0
2006-06-08	AOM	ETF	7.15	7.15	6.85	7.12	38300.0
2006-06-08	ARB	ETF	38.53	39.5	38.11	39.0	569000.0
2006-06-08	BAB	ETF	62.6	63.03	61.94	62.58	75900.0
2006-06-08	BBC	ETF	9.27	9.5	8.5	8.82	588600.0
2006-06-08	BBH	ETF	57.1133	58.3233	56.5	58.0367	5590200.0
2006-06-08	BCM	ETF	69.67	70.22	69.37	70.06	41900.0
2006-06-08	BITS	ETF	23.88	24.72	23.64	24.08	14613.0
2006-06-08	BKF	ETF	6.1	6.48	5.94	6.42	117300.0
2006-06-08	BNE	ETF	13.96	14.43	13.73	14.3	137600.0
2006-06-08	BRF	ETF	13.98	13.98	13.92	13.94	2500.0
2006-06-08	BTF	ETF	88.49999999999999	88.9	88.05	88.49999999999999	2900.0
2006-06-08	CBON	ETF	30.4	31.24	30.4	30.88	33540.0
2006-06-08	CDL	ETF	9.04	9.2	8.95	9.17	298000.0
2006-06-08	CEF	ETF	8.75	8.9	8.65	8.88	697700.0
2006-06-08	CEW	ETF	25.56	25.56	25.56	25.56	200.0
2006-06-08	CFO	ETF	10.0	10.05	10.0	10.05	400.0
2006-06-08	CGO	ETF	14.51	14.56	14.34	14.34	10600.0
2006-06-08	CHB	ETF	11.18	11.24	10.67	11.16	1099800.0
2006-06-08	CHI	ETF	19.7	19.84	19.53	19.6	87800.0
2006-06-08	CHIC	ETF	20.68	20.81	19.8	20.09	755329.0
2006-06-08	CHY	ETF	16.83	16.83	16.5	16.65	142400.0
2006-06-08	CIL	ETF	25.1	25.1	25.1	25.1	200.0
2006-06-08	CN	ETF	31.69	31.94	30.67	31.75	88700.0
2006-06-08	CNXT	ETF	2.6	2.61	2.4	2.55	23036340.0
2006-06-08	COMB	ETF	9.9	10.02	9.78	9.89	24622.0
2006-06-08	CPI	ETF	33.3599	33.3599	33.3	33.3	200.0
2006-06-08	CPST	ETF	2.76	2.79	2.58	2.66	2324448.0
2006-06-08	CSA	ETF	18.01	18.25	18.01	18.2	2900.0
2006-06-08	CSB	ETF	27.45	27.66	27.3301	27.57	5000.0
2006-06-08	CSQ	ETF	13.98	14.0	13.81	13.98	324800.0
2006-06-08	CTEC	ETF	70.0	70.8	69.5	70.19999999999999	10418.0
2006-06-08	CYB	ETF	5.96	5.96	5.65	5.7	15600.0
2006-06-08	DBC	ETF	25.01	25.06	24.7	24.98	722700.0
2006-06-08	DGT	ETF	66.3	66.35	65.46	66.2	2600.0
2006-06-08	DIG	ETF	17.75	17.75	17.5625	17.7	9520.0
2006-06-08	DIV	ETF	11.96	12.02	11.86	12.02	31100.0
2006-06-08	DJP	ETF	49.27	49.38	48.93	49.25	100600.0
2006-06-08	DRIV	ETF	38.95	39.53	37.0	38.99	1163334.0

> showing 50 of 330 rows — these rows as CSV

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