PREVIEW / etf_daily / 2006-12-29

all etf daily files

  file:    by_date/etf_daily/2006/2006-12-29.parquet
  size:    19 KB
  rows:    392

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-29	SPY	ETF	142.06	142.54	141.43	141.62	45461200.0
2006-12-29	QQQ	ETF	43.21	43.61	43.12	43.16	75169388.0
2006-12-29	IWM	ETF	78.66	78.99	77.99	78.03	30795200.0
2006-12-29	DIA	ETF	124.8	125.1	124.34	124.41	4935800.0
2006-12-29	GLD	ETF	62.91	63.25	62.88	63.21	2117200.0
2006-12-29	TLT	ETF	88.35	88.55	88.21	88.43	775500.0
2006-12-29	AAA	ETF	62.0	62.09	61.75	62.0	1700.0
2006-12-29	ADRE	ETF	39.03	39.07	38.83	38.932	173826.0
2006-12-29	AGG	ETF	99.73	99.73	99.61	99.7	278800.0
2006-12-29	AIQ	ETF	33.9	34.0	33.05	33.25	19760.0
2006-12-29	AIS	ETF	1.19	1.2	1.16	1.2	305700.0
2006-12-29	ARB	ETF	44.1	44.35	43.41	43.44	137300.0
2006-12-29	BAB	ETF	104.49	104.49	103.24	103.27	29300.0
2006-12-29	BBC	ETF	5.05	5.42	5.05	5.1	674500.0
2006-12-29	BBH	ETF	61.03	61.6933	61.03	61.24	769500.0
2006-12-29	BITS	ETF	34.84	35.32	34.32	34.8	8646.0
2006-12-29	BNE	ETF	16.06	16.18	15.91	15.94	227000.0
2006-12-29	BOSS	ETF	40.25	40.8	40.25	40.8	300.0
2006-12-29	BRF	ETF	14.35	14.445	14.35	14.42	15100.0
2006-12-29	BTF	ETF	111.19999999999999	112.14999999999999	110.7	111.69999999999999	5880.0
2006-12-29	CBON	ETF	30.38	30.54	30.05	30.19	43528.0
2006-12-29	CDL	ETF	9.96	10.06	9.89	9.96	289500.0
2006-12-29	CEF	ETF	9.31	9.37	9.27	9.34	260900.0
2006-12-29	CEW	ETF	26.06	26.06	26.06	26.06	100.0
2006-12-29	CGO	ETF	16.98	17.1	16.93	17.0	11000.0
2006-12-29	CHB	ETF	9.56	9.59	9.32	9.36	890600.0
2006-12-29	CHI	ETF	20.17	20.34	20.13	20.3101	50100.0
2006-12-29	CHIC	ETF	30.9	31.3	30.48	30.75	267918.0
2006-12-29	CHY	ETF	17.2	17.35	17.2	17.3	85300.0
2006-12-29	CIL	ETF	25.21	25.21	25.17	25.17	3000.0
2006-12-29	CN	ETF	54.5	56.0	53.26	53.52	302100.0
2006-12-29	CNXT	ETF	2.05	2.06	2.02	2.04	8505199.0
2006-12-29	CPI	ETF	24.0399	24.0399	24.0399	24.0399	500.0
2006-12-29	CPST	ETF	1.24	1.25	1.21	1.23	2185808.0
2006-12-29	CSA	ETF	21.42	21.57	21.41	21.5	19000.0
2006-12-29	CSB	ETF	33.05	33.38	33.04	33.31	8900.0
2006-12-29	CSD	ETF	25.13	25.16	25.06	25.07	14200.0
2006-12-29	CSM	ETF	1.3425	1.3425	1.3425	1.3425	800.0
2006-12-29	CSQ	ETF	15.63	15.75	15.61	15.64	213800.0
2006-12-29	CTEC	ETF	91.75	92.14999999999999	91.25	92.14999999999999	17476.4
2006-12-29	CVY	ETF	26.54	26.54	26.43	26.43	24300.0
2006-12-29	DBC	ETF	24.42	24.64	24.25	24.58	276300.0
2006-12-29	DBV	ETF	26.0	26.01	25.77	25.95	161800.0
2006-12-29	DDM	ETF	6.9492	6.9667	6.89	6.9167	636000.0
2006-12-29	DEF	ETF	25.15	25.18	25.09	25.09	8200.0
2006-12-29	DES	ETF	19.2767	19.3333	19.12	19.12	79200.0
2006-12-29	DEW	ETF	61.73	61.92	61.64	61.66	4600.0
2006-12-29	DFE	ETF	65.34	65.51	65.25	65.25	13400.0
2006-12-29	DFJ	ETF	50.95	51.12	50.8	50.8	12900.0
2006-12-29	DGT	ETF	76.27	76.42	76.08	76.08	10200.0

> showing 50 of 392 rows — these rows as CSV

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