PREVIEW / etf_daily / 2006-10-30

all etf daily files

  file:    by_date/etf_daily/2006/2006-10-30.parquet
  size:    19 KB
  rows:    375

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-10-30	SPY	ETF	137.66	138.2	137.4	137.81	49717800.0
2006-10-30	QQQ	ETF	42.17	42.65	42.06	42.48	103952624.0
2006-10-30	IWM	ETF	75.78	76.71	75.53	76.47	51246800.0
2006-10-30	DIA	ETF	120.6	121.06	120.36	120.77	5699600.0
2006-10-30	GLD	ETF	60.05	60.65	59.88	59.9	4675700.0
2006-10-30	TLT	ETF	88.89	89.12	88.84	89.12	901200.0
2006-10-30	AAA	ETF	55.12	55.48	55.12	55.28	3500.0
2006-10-30	ADRE	ETF	34.0	34.14	33.75	33.906	174380.0
2006-10-30	AGG	ETF	100.02	100.07	99.93	100.06	175300.0
2006-10-30	AIQ	ETF	41.85	42.25	41.5	42.05	21420.0
2006-10-30	AIS	ETF	1.18	1.25	1.18	1.21	120500.0
2006-10-30	ARB	ETF	41.5	42.2	41.46	42.11	257800.0
2006-10-30	BAB	ETF	86.8	87.95	86.74	87.54	68400.0
2006-10-30	BBC	ETF	9.26	9.3264	9.13	9.15	176800.0
2006-10-30	BBH	ETF	63.6667	64.0567	63.34	63.8933	972000.0
2006-10-30	BITS	ETF	39.72	39.72	36.44	37.28	121443.0
2006-10-30	BNE	ETF	15.83	16.0	15.77	15.91	59200.0
2006-10-30	BRF	ETF	14.25	14.3	14.24	14.24	2700.0
2006-10-30	BTF	ETF	101.95	103.14999999999999	101.69999999999999	103.14999999999999	20320.0
2006-10-30	CBON	ETF	29.16	29.22	28.88	29.09	46433.0
2006-10-30	CDL	ETF	10.1	10.35	10.07	10.28	313900.0
2006-10-30	CEF	ETF	8.5	8.58	8.41	8.45	397800.0
2006-10-30	CEW	ETF	25.52	25.6	25.52	25.6	200.0
2006-10-30	CFO	ETF	10.5	10.5	10.38	10.39	2000.0
2006-10-30	CGO	ETF	15.72	15.95	15.6	15.66	28400.0
2006-10-30	CHB	ETF	9.1	9.8	9.09	9.54	2237000.0
2006-10-30	CHI	ETF	19.75	19.78	19.63	19.69	111000.0
2006-10-30	CHIC	ETF	28.39	28.96	28.1	28.76	141609.0
2006-10-30	CHY	ETF	17.07	17.08	16.96	17.0	148700.0
2006-10-30	CIZ	ETF	22.4	22.4	22.01	22.01	1400.0
2006-10-30	CN	ETF	35.94	35.95	35.52	35.76	29300.0
2006-10-30	CNXT	ETF	1.92	1.93	1.88	1.92	8965441.0
2006-10-30	COMB	ETF	9.9	10.03	9.9	9.92	16801.0
2006-10-30	CPST	ETF	1.45	1.46	1.4	1.42	865451.0
2006-10-30	CSA	ETF	22.69	23.05	22.5	22.89	26200.0
2006-10-30	CSB	ETF	30.69	30.79	30.53	30.74	7100.0
2006-10-30	CSQ	ETF	14.94	14.98	14.91	14.96	308200.0
2006-10-30	CTEC	ETF	73.0	76.55	72.64999999999999	76.55	37367.8
2006-10-30	CVY	ETF	26.03	26.03	25.91	25.98	38600.0
2006-10-30	CYB	ETF	7.31	7.49	7.25	7.4	54400.0
2006-10-30	DBC	ETF	24.55	24.59	24.25	24.34	393100.0
2006-10-30	DBV	ETF	25.42	25.47	25.39	25.45	27400.0
2006-10-30	DDM	ETF	7.0183	7.0592	6.975	7.0192	668400.0
2006-10-30	DES	ETF	18.5833	18.8067	18.5833	18.78	62100.0
2006-10-30	DEW	ETF	58.02	58.22	57.93	58.06	8800.0
2006-10-30	DFE	ETF	58.33	58.51	58.33	58.42	1700.0
2006-10-30	DFJ	ETF	49.65	49.88	49.58	49.71	3500.0
2006-10-30	DGT	ETF	73.6	73.83	73.35	73.45	12000.0
2006-10-30	DHS	ETF	56.4	56.4	56.13	56.26	12400.0
2006-10-30	DIM	ETF	58.47	58.71	58.43	58.59	11200.0

> showing 50 of 375 rows — these rows as CSV

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