PREVIEW / etf_daily / 2008-11-17

all etf daily files

  file:    by_date/etf_daily/2008/2008-11-17.parquet
  size:    27 KB
  rows:    624

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-11-17	SPY	ETF	86.38	88.56	85.16	85.47	415254900.0
2008-11-17	QQQ	ETF	28.49	29.23	28.26	28.37	202894875.0
2008-11-17	IWM	ETF	45.35	46.58	44.89	45.25	84029400.0
2008-11-17	DIA	ETF	83.98	85.98	82.72	82.95	38157100.0
2008-11-17	GLD	ETF	72.43	73.8	72.15	72.65	7708600.0
2008-11-17	TLT	ETF	95.68	96.03	95.29	95.59	490300.0
2008-11-17	AAXJ	ETF	30.3	30.8	29.82	29.94	177100.0
2008-11-17	ACWI	ETF	30.47	30.64	29.5	30.0	138800.0
2008-11-17	ACWX	ETF	28.01	28.15	27.25	27.902	95589.0
2008-11-17	ADRE	ETF	24.5	25.34	24.22	24.46	256290.0
2008-11-17	AFK	ETF	22.8	22.8	22.8	22.8	423.0
2008-11-17	AGG	ETF	96.91	97.24	96.62	97.24	407500.0
2008-11-17	AGZ	ETF	102.67	102.86	102.67	102.86	470.0
2008-11-17	AIA	ETF	24.81	24.81	23.2	23.26	17318.0
2008-11-17	AIQ	ETF	43.6	45.05	42.6	43.5	47144.0
2008-11-17	AIS	ETF	0.45	0.49	0.43	0.49	67560.0
2008-11-17	AIVI	ETF	33.63	34.55	33.44	33.82	9900.0
2008-11-17	AOA	ETF	23.01	23.04	23.01	23.01	1300.0
2008-11-17	AOR	ETF	23.59	24.9	23.46	24.65	9050.0
2008-11-17	ARB	ETF	24.88	25.1	23.48	24.17	335728.0
2008-11-17	BAL	ETF	24.03	24.03	24.03	24.03	100.0
2008-11-17	BBH	ETF	56.1533	57.0033	55.8033	55.87	1495500.0
2008-11-17	BIL	ETF	91.88	91.94	91.84	91.94	170900.0
2008-11-17	BITS	ETF	15.0	15.44	14.6	14.8	3750.0
2008-11-17	BIV	ETF	72.48	72.78	72.33	72.77	26900.0
2008-11-17	BJK	ETF	16.07	16.07	15.34	15.34	1100.0
2008-11-17	BKF	ETF	22.69	23.3806	22.38	22.6025	50304.0
2008-11-17	BLV	ETF	68.23	68.78	68.23	68.54	11900.0
2008-11-17	BMVP	ETF	10.13	10.31	9.97	9.97	50117.0
2008-11-17	BND	ETF	74.55	74.78	74.33	74.62	157000.0
2008-11-17	BNE	ETF	2.99	3.02	2.56	2.8	257112.0
2008-11-17	BRF	ETF	14.91	14.91	14.9	14.9	2600.0
2008-11-17	BSV	ETF	76.76	77.26	76.54	76.7	62900.0
2008-11-17	BTF	ETF	48.75	49.699999999999996	45.0	45.449999999999996	42940.200000000004
2008-11-17	BWX	ETF	24.625	24.7	24.54	24.625	94688.0
2008-11-17	CBON	ETF	2.75	2.79	2.51	2.6	113772.0
2008-11-17	CDL	ETF	0.187	0.25	0.1807	0.22	1755751.0
2008-11-17	CEF	ETF	8.72	9.01	8.7	8.71	424200.0
2008-11-17	CGO	ETF	8.75	8.75	8.15	8.47	41513.0
2008-11-17	CGW	ETF	14.16	15.36	14.16	14.6	88211.0
2008-11-17	CHB	ETF	0.62	0.78	0.4	0.42	2004288.0
2008-11-17	CHI	ETF	7.4	7.4	7.0	7.3	202673.0
2008-11-17	CHIC	ETF	6.29	6.722	5.83	5.96	946096.0
2008-11-17	CHW	ETF	5.5	5.5	5.0	5.08	176030.0
2008-11-17	CHY	ETF	6.95	6.96	6.45	6.7027	453711.0
2008-11-17	CMF	ETF	50.77	50.77	50.35	50.37	7438.0
2008-11-17	CNXT	ETF	1.1	1.13	1.0	1.01	247361.0
2008-11-17	COW	ETF	35.0	35.0117	34.43	34.52	25240.0
2008-11-17	CPI	ETF	22.6	22.6	22.6	22.6	500.0
2008-11-17	CPST	ETF	0.98	1.02	0.97	0.98	920905.0

> showing 50 of 624 rows — these rows as CSV

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