PREVIEW / etf_daily / 2006-05-23

all etf daily files

  file:    by_date/etf_daily/2006/2006-05-23.parquet
  size:    17 KB
  rows:    327

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-05-23	SPY	ETF	127.18	127.63	125.17	125.17	92006500.0
2006-05-23	QQQ	ETF	39.26	39.3801	38.57	38.59	142649419.0
2006-05-23	IWM	ETF	71.88	72.39	70.1	70.18	73644800.0
2006-05-23	DIA	ETF	111.62	111.94	110.35	110.37	9473200.0
2006-05-23	GLD	ETF	65.99	67.16	65.91	66.38	10509700.0
2006-05-23	TLT	ETF	84.05	84.56	84.03	84.56	1394900.0
2006-05-23	AAA	ETF	59.18	59.66	59.13	59.29	3800.0
2006-05-23	ADRE	ETF	123.16	128.08	121.91	123.47	117368.0
2006-05-23	AFK	ETF	25.21	25.22	25.15	25.15	8300.0
2006-05-23	AGG	ETF	98.05	98.2	97.91	97.99	246100.0
2006-05-23	AIQ	ETF	31.8	32.35	30.25	30.45	18160.0
2006-05-23	AIS	ETF	1.27	1.2799	1.2	1.22	381400.0
2006-05-23	AOM	ETF	7.4	7.44	7.3	7.38	87200.0
2006-05-23	ARB	ETF	39.5	40.0	38.79	38.82	523300.0
2006-05-23	BAB	ETF	62.97	64.05	62.95	63.15	39000.0
2006-05-23	BBC	ETF	11.1	11.74	11.1	11.29	268700.0
2006-05-23	BBH	ETF	57.33	58.0	56.4233	56.5667	2195700.0
2006-05-23	BCM	ETF	71.57	72.24	71.38	71.38	17700.0
2006-05-23	BITS	ETF	24.96	26.2	24.24	25.12	29830.0
2006-05-23	BKF	ETF	7.8	7.9399	7.75	7.76	69000.0
2006-05-23	BNE	ETF	14.7	14.94	14.16	14.34	177800.0
2006-05-23	BOSS	ETF	30.4	31.82	30.4	31.82	300.0
2006-05-23	BRF	ETF	13.97	13.98	13.94	13.94	8500.0
2006-05-23	BTF	ETF	88.75	88.8	88.49999999999999	88.8	1780.0
2006-05-23	CBON	ETF	32.0	32.37	31.75	32.0	35882.0
2006-05-23	CDL	ETF	10.59	10.59	9.92	9.93	413900.0
2006-05-23	CEF	ETF	9.13	9.44	9.05	9.34	1089500.0
2006-05-23	CEW	ETF	25.9	25.9	25.9	25.9	300.0
2006-05-23	CFO	ETF	10.1	10.1	10.02	10.02	21500.0
2006-05-23	CGO	ETF	14.31	14.37	14.23	14.26	31200.0
2006-05-23	CHB	ETF	12.75	13.48	12.69	13.02	1602400.0
2006-05-23	CHI	ETF	19.74	19.88	19.68	19.74	73300.0
2006-05-23	CHIC	ETF	22.04	22.26	21.01	21.12	405674.0
2006-05-23	CHY	ETF	16.34	16.47	16.3312	16.47	176800.0
2006-05-23	CN	ETF	31.6	31.75	31.11	31.12	66900.0
2006-05-23	CNXT	ETF	3.21	3.2701	3.1	3.11	12060925.0
2006-05-23	COMB	ETF	10.08	10.08	9.85	9.95	26184.0
2006-05-23	CPI	ETF	31.5	31.5	31.4	31.4	600.0
2006-05-23	CPST	ETF	2.805	3.07	2.71	2.94	4000323.0
2006-05-23	CSA	ETF	19.1	19.16	18.7	18.75	6900.0
2006-05-23	CSB	ETF	29.51	29.7	29.49	29.56	9400.0
2006-05-23	CSQ	ETF	13.78	13.81	13.73	13.77	295700.0
2006-05-23	CTEC	ETF	63.3	64.5	63.3	64.19999999999999	17725.4
2006-05-23	CYB	ETF	5.77	5.8	5.7	5.75	40500.0
2006-05-23	DBC	ETF	25.93	26.27	25.85	26.02	855100.0
2006-05-23	DGT	ETF	67.2	67.41	66.76	66.77	4000.0
2006-05-23	DIG	ETF	17.725	17.725	17.725	17.725	80.0
2006-05-23	DIV	ETF	11.7	11.85	11.65	11.74	19200.0
2006-05-23	DRIV	ETF	45.59	46.88	44.95	45.27	629359.0
2006-05-23	DSI	ETF	6.34	6.34	6.34	6.34	400.0

> showing 50 of 327 rows — these rows as CSV

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