PREVIEW / etf_daily / 2006-09-29

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-29.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-29	SPY	ETF	133.8	133.94	133.48	133.58	47966600.0
2006-09-29	QQQ	ETF	40.89	40.93	40.62	40.65	85447832.0
2006-09-29	IWM	ETF	72.71	72.99	71.93	72.0	33558300.0
2006-09-29	DIA	ETF	117.07	117.33	116.67	116.74	6476600.0
2006-09-29	GLD	ETF	59.52	59.63	58.98	59.47	3201000.0
2006-09-29	TLT	ETF	89.69	89.73	89.09	89.41	1398000.0
2006-09-29	AAA	ETF	55.42	55.56	54.95	55.39	10800.0
2006-09-29	ADRE	ETF	32.5	32.5	32.22	32.35	90775.0
2006-09-29	AGG	ETF	100.22	100.35	100.08	100.16	414400.0
2006-09-29	AIQ	ETF	39.4	40.0	39.0	39.05	11320.0
2006-09-29	AIS	ETF	1.09	1.1	1.01	1.1	208800.0
2006-09-29	ARB	ETF	37.29	37.48	37.0	37.01	128200.0
2006-09-29	BAB	ETF	79.9	80.28	79.75	80.02	45200.0
2006-09-29	BBC	ETF	9.63	9.64	8.59	8.94	1239600.0
2006-09-29	BBH	ETF	61.9867	61.9867	61.3667	61.6167	595800.0
2006-09-29	BITS	ETF	37.52	38.2864	36.8	37.32	55548.0
2006-09-29	BNE	ETF	14.97	14.97	14.21	14.28	272800.0
2006-09-29	BOSS	ETF	34.49	34.89	34.49	34.89	100.0
2006-09-29	BRF	ETF	14.22	14.22	14.21	14.21	8700.0
2006-09-29	BTF	ETF	95.55	95.8005	95.44999999999999	95.7	3140.0
2006-09-29	CBON	ETF	30.95	30.95	30.49	30.51	61260.0
2006-09-29	CDL	ETF	9.34	9.52	9.34	9.4	309400.0
2006-09-29	CEF	ETF	8.46	8.46	8.25	8.41	234400.0
2006-09-29	CEW	ETF	25.3301	25.3301	25.3301	25.3301	100.0
2006-09-29	CFO	ETF	10.0	10.0	9.82	9.82	3600.0
2006-09-29	CGO	ETF	15.44	15.46	15.2	15.24	23000.0
2006-09-29	CHB	ETF	7.13	7.21	6.88	6.9	635000.0
2006-09-29	CHI	ETF	19.59	19.69	19.59	19.66	84500.0
2006-09-29	CHIC	ETF	27.62	28.25	27.26	27.54	525638.0
2006-09-29	CHY	ETF	16.83	16.89	16.79	16.8899	121800.0
2006-09-29	CIZ	ETF	22.25	22.75	22.25	22.65	2700.0
2006-09-29	CN	ETF	36.06	36.2	35.75	35.81	35200.0
2006-09-29	CNXT	ETF	1.96	2.0	1.95	2.0	12489101.0
2006-09-29	COMB	ETF	10.0	10.0	10.0	10.0	5000.0
2006-09-29	CPI	ETF	24.0	24.0	23.5	23.99	4000.0
2006-09-29	CPST	ETF	1.27	1.44	1.27	1.4	3726657.0
2006-09-29	CSA	ETF	20.59	20.75	20.55	20.75	3400.0
2006-09-29	CSB	ETF	30.21	30.3	30.13	30.21	7000.0
2006-09-29	CSQ	ETF	14.73	14.84	14.69	14.81	432000.0
2006-09-29	CTEC	ETF	59.65	61.449999999999996	59.65	60.0	7360.0
2006-09-29	CVY	ETF	25.22	25.22	25.1	25.11	57200.0
2006-09-29	CYB	ETF	6.65	6.65	6.6	6.65	26200.0
2006-09-29	DBC	ETF	23.85	23.96	23.56	23.95	884300.0
2006-09-29	DBV	ETF	25.01	25.03	24.99	25.0	400000.0
2006-09-29	DDM	ETF	6.6192	6.6483	6.5733	6.5733	834000.0
2006-09-29	DES	ETF	18.1667	18.1667	17.95	17.95	26400.0
2006-09-29	DEW	ETF	55.7	55.74	55.56	55.73	3600.0
2006-09-29	DFE	ETF	55.85	55.89	55.85	55.89	500.0
2006-09-29	DFJ	ETF	50.1	50.1	49.99	49.99	1400.0
2006-09-29	DGT	ETF	71.8	71.89	71.46	71.62	16300.0

> showing 50 of 367 rows — these rows as CSV

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