PREVIEW / etf_daily / 2006-11-07

all etf daily files

  file:    by_date/etf_daily/2006/2006-11-07.parquet
  size:    19 KB
  rows:    388

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-07	SPY	ETF	138.2	138.98	138.0	138.61	63318900.0
2006-11-07	QQQ	ETF	42.53	43.09	42.47	42.83	139889250.0
2006-11-07	IWM	ETF	75.83	76.83	75.77	76.2	49200600.0
2006-11-07	DIA	ETF	121.12	121.88	120.96	121.55	9506400.0
2006-11-07	GLD	ETF	62.35	62.48	61.97	62.04	5332400.0
2006-11-07	TLT	ETF	89.28	89.51	89.12	89.2	525900.0
2006-11-07	AAA	ETF	56.96	57.06	56.85	56.94	13800.0
2006-11-07	ADRE	ETF	35.48	35.52	35.2	35.28	213611.0
2006-11-07	AGG	ETF	99.85	100.0	99.77	99.8	225400.0
2006-11-07	AIQ	ETF	36.75	38.55	36.75	38.0	16420.0
2006-11-07	AIS	ETF	1.19	1.23	1.19	1.21	70900.0
2006-11-07	ARB	ETF	42.74	43.68	42.74	43.17	493400.0
2006-11-07	BAB	ETF	86.4	87.46	86.34	87.19	62300.0
2006-11-07	BBC	ETF	10.41	10.41	9.95	10.2	264900.0
2006-11-07	BBH	ETF	63.1267	64.1933	63.1267	63.9167	717300.0
2006-11-07	BITS	ETF	32.04	32.36	31.28	32.36	54777.0
2006-11-07	BNE	ETF	15.33	15.6	15.21	15.25	131200.0
2006-11-07	BRF	ETF	14.27	14.29	14.26	14.26	19300.0
2006-11-07	BTF	ETF	105.19999999999999	106.3	104.45	104.45	5440.0
2006-11-07	CBON	ETF	29.92	30.4	29.78	30.38	332299.0
2006-11-07	CDL	ETF	10.4	10.49	10.24	10.39	424100.0
2006-11-07	CEF	ETF	8.88	8.89	8.82	8.83	215300.0
2006-11-07	CFO	ETF	10.6	10.6	10.52	10.52	3500.0
2006-11-07	CGO	ETF	15.79	15.93	15.74	15.76	16500.0
2006-11-07	CHB	ETF	8.93	8.95	8.49	8.65	1833600.0
2006-11-07	CHI	ETF	19.75	19.9	19.58	19.66	156300.0
2006-11-07	CHIC	ETF	26.81	27.84	26.71	27.44	442163.0
2006-11-07	CHY	ETF	16.89	17.04	16.89	16.94	126200.0
2006-11-07	CIZ	ETF	22.45	22.45	22.3	22.3	500.0
2006-11-07	CN	ETF	37.45	38.0	37.43	37.74	72900.0
2006-11-07	CNXT	ETF	2.02	2.04	1.92	1.98	19920251.0
2006-11-07	COMB	ETF	9.7	9.9	9.64	9.77	4554.0
2006-11-07	CPI	ETF	24.3	24.35	23.95	23.95	1900.0
2006-11-07	CPST	ETF	1.53	1.62	1.53	1.53	1367908.0
2006-11-07	CSA	ETF	19.85	20.18	19.85	20.14	21000.0
2006-11-07	CSB	ETF	31.75	31.9	31.62	31.9	12100.0
2006-11-07	CSM	ETF	1.25	1.3375	1.25	1.3025	15200.0
2006-11-07	CSQ	ETF	14.97	14.99	14.92	14.98	349500.0
2006-11-07	CTEC	ETF	81.54999999999998	83.64999999999999	81.54999999999998	82.69999999999999	32309.2
2006-11-07	CVY	ETF	26.03	26.07	25.9	25.92	103700.0
2006-11-07	CYB	ETF	6.45	6.65	6.45	6.59	88700.0
2006-11-07	DBC	ETF	25.09	25.09	24.82	24.99	170800.0
2006-11-07	DBV	ETF	25.5	25.58	25.48	25.55	43800.0
2006-11-07	DDM	ETF	7.075	7.1417	7.0667	7.1008	1113600.0
2006-11-07	DES	ETF	18.6	18.7433	18.5433	18.5433	44400.0
2006-11-07	DEW	ETF	59.27	59.4	59.09	59.09	26200.0
2006-11-07	DFE	ETF	59.85	59.98	59.66	59.66	2900.0
2006-11-07	DFJ	ETF	49.7	49.86	49.46	49.49	4000.0
2006-11-07	DGT	ETF	74.4	74.65	74.3	74.41	9200.0
2006-11-07	DHS	ETF	56.3	56.45	56.24	56.27	21700.0

> showing 50 of 388 rows — these rows as CSV

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