PREVIEW / etf_daily / 2008-12-19

all etf daily files

  file:    by_date/etf_daily/2008/2008-12-19.parquet
  size:    28 KB
  rows:    633

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-12-19	SPY	ETF	89.1	90.62	88.09	88.19	301451300.0
2008-12-19	QQQ	ETF	29.98	30.37	29.66	29.86	118332946.0
2008-12-19	IWM	ETF	49.0	50.01	48.21	48.7	88221200.0
2008-12-19	DIA	ETF	86.74	87.82	85.36	85.36	19707600.0
2008-12-19	GLD	ETF	82.65	82.87	82.01	82.63	9139500.0
2008-12-19	TLT	ETF	121.44	122.99	121.28	122.26	2668500.0
2008-12-19	AAXJ	ETF	34.51	34.95	34.21	34.56	294400.0
2008-12-19	ACWI	ETF	31.7	32.15	31.35	31.62	300100.0
2008-12-19	ACWX	ETF	29.93	30.2	29.47	29.62	624458.0
2008-12-19	ADRE	ETF	27.9	28.11	27.35	27.4748	290677.0
2008-12-19	AFK	ETF	21.98	21.98	21.9799	21.9799	525.0
2008-12-19	AGG	ETF	101.93	102.31	101.5	101.98	829700.0
2008-12-19	AGQ	ETF	58.68	60.0	58.2	58.94	11600.0
2008-12-19	AGZ	ETF	108.45	108.52	108.28	108.28	1748.0
2008-12-19	AIA	ETF	26.91	26.91	26.58	26.814	3371.0
2008-12-19	AIQ	ETF	37.95	37.95	36.4	36.8	66233.0
2008-12-19	AIS	ETF	0.31	0.36	0.31	0.32	106399.0
2008-12-19	AIVI	ETF	36.71	37.26	36.39	36.54	33700.0
2008-12-19	AOA	ETF	24.6	25.1	23.76	23.96	202600.0
2008-12-19	AOK	ETF	25.7499	26.35	25.68	26.18	9000.0
2008-12-19	AOM	ETF	25.32	25.43	25.22	25.22	7762.0
2008-12-19	AOR	ETF	24.86	24.86	24.86	24.86	3286.0
2008-12-19	ARB	ETF	11.95	13.08	11.76	12.52	871730.0
2008-12-19	BAL	ETF	26.68	26.68	26.68	26.68	220.0
2008-12-19	BBH	ETF	56.3567	57.45	56.2133	57.3567	1098900.0
2008-12-19	BIL	ETF	91.78	91.84	91.66	91.72	202500.0
2008-12-19	BITS	ETF	17.8	18.0	16.2	18.0	2360.0
2008-12-19	BIV	ETF	78.77	79.21	77.65	78.89	107800.0
2008-12-19	BJK	ETF	17.0	17.0	17.0	17.0	1000.0
2008-12-19	BKF	ETF	25.26	26.93	25.26	25.52	84726.0
2008-12-19	BLV	ETF	80.59	81.12	80.5	81.02	31300.0
2008-12-19	BMVP	ETF	10.52	10.7	10.45	10.45	46039.0
2008-12-19	BND	ETF	77.78	78.0	77.57	77.57	258500.0
2008-12-19	BNE	ETF	4.71	6.25	4.65	6.25	697577.0
2008-12-19	BOSS	ETF	13.15	13.26	13.15	13.23	100.0
2008-12-19	BSV	ETF	79.46	79.91	78.59	79.87	120700.0
2008-12-19	BTF	ETF	49.24999999999999	50.3	47.300000000000004	48.8	12984.0
2008-12-19	BWX	ETF	27.065	27.25	27.015	27.165	260326.0
2008-12-19	CBON	ETF	2.34	2.4	2.23	2.33	36423.0
2008-12-19	CDL	ETF	0.201	0.24	0.2	0.23	1267027.0
2008-12-19	CEF	ETF	10.6	10.65	10.33	10.44	829100.0
2008-12-19	CGO	ETF	8.82	9.19	8.7528	9.0	24286.0
2008-12-19	CGW	ETF	14.72	15.187	14.72	14.78	38206.0
2008-12-19	CHB	ETF	0.92	1.13	0.57	0.57	12719515.0
2008-12-19	CHI	ETF	8.21	8.3	8.0	8.14	596722.0
2008-12-19	CHIC	ETF	6.25	6.71	6.0	6.71	648265.0
2008-12-19	CHW	ETF	5.38	5.42	5.21	5.35	415439.0
2008-12-19	CHY	ETF	7.49	7.79	7.45	7.53	567036.0
2008-12-19	CMF	ETF	49.525	50.025	49.525	49.65	5334.0
2008-12-19	CNXT	ETF	0.77	0.7999	0.74	0.741	605672.0

> showing 50 of 633 rows — these rows as CSV

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