PREVIEW / etf_daily / 2006-12-01

all etf daily files

  file:    by_date/etf_daily/2006/2006-12-01.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-01	SPY	ETF	140.53	140.66	138.97	140.22	126080000.0
2006-12-01	QQQ	ETF	44.0	44.35	43.26	43.66	144582226.0
2006-12-01	IWM	ETF	78.15	78.37	76.85	77.78	87109800.0
2006-12-01	DIA	ETF	122.37	122.46	120.9	122.05	14513700.0
2006-12-01	GLD	ETF	64.2	64.55	63.99	64.12	6363800.0
2006-12-01	TLT	ETF	91.28	91.8	91.15	91.42	1156000.0
2006-12-01	AAA	ETF	58.73	59.2	58.73	59.2	2600.0
2006-12-01	ADRE	ETF	36.87	36.9	36.3	36.59	881366.0
2006-12-01	AGG	ETF	100.64	100.97	100.55	100.86	354500.0
2006-12-01	AIQ	ETF	29.9	30.1	29.5	29.75	68240.0
2006-12-01	AIS	ETF	1.3	1.3216	1.27	1.31	208200.0
2006-12-01	ARB	ETF	44.12	44.12	43.34	44.0	166900.0
2006-12-01	BAB	ETF	97.93	98.4	96.71	97.93	96100.0
2006-12-01	BBC	ETF	5.28	5.3076	5.0125	5.07	338000.0
2006-12-01	BBH	ETF	62.4967	62.77	61.6267	62.2567	918300.0
2006-12-01	BITS	ETF	35.2	35.4	34.12	34.88	19425.0
2006-12-01	BNE	ETF	15.86	15.86	15.38	15.54	78600.0
2006-12-01	BRF	ETF	14.33	14.34	14.29	14.34	7300.0
2006-12-01	BTF	ETF	107.79999999999998	107.79999999999998	106.5	106.8	2580.0
2006-12-01	CBON	ETF	30.18	30.33	29.61	29.91	31911.0
2006-12-01	CDL	ETF	9.48	9.55	9.38	9.4	258700.0
2006-12-01	CEF	ETF	9.7	9.83	9.62	9.78	774000.0
2006-12-01	CEW	ETF	25.62	25.62	25.62	25.62	1700.0
2006-12-01	CFO	ETF	10.95	11.1	10.95	11.08	22800.0
2006-12-01	CGO	ETF	16.75	16.75	16.55	16.57	7700.0
2006-12-01	CHB	ETF	9.41	9.99	9.28	9.56	1691700.0
2006-12-01	CHI	ETF	20.01	20.09	20.0	20.01	112000.0
2006-12-01	CHIC	ETF	30.31	31.17	29.78	30.33	527328.0
2006-12-01	CHY	ETF	17.17	17.25	17.1	17.13	104400.0
2006-12-01	CIL	ETF	25.23	25.23	25.11	25.11	1200.0
2006-12-01	CN	ETF	38.81	39.05	38.5	38.69	39500.0
2006-12-01	CNXT	ETF	2.17	2.18	2.11	2.13	7271795.0
2006-12-01	CPST	ETF	1.36	1.37	1.31	1.35	1076636.0
2006-12-01	CSA	ETF	21.98	21.98	21.8	21.82	25000.0
2006-12-01	CSB	ETF	32.67	32.78	32.4	32.52	28900.0
2006-12-01	CSM	ETF	1.3175	1.3175	1.315	1.315	8400.0
2006-12-01	CSQ	ETF	15.33	15.42	15.29	15.35	409200.0
2006-12-01	CTEC	ETF	91.44999999999999	93.0	87.94999999999999	89.25	34546.200000000004
2006-12-01	CVY	ETF	26.55	26.6	26.35	26.56	39500.0
2006-12-01	DBC	ETF	25.85	25.95	25.64	25.77	295800.0
2006-12-01	DBV	ETF	25.02	25.12	24.56	25.04	229700.0
2006-12-01	DDM	ETF	7.2233	7.2233	7.0433	7.1742	1216800.0
2006-12-01	DES	ETF	19.1633	19.1633	18.8833	19.0633	168300.0
2006-12-01	DEW	ETF	60.34	60.41	60.12	60.13	8500.0
2006-12-01	DFE	ETF	63.1	63.37	62.79	63.27	8600.0
2006-12-01	DFJ	ETF	49.87	50.17	49.76	50.08	14700.0
2006-12-01	DGT	ETF	75.0	75.0	74.24	74.7	4800.0
2006-12-01	DHS	ETF	56.9	56.9	56.37	56.75	10100.0
2006-12-01	DIM	ETF	61.6	61.61	61.12	61.55	15700.0
2006-12-01	DIV	ETF	13.38	13.43	13.27	13.3599	41100.0

> showing 50 of 386 rows — these rows as CSV

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