PREVIEW / etf_daily / 2006-10-09

all etf daily files

  file:    by_date/etf_daily/2006/2006-10-09.parquet
  size:    18 KB
  rows:    360

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-09	SPY	ETF	134.85	135.3	134.64	135.09	41176800.0
2006-10-09	QQQ	ETF	41.37	41.74	41.32	41.55	62824047.0
2006-10-09	IWM	ETF	73.36	74.14	73.06	74.06	25997000.0
2006-10-09	DIA	ETF	118.32	118.74	118.1	118.62	3432300.0
2006-10-09	GLD	ETF	57.46	57.5	56.72	57.2	2689800.0
2006-10-09	TLT	ETF	88.1	88.6	88.01	88.51	834900.0
2006-10-09	AAA	ETF	54.2	54.41	54.19	54.3	2900.0
2006-10-09	ADRE	ETF	32.8	33.01	32.54	32.76	238390.0
2006-10-09	AGG	ETF	99.62	99.75	99.58	99.74	181900.0
2006-10-09	AIQ	ETF	39.3	40.15	38.9	39.75	16160.0
2006-10-09	AIS	ETF	1.13	1.1301	1.1	1.12	93100.0
2006-10-09	ARB	ETF	37.91	38.27	37.8	38.18	91500.0
2006-10-09	BAB	ETF	80.08	80.82	79.48	80.65	39100.0
2006-10-09	BBC	ETF	9.0	9.5	8.81	8.95	250600.0
2006-10-09	BBH	ETF	62.6933	63.3767	62.41	63.19	1025700.0
2006-10-09	BITS	ETF	36.0	36.7996	33.08	34.4	83350.0
2006-10-09	BNE	ETF	14.96	15.11	14.89	15.02	126900.0
2006-10-09	BOSS	ETF	35.4	35.4	35.4	35.4	100.0
2006-10-09	BRF	ETF	14.21	14.22	14.21	14.22	7800.0
2006-10-09	BTF	ETF	97.55	98.14999999999999	97.55	98.0	1960.0
2006-10-09	CBON	ETF	31.42	31.83	31.19	31.75	45561.0
2006-10-09	CDL	ETF	9.68	9.95	9.65	9.74	385800.0
2006-10-09	CEF	ETF	8.14	8.29	8.11	8.12	145200.0
2006-10-09	CGO	ETF	15.45	15.6	15.45	15.54	12100.0
2006-10-09	CHB	ETF	7.24	7.52	7.24	7.46	1084400.0
2006-10-09	CHI	ETF	19.3	19.43	19.26	19.43	115000.0
2006-10-09	CHIC	ETF	27.08	27.52	26.93	27.29	349562.0
2006-10-09	CHY	ETF	16.89	17.0	16.88	16.99	131600.0
2006-10-09	CN	ETF	36.33	36.5	36.05	36.21	25300.0
2006-10-09	CNXT	ETF	1.85	1.86	1.82	1.83	4457345.0
2006-10-09	CPST	ETF	1.51	1.55	1.51	1.52	796037.0
2006-10-09	CSA	ETF	21.61	21.68	21.59	21.65	23200.0
2006-10-09	CSB	ETF	29.94	30.17	29.93	30.06	10000.0
2006-10-09	CSQ	ETF	14.84	14.9	14.8	14.9	285300.0
2006-10-09	CTEC	ETF	62.5	62.64999999999999	62.15	62.199999999999996	8775.0
2006-10-09	CVY	ETF	25.3	25.33	25.19	25.33	32100.0
2006-10-09	CYB	ETF	7.29	7.2952	7.12	7.2	166100.0
2006-10-09	DBC	ETF	23.79	24.49	23.79	24.49	351700.0
2006-10-09	DBV	ETF	25.3	25.42	25.2903	25.42	61600.0
2006-10-09	DDM	ETF	6.7583	6.7992	6.7392	6.7767	1323600.0
2006-10-09	DES	ETF	18.1333	18.24	18.07	18.2333	21000.0
2006-10-09	DEW	ETF	56.08	56.22	55.96	56.2	3400.0
2006-10-09	DFJ	ETF	48.85	48.9	48.73	48.74	31800.0
2006-10-09	DGT	ETF	72.0	72.2	71.92	71.95	4000.0
2006-10-09	DHS	ETF	55.2	55.36	55.01	55.36	17700.0
2006-10-09	DIM	ETF	56.7	56.88	56.6	56.77	6500.0
2006-10-09	DIV	ETF	12.71	12.84	12.71	12.77	27800.0
2006-10-09	DJP	ETF	47.2	47.62	47.08	47.46	83600.0
2006-10-09	DLN	ETF	27.54	27.605	27.52	27.595	21600.0
2006-10-09	DLS	ETF	54.96	55.11	54.93	55.07	96100.0

> showing 50 of 360 rows — these rows as CSV

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