PREVIEW / etf_daily / 2006-08-01

all etf daily files

  file:    by_date/etf_daily/2006/2006-08-01.parquet
  size:    18 KB
  rows:    356

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-08-01	SPY	ETF	127.34	127.38	126.6	127.22	65225600.0
2006-08-01	QQQ	ETF	36.79	36.8	36.26	36.48	98573511.0
2006-08-01	IWM	ETF	69.17	69.23	68.18	68.59	45003700.0
2006-08-01	DIA	ETF	111.5	111.52	110.75	111.22	5439000.0
2006-08-01	GLD	ETF	62.92	64.46	62.92	64.32	4669800.0
2006-08-01	TLT	ETF	85.32	85.5	85.04	85.46	577800.0
2006-08-01	AAA	ETF	57.48	57.52	56.54	57.1	7800.0
2006-08-01	ADRE	ETF	31.65	31.65	31.34	31.52	159301.0
2006-08-01	AFK	ETF	25.13	25.18	25.07	25.12	41800.0
2006-08-01	AGG	ETF	98.18	98.25	97.91	98.23	195000.0
2006-08-01	AIQ	ETF	31.1	33.55	30.75	33.15	26000.0
2006-08-01	AIS	ETF	1.08	1.09	1.06	1.09	18700.0
2006-08-01	AOM	ETF	6.35	6.36	6.26	6.26	4700.0
2006-08-01	ARB	ETF	36.45	36.48	35.78	36.3	148900.0
2006-08-01	BAB	ETF	72.52	72.72	71.87	72.5	51700.0
2006-08-01	BBC	ETF	13.25	13.26	12.8	12.81	139700.0
2006-08-01	BBH	ETF	58.7833	59.3333	58.7	59.1567	999900.0
2006-08-01	BITS	ETF	16.84	16.84	16.28	16.56	9018.0
2006-08-01	BKF	ETF	4.0	4.04	3.92	3.92	79800.0
2006-08-01	BNE	ETF	13.77	13.77	13.37	13.49	78100.0
2006-08-01	BRF	ETF	14.06	14.06	14.01	14.02	19100.0
2006-08-01	BTF	ETF	86.95	87.44999999999999	86.95	87.44999999999999	5420.0
2006-08-01	CBON	ETF	33.48	33.82	33.28	33.7	49755.0
2006-08-01	CDL	ETF	9.28	9.35	9.14	9.34	241000.0
2006-08-01	CEF	ETF	8.7	8.93	8.69	8.93	707300.0
2006-08-01	CEW	ETF	25.9	25.9	25.9	25.9	200.0
2006-08-01	CFO	ETF	10.01	10.01	10.01	10.01	4000.0
2006-08-01	CGO	ETF	14.95	15.35	14.9	14.94	44600.0
2006-08-01	CHB	ETF	6.63	6.64	6.25	6.35	1992600.0
2006-08-01	CHI	ETF	19.76	20.08	19.76	20.03	90700.0
2006-08-01	CHIC	ETF	26.76	26.85	25.63	26.28	959005.0
2006-08-01	CHY	ETF	16.11	16.15	16.09	16.14	128400.0
2006-08-01	CIL	ETF	25.34	25.39	25.34	25.39	3600.0
2006-08-01	CIZ	ETF	22.0	22.05	21.9	21.9	1400.0
2006-08-01	CN	ETF	36.19	36.19	35.72	35.94	32000.0
2006-08-01	CNXT	ETF	1.78	1.8	1.72	1.74	10498535.0
2006-08-01	COMB	ETF	9.81	9.84	9.7	9.79	10000.0
2006-08-01	CPST	ETF	1.81	1.84	1.75	1.8	1076529.0
2006-08-01	CSA	ETF	18.7	19.0	18.5	18.51	4100.0
2006-08-01	CSB	ETF	27.6	27.6	27.26	27.48	12500.0
2006-08-01	CSQ	ETF	14.16	14.22	14.15	14.22	322400.0
2006-08-01	CTEC	ETF	53.449999999999996	57.949999999999996	52.55	56.74999999999999	37814.6
2006-08-01	CYB	ETF	5.5	5.55	5.46	5.48	11400.0
2006-08-01	DBC	ETF	25.9	26.05	25.76	25.98	200300.0
2006-08-01	DDM	ETF	6.025	6.025	5.9392	5.9883	553200.0
2006-08-01	DES	ETF	17.0533	17.15	17.0533	17.15	13200.0
2006-08-01	DEW	ETF	53.11	53.11	53.11	53.11	1800.0
2006-08-01	DFE	ETF	53.53	53.63	53.53	53.63	500.0
2006-08-01	DFJ	ETF	49.25	49.5	49.25	49.5	500.0
2006-08-01	DGT	ETF	69.12	69.12	68.68	68.97	30000.0

> showing 50 of 356 rows — these rows as CSV

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