PREVIEW / etf_daily / 2006-10-04

all etf daily files

  file:    by_date/etf_daily/2006/2006-10-04.parquet
  size:    18 KB
  rows:    363

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-04	SPY	ETF	133.23	135.0	133.08	134.92	80890500.0
2006-10-04	QQQ	ETF	40.22	41.31	40.14	41.3	149498602.0
2006-10-04	IWM	ETF	71.19	72.95	71.09	72.95	51122100.0
2006-10-04	DIA	ETF	117.04	118.48	117.0	118.39	9500700.0
2006-10-04	GLD	ETF	57.47	57.52	55.55	56.37	8153900.0
2006-10-04	TLT	ETF	89.33	89.85	89.33	89.83	1155500.0
2006-10-04	AAA	ETF	55.1	55.67	54.97	55.62	11000.0
2006-10-04	ADRE	ETF	31.62	32.57	31.62	32.57	311967.0
2006-10-04	AGG	ETF	99.9	100.22	99.81	100.21	252200.0
2006-10-04	AIQ	ETF	36.65	37.7	36.3505	37.25	21540.0
2006-10-04	AIS	ETF	1.14	1.18	1.06	1.07	607700.0
2006-10-04	ARB	ETF	37.01	37.5	37.0	37.49	96200.0
2006-10-04	BAB	ETF	83.24	85.5988	83.24	84.74	154300.0
2006-10-04	BBC	ETF	9.21	9.74	9.16	9.6	250300.0
2006-10-04	BBH	ETF	60.9	61.7167	60.5467	61.55	874500.0
2006-10-04	BITS	ETF	36.08	37.56	35.4	37.0	50119.0
2006-10-04	BNE	ETF	14.72	15.19	14.71	15.15	115700.0
2006-10-04	BRF	ETF	14.25	14.35	14.25	14.29	12100.0
2006-10-04	BTF	ETF	95.8	96.75	95.74999999999999	96.54999999999998	2520.0
2006-10-04	CBON	ETF	30.74	31.63	30.74	31.2	43065.0
2006-10-04	CDL	ETF	9.81	9.9	9.6	9.68	818900.0
2006-10-04	CEF	ETF	8.05	8.1	7.9	8.0	457000.0
2006-10-04	CEW	ETF	25.37	25.37	25.37	25.37	100.0
2006-10-04	CGO	ETF	15.46	15.91	15.46	15.82	36400.0
2006-10-04	CHB	ETF	6.88	7.09	6.79	7.06	1384800.0
2006-10-04	CHI	ETF	19.4	19.49	19.34	19.4	171700.0
2006-10-04	CHIC	ETF	27.31	27.97	26.92	27.9	369622.0
2006-10-04	CHY	ETF	16.63	16.75	16.61	16.74	151500.0
2006-10-04	CIZ	ETF	22.5	22.75	22.5	22.55	4700.0
2006-10-04	CN	ETF	35.72	36.32	35.6901	36.2	102900.0
2006-10-04	CNXT	ETF	1.82	1.85	1.71	1.79	25077369.0
2006-10-04	CPST	ETF	1.45	1.54	1.42	1.51	1391697.0
2006-10-04	CSA	ETF	21.24	21.69	21.24	21.28	28400.0
2006-10-04	CSB	ETF	30.06	30.39	30.05	30.38	16300.0
2006-10-04	CSQ	ETF	14.7	14.79	14.65	14.75	329200.0
2006-10-04	CTEC	ETF	62.5	63.15	61.55	62.75	25234.800000000003
2006-10-04	CVY	ETF	24.96	25.15	24.91	25.15	31700.0
2006-10-04	CYB	ETF	6.63	6.75	6.6212	6.74	21500.0
2006-10-04	DBC	ETF	23.16	23.5199	22.83	23.47	872600.0
2006-10-04	DBV	ETF	25.1	25.16	25.1	25.14	34100.0
2006-10-04	DDM	ETF	6.63	6.7775	6.6233	6.775	1231200.0
2006-10-04	DES	ETF	17.8433	18.05	17.8333	18.05	258600.0
2006-10-04	DEW	ETF	56.0	56.74	56.0	56.74	8200.0
2006-10-04	DFE	ETF	56.3	56.57	56.23	56.55	12100.0
2006-10-04	DFJ	ETF	49.51	50.17	49.51	50.17	21700.0
2006-10-04	DGT	ETF	71.55	72.41	71.55	72.3	24000.0
2006-10-04	DHS	ETF	55.0	55.44	54.95	55.4	270400.0
2006-10-04	DIM	ETF	56.51	57.14	56.51	57.11	8600.0
2006-10-04	DIV	ETF	12.74	12.85	12.72	12.76	55400.0
2006-10-04	DJP	ETF	45.34	45.66	44.7	45.62	87900.0

> showing 50 of 363 rows — these rows as CSV

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