PREVIEW / etf_daily / 2006-12-27

all etf daily files

  file:    by_date/etf_daily/2006/2006-12-27.parquet
  size:    19 KB
  rows:    391

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-27	SPY	ETF	141.87	142.6	141.83	142.51	39727100.0
2006-12-27	QQQ	ETF	43.19	43.4	43.1	43.33	54155197.0
2006-12-27	IWM	ETF	78.37	79.17	78.35	79.14	39294000.0
2006-12-27	DIA	ETF	124.36	124.99	124.25	124.93	5714600.0
2006-12-27	GLD	ETF	62.3	62.46	62.17	62.22	3063500.0
2006-12-27	TLT	ETF	89.28	89.33	88.7	88.7	840700.0
2006-12-27	AAA	ETF	62.0	62.0	61.79	61.97	6300.0
2006-12-27	ADRE	ETF	38.5	38.98	38.4001	38.97	145077.0
2006-12-27	AGG	ETF	100.01	100.11	99.66	99.84	781500.0
2006-12-27	AIQ	ETF	33.5	34.05	33.25	33.85	21540.0
2006-12-27	AIS	ETF	1.2	1.24	1.1801	1.2	709600.0
2006-12-27	ARB	ETF	44.15	44.48	43.81	44.45	101500.0
2006-12-27	BAB	ETF	102.83	103.27	102.28	103.27	31700.0
2006-12-27	BBC	ETF	4.5	4.5399	4.2801	4.44	291200.0
2006-12-27	BBH	ETF	61.2533	61.49	60.9733	61.1633	353700.0
2006-12-27	BITS	ETF	33.12	35.16	32.8752	35.0	22828.0
2006-12-27	BNE	ETF	15.8	16.2	15.8	16.14	117800.0
2006-12-27	BRF	ETF	14.29	14.35	14.27	14.33	38200.0
2006-12-27	BTF	ETF	107.94999999999999	108.6	107.5	108.6	2320.0
2006-12-27	CBON	ETF	30.06	30.5	30.06	30.3	43008.0
2006-12-27	CDL	ETF	9.75	9.94	9.69	9.85	420600.0
2006-12-27	CEF	ETF	9.2	9.31	9.2	9.21	189800.0
2006-12-27	CEW	ETF	26.12	26.12	26.12	26.12	100.0
2006-12-27	CGO	ETF	16.6	16.8	16.5806	16.8	10200.0
2006-12-27	CHB	ETF	9.44	9.5	9.27	9.41	759500.0
2006-12-27	CHI	ETF	20.15	20.22	19.94	20.15	84700.0
2006-12-27	CHIC	ETF	30.17	30.96	29.96	30.87	271598.0
2006-12-27	CHY	ETF	17.1	17.12	17.01	17.12	69500.0
2006-12-27	CIL	ETF	25.16	25.45	25.14	25.3	5200.0
2006-12-27	CN	ETF	61.39	63.02	58.49	61.15	669900.0
2006-12-27	CNXT	ETF	2.031	2.1	2.01	2.08	7892052.0
2006-12-27	CPI	ETF	23.56	23.6	23.56	23.6	300.0
2006-12-27	CPST	ETF	1.23	1.27	1.23	1.26	1376823.0
2006-12-27	CSA	ETF	21.0	21.31	20.9	21.26	12000.0
2006-12-27	CSB	ETF	33.34	33.4	33.22	33.38	7900.0
2006-12-27	CSD	ETF	25.2	25.21	25.1	25.15	12000.0
2006-12-27	CSM	ETF	1.3325	1.3325	1.3325	1.3325	400.0
2006-12-27	CSQ	ETF	15.69	15.7	15.52	15.6	209800.0
2006-12-27	CTEC	ETF	92.24999999999999	92.94999999999999	91.69999999999999	91.75	17107.2
2006-12-27	CVY	ETF	26.43	26.62	26.43	26.62	46700.0
2006-12-27	DBC	ETF	24.5	24.5599	24.3	24.3	152200.0
2006-12-27	DBV	ETF	25.82	25.91	25.8	25.91	115200.0
2006-12-27	DDM	ETF	6.9083	6.9542	6.9	6.9542	540000.0
2006-12-27	DEF	ETF	25.06	25.14	25.04	25.14	59700.0
2006-12-27	DES	ETF	19.2267	19.3767	19.2267	19.3767	44100.0
2006-12-27	DEW	ETF	61.54	61.98	61.54	61.98	8700.0
2006-12-27	DFE	ETF	65.2	65.39	65.09	65.39	25300.0
2006-12-27	DFJ	ETF	51.08	51.08	50.85	51.05	30200.0
2006-12-27	DGT	ETF	75.9	76.46	75.9	76.45	4600.0
2006-12-27	DHS	ETF	58.0	58.21	57.94	58.21	14700.0

> showing 50 of 391 rows — these rows as CSV

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