PREVIEW / etf_daily / 2006-11-08

all etf daily files

  file:    by_date/etf_daily/2006/2006-11-08.parquet
  size:    19 KB
  rows:    380

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-08	SPY	ETF	138.0	139.05	136.86	138.91	87517800.0
2006-11-08	QQQ	ETF	42.58	43.2	42.47	43.03	180467199.0
2006-11-08	IWM	ETF	75.61	76.8	75.41	76.59	52411800.0
2006-11-08	DIA	ETF	121.19	121.96	121.03	121.83	9262100.0
2006-11-08	GLD	ETF	61.94	62.08	60.87	61.11	5319300.0
2006-11-08	TLT	ETF	89.24	89.52	89.09	89.52	706300.0
2006-11-08	AAA	ETF	56.46	56.749	56.37	56.7	4100.0
2006-11-08	ADRE	ETF	35.13	35.36	34.89	35.33	87010.0
2006-11-08	AGG	ETF	99.86	100.09	99.86	100.07	185400.0
2006-11-08	AIQ	ETF	37.75	39.25	37.3	38.75	14560.0
2006-11-08	AIS	ETF	1.21	1.35	1.2	1.26	484000.0
2006-11-08	ARB	ETF	42.92	43.6	42.49	43.55	455100.0
2006-11-08	BAB	ETF	87.03	87.61	86.82	87.38	24900.0
2006-11-08	BBC	ETF	10.14	10.23	9.82	10.01	245500.0
2006-11-08	BBH	ETF	63.91	64.2433	63.0467	64.0433	737700.0
2006-11-08	BITS	ETF	36.2	38.6	36.0	38.44	171492.0
2006-11-08	BNE	ETF	15.2	15.56	15.19	15.3	130500.0
2006-11-08	BRF	ETF	14.29	14.29	14.27	14.27	11500.0
2006-11-08	BTF	ETF	104.19999999999999	104.94999999999999	103.64999999999999	104.7	7520.0
2006-11-08	CBON	ETF	30.32	30.49	29.77	29.91	51819.0
2006-11-08	CDL	ETF	10.36	10.52	10.19	10.51	455400.0
2006-11-08	CEF	ETF	8.72	8.8	8.63	8.72	448200.0
2006-11-08	CEW	ETF	25.52	25.52	25.52	25.52	900.0
2006-11-08	CFO	ETF	10.62	10.8	10.6	10.8	3400.0
2006-11-08	CGO	ETF	15.7	15.97	15.7	15.88	14100.0
2006-11-08	CHB	ETF	8.43	8.67	8.13	8.61	1569300.0
2006-11-08	CHI	ETF	19.54	19.77	19.52	19.74	101900.0
2006-11-08	CHIC	ETF	27.15	27.9	26.86	27.59	525963.0
2006-11-08	CHY	ETF	16.89	17.0	16.87	16.99	114700.0
2006-11-08	CIL	ETF	25.82	25.82	25.81	25.81	1000.0
2006-11-08	CIZ	ETF	22.2	22.2	22.2	22.2	1400.0
2006-11-08	CN	ETF	38.56	38.9	38.28	38.9	103700.0
2006-11-08	CNXT	ETF	1.96	2.11	1.94	2.08	19592710.0
2006-11-08	CPST	ETF	1.52	1.64	1.52	1.61	1508800.0
2006-11-08	CSA	ETF	20.1	20.1	19.58	19.71	40600.0
2006-11-08	CSB	ETF	31.12	31.12	30.85	30.97	15700.0
2006-11-08	CSM	ETF	1.25	1.25	1.25	1.25	400.0
2006-11-08	CSQ	ETF	14.98	14.98	14.87	14.92	345600.0
2006-11-08	CTEC	ETF	83.2	87.79999999999998	83.14999999999999	87.2	69614.0
2006-11-08	CVY	ETF	25.91	25.98	25.81	25.94	52400.0
2006-11-08	CYB	ETF	6.61	6.73	6.5	6.64	36800.0
2006-11-08	DBC	ETF	24.9	25.09	24.76	24.96	257400.0
2006-11-08	DBV	ETF	25.5	25.51	25.4	25.49	60500.0
2006-11-08	DDM	ETF	7.0392	7.1433	7.0392	7.1342	1120800.0
2006-11-08	DES	ETF	18.5	18.7367	18.5	18.69	42600.0
2006-11-08	DEW	ETF	59.35	59.62	59.25	59.53	3900.0
2006-11-08	DFE	ETF	59.65	60.2	59.65	60.12	3000.0
2006-11-08	DFJ	ETF	48.53	48.91	48.44	48.89	3800.0
2006-11-08	DGT	ETF	74.05	74.67	73.86	74.59	7900.0
2006-11-08	DHS	ETF	56.15	56.47	56.12	56.38	20300.0

> showing 50 of 380 rows — these rows as CSV

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