PREVIEW / etf_daily / 2006-09-14

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-14.parquet
  size:    18 KB
  rows:    361

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-14	SPY	ETF	131.96	132.24	131.75	132.23	57805400.0
2006-09-14	QQQ	ETF	39.85	40.22	39.76	39.99	98115993.0
2006-09-14	IWM	ETF	72.47	72.59	72.01	72.49	33680200.0
2006-09-14	DIA	ETF	115.28	115.59	115.06	115.51	4182000.0
2006-09-14	GLD	ETF	58.59	58.72	57.08	57.19	7637700.0
2006-09-14	TLT	ETF	87.65	87.87	87.42	87.53	672800.0
2006-09-14	AAA	ETF	57.25	57.8	57.25	57.56	4100.0
2006-09-14	ADRE	ETF	32.12	32.12	31.82	31.9	113404.0
2006-09-14	AFK	ETF	25.04	25.05	24.98	25.04	6900.0
2006-09-14	AGG	ETF	99.39	99.46	99.26	99.28	172400.0
2006-09-14	AIQ	ETF	41.5	41.8495	40.4	41.1	36220.0
2006-09-14	AIS	ETF	1.08	1.11	1.0	1.09	110500.0
2006-09-14	ARB	ETF	38.16	38.23	37.84	37.96	91800.0
2006-09-14	BAB	ETF	80.11	80.84	80.04	80.81	34200.0
2006-09-14	BBC	ETF	10.7	10.95	10.7	10.94	191700.0
2006-09-14	BBH	ETF	59.0	59.59	59.0	59.1067	537300.0
2006-09-14	BITS	ETF	28.4	28.5496	27.68	27.96	7244.0
2006-09-14	BNE	ETF	14.81	14.98	14.5	14.5	147100.0
2006-09-14	BRF	ETF	14.16	14.16	14.15	14.16	7400.0
2006-09-14	BTF	ETF	93.35000000000001	93.49999999999999	93.2	93.45	5960.0
2006-09-14	CBON	ETF	33.15	33.15	32.8	33.05	32106.0
2006-09-14	CDL	ETF	9.21	9.24	9.05	9.12	159600.0
2006-09-14	CEF	ETF	8.39	8.4	8.01	8.02	426500.0
2006-09-14	CEW	ETF	25.4099	25.4099	25.4099	25.4099	100.0
2006-09-14	CGO	ETF	15.52	15.52	15.37	15.39	14800.0
2006-09-14	CHB	ETF	6.58	6.67	6.48	6.52	713300.0
2006-09-14	CHI	ETF	19.53	19.61	19.47	19.52	152400.0
2006-09-14	CHIC	ETF	27.18	27.63	26.71	27.44	990039.0
2006-09-14	CHY	ETF	16.63	16.65	16.57	16.6301	87500.0
2006-09-14	CIZ	ETF	22.1	22.1	22.1	22.1	100.0
2006-09-14	CN	ETF	35.0	35.19	34.95	35.19	19200.0
2006-09-14	CNXT	ETF	1.93	1.93	1.86	1.88	7220108.0
2006-09-14	COMB	ETF	10.1	10.101	9.96	9.96	21200.0
2006-09-14	CPI	ETF	24.75	24.75	23.99	24.4899	12000.0
2006-09-14	CPST	ETF	1.77	1.8	1.62	1.65	2897938.0
2006-09-14	CSA	ETF	20.45	20.9	20.45	20.75	21500.0
2006-09-14	CSB	ETF	28.3	28.44	28.25	28.26	28000.0
2006-09-14	CSQ	ETF	14.52	14.52	14.36	14.44	312100.0
2006-09-14	CTEC	ETF	64.89999999999999	65.1	63.099999999999994	64.64999999999999	13472.800000000001
2006-09-14	CYB	ETF	6.4	6.4	6.28	6.3	66800.0
2006-09-14	DBC	ETF	23.67	23.67	23.18	23.35	288700.0
2006-09-14	DDM	ETF	6.425	6.45	6.3933	6.425	529200.0
2006-09-14	DES	ETF	17.9067	17.9067	17.8333	17.8667	42000.0
2006-09-14	DEW	ETF	54.76	54.86	54.63	54.72	58300.0
2006-09-14	DFE	ETF	54.94	54.96	54.88	54.9	1700.0
2006-09-14	DFJ	ETF	49.24	49.32	49.21	49.21	1600.0
2006-09-14	DGT	ETF	70.85	70.89	70.62	70.62	4300.0
2006-09-14	DHS	ETF	54.55	54.56	54.42	54.56	45800.0
2006-09-14	DIM	ETF	55.18	55.31	55.09	55.25	4900.0
2006-09-14	DIV	ETF	12.55	12.6	12.5	12.52	20700.0

> showing 50 of 361 rows — these rows as CSV

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