PREVIEW / etf_daily / 2008-06-20

all etf daily files

  file:    by_date/etf_daily/2008/2008-06-20.parquet
  size:    27 KB
  rows:    597

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-20	SPY	ETF	132.84	133.09	131.22	131.58	289275700.0
2008-06-20	QQQ	ETF	48.34	48.35	47.21	47.42	197434104.0
2008-06-20	IWM	ETF	73.45	73.45	71.85	72.57	121586400.0
2008-06-20	DIA	ETF	119.61	119.71	118.09	118.24	21836600.0
2008-06-20	GLD	ETF	88.82	89.61	88.77	88.95	10057800.0
2008-06-20	TLT	ETF	89.94	90.07	89.69	89.81	4580900.0
2008-06-20	ACWI	ETF	50.71	51.49	50.12	50.19	35700.0
2008-06-20	ACWX	ETF	51.5	51.5	50.98	50.98	12970.0
2008-06-20	ADRE	ETF	52.32	52.32	50.43	50.43	320884.0
2008-06-20	AGG	ETF	100.11	100.13	99.76	99.86	419000.0
2008-06-20	AIA	ETF	43.75	43.75	42.39	42.39	3845.0
2008-06-20	AIQ	ETF	45.8	46.35	45.3	45.75	120546.0
2008-06-20	AIS	ETF	0.76	0.77	0.7001	0.74	122390.0
2008-06-20	AIVI	ETF	61.66	61.66	60.62	60.78	50700.0
2008-06-20	ARB	ETF	50.25	50.28	48.76	49.48	383338.0
2008-06-20	BBH	ETF	55.9367	56.23	55.5833	56.0233	340800.0
2008-06-20	BIL	ETF	91.8	91.82	91.74	91.8	81400.0
2008-06-20	BITS	ETF	26.0004	26.0004	24.28	25.48	3888.0
2008-06-20	BIV	ETF	76.0	76.29	75.98	76.04	43400.0
2008-06-20	BJK	ETF	34.0	34.3	33.5	34.3	400.0
2008-06-20	BKF	ETF	54.71	54.71	52.61	52.76	45534.0
2008-06-20	BLV	ETF	73.82	74.11	73.64	73.85	7400.0
2008-06-20	BMVP	ETF	15.78	15.847	15.6067	15.6352	30464.0
2008-06-20	BND	ETF	75.84	75.84	75.58	75.71	145900.0
2008-06-20	BNE	ETF	14.67	15.6	14.19	14.34	265388.0
2008-06-20	BRF	ETF	14.83	14.83	14.72	14.73	3400.0
2008-06-20	BSV	ETF	77.0	77.03	76.83	76.93	73300.0
2008-06-20	BTF	ETF	98.9	99.0495	97.85	97.93499999999999	4171.6
2008-06-20	BWX	ETF	27.215	27.41	27.215	27.38	307304.0
2008-06-20	CBON	ETF	5.9	6.44	5.9	6.27	218328.0
2008-06-20	CDL	ETF	1.44	1.465	1.35	1.45	1626404.0
2008-06-20	CEF	ETF	12.53	12.7	12.53	12.67	312500.0
2008-06-20	CGO	ETF	15.86	15.96	15.6701	15.75	24364.0
2008-06-20	CGW	ETF	24.28	24.48	23.89	23.9	170937.0
2008-06-20	CHB	ETF	7.0	7.12	6.82	6.9	3575154.0
2008-06-20	CHI	ETF	14.8	14.93	14.64	14.7	79051.0
2008-06-20	CHIC	ETF	17.98	18.27	17.4	18.14	467134.0
2008-06-20	CHW	ETF	12.14	12.36	11.92	12.21	174530.0
2008-06-20	CHY	ETF	13.8	13.91	13.67	13.76	89830.0
2008-06-20	CMF	ETF	51.27	51.295	50.885	50.885	21294.0
2008-06-20	CN	ETF	55.77	55.77	53.14	53.35	285398.0
2008-06-20	CNXT	ETF	0.61	0.65	0.58	0.59	8666324.0
2008-06-20	COW	ETF	44.82	45.99	44.65	45.71	438352.0
2008-06-20	CPI	ETF	21.2999	21.5	21.25	21.3	1850.0
2008-06-20	CPST	ETF	4.07	4.18	3.9	4.17	6660220.0
2008-06-20	CSA	ETF	18.46	18.46	17.33	17.67	108693.0
2008-06-20	CSB	ETF	17.75	20.09	17.75	19.77	33953.0
2008-06-20	CSD	ETF	22.81	22.81	22.49	22.51	16300.0
2008-06-20	CSQ	ETF	12.2	12.2	12.06	12.17	311625.0
2008-06-20	CUT	ETF	20.25	20.25	20.04	20.15	25200.0

> showing 50 of 597 rows — these rows as CSV

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