PREVIEW / etf_daily / 2006-09-26

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-26.parquet
  size:    18 KB
  rows:    367

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-09-26	SPY	ETF	132.5	133.6	132.4	133.58	73962700.0
2006-09-26	QQQ	ETF	40.52	40.8	40.4	40.77	113554527.0
2006-09-26	IWM	ETF	72.14	72.75	71.96	72.39	42739700.0
2006-09-26	DIA	ETF	115.67	116.64	115.56	116.59	5624600.0
2006-09-26	GLD	ETF	58.5	58.97	58.25	58.74	2763400.0
2006-09-26	TLT	ETF	90.0	90.1	89.82	89.93	2200000.0
2006-09-26	AAA	ETF	56.71	56.77	56.3201	56.57	10400.0
2006-09-26	ADRE	ETF	31.81	32.06	31.5715	32.03	149107.0
2006-09-26	AGG	ETF	100.35	100.38	100.21	100.25	340200.0
2006-09-26	AIQ	ETF	40.5	41.25	39.25	39.95	18480.0
2006-09-26	AIS	ETF	1.14	1.14	1.07	1.1	96300.0
2006-09-26	ARB	ETF	37.2	37.56	37.0	37.44	186500.0
2006-09-26	BAB	ETF	80.92	81.75	80.58	81.74	41000.0
2006-09-26	BBC	ETF	10.55	10.75	10.51	10.72	153400.0
2006-09-26	BBH	ETF	59.8167	60.16	59.5267	60.16	726600.0
2006-09-26	BITS	ETF	33.4	34.16	33.0	33.48	20373.0
2006-09-26	BNE	ETF	14.84	15.18	14.83	14.95	214200.0
2006-09-26	BRF	ETF	14.25	14.25	14.2	14.2	8900.0
2006-09-26	BTF	ETF	94.60000000000001	95.19999999999999	94.0	95.19999999999999	12040.0
2006-09-26	CBON	ETF	31.19	31.46	31.03	31.15	95305.0
2006-09-26	CDL	ETF	9.49	9.59	9.42	9.53	199700.0
2006-09-26	CEF	ETF	8.09	8.2	8.09	8.2	242700.0
2006-09-26	CEW	ETF	25.45	25.45	25.3208	25.44	2700.0
2006-09-26	CFO	ETF	9.7	9.7	9.65	9.65	700.0
2006-09-26	CGO	ETF	15.24	15.25	15.14	15.25	26900.0
2006-09-26	CHB	ETF	7.2	7.65	7.15	7.44	1475000.0
2006-09-26	CHI	ETF	19.67	19.6965	19.54	19.65	118400.0
2006-09-26	CHIC	ETF	26.47	27.71	26.36	27.25	1077744.0
2006-09-26	CHY	ETF	16.69	16.7	16.56	16.7	137400.0
2006-09-26	CIL	ETF	25.61	25.72	25.6	25.72	2100.0
2006-09-26	CIZ	ETF	21.55	22.04	21.55	22.04	2300.0
2006-09-26	CN	ETF	35.37	35.7	35.21	35.65	29200.0
2006-09-26	CNXT	ETF	1.9	1.99	1.87	1.92	26932959.0
2006-09-26	COMB	ETF	9.91	9.91	9.9	9.9	3010.0
2006-09-26	CPI	ETF	24.12	24.12	24.1	24.1	1800.0
2006-09-26	CPST	ETF	1.27	1.32	1.26	1.3	2727964.0
2006-09-26	CSA	ETF	21.0	21.0	20.9109	20.97	6500.0
2006-09-26	CSB	ETF	30.25	30.48	30.22	30.43	33700.0
2006-09-26	CSQ	ETF	14.78	14.79	14.6	14.66	541000.0
2006-09-26	CTEC	ETF	61.39999999999999	62.5	60.449999999999996	62.449999999999996	10575.400000000001
2006-09-26	CVY	ETF	24.95	25.04	24.88	25.04	174400.0
2006-09-26	CYB	ETF	6.45	6.45	6.35	6.35	38400.0
2006-09-26	DBC	ETF	23.3	23.4999	23.15	23.35	195200.0
2006-09-26	DBV	ETF	25.08	25.11	25.0	25.03	73400.0
2006-09-26	DDM	ETF	6.4708	6.6133	6.4708	6.5758	610800.0
2006-09-26	DES	ETF	18.0067	18.09	17.98	18.0567	66900.0
2006-09-26	DEW	ETF	55.21	55.6	55.16	55.59	19100.0
2006-09-26	DFE	ETF	55.42	55.55	55.28	55.55	7700.0
2006-09-26	DFJ	ETF	49.35	49.43	49.18	49.34	3200.0
2006-09-26	DGT	ETF	70.9	71.31	70.68	71.22	5300.0

> showing 50 of 367 rows — these rows as CSV

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