PREVIEW / etf_daily / 2005-09-02

all etf daily files

  file:    by_date/etf_daily/2005/2005-09-02.parquet
  size:    15 KB
  rows:    280

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
2005-09-02	SPY	ETF	122.85	122.88	122.04	122.27	47653400.0
2005-09-02	QQQ	ETF	38.99	39.031	38.74	38.77	53270335.0
2005-09-02	IWM	ETF	66.76	66.8	65.9	66.17	21928100.0
2005-09-02	DIA	ETF	104.78	104.93	104.3	104.6	11825500.0
2005-09-02	GLD	ETF	44.24	44.36	44.09	44.25	1414900.0
2005-09-02	TLT	ETF	94.88	95.29	94.8	95.16	621400.0
2005-09-02	AAA	ETF	58.4	58.83	58.252	58.56	3300.0
2005-09-02	ADRE	ETF	100.79	101.72	100.79	101.57	498616.0
2005-09-02	AFK	ETF	25.92	25.98	25.9	25.9	4200.0
2005-09-02	AGG	ETF	102.47	102.75	102.39	102.6	264800.0
2005-09-02	AIQ	ETF	45.7	45.7	44.5	45.2	6700.0
2005-09-02	AIS	ETF	0.8	0.94	0.8	0.91	321800.0
2005-09-02	ARB	ETF	41.95	42.0	41.44	41.52	71900.0
2005-09-02	BAB	ETF	51.27	51.62	51.2	51.48	15100.0
2005-09-02	BBC	ETF	6.7	6.88	6.65	6.85	18700.0
2005-09-02	BBH	ETF	66.17	66.2333	65.38	65.5367	1251900.0
2005-09-02	BCM	ETF	58.97	59.55	58.97	59.52	167400.0
2005-09-02	BIS	ETF	688.0	702.4	688.0	702.4	13.75
2005-09-02	BITS	ETF	12.004	12.004	11.368	11.796	5438.0
2005-09-02	BKF	ETF	32.88	32.88	32.35	32.46	29900.0
2005-09-02	BNE	ETF	14.57	14.75	14.5	14.5	80400.0
2005-09-02	BRF	ETF	15.59	15.6	15.51	15.54	12500.0
2005-09-02	BTF	ETF	84.64999999999999	84.89999999999999	84.25	84.49999999999999	2860.0
2005-09-02	CBON	ETF	34.51	34.65	34.21	34.21	4463.0
2005-09-02	CDC	ETF	3.35	3.45	3.2	3.28	7700.0
2005-09-02	CDL	ETF	13.43	13.43	13.07	13.15	603700.0
2005-09-02	CEF	ETF	5.43	5.43	5.36	5.41	270600.0
2005-09-02	CEW	ETF	26.18	26.18	26.18	26.18	100.0
2005-09-02	CHB	ETF	13.5	13.5	12.52	13.16	1932800.0
2005-09-02	CHI	ETF	20.35	20.58	20.33	20.43	73500.0
2005-09-02	CHIC	ETF	12.88	14.02	12.88	13.75	767222.0
2005-09-02	CHIR	ETF	42.9999	43.0101	42.54	42.7899	4322629.0
2005-09-02	CHY	ETF	16.52	16.7	16.52	16.62	77500.0
2005-09-02	CIL	ETF	25.85	25.86	25.85	25.85	1600.0
2005-09-02	CIZ	ETF	22.85	22.85	22.85	22.85	300.0
2005-09-02	CN	ETF	33.84	33.9	33.7	33.84	2400.0
2005-09-02	CNXT	ETF	1.65	1.67	1.62	1.63	3455068.0
2005-09-02	CPI	ETF	23.6	23.6	23.6	23.6	1000.0
2005-09-02	CPST	ETF	5.0	5.01	4.72	4.95	10363380.0
2005-09-02	CSB	ETF	31.45	31.45	31.14	31.14	4000.0
2005-09-02	CSQ	ETF	14.16	14.24	14.1	14.14	284400.0
2005-09-02	CTEC	ETF	50.49999999999999	51.25	49.4	50.3	8861.6
2005-09-02	CURE	ETF	0.2812	0.2812	0.2687	0.2737	331080.0
2005-09-02	CYA	ETF	60.0	64.0	59.8	61.6	595.0
2005-09-02	CYB	ETF	3.76	3.77	3.66	3.7	3700.0
2005-09-02	DGT	ETF	64.8	64.99	64.71	64.71	2000.0
2005-09-02	DIG	ETF	13.4	13.4125	13.4	13.4	400.0
2005-09-02	DIV	ETF	13.61	13.65	13.59	13.64	4100.0
2005-09-02	DRIV	ETF	38.25	38.64	37.85	38.44	346151.0
2005-09-02	DSI	ETF	5.715	5.765	5.715	5.765	2600.0

> showing 50 of 280 rows — these rows as CSV

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