PREVIEW / etf_daily / 2006-11-20

all etf daily files

  file:    by_date/etf_daily/2006/2006-11-20.parquet
  size:    19 KB
  rows:    383

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-11-20	SPY	ETF	140.3	140.74	139.94	140.5	69174200.0
2006-11-20	QQQ	ETF	44.16	44.48	44.01	44.39	107248632.0
2006-11-20	IWM	ETF	78.35	78.85	78.11	78.7	48400400.0
2006-11-20	DIA	ETF	123.1	123.45	122.9	123.13	5772200.0
2006-11-20	GLD	ETF	62.06	62.25	61.56	61.77	2947200.0
2006-11-20	TLT	ETF	90.0	90.12	89.86	90.09	857200.0
2006-11-20	AAA	ETF	57.79	58.08	57.79	58.08	4600.0
2006-11-20	ADRE	ETF	35.59	35.9	35.59	35.73	243864.0
2006-11-20	AGG	ETF	100.35	100.43	100.24	100.39	222200.0
2006-11-20	AIQ	ETF	31.25	32.2	30.75	30.75	70080.0
2006-11-20	AIS	ETF	1.25	1.25	1.17	1.22	288900.0
2006-11-20	ARB	ETF	45.4	45.8	44.91	45.3	98300.0
2006-11-20	BAB	ETF	90.86	91.99	90.79	91.62	58400.0
2006-11-20	BBC	ETF	5.02	5.54	5.014	5.47	1010700.0
2006-11-20	BBH	ETF	63.2667	63.51	62.72	62.9167	950700.0
2006-11-20	BITS	ETF	33.6	35.52	33.6	34.8	40355.0
2006-11-20	BNE	ETF	15.8	15.85	15.33	15.46	149300.0
2006-11-20	BRF	ETF	14.33	14.33	14.22	14.23	37000.0
2006-11-20	BTF	ETF	106.14999999999999	106.35	105.99999999999999	106.3	3260.0
2006-11-20	CBON	ETF	31.27	31.27	30.8	30.99	49894.0
2006-11-20	CDL	ETF	9.91	9.95	9.85	9.88	441800.0
2006-11-20	CEF	ETF	9.06	9.18	9.02	9.04	427600.0
2006-11-20	CEW	ETF	25.52	25.55	25.52	25.546	1600.0
2006-11-20	CGO	ETF	15.77	16.23	15.77	16.12	45900.0
2006-11-20	CHB	ETF	9.34	9.36	9.0	9.29	1282700.0
2006-11-20	CHI	ETF	19.71	19.82	19.7	19.77	90300.0
2006-11-20	CHIC	ETF	28.43	29.0	27.83	28.84	557561.0
2006-11-20	CHY	ETF	16.85	16.9	16.79	16.88	116400.0
2006-11-20	CN	ETF	39.0	39.41	39.0	39.09	25100.0
2006-11-20	CNXT	ETF	2.16	2.22	2.13	2.19	7510530.0
2006-11-20	CPST	ETF	1.37	1.37	1.33	1.34	1175601.0
2006-11-20	CSA	ETF	21.6	21.6	21.26	21.35	58900.0
2006-11-20	CSB	ETF	30.98	31.14	30.85	30.85	32300.0
2006-11-20	CSM	ETF	1.3	1.305	1.3	1.305	16800.0
2006-11-20	CSQ	ETF	14.99	15.0	14.94	15.0	472100.0
2006-11-20	CTEC	ETF	91.44999999999999	92.5	90.89999999999999	92.5	23283.600000000002
2006-11-20	CVY	ETF	26.2	26.3	26.2	26.24	22900.0
2006-11-20	CYB	ETF	6.6	7.03	6.5	6.75	154200.0
2006-11-20	DBC	ETF	24.52	24.7	24.27	24.43	413200.0
2006-11-20	DBV	ETF	25.4	25.47	25.35	25.47	129700.0
2006-11-20	DDM	ETF	7.315	7.3508	7.2933	7.3142	560400.0
2006-11-20	DES	ETF	19.0833	19.22	19.0833	19.1967	56100.0
2006-11-20	DEW	ETF	59.3	59.46	59.25	59.36	27100.0
2006-11-20	DFE	ETF	60.42	60.42	60.18	60.18	3900.0
2006-11-20	DFJ	ETF	46.7	46.81	46.61	46.71	10900.0
2006-11-20	DGT	ETF	74.7	74.98	74.52	74.75	6000.0
2006-11-20	DHS	ETF	56.85	56.99	56.76	56.86	24600.0
2006-11-20	DIM	ETF	59.57	59.67	59.47	59.58	4500.0
2006-11-20	DIV	ETF	13.18	13.27	13.1701	13.27	26400.0
2006-11-20	DJP	ETF	48.92	49.02	48.65	48.85	132300.0

> showing 50 of 383 rows — these rows as CSV

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