PREVIEW / etf_daily / 2006-11-02

all etf daily files

  file:    by_date/etf_daily/2006/2006-11-02.parquet
  size:    19 KB
  rows:    378

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-02	SPY	ETF	136.51	137.01	136.36	136.78	60693100.0
2006-11-02	QQQ	ETF	41.815	42.14	41.74	42.04	100228453.0
2006-11-02	IWM	ETF	74.11	74.9	74.1	74.47	47585300.0
2006-11-02	DIA	ETF	119.88	120.24	119.72	120.0	6938800.0
2006-11-02	GLD	ETF	61.47	62.19	61.47	61.92	6680500.0
2006-11-02	TLT	ETF	89.63	89.77	89.48	89.59	853300.0
2006-11-02	AAA	ETF	57.4	57.549	57.0	57.26	14400.0
2006-11-02	ADRE	ETF	34.14	34.52	34.13	34.41	180261.0
2006-11-02	AGG	ETF	100.0	100.09	99.98	100.07	249400.0
2006-11-02	AIQ	ETF	41.05	41.05	38.5	38.7	33600.0
2006-11-02	AIS	ETF	1.26	1.26	1.22	1.25	50100.0
2006-11-02	ARB	ETF	40.66	41.28	40.56	41.25	269800.0
2006-11-02	BAB	ETF	87.83	88.83	87.83	88.7	73300.0
2006-11-02	BBC	ETF	9.2	9.2591	9.0501	9.11	91100.0
2006-11-02	BBH	ETF	62.8333	63.1067	62.5667	63.0567	658200.0
2006-11-02	BITS	ETF	33.2	33.28	31.4	32.24	62600.0
2006-11-02	BNE	ETF	15.16	15.42	15.14	15.25	156100.0
2006-11-02	BRF	ETF	14.35	14.4	14.35	14.37	5600.0
2006-11-02	BTF	ETF	103.0	103.3	102.10000000000001	102.3	1740.0
2006-11-02	CBON	ETF	29.17	29.4	29.0	29.02	56589.0
2006-11-02	CDL	ETF	9.95	10.02	9.93	9.94	269900.0
2006-11-02	CEF	ETF	8.74	8.92	8.72	8.86	838500.0
2006-11-02	CEW	ETF	25.45	25.45	25.45	25.45	700.0
2006-11-02	CFO	ETF	10.28	10.3	10.28	10.3	1800.0
2006-11-02	CGO	ETF	15.62	15.72	15.62	15.72	17700.0
2006-11-02	CHB	ETF	8.85	9.13	8.68	8.86	1054200.0
2006-11-02	CHI	ETF	19.69	19.69	19.43	19.43	118000.0
2006-11-02	CHIC	ETF	25.89	26.92	24.83	25.84	917563.0
2006-11-02	CHY	ETF	17.02	17.03	16.82	16.84	149900.0
2006-11-02	CIL	ETF	25.77	25.77	25.77	25.77	100.0
2006-11-02	CIZ	ETF	22.5	22.6	22.5	22.6	300.0
2006-11-02	CN	ETF	35.02	35.65	35.02	35.52	63100.0
2006-11-02	CNXT	ETF	1.96	2.02	1.9	1.91	19583439.0
2006-11-02	COMB	ETF	9.5	10.59	9.34	9.4	17008.0
2006-11-02	CPST	ETF	1.55	1.62	1.51	1.55	700744.0
2006-11-02	CSA	ETF	21.4599	21.48	20.521	20.74	43900.0
2006-11-02	CSB	ETF	30.9	31.1	30.9	31.1	4700.0
2006-11-02	CSQ	ETF	14.79	14.84	14.69	14.8	315200.0
2006-11-02	CTEC	ETF	79.25	80.29999999999998	78.0	80.05	34773.200000000004
2006-11-02	CVY	ETF	25.7	25.7	25.49	25.62	48200.0
2006-11-02	CYB	ETF	7.37	7.37	6.29	6.5599	334800.0
2006-11-02	DBC	ETF	24.48	24.7	24.2501	24.32	640300.0
2006-11-02	DBV	ETF	25.53	25.55	25.5	25.52	22800.0
2006-11-02	DDM	ETF	6.9233	6.9525	6.8975	6.935	916800.0
2006-11-02	DES	ETF	18.3567	18.4433	18.2233	18.36	31200.0
2006-11-02	DEW	ETF	58.1	58.41	58.1	58.33	1600.0
2006-11-02	DFE	ETF	59.01	59.03	58.94	59.03	1000.0
2006-11-02	DFJ	ETF	49.75	49.96	49.73	49.8	11600.0
2006-11-02	DGT	ETF	73.1	73.55	72.0	73.34	6700.0
2006-11-02	DHS	ETF	56.0	56.04	55.69	55.85	23000.0

> showing 50 of 378 rows — these rows as CSV

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