PREVIEW / etf_daily / 2008-10-16

all etf daily files

  file:    by_date/etf_daily/2008/2008-10-16.parquet
  size:    27 KB
  rows:    604

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-16	SPY	ETF	91.29	94.77	86.54	93.77	708811200.0
2008-10-16	QQQ	ETF	30.82	32.27	29.25	32.26	494913283.0
2008-10-16	IWM	ETF	51.02	53.88	48.29	53.71	207587400.0
2008-10-16	DIA	ETF	86.31	90.16	82.08	89.87	60371000.0
2008-10-16	GLD	ETF	82.4	82.5	77.22	79.29	30645600.0
2008-10-16	TLT	ETF	94.99	95.27	94.18	94.52	1063200.0
2008-10-16	AAXJ	ETF	33.25	33.89	31.9	33.62	186700.0
2008-10-16	ACWI	ETF	32.15	33.41	30.77	33.31	29700.0
2008-10-16	ACWX	ETF	30.34	31.3306	28.84	31.3306	52017.0
2008-10-16	ADRE	ETF	26.4	27.47	25.0	27.17	622324.0
2008-10-16	AFK	ETF	26.27	26.27	24.5	24.5	3224.0
2008-10-16	AGG	ETF	95.25	95.79	93.49	93.75	482900.0
2008-10-16	AIA	ETF	26.81	29.36	24.96	29.36	21597.0
2008-10-16	AIQ	ETF	40.05	41.5	38.0	41.2	44373.0
2008-10-16	AIS	ETF	0.49	0.5	0.44	0.5	61600.0
2008-10-16	AIVI	ETF	39.26	40.6	37.48	40.49	18600.0
2008-10-16	ARB	ETF	34.95	36.63	33.79	36.54	358192.0
2008-10-16	BAL	ETF	29.02	29.98	29.02	29.98	2800.0
2008-10-16	BBH	ETF	52.5	54.2	51.6667	54.2	593400.0
2008-10-16	BIL	ETF	91.96	91.96	91.72	91.84	200950.0
2008-10-16	BITS	ETF	14.0404	16.8	13.92	16.28	4560.0
2008-10-16	BIV	ETF	70.48	71.0	69.75	70.54	96600.0
2008-10-16	BKF	ETF	25.5	25.67	23.0	25.0	50910.0
2008-10-16	BLV	ETF	67.74	67.81	67.05	67.15	10700.0
2008-10-16	BMVP	ETF	10.14	10.71	9.26	10.71	168740.0
2008-10-16	BND	ETF	73.41	73.44	72.49	73.34	203200.0
2008-10-16	BNE	ETF	6.01	7.23	5.85	7.19	188852.0
2008-10-16	BRF	ETF	14.63	14.7	14.63	14.7	1500.0
2008-10-16	BSV	ETF	75.5	75.5	74.26	74.93	70800.0
2008-10-16	BTF	ETF	59.65	61.6	57.300000000000004	59.599999999999994	9738.6
2008-10-16	BWX	ETF	25.21	25.85	24.615	24.615	215046.0
2008-10-16	CBON	ETF	3.82	4.1881	3.61	3.75	79874.0
2008-10-16	CDL	ETF	0.35	0.4	0.22	0.24	1672503.0
2008-10-16	CEF	ETF	10.34	10.34	9.27	9.86	2362500.0
2008-10-16	CGO	ETF	9.84	9.84	9.15	9.2001	29126.0
2008-10-16	CGW	ETF	15.85	16.49	15.2752	16.47	101465.0
2008-10-16	CHB	ETF	3.4	3.75	2.97	3.69	1577832.0
2008-10-16	CHI	ETF	8.7	8.7	7.81	8.35	213507.0
2008-10-16	CHIC	ETF	8.64	9.03	8.0	8.77	619560.0
2008-10-16	CHW	ETF	6.14	6.15	5.4	6.03	186880.0
2008-10-16	CHY	ETF	8.06	8.5	7.2999	7.74	359612.0
2008-10-16	CMF	ETF	45.995	46.0	44.81	45.597	23700.0
2008-10-16	CNXT	ETF	2.66	2.78	2.48	2.55	329630.0
2008-10-16	COW	ETF	35.64	35.93	35.31	35.65	104958.0
2008-10-16	CPI	ETF	21.95	22.0	21.95	22.0	3000.0
2008-10-16	CPST	ETF	1.26	1.35	1.25	1.33	2082152.0
2008-10-16	CSA	ETF	12.42	12.67	11.75	12.41	148830.0
2008-10-16	CSB	ETF	15.1	15.1	14.0	14.5	51350.0
2008-10-16	CSD	ETF	13.37	13.59	12.97	13.59	5600.0
2008-10-16	CSQ	ETF	6.2	6.46	5.75	6.43	488706.0

> showing 50 of 604 rows — these rows as CSV

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