PREVIEW / etf_daily / 2006-12-06

all etf daily files

  file:    by_date/etf_daily/2006/2006-12-06.parquet
  size:    19 KB
  rows:    386

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-12-06	SPY	ETF	141.87	142.07	141.5	141.78	53253200.0
2006-12-06	QQQ	ETF	44.29	44.4	44.07	44.26	78254132.0
2006-12-06	IWM	ETF	79.2	79.49	78.79	79.11	37810400.0
2006-12-06	DIA	ETF	123.31	123.4	122.97	123.15	4234800.0
2006-12-06	GLD	ETF	63.08	63.45	62.29	62.69	6386500.0
2006-12-06	TLT	ETF	91.03	91.18	90.89	90.97	936100.0
2006-12-06	AAA	ETF	59.42	59.8	59.42	59.8	2100.0
2006-12-06	ADRE	ETF	37.84	37.92	37.56	37.6	86697.0
2006-12-06	AGG	ETF	100.82	100.89	100.75	100.82	222800.0
2006-12-06	AIQ	ETF	30.25	31.2	30.0	31.05	104320.0
2006-12-06	AIS	ETF	1.25	1.28	1.05	1.18	2200500.0
2006-12-06	ARB	ETF	44.3	44.61	44.05	44.3	146600.0
2006-12-06	BAB	ETF	97.9	98.34	97.56	98.17	53700.0
2006-12-06	BBC	ETF	5.01	5.039	4.85	5.0	176600.0
2006-12-06	BBH	ETF	62.5833	62.9	62.5433	62.89	291900.0
2006-12-06	BITS	ETF	35.2	35.48	34.04	34.88	17142.0
2006-12-06	BNE	ETF	15.7	15.9	15.66	15.84	126600.0
2006-12-06	BRF	ETF	14.37	14.4	14.35	14.35	8200.0
2006-12-06	BTF	ETF	111.89999999999999	112.4995	110.5	110.7995	1280.0
2006-12-06	CBON	ETF	30.43	30.5	30.0	30.19	27895.0
2006-12-06	CDL	ETF	9.83	9.85	9.67	9.75	311200.0
2006-12-06	CEF	ETF	9.59	9.6	9.45	9.55	838300.0
2006-12-06	CFO	ETF	11.06	11.07	11.06	11.07	1400.0
2006-12-06	CGO	ETF	16.35	16.39	16.15	16.2	20100.0
2006-12-06	CHB	ETF	10.13	10.28	10.01	10.09	1649500.0
2006-12-06	CHI	ETF	20.09	20.2	20.0401	20.06	84100.0
2006-12-06	CHIC	ETF	31.48	31.9	31.02	31.6	320922.0
2006-12-06	CHY	ETF	16.98	17.1	16.98	17.06	125700.0
2006-12-06	CIL	ETF	25.2	25.24	25.2	25.24	2600.0
2006-12-06	CN	ETF	43.68	44.2	43.2	44.2	184800.0
2006-12-06	CNXT	ETF	2.22	2.33	2.22	2.3	13925706.0
2006-12-06	CPST	ETF	1.34	1.41	1.33	1.36	1937504.0
2006-12-06	CSA	ETF	22.46	22.55	22.06	22.22	36800.0
2006-12-06	CSB	ETF	32.73	32.96	32.7	32.85	14300.0
2006-12-06	CSM	ETF	1.33	1.33	1.33	1.33	40000.0
2006-12-06	CSQ	ETF	15.28	15.3	15.19	15.28	405100.0
2006-12-06	CTEC	ETF	90.0	91.44999999999999	88.8	91.19999999999999	12338.2
2006-12-06	CVY	ETF	26.85	26.85	26.72	26.79	32800.0
2006-12-06	DBC	ETF	25.44	25.58	25.3	25.39	227700.0
2006-12-06	DBV	ETF	25.05	25.11	24.98	25.1	49100.0
2006-12-06	DDM	ETF	7.3225	7.3275	7.2808	7.3	418800.0
2006-12-06	DES	ETF	19.35	19.3867	19.3133	19.3467	37800.0
2006-12-06	DEW	ETF	60.47	60.71	60.39	60.51	26900.0
2006-12-06	DFE	ETF	63.6	63.81	63.56	63.64	16000.0
2006-12-06	DFJ	ETF	50.9	51.04	50.85	50.97	2700.0
2006-12-06	DGT	ETF	74.98	75.26	74.8	74.89	1800.0
2006-12-06	DHS	ETF	57.1	57.1	56.86	56.98	11700.0
2006-12-06	DIM	ETF	61.98	62.35	61.98	62.18	10600.0
2006-12-06	DIV	ETF	13.51	13.51	13.43	13.5	23300.0
2006-12-06	DJP	ETF	49.9	50.09	49.53	49.72	165000.0

> showing 50 of 386 rows — these rows as CSV

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