PREVIEW / etf_daily / 2006-06-12

all etf daily files

  file:    by_date/etf_daily/2006/2006-06-12.parquet
  size:    17 KB
  rows:    325

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-12	SPY	ETF	125.88	125.93	123.82	123.99	95815900.0
2006-06-12	QQQ	ETF	38.2	38.26	37.39	37.4	145634471.0
2006-06-12	IWM	ETF	69.7	69.75	67.83	67.94	108263800.0
2006-06-12	DIA	ETF	109.19	109.26	107.85	107.95	9054200.0
2006-06-12	GLD	ETF	60.78	60.84	59.98	60.03	4122500.0
2006-06-12	TLT	ETF	85.68	85.79	85.53	85.79	528700.0
2006-06-12	AAA	ETF	56.71	56.72	56.35	56.6	7900.0
2006-06-12	ADRE	ETF	114.19	115.36	111.03	111.03	83832.0
2006-06-12	AFK	ETF	25.4	25.48	25.32	25.38	9300.0
2006-06-12	AGG	ETF	98.36	98.36	98.06	98.07	193700.0
2006-06-12	AIQ	ETF	28.95	29.25	27.25	27.5	16640.0
2006-06-12	AIS	ETF	1.28	1.29	1.19	1.2399	256400.0
2006-06-12	AOM	ETF	7.25	7.27	7.24	7.24	8300.0
2006-06-12	ARB	ETF	38.45	38.45	37.85	37.85	441200.0
2006-06-12	BAB	ETF	64.88	64.96	63.27	63.39	60500.0
2006-06-12	BBC	ETF	9.2	9.4165	8.88	9.13	157500.0
2006-06-12	BBH	ETF	58.1267	58.2767	57.27	57.41	1614300.0
2006-06-12	BCM	ETF	71.91	72.09	71.33	71.8	39300.0
2006-06-12	BITS	ETF	24.2	24.64	23.56	24.04	20827.0
2006-06-12	BKF	ETF	6.77	6.99	6.7	6.77	23300.0
2006-06-12	BNE	ETF	13.79	13.9	13.21	13.64	158500.0
2006-06-12	BOSS	ETF	32.01	32.01	31.3	31.3	200.0
2006-06-12	BRF	ETF	13.95	13.98	13.95	13.95	7500.0
2006-06-12	BTF	ETF	88.6	88.85	88.49999999999999	88.75	360.0
2006-06-12	CBON	ETF	30.76	30.91	30.6	30.79	11533.0
2006-06-12	CDL	ETF	8.85	9.01	8.85	8.93	567200.0
2006-06-12	CEF	ETF	8.69	8.8	8.26	8.28	890800.0
2006-06-12	CFO	ETF	9.95	9.95	9.86	9.86	12200.0
2006-06-12	CGO	ETF	14.52	14.52	14.28	14.33	20600.0
2006-06-12	CHB	ETF	11.14	11.14	10.28	10.34	1415800.0
2006-06-12	CHI	ETF	19.57	19.73	19.4	19.4	92000.0
2006-06-12	CHIC	ETF	20.36	20.36	19.5	19.54	195150.0
2006-06-12	CHY	ETF	16.66	16.73	16.51	16.51	163900.0
2006-06-12	CIL	ETF	25.06	25.07	25.06	25.06	4400.0
2006-06-12	CIZ	ETF	23.05	23.15	23.05	23.15	300.0
2006-06-12	CN	ETF	32.75	32.75	31.88	31.88	57200.0
2006-06-12	CNXT	ETF	2.45	2.49	2.35	2.39	17184291.0
2006-06-12	COMB	ETF	10.0	10.0	9.35	9.51	6603.0
2006-06-12	CPI	ETF	33.1	33.1	33.1	33.1	500.0
2006-06-12	CPST	ETF	2.63	2.65	2.38	2.43	1786680.0
2006-06-12	CSA	ETF	18.58	18.99	18.2	18.72	4800.0
2006-06-12	CSB	ETF	27.6	27.6	27.15	27.16	3000.0
2006-06-12	CSQ	ETF	13.93	13.96	13.81	13.85	248400.0
2006-06-12	CTEC	ETF	71.35	71.9	67.14999999999999	67.45	17563.0
2006-06-12	CYB	ETF	5.7	5.9999	5.5	5.53	47300.0
2006-06-12	DBC	ETF	25.18	25.28	24.65	24.72	362400.0
2006-06-12	DGT	ETF	65.8	65.82	65.35	65.36	7200.0
2006-06-12	DIG	ETF	17.7125	17.7125	17.7125	17.7125	480.0
2006-06-12	DIV	ETF	11.96	11.99	11.93	11.95	13800.0
2006-06-12	DJP	ETF	49.19	49.21	48.78	48.8	54000.0

> showing 50 of 325 rows — these rows as CSV

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