PREVIEW / etf_daily / 2008-12-26

all etf daily files

  file:    by_date/etf_daily/2008/2008-12-26.parquet
  size:    27 KB
  rows:    615

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-26	SPY	ETF	87.24	87.3	86.5	87.16	74767700.0
2008-12-26	QQQ	ETF	29.19	29.23	28.97	29.13	20946302.0
2008-12-26	IWM	ETF	47.35	47.67	46.73	47.55	25104700.0
2008-12-26	DIA	ETF	85.01	85.28	84.56	85.07	5294600.0
2008-12-26	GLD	ETF	83.52	85.97	83.12	85.6	5080800.0
2008-12-26	TLT	ETF	121.59	121.97	121.2	121.3	454400.0
2008-12-26	AAXJ	ETF	37.79	37.79	32.66	32.82	87400.0
2008-12-26	ACWI	ETF	31.18	31.22	30.92	31.18	181400.0
2008-12-26	ACWX	ETF	29.35	29.53	29.2	29.49	114858.0
2008-12-26	ADRE	ETF	26.2	26.33	25.92	26.29	137079.0
2008-12-26	AFK	ETF	20.9	20.9	20.9	20.9	250.0
2008-12-26	AGG	ETF	104.1	104.22	103.48	103.67	467300.0
2008-12-26	AGQ	ETF	53.72	57.44	53.08	57.44	3800.0
2008-12-26	AGZ	ETF	108.71	108.71	108.5733	108.58	1770.0
2008-12-26	AIA	ETF	25.05	25.13	25.014	25.13	6687.0
2008-12-26	AIQ	ETF	35.05	36.25	34.85	35.6	15176.0
2008-12-26	AIS	ETF	0.3	0.34	0.3	0.33	118186.0
2008-12-26	AIVI	ETF	33.17	33.17	31.89	32.99	34300.0
2008-12-26	AOA	ETF	23.4	24.07	23.4	23.55	10600.0
2008-12-26	AOK	ETF	25.75	25.79	25.514	25.7692	612.0
2008-12-26	AOM	ETF	26.08	26.08	25.0699	25.07	10815.0
2008-12-26	AOR	ETF	24.3575	25.3	24.34	24.39	14245.0
2008-12-26	ARB	ETF	12.3	12.46	11.79	12.26	168619.0
2008-12-26	BAL	ETF	27.16	27.16	26.86	27.1089	340.0
2008-12-26	BBH	ETF	57.1833	57.1833	56.5433	56.6433	88200.0
2008-12-26	BIL	ETF	91.76	91.88	91.76	91.84	70500.0
2008-12-26	BITS	ETF	18.12	18.12	17.84	17.96	788.0
2008-12-26	BIV	ETF	78.9	79.42	78.12	79.42	72700.0
2008-12-26	BJK	ETF	17.38	17.38	16.5	16.5	400.0
2008-12-26	BKF	ETF	24.32	24.4	23.51	24.35	21734.0
2008-12-26	BLV	ETF	80.54	81.12	80.42	81.0	14100.0
2008-12-26	BMVP	ETF	10.28	10.3748	10.2467	10.36	140666.0
2008-12-26	BND	ETF	77.85	78.41	77.76	78.23	138700.0
2008-12-26	BNE	ETF	5.91	6.38	5.76	6.09	334512.0
2008-12-26	BSV	ETF	79.2	80.09	79.2	80.07	118700.0
2008-12-26	BTF	ETF	48.89999999999999	48.89999999999999	47.5	48.246	5952.8
2008-12-26	BWX	ETF	27.275	27.35	27.1801	27.2	121380.0
2008-12-26	CBON	ETF	2.51	2.66	2.47	2.63	25631.0
2008-12-26	CDL	ETF	0.2	0.21	0.15	0.19	1292625.0
2008-12-26	CEF	ETF	10.4	11.06	10.3	11.01	409700.0
2008-12-26	CGO	ETF	9.48	9.78	9.39	9.56	20393.0
2008-12-26	CGW	ETF	13.33	13.69	13.21	13.5101	31816.0
2008-12-26	CHB	ETF	0.67	0.69	0.64	0.66	808104.0
2008-12-26	CHI	ETF	8.2	8.345	8.07	8.21	274144.0
2008-12-26	CHIC	ETF	6.24	6.4	6.12	6.29	99506.0
2008-12-26	CHW	ETF	5.4	5.51	5.36	5.51	184307.0
2008-12-26	CHY	ETF	7.86	8.2	7.8	8.16	251787.0
2008-12-26	CMF	ETF	50.555	50.71	50.1	50.61	13444.0
2008-12-26	CNXT	ETF	0.67	0.69	0.67	0.67	207154.0
2008-12-26	COW	ETF	34.03	34.03	33.16	33.38	20389.0

> showing 50 of 615 rows — these rows as CSV

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