PREVIEW / etf_daily / 2008-06-11

all etf daily files

  file:    by_date/etf_daily/2008/2008-06-11.parquet
  size:    26 KB
  rows:    589

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
2008-06-11	SPY	ETF	135.97	136.26	133.93	133.94	283890100.0
2008-06-11	QQQ	ETF	48.45	48.52	47.35	47.38	170367269.0
2008-06-11	IWM	ETF	73.05	73.22	71.77	71.87	97453600.0
2008-06-11	DIA	ETF	122.68	122.72	120.98	121.05	19598200.0
2008-06-11	GLD	ETF	86.57	87.1	86.35	87.02	10153600.0
2008-06-11	TLT	ETF	90.05	90.72	89.71	89.96	2265400.0
2008-06-11	ACWI	ETF	51.56	51.56	50.89	50.89	1900.0
2008-06-11	ACWX	ETF	52.41	52.54	51.81	51.81	11356.0
2008-06-11	ADRE	ETF	52.08	52.51	51.4	51.47	711158.0
2008-06-11	AGG	ETF	100.18	100.43	99.91	100.07	508600.0
2008-06-11	AIA	ETF	43.85	44.06	43.1	43.57	13700.0
2008-06-11	AIQ	ETF	43.45	44.3	42.25	43.4	53275.0
2008-06-11	AIS	ETF	0.74	0.74	0.71	0.73	49876.0
2008-06-11	AIVI	ETF	63.6	63.64	62.64	62.65	54700.0
2008-06-11	ARB	ETF	50.91	51.2	50.33	50.34	256238.0
2008-06-11	BBH	ETF	55.8533	55.8533	54.6833	54.7767	1098000.0
2008-06-11	BIL	ETF	91.7	91.76	91.66	91.76	183700.0
2008-06-11	BITS	ETF	25.96	26.0	25.44	25.64	4475.0
2008-06-11	BIV	ETF	76.45	76.69	76.27	76.42	25400.0
2008-06-11	BJK	ETF	35.2	35.2	34.6	34.6	2900.0
2008-06-11	BKF	ETF	55.11	55.11	53.0	53.2	21345.0
2008-06-11	BLV	ETF	74.17	74.27	73.63	73.63	5000.0
2008-06-11	BMVP	ETF	16.02	16.02	15.82	15.82	20842.0
2008-06-11	BND	ETF	75.72	76.06	75.65	75.94	114000.0
2008-06-11	BNE	ETF	15.55	15.55	15.05	15.05	182149.0
2008-06-11	BOSS	ETF	29.85	29.86	28.88	28.88	300.0
2008-06-11	BRF	ETF	14.71	14.7301	14.7	14.7301	17000.0
2008-06-11	BSV	ETF	76.89	77.19	76.89	77.08	78300.0
2008-06-11	BTF	ETF	101.54999999999998	101.69999999999999	100.74999999999999	100.783	2753.4
2008-06-11	BWX	ETF	27.285	27.305	27.1	27.195	1889956.0
2008-06-11	CBON	ETF	6.32	6.47	6.2	6.25	77780.0
2008-06-11	CDL	ETF	1.58	1.59	1.43	1.44	1560233.0
2008-06-11	CEF	ETF	12.2	12.45	12.2	12.37	255800.0
2008-06-11	CGO	ETF	16.22	16.27	15.85	16.19	23426.0
2008-06-11	CGW	ETF	25.36	25.36	24.67	24.76	113914.0
2008-06-11	CHB	ETF	8.03	8.15	7.56	7.57	1713551.0
2008-06-11	CHI	ETF	15.19	15.39	15.15	15.16	98361.0
2008-06-11	CHIC	ETF	17.38	17.51	17.19	17.23	381932.0
2008-06-11	CHW	ETF	12.15	12.24	11.79	11.81	140671.0
2008-06-11	CHY	ETF	14.27	14.27	13.98	14.0	117636.0
2008-06-11	CMF	ETF	52.07	52.145	52.07	52.1	5900.0
2008-06-11	CN	ETF	54.04	54.35	52.48	52.72	234949.0
2008-06-11	CNXT	ETF	0.6	0.6024	0.56	0.5826	4777259.0
2008-06-11	COW	ETF	42.96	43.98	42.9	43.7399	266439.0
2008-06-11	CPI	ETF	21.056	21.056	21.056	21.056	100.0
2008-06-11	CPST	ETF	3.51	3.53	3.35	3.36	2451532.0
2008-06-11	CSA	ETF	18.15	18.1899	17.65	17.9	34396.0
2008-06-11	CSB	ETF	20.85	20.85	20.0	20.1	50434.0
2008-06-11	CSD	ETF	23.61	23.61	23.29	23.29	3300.0
2008-06-11	CSQ	ETF	12.52	12.57	12.37	12.38	234350.0

> showing 50 of 589 rows — these rows as CSV

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