PREVIEW / etf_daily / 2006-09-13

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-13.parquet
  size:    18 KB
  rows:    362

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-09-13	SPY	ETF	131.64	132.45	131.52	132.22	62898400.0
2006-09-13	QQQ	ETF	39.73	39.982	39.63	39.96	116096212.0
2006-09-13	IWM	ETF	72.16	72.88	72.0	72.75	35612000.0
2006-09-13	DIA	ETF	114.86	115.79	114.85	115.47	4674000.0
2006-09-13	GLD	ETF	58.6	58.93	57.97	58.62	3539100.0
2006-09-13	TLT	ETF	88.03	88.03	87.66	87.73	797000.0
2006-09-13	AAA	ETF	57.37	57.6	57.3	57.55	7900.0
2006-09-13	ADRE	ETF	31.75	32.26	31.7001	32.13	142940.0
2006-09-13	AFK	ETF	25.02	25.08	25.01	25.08	8600.0
2006-09-13	AGG	ETF	99.49	99.53	99.32	99.42	130600.0
2006-09-13	AIQ	ETF	41.6	42.25	41.2	41.5	53400.0
2006-09-13	AIS	ETF	1.12	1.12	1.04	1.05	254000.0
2006-09-13	ARB	ETF	37.55	38.39	37.55	38.33	147200.0
2006-09-13	BAB	ETF	80.07	80.67	79.51	80.64	57500.0
2006-09-13	BBC	ETF	11.4	11.4	10.45	10.75	327900.0
2006-09-13	BBH	ETF	59.0667	59.1667	58.7867	58.97	734700.0
2006-09-13	BITS	ETF	27.84	28.96	27.52	28.16	15230.0
2006-09-13	BNE	ETF	14.48	14.93	14.47	14.83	96600.0
2006-09-13	BRF	ETF	14.17	14.17	14.16	14.16	800.0
2006-09-13	BTF	ETF	93.14999999999999	93.24999999999999	92.5	93.24999999999999	7540.0
2006-09-13	CBON	ETF	33.14	33.14	32.82	33.0	22011.0
2006-09-13	CDL	ETF	9.28	9.31	9.18	9.21	207400.0
2006-09-13	CEF	ETF	8.23	8.37	8.18	8.35	443000.0
2006-09-13	CEW	ETF	25.25	25.43	25.25	25.43	400.0
2006-09-13	CFO	ETF	9.9	9.98	9.85	9.98	4000.0
2006-09-13	CGO	ETF	15.35	15.51	15.35	15.51	9400.0
2006-09-13	CHB	ETF	6.73	6.8	6.56	6.6	1244300.0
2006-09-13	CHI	ETF	19.6	19.6301	19.53	19.6	134000.0
2006-09-13	CHIC	ETF	26.6	27.49	26.54	27.09	561535.0
2006-09-13	CHY	ETF	16.53	16.63	16.5	16.6	145700.0
2006-09-13	CIZ	ETF	22.0	22.0	22.0	22.0	200.0
2006-09-13	CN	ETF	35.05	35.37	35.0	35.22	52600.0
2006-09-13	CNXT	ETF	1.93	1.97	1.91	1.92	10276711.0
2006-09-13	COMB	ETF	10.1	10.1	10.1	10.1	5700.0
2006-09-13	CPI	ETF	26.55	26.55	24.8	25.25	8500.0
2006-09-13	CPST	ETF	1.81	1.81	1.75	1.77	956576.0
2006-09-13	CSA	ETF	20.18	20.4	20.18	20.4	12500.0
2006-09-13	CSB	ETF	27.82	28.12	27.82	27.95	8600.0
2006-09-13	CSQ	ETF	14.55	14.59	14.43	14.49	446200.0
2006-09-13	CTEC	ETF	63.89999999999999	64.95	63.75	64.89999999999999	11509.800000000001
2006-09-13	CYB	ETF	6.56	6.56	6.3	6.4	42600.0
2006-09-13	DBC	ETF	23.51	23.7	23.37	23.49	383900.0
2006-09-13	DDM	ETF	6.3733	6.4675	6.3733	6.4375	524400.0
2006-09-13	DES	ETF	17.8167	17.9433	17.8167	17.9433	27000.0
2006-09-13	DEW	ETF	54.5	54.65	54.2	54.65	3600.0
2006-09-13	DFE	ETF	54.28	54.51	54.28	54.5	1300.0
2006-09-13	DFJ	ETF	49.5	49.56	49.28	49.47	46900.0
2006-09-13	DGT	ETF	70.8	71.17	70.55	71.02	20500.0
2006-09-13	DHS	ETF	54.35	54.57	54.27	54.57	26900.0
2006-09-13	DIM	ETF	54.89	55.1	54.79	55.0	7300.0

> showing 50 of 362 rows — these rows as CSV

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