PREVIEW / etf_daily / 2006-05-31

all etf daily files

  file:    by_date/etf_daily/2006/2006-05-31.parquet
  size:    17 KB
  rows:    324

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-31	SPY	ETF	126.62	127.51	126.2	127.51	86926200.0
2006-05-31	QQQ	ETF	38.72	39.06	38.54	38.82	137104477.0
2006-05-31	IWM	ETF	70.81	71.87	70.67	71.87	58723800.0
2006-05-31	DIA	ETF	111.25	111.81	110.8	111.73	7130200.0
2006-05-31	GLD	ETF	65.53	65.59	63.58	64.23	7573300.0
2006-05-31	TLT	ETF	84.34	84.43	83.58	83.67	880700.0
2006-05-31	AAA	ETF	59.47	59.65	58.98	59.64	7300.0
2006-05-31	ADRE	ETF	123.6	124.29	122.24	123.23	118284.0
2006-05-31	AFK	ETF	25.18	25.25	25.18	25.19	10400.0
2006-05-31	AGG	ETF	98.31	98.31	97.91	97.98	415500.0
2006-05-31	AIQ	ETF	28.35	29.25	28.15	29.0	18640.0
2006-05-31	AIS	ETF	1.36	1.38	1.28	1.37	462800.0
2006-05-31	AOM	ETF	7.0	7.35	7.0	7.18	73800.0
2006-05-31	ARB	ETF	39.5	40.1	39.26	39.86	349300.0
2006-05-31	BAB	ETF	63.23	63.98	63.1	63.93	52100.0
2006-05-31	BBC	ETF	11.2	11.64	11.2	11.44	138600.0
2006-05-31	BBH	ETF	58.3667	59.22	58.3667	59.1867	1675500.0
2006-05-31	BCM	ETF	74.25	74.34	73.27	73.56	31500.0
2006-05-31	BITS	ETF	26.0	26.0	25.24	25.64	8138.0
2006-05-31	BKF	ETF	7.22	7.29	6.9	7.07	105300.0
2006-05-31	BNE	ETF	14.06	14.56	14.06	14.5	213000.0
2006-05-31	BRF	ETF	13.94	13.95	13.92	13.92	16700.0
2006-05-31	BTF	ETF	88.55	89.0	88.55	88.60049999999998	360.0
2006-05-31	CBON	ETF	31.7	32.02	31.31	31.79	41986.0
2006-05-31	CDL	ETF	9.69	9.75	9.39	9.51	809400.0
2006-05-31	CEF	ETF	9.48	9.52	9.23	9.36	671700.0
2006-05-31	CFO	ETF	10.05	10.05	10.05	10.05	10000.0
2006-05-31	CGO	ETF	14.18	14.18	14.05	14.16	15300.0
2006-05-31	CHB	ETF	12.13	12.44	11.77	11.9	1836500.0
2006-05-31	CHI	ETF	19.72	19.89	19.69	19.69	106700.0
2006-05-31	CHIC	ETF	20.8	21.26	20.7	21.23	359923.0
2006-05-31	CHY	ETF	16.52	16.58	16.48	16.51	107000.0
2006-05-31	CIL	ETF	25.0	25.0	25.0	25.0	1000.0
2006-05-31	CN	ETF	31.41	32.96	31.41	32.75	162500.0
2006-05-31	CNXT	ETF	2.9	2.9301	2.82	2.93	17582871.0
2006-05-31	COMB	ETF	10.2	10.2	10.0	10.15	14512.0
2006-05-31	CPI	ETF	31.8	32.0	31.8	32.0	2300.0
2006-05-31	CPST	ETF	3.22	3.23	3.02	3.05	2246530.0
2006-05-31	CSA	ETF	18.57	18.58	18.31	18.57	5200.0
2006-05-31	CSB	ETF	29.12	29.24	28.8701	28.98	8300.0
2006-05-31	CSQ	ETF	13.9	14.04	13.86	13.94	310700.0
2006-05-31	CTEC	ETF	68.49999999999999	68.89999999999999	66.55	68.49999999999999	20102.600000000002
2006-05-31	CYB	ETF	5.94	6.06	5.93	6.0201	52500.0
2006-05-31	DBC	ETF	25.75	25.84	25.23	25.52	337500.0
2006-05-31	DGT	ETF	66.75	66.95	66.75	66.95	500.0
2006-05-31	DIG	ETF	17.925	17.925	17.925	17.925	560.0
2006-05-31	DIV	ETF	11.79	11.9	11.79	11.87	14700.0
2006-05-31	DRIV	ETF	44.78	44.86	42.32	43.96	1536769.0
2006-05-31	DSI	ETF	6.42	6.44	6.42	6.44	40800.0
2006-05-31	DUSA	ETF	5.78	6.29	5.78	5.92	136101.0

> showing 50 of 324 rows — these rows as CSV

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