PREVIEW / etf_daily / 2006-07-27

all etf daily files

  file:    by_date/etf_daily/2006/2006-07-27.parquet
  size:    18 KB
  rows:    358

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-07-27	SPY	ETF	127.38	127.69	126.2	126.71	87257100.0
2006-07-27	QQQ	ETF	36.73	37.04	36.25	36.35	99707252.0
2006-07-27	IWM	ETF	69.41	69.89	67.97	68.24	59015800.0
2006-07-27	DIA	ETF	111.35	111.78	110.78	111.27	9135400.0
2006-07-27	GLD	ETF	63.53	63.61	62.55	62.9	4697300.0
2006-07-27	TLT	ETF	85.48	85.48	85.12	85.21	295500.0
2006-07-27	AAA	ETF	55.57	56.06	55.46	55.46	8200.0
2006-07-27	ADRE	ETF	31.76	32.06	31.323	31.45	595398.0
2006-07-27	AFK	ETF	25.0	25.05	24.98	25.05	2900.0
2006-07-27	AGG	ETF	98.29	98.4	98.05	98.31	135700.0
2006-07-27	AIQ	ETF	32.0	32.0	30.75	31.3	13340.0
2006-07-27	AIS	ETF	1.11	1.15	1.1	1.12	47800.0
2006-07-27	AOM	ETF	6.41	6.43	6.38	6.42	51300.0
2006-07-27	ARB	ETF	36.5	36.6	35.86	35.97	118300.0
2006-07-27	BAB	ETF	71.76	72.62	71.57	71.75	65800.0
2006-07-27	BBC	ETF	13.3	13.75	13.1	13.5	223900.0
2006-07-27	BBH	ETF	59.9967	60.0533	58.7	59.2667	1114200.0
2006-07-27	BITS	ETF	18.16	18.6	17.2	17.52	15068.0
2006-07-27	BKF	ETF	4.14	4.43	4.07	4.1	58900.0
2006-07-27	BNE	ETF	13.5	13.65	13.2	13.29	111500.0
2006-07-27	BRF	ETF	14.0	14.09	14.0	14.09	1500.0
2006-07-27	BTF	ETF	86.8	87.10000000000001	86.8	86.89999999999999	1240.0
2006-07-27	CBON	ETF	32.93	33.05	32.57	33.01	43770.0
2006-07-27	CDL	ETF	9.08	9.09	8.9	8.95	266000.0
2006-07-27	CEF	ETF	8.79	8.9	8.73	8.74	411700.0
2006-07-27	CEW	ETF	25.82	25.95	25.82	25.95	1400.0
2006-07-27	CFO	ETF	10.01	10.01	10.0	10.0	2500.0
2006-07-27	CGO	ETF	14.88	15.0372	14.8	15.0	28800.0
2006-07-27	CHB	ETF	6.6	6.72	6.58	6.58	2000900.0
2006-07-27	CHI	ETF	19.85	19.88	19.79	19.81	56200.0
2006-07-27	CHIC	ETF	25.69	25.95	25.35	25.43	420663.0
2006-07-27	CHY	ETF	16.08	16.14	16.07	16.1	130000.0
2006-07-27	CIL	ETF	25.25	25.25	25.2	25.2	1000.0
2006-07-27	CIZ	ETF	22.1	22.1	22.0	22.0	900.0
2006-07-27	CN	ETF	36.23	36.55	35.9	35.99	35400.0
2006-07-27	CNXT	ETF	2.1	2.12	1.89	1.93	24988364.0
2006-07-27	COMB	ETF	9.76	9.79	9.75	9.78	1800.0
2006-07-27	CPST	ETF	1.89	1.9	1.74	1.77	1351324.0
2006-07-27	CSA	ETF	18.65	18.8	18.55	18.7	2600.0
2006-07-27	CSB	ETF	27.53	27.6204	27.21	27.29	34600.0
2006-07-27	CSQ	ETF	14.14	14.2	14.1	14.17	301100.0
2006-07-27	CTEC	ETF	57.24999999999999	59.74999999999999	55.95049999999999	59.65	21885.2
2006-07-27	CYB	ETF	5.2	5.39	5.06	5.25	62300.0
2006-07-27	DBC	ETF	25.7	25.78	25.5	25.7	155900.0
2006-07-27	DDM	ETF	6.0408	6.0542	5.9492	5.9667	1473600.0
2006-07-27	DES	ETF	17.2	17.2433	17.0	17.0	24600.0
2006-07-27	DEW	ETF	53.05	53.05	52.58	52.58	1000.0
2006-07-27	DFE	ETF	52.99	52.99	52.99	52.99	3000.0
2006-07-27	DFJ	ETF	48.66	48.74	48.24	48.24	2800.0
2006-07-27	DGT	ETF	68.7	68.81	68.11	68.35	11100.0

> showing 50 of 358 rows — these rows as CSV

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