PREVIEW / etf_daily / 2008-12-31

all etf daily files

  file:    by_date/etf_daily/2008/2008-12-31.parquet
  size:    28 KB
  rows:    642

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-31	SPY	ETF	89.08	90.97	88.87	90.24	193987200.0
2008-12-31	QQQ	ETF	29.48	30.08	29.45	29.74	89221187.0
2008-12-31	IWM	ETF	48.22	50.32	48.14	49.24	75369500.0
2008-12-31	DIA	ETF	86.81	88.37	86.63	87.52	18703600.0
2008-12-31	GLD	ETF	84.98	87.1	84.28	86.52	7837100.0
2008-12-31	TLT	ETF	121.41	122.0	118.85	119.35	2738000.0
2008-12-31	AAXJ	ETF	33.15	34.41	33.15	33.53	177400.0
2008-12-31	ACWI	ETF	31.8	32.65	31.79	32.42	221700.0
2008-12-31	ACWX	ETF	30.29	30.91	30.29	30.72	261877.0
2008-12-31	ADRE	ETF	26.92	27.54	26.78	27.31	251849.0
2008-12-31	AFK	ETF	20.82	21.48	20.82	21.21	1995.0
2008-12-31	AGG	ETF	104.24	104.33	103.54	104.2	611900.0
2008-12-31	AGQ	ETF	58.14	64.02	57.34	63.0	17250.0
2008-12-31	AGZ	ETF	108.56	108.58	107.9	108.12	9737.0
2008-12-31	AIA	ETF	25.33	25.68	25.2	25.2	4948.0
2008-12-31	AIQ	ETF	37.85	40.0	37.35	39.85	94658.0
2008-12-31	AIS	ETF	0.34	0.3999	0.3301	0.37	485752.0
2008-12-31	AIVI	ETF	33.22	34.21	33.2	34.21	35600.0
2008-12-31	AOA	ETF	23.84	25.15	23.8	24.38	81100.0
2008-12-31	AOK	ETF	25.654	27.554	25.634	25.9	1550.0
2008-12-31	AOM	ETF	27.13	27.13	25.2	25.47	14291.0
2008-12-31	AOR	ETF	24.72	24.97	24.72	24.87	6567.0
2008-12-31	ARB	ETF	11.94	13.36	11.86	13.28	469522.0
2008-12-31	BAL	ETF	28.4	28.95	28.4	28.95	2440.0
2008-12-31	BBH	ETF	57.1733	57.7933	57.04	57.21	132300.0
2008-12-31	BIL	ETF	91.66	91.72	91.48	91.58	163600.0
2008-12-31	BITS	ETF	18.08	18.8	17.04	18.36	11723.0
2008-12-31	BIV	ETF	79.25	79.93	79.05	79.57	192500.0
2008-12-31	BJK	ETF	17.55	17.59	17.55	17.59	400.0
2008-12-31	BKF	ETF	23.98	24.99	23.98	24.97	14381.0
2008-12-31	BLV	ETF	81.13	81.15	79.69	80.27	15100.0
2008-12-31	BMVP	ETF	10.71	10.92	10.6367	10.8267	65258.0
2008-12-31	BND	ETF	78.45	79.22	78.45	78.97	381800.0
2008-12-31	BNE	ETF	5.5	6.16	5.5	5.88	310052.0
2008-12-31	BSV	ETF	80.22	80.96	79.2	80.55	167700.0
2008-12-31	BTF	ETF	47.0	49.9	46.74999999999999	49.3	8091.8
2008-12-31	BWX	ETF	27.2	27.225	27.052	27.2	285906.0
2008-12-31	CBON	ETF	3.04	3.47	2.75	3.47	72120.0
2008-12-31	CDL	ETF	0.17	0.18	0.13	0.16	1008640.0
2008-12-31	CEF	ETF	10.75	11.23	10.73	11.22	745300.0
2008-12-31	CGO	ETF	9.45	9.79	9.15	9.5	49013.0
2008-12-31	CGW	ETF	14.05	14.3899	14.04	14.155	62557.0
2008-12-31	CHB	ETF	0.66	0.71	0.56	0.56	658160.0
2008-12-31	CHI	ETF	8.08	8.44	8.03	8.29	305195.0
2008-12-31	CHIC	ETF	6.2	6.74	6.2	6.49	397021.0
2008-12-31	CHW	ETF	5.58	5.89	5.56	5.78	359428.0
2008-12-31	CHY	ETF	8.28	8.48	8.2	8.48	247466.0
2008-12-31	CMF	ETF	50.551	50.71	49.97	50.695	17910.0
2008-12-31	CNXT	ETF	0.66	0.7	0.66	0.685	571037.0
2008-12-31	COW	ETF	33.08	33.6	32.94	33.49	16262.0

> showing 50 of 642 rows — these rows as CSV

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