PREVIEW / etf_daily / 2006-09-28

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-28.parquet
  size:    18 KB
  rows:    368

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-28	SPY	ETF	133.74	133.99	133.28	133.69	58597500.0
2006-09-28	QQQ	ETF	40.77	40.89	40.43	40.83	86053939.0
2006-09-28	IWM	ETF	72.98	73.28	72.25	72.63	35641100.0
2006-09-28	DIA	ETF	116.98	117.18	116.5	116.9	11939700.0
2006-09-28	GLD	ETF	59.88	60.27	59.57	59.79	3930900.0
2006-09-28	TLT	ETF	89.43	89.59	89.27	89.52	1796800.0
2006-09-28	AAA	ETF	56.0	56.27	55.8601	56.27	9600.0
2006-09-28	ADRE	ETF	32.4	32.43	32.0	32.43	207055.0
2006-09-28	AGG	ETF	100.29	100.29	100.08	100.24	155400.0
2006-09-28	AIQ	ETF	38.85	40.0	38.5005	39.45	17120.0
2006-09-28	AIS	ETF	1.07	1.1	1.04	1.05	61900.0
2006-09-28	ARB	ETF	37.52	37.52	36.92	37.3	100000.0
2006-09-28	BAB	ETF	81.23	81.83	81.01	81.55	30700.0
2006-09-28	BBC	ETF	10.29	10.3405	9.95	9.98	152400.0
2006-09-28	BBH	ETF	61.5867	61.65	61.0633	61.5267	884700.0
2006-09-28	BITS	ETF	38.0	38.0	35.28	36.64	70082.0
2006-09-28	BNE	ETF	15.22	15.22	14.92	15.05	142100.0
2006-09-28	BOSS	ETF	34.06	34.7	34.06	34.7	200.0
2006-09-28	BRF	ETF	14.21	14.21	14.21	14.21	6200.0
2006-09-28	BTF	ETF	95.55	95.6	95.44999999999999	95.6	1560.0
2006-09-28	CBON	ETF	31.24	31.24	30.78	30.85	68111.0
2006-09-28	CDL	ETF	9.5	9.5	9.1613	9.33	268000.0
2006-09-28	CEF	ETF	8.45	8.51	8.37	8.49	654800.0
2006-09-28	CEW	ETF	25.4	25.4	25.4	25.4	100.0
2006-09-28	CFO	ETF	9.85	9.901	9.8	9.901	1800.0
2006-09-28	CGO	ETF	15.3	15.38	15.22	15.38	16500.0
2006-09-28	CHB	ETF	7.22	7.35	6.96	7.13	802700.0
2006-09-28	CHI	ETF	19.58	19.7226	19.57	19.62	73800.0
2006-09-28	CHIC	ETF	27.81	27.81	27.0	27.54	406580.0
2006-09-28	CHY	ETF	16.76	16.84	16.73	16.8	105300.0
2006-09-28	CIZ	ETF	22.15	22.15	22.15	22.15	200.0
2006-09-28	CN	ETF	35.86	36.4	35.8	36.05	32900.0
2006-09-28	CNXT	ETF	1.99	1.99	1.92	1.98	10866774.0
2006-09-28	COMB	ETF	10.0	10.0	10.0	10.0	14600.0
2006-09-28	CPI	ETF	24.2	24.2	24.0	24.0	800.0
2006-09-28	CPST	ETF	1.27	1.31	1.25	1.25	2251656.0
2006-09-28	CSA	ETF	20.53	20.62	20.4601	20.56	3700.0
2006-09-28	CSB	ETF	30.15	30.3	30.02	30.3	9200.0
2006-09-28	CSQ	ETF	14.75	14.77	14.65	14.73	358100.0
2006-09-28	CTEC	ETF	62.35	62.449999999999996	59.349999999999994	61.74999999999999	19687.4
2006-09-28	CVY	ETF	25.21	25.29	25.12	25.2	33500.0
2006-09-28	CYB	ETF	6.45	6.65	6.4201	6.65	36200.0
2006-09-28	DBC	ETF	23.79	24.05	23.64	23.89	185800.0
2006-09-28	DBV	ETF	24.97	24.99	24.93	24.98	227100.0
2006-09-28	DDM	ETF	6.63	6.6317	6.5625	6.6167	625200.0
2006-09-28	DES	ETF	18.1667	18.1867	18.0367	18.1367	31500.0
2006-09-28	DEW	ETF	55.77	55.92	55.68	55.92	3000.0
2006-09-28	DFE	ETF	55.6	55.93	55.57	55.93	31300.0
2006-09-28	DFJ	ETF	50.07	50.18	49.92	50.18	800.0
2006-09-28	DGT	ETF	71.75	71.85	71.5	71.68	32200.0

> showing 50 of 368 rows — these rows as CSV

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