PREVIEW / etf_daily / 2008-04-03

all etf daily files

  file:    by_date/etf_daily/2008/2008-04-03.parquet
  size:    26 KB
  rows:    588

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-04-03	SPY	ETF	135.96	137.44	135.71	137.04	175884800.0
2008-04-03	QQQ	ETF	45.29	45.91	45.14	45.59	140033769.0
2008-04-03	IWM	ETF	70.43	71.47	70.35	71.18	57228200.0
2008-04-03	DIA	ETF	125.53	126.64	125.22	126.33	11471000.0
2008-04-03	GLD	ETF	88.59	89.75	87.64	89.42	9324800.0
2008-04-03	TLT	ETF	94.5	94.67	94.12	94.34	2839100.0
2008-04-03	ACWI	ETF	59.7	59.7	50.95	51.5	29100.0
2008-04-03	ACWX	ETF	52.11	52.36	52.11	52.32	1750.0
2008-04-03	ADRE	ETF	50.71	51.92	50.62	51.61	541891.0
2008-04-03	AGG	ETF	101.89	102.08	101.6	101.94	480900.0
2008-04-03	AIA	ETF	45.25	46.13	45.25	45.7	6900.0
2008-04-03	AIQ	ETF	42.95	43.25	42.35	42.5	23260.0
2008-04-03	AIS	ETF	0.98	0.99	0.93	0.96	60150.0
2008-04-03	AIVI	ETF	65.55	66.81	65.3	66.41	12500.0
2008-04-03	ARB	ETF	44.19	44.55	43.83	44.39	258968.0
2008-04-03	BBH	ETF	57.4333	58.0033	57.4333	57.64	586500.0
2008-04-03	BIL	ETF	91.7	91.74	91.68	91.7	23600.0
2008-04-03	BITS	ETF	23.16	23.72	23.16	23.64	7229.0
2008-04-03	BIV	ETF	78.61	78.75	78.5	78.5	197100.0
2008-04-03	BJK	ETF	40.59	40.76	40.59	40.67	1700.0
2008-04-03	BKF	ETF	51.4	52.85	51.4	52.13	47300.0
2008-04-03	BLV	ETF	76.2	76.3	75.68	75.9	7400.0
2008-04-03	BMVP	ETF	15.7699	15.8567	15.7233	15.8133	33848.0
2008-04-03	BND	ETF	77.16	77.3	76.84	76.9	279000.0
2008-04-03	BNE	ETF	15.52	15.72	15.33	15.72	150100.0
2008-04-03	BRF	ETF	14.67	14.68	14.62	14.68	9200.0
2008-04-03	BSV	ETF	78.67	78.67	78.21	78.21	49800.0
2008-04-03	BTF	ETF	103.045	103.45	102.90050000000001	103.45	977.2
2008-04-03	BWX	ETF	28.545	28.715	28.52	28.6537	195546.0
2008-04-03	CBON	ETF	13.5	13.63	12.99	13.13	75726.0
2008-04-03	CDL	ETF	1.8	1.8025	1.71	1.76	848088.0
2008-04-03	CEF	ETF	12.78	12.85	12.45	12.57	581900.0
2008-04-03	CGO	ETF	16.86	17.01	16.7401	17.01	12900.0
2008-04-03	CGW	ETF	24.01	24.37	24.0	24.2501	55200.0
2008-04-03	CHB	ETF	10.98	11.03	10.2	10.91	1989096.0
2008-04-03	CHI	ETF	14.25	14.402	14.17	14.402	89700.0
2008-04-03	CHIC	ETF	17.42	17.42	16.81	17.16	1187324.0
2008-04-03	CHW	ETF	11.51	11.69	11.49	11.66	123491.0
2008-04-03	CHY	ETF	13.07	13.24	12.9672	13.23	166100.0
2008-04-03	CMF	ETF	51.29	51.325	51.25	51.275	5200.0
2008-04-03	CN	ETF	59.8	61.71	59.7	61.64	299657.0
2008-04-03	CNXT	ETF	0.6	0.61	0.59	0.6	1370418.0
2008-04-03	COW	ETF	39.95	41.13	39.8601	40.95	48000.0
2008-04-03	CPST	ETF	2.43	2.52	2.4	2.43	4683901.0
2008-04-03	CSA	ETF	16.51	17.01	16.33	16.38	45101.0
2008-04-03	CSB	ETF	21.5	21.9	21.2	21.75	110400.0
2008-04-03	CSD	ETF	23.63	23.79	23.63	23.79	500.0
2008-04-03	CSQ	ETF	12.4	12.6022	12.35	12.51	216700.0
2008-04-03	CUT	ETF	22.5	22.5	21.53	22.49	31200.0
2008-04-03	CVY	ETF	22.53	22.75	22.52	22.73	13200.0

> showing 50 of 588 rows — these rows as CSV

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