PREVIEW / etf_daily / 2006-10-17

all etf daily files

  file:    by_date/etf_daily/2006/2006-10-17.parquet
  size:    19 KB
  rows:    376

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-17	SPY	ETF	136.47	136.7	135.67	136.41	90500600.0
2006-10-17	QQQ	ETF	42.17	42.2	41.76	42.0	146154304.0
2006-10-17	IWM	ETF	75.94	76.24	75.35	75.97	48733400.0
2006-10-17	DIA	ETF	119.6	119.75	118.87	119.57	9414600.0
2006-10-17	GLD	ETF	59.0	59.1	58.12	58.65	2657100.0
2006-10-17	TLT	ETF	87.88	88.05	87.51	87.62	730800.0
2006-10-17	AAA	ETF	53.75	53.82	53.64	53.75	5900.0
2006-10-17	ADRE	ETF	34.28	34.28	33.68	33.89	215555.0
2006-10-17	AGG	ETF	99.58	99.6	99.32	99.4	144600.0
2006-10-17	AIQ	ETF	41.0	41.85	40.8	41.35	41540.0
2006-10-17	AIS	ETF	1.27	1.27	1.16	1.19	121800.0
2006-10-17	ARB	ETF	38.8	39.26	38.63	39.17	94200.0
2006-10-17	BAB	ETF	82.49	83.47	82.49	83.4	176800.0
2006-10-17	BBC	ETF	8.75	8.77	8.4704	8.66	138400.0
2006-10-17	BBH	ETF	62.8333	62.8333	62.0433	62.48	1124700.0
2006-10-17	BITS	ETF	41.0	41.8	39.08	41.6	135101.0
2006-10-17	BNE	ETF	15.43	15.55	15.35	15.54	123100.0
2006-10-17	BRF	ETF	14.23	14.2503	14.22	14.2503	4000.0
2006-10-17	BTF	ETF	100.5	100.6	100.25	100.5	1940.0
2006-10-17	CBON	ETF	32.82	33.29	31.7	32.72	62935.0
2006-10-17	CDL	ETF	9.69	9.71	9.56	9.64	279700.0
2006-10-17	CEF	ETF	8.48	8.48	8.24	8.34	220200.0
2006-10-17	CFO	ETF	10.0	10.0	10.0	10.0	1000.0
2006-10-17	CGO	ETF	15.8	15.95	15.66	15.7	20700.0
2006-10-17	CHB	ETF	8.08	8.12	7.68	7.74	1933700.0
2006-10-17	CHI	ETF	19.25	19.3	19.2102	19.3	102800.0
2006-10-17	CHIC	ETF	28.58	29.41	27.53	28.38	456011.0
2006-10-17	CHY	ETF	17.04	17.08	16.89	16.96	126000.0
2006-10-17	CIZ	ETF	22.6	22.6	22.6	22.6	200.0
2006-10-17	CN	ETF	36.14	36.5	35.98	36.13	48000.0
2006-10-17	CNXT	ETF	2.05	2.07	2.0	2.04	10911818.0
2006-10-17	COMB	ETF	10.22	10.4	10.22	10.4	1194.0
2006-10-17	CPI	ETF	24.0	24.0	23.5	23.51	1300.0
2006-10-17	CPST	ETF	1.7	1.7	1.62	1.67	1173693.0
2006-10-17	CSA	ETF	21.66	21.69	21.55	21.55	29700.0
2006-10-17	CSB	ETF	29.72	29.72	29.47	29.6	12700.0
2006-10-17	CSQ	ETF	14.93	14.93	14.8	14.93	377500.0
2006-10-17	CTEC	ETF	62.15	62.599999999999994	61.8	62.55	8096.200000000001
2006-10-17	CVY	ETF	25.76	25.76	25.6	25.72	33100.0
2006-10-17	CYB	ETF	7.42	7.54	7.41	7.49	91600.0
2006-10-17	DBC	ETF	24.74	24.74	24.18	24.38	598600.0
2006-10-17	DBV	ETF	25.55	25.57	25.44	25.57	127500.0
2006-10-17	DDM	ETF	6.8708	6.9025	6.8042	6.8883	842400.0
2006-10-17	DES	ETF	18.5267	18.62	18.4833	18.5733	41400.0
2006-10-17	DEW	ETF	56.6	56.8	56.43	56.8	5300.0
2006-10-17	DFE	ETF	57.06	57.08	56.88	57.08	6300.0
2006-10-17	DFJ	ETF	49.07	49.09	48.84	49.09	24100.0
2006-10-17	DGT	ETF	72.9	72.99	72.35	72.74	10200.0
2006-10-17	DHS	ETF	55.53	55.72	55.43	55.66	19600.0
2006-10-17	DIM	ETF	57.33	57.33	57.04	57.25	11000.0

> showing 50 of 376 rows — these rows as CSV

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