PREVIEW / etf_daily / 2006-11-21

all etf daily files

  file:    by_date/etf_daily/2006/2006-11-21.parquet
  size:    19 KB
  rows:    382

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-21	SPY	ETF	140.49	140.67	140.29	140.64	51367900.0
2006-11-21	QQQ	ETF	44.42	44.51	44.25	44.45	68145670.0
2006-11-21	IWM	ETF	78.69	78.87	78.31	78.83	40727000.0
2006-11-21	DIA	ETF	123.16	123.32	122.86	123.15	5692600.0
2006-11-21	GLD	ETF	62.25	62.52	62.03	62.27	2930400.0
2006-11-21	TLT	ETF	90.14	90.39	89.96	90.31	605100.0
2006-11-21	AAA	ETF	57.56	57.97	57.56	57.95	3500.0
2006-11-21	ADRE	ETF	35.91	36.2	35.8	36.13	311180.0
2006-11-21	AGG	ETF	100.39	100.54	100.3	100.52	251200.0
2006-11-21	AIQ	ETF	29.05	29.75	28.75	29.6	719620.0
2006-11-21	AIS	ETF	1.22	1.24	1.1601	1.17	87800.0
2006-11-21	ARB	ETF	45.3	45.41	44.75	44.91	107700.0
2006-11-21	BAB	ETF	92.02	92.23	91.0	91.87	39100.0
2006-11-21	BBC	ETF	5.509	5.8199	5.509	5.67	770500.0
2006-11-21	BBH	ETF	62.9667	63.0567	62.4367	62.6	1516500.0
2006-11-21	BITS	ETF	35.04	35.92	34.84	35.0796	25387.0
2006-11-21	BNE	ETF	15.53	15.82	15.41	15.74	138800.0
2006-11-21	BRF	ETF	14.22	14.28	14.21	14.28	36300.0
2006-11-21	BTF	ETF	105.99999999999999	106.19999999999999	105.89999999999999	106.19999999999999	4460.0
2006-11-21	CBON	ETF	30.95	31.07	30.36	30.44	55517.0
2006-11-21	CDL	ETF	9.88	9.9	9.85	9.86	238200.0
2006-11-21	CEF	ETF	9.2	9.24	9.1	9.23	321600.0
2006-11-21	CEW	ETF	25.58	25.58	25.58	25.58	1000.0
2006-11-21	CFO	ETF	10.85	10.9	10.85	10.9	3100.0
2006-11-21	CGO	ETF	16.05	16.26	16.02	16.26	38800.0
2006-11-21	CHB	ETF	9.14	9.3	9.01	9.19	1206200.0
2006-11-21	CHI	ETF	19.73	19.84	19.7	19.83	65100.0
2006-11-21	CHIC	ETF	28.05	28.4	27.85	28.11	703904.0
2006-11-21	CHY	ETF	16.88	17.02	16.88	17.0	116800.0
2006-11-21	CN	ETF	38.3	38.65	38.0	38.5	57700.0
2006-11-21	CNXT	ETF	2.19	2.23	2.18	2.19	5754324.0
2006-11-21	CPST	ETF	1.32	1.35	1.29	1.31	1252797.0
2006-11-21	CSA	ETF	21.35	21.45	21.26	21.33	22100.0
2006-11-21	CSB	ETF	31.18	31.29	30.85	31.16	15300.0
2006-11-21	CSM	ETF	1.3075	1.3125	1.3075	1.3125	2000.0
2006-11-21	CSQ	ETF	15.0	15.12	14.94	15.12	519400.0
2006-11-21	CTEC	ETF	92.2	92.5	89.60000000000001	90.99999999999999	26397.600000000002
2006-11-21	CVY	ETF	26.32	26.35	26.22	26.35	26500.0
2006-11-21	DBC	ETF	24.6	24.75	24.54	24.66	263500.0
2006-11-21	DBV	ETF	25.5	25.5	25.4	25.47	21800.0
2006-11-21	DDM	ETF	7.315	7.3333	7.2892	7.3125	567600.0
2006-11-21	DES	ETF	19.19	19.2333	19.1467	19.2333	33900.0
2006-11-21	DEW	ETF	59.65	59.75	59.57	59.75	15200.0
2006-11-21	DFE	ETF	60.63	60.75	60.58	60.75	2500.0
2006-11-21	DFJ	ETF	46.45	46.6	46.41	46.58	26700.0
2006-11-21	DGT	ETF	74.8	74.8	74.43	74.47	14600.0
2006-11-21	DHS	ETF	56.9	56.91	56.66	56.88	18900.0
2006-11-21	DIM	ETF	59.79	60.09	59.79	60.09	7500.0
2006-11-21	DIV	ETF	13.28	13.35	13.17	13.35	49100.0
2006-11-21	DJP	ETF	49.05	49.55	49.04	49.54	111000.0

> showing 50 of 382 rows — these rows as CSV

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