PREVIEW / etf_daily / 2008-10-09

all etf daily files

  file:    by_date/etf_daily/2008/2008-10-09.parquet
  size:    27 KB
  rows:    614

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-10-09	SPY	ETF	99.66	100.62	90.25	90.7	534485200.0
2008-10-09	QQQ	ETF	33.15	33.68	30.97	31.52	352617181.0
2008-10-09	IWM	ETF	55.65	55.93	49.45	49.99	154548100.0
2008-10-09	DIA	ETF	93.92	94.51	85.4	85.55	44474300.0
2008-10-09	GLD	ETF	87.29	90.58	86.54	89.9	19981800.0
2008-10-09	TLT	ETF	97.37	97.7	96.22	96.63	1785400.0
2008-10-09	AAXJ	ETF	35.14	35.26	32.58	32.58	2700.0
2008-10-09	ACWI	ETF	35.08	35.45	32.25	32.44	30200.0
2008-10-09	ACWX	ETF	33.57	33.58	30.26	30.424	50934.0
2008-10-09	ADRE	ETF	29.11	29.99	26.5	27.0	314579.0
2008-10-09	AFK	ETF	27.0	27.0	27.0	27.0	500.0
2008-10-09	AGG	ETF	94.52	95.37	92.9	94.89	946600.0
2008-10-09	AIA	ETF	28.69	28.74	26.13	26.28	51664.0
2008-10-09	AIQ	ETF	43.3	43.35	39.2	39.25	38360.0
2008-10-09	AIS	ETF	0.58	0.59	0.5	0.53	221300.0
2008-10-09	AIVI	ETF	43.57	43.63	39.21	39.56	44900.0
2008-10-09	ARB	ETF	40.56	41.4799	38.24	38.24	306031.0
2008-10-09	BBH	ETF	54.5133	55.61	51.8367	52.3833	936900.0
2008-10-09	BIL	ETF	91.84	91.98	91.76	91.98	177800.0
2008-10-09	BITS	ETF	18.3604	19.36	16.0	17.2	3082.0
2008-10-09	BIV	ETF	72.01	72.01	70.0	70.0	111600.0
2008-10-09	BJK	ETF	20.15	20.15	19.0	19.0	1800.0
2008-10-09	BKF	ETF	27.5	28.21	24.23	24.26	87450.0
2008-10-09	BLV	ETF	70.32	70.33	69.39	69.49	16500.0
2008-10-09	BMVP	ETF	11.11	11.39	9.9	9.9	46292.0
2008-10-09	BND	ETF	74.42	75.0	71.73	72.16	366000.0
2008-10-09	BNE	ETF	7.72	7.95	6.26	6.32	237203.0
2008-10-09	BRF	ETF	14.55	14.69	14.53	14.68	17000.0
2008-10-09	BSV	ETF	76.0	77.5	75.5	76.71	133200.0
2008-10-09	BTF	ETF	64.8	65.232	51.050000000000004	53.11	14453.0
2008-10-09	BWX	ETF	24.795	25.0	24.575	24.655	873910.0
2008-10-09	CBON	ETF	5.36	5.4899	3.31	4.27	91397.0
2008-10-09	CDL	ETF	0.44	0.57	0.35	0.37	1391626.0
2008-10-09	CEF	ETF	11.29	11.55	11.03	11.55	1652400.0
2008-10-09	CGO	ETF	8.64	8.646	7.3	7.36	114399.0
2008-10-09	CGW	ETF	15.6	16.75	14.96	15.03	82179.0
2008-10-09	CHB	ETF	4.24	4.47	3.49	3.49	1860101.0
2008-10-09	CHI	ETF	7.87	7.9	6.4	6.59	455716.0
2008-10-09	CHIC	ETF	9.97	10.05	8.86	8.98	404707.0
2008-10-09	CHW	ETF	5.8	5.81	4.55	4.98	354217.0
2008-10-09	CHY	ETF	8.5	8.51	7.5	7.9	539456.0
2008-10-09	CMF	ETF	48.5	49.23	48.0	48.0	14698.0
2008-10-09	CNXT	ETF	2.69	2.69	2.3	2.45	1054224.0
2008-10-09	COW	ETF	37.99	37.99	37.12	37.12	37118.0
2008-10-09	CPST	ETF	1.15	1.19	1.0	1.0	3805286.0
2008-10-09	CSA	ETF	13.99	14.19	13.25	13.27	200403.0
2008-10-09	CSB	ETF	11.35	12.49	11.25	11.74	18100.0
2008-10-09	CSD	ETF	14.35	14.35	13.46	13.57	8400.0
2008-10-09	CSQ	ETF	5.7	5.99	4.5	5.1	1272246.0
2008-10-09	CUT	ETF	13.35	13.62	12.44	12.44	23700.0

> showing 50 of 614 rows — these rows as CSV

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