PREVIEW / etf_daily / 2008-10-23

all etf daily files

  file:    by_date/etf_daily/2008/2008-10-23.parquet
  size:    27 KB
  rows:    612

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-23	SPY	ETF	90.29	92.45	85.81	91.69	634666400.0
2008-10-23	QQQ	ETF	30.46	31.09	28.9	30.49	377966829.0
2008-10-23	IWM	ETF	50.68	50.94	46.68	48.99	133202600.0
2008-10-23	DIA	ETF	85.67	87.99	82.4	87.99	59594500.0
2008-10-23	GLD	ETF	69.64	72.19	69.5	70.65	16651600.0
2008-10-23	TLT	ETF	97.95	98.89	96.82	97.77	1802000.0
2008-10-23	AAXJ	ETF	29.92	30.45	28.78	30.2	248100.0
2008-10-23	ACWI	ETF	30.78	31.54	29.8	30.96	126700.0
2008-10-23	ACWX	ETF	28.31	29.12	27.44	28.3	81534.0
2008-10-23	ADRE	ETF	24.0	25.143	22.97	24.37	1089140.0
2008-10-23	AFK	ETF	24.32	24.32	21.71	22.43	4783.0
2008-10-23	AGG	ETF	97.97	97.97	95.51	96.01	855400.0
2008-10-23	AIA	ETF	23.3	24.07	23.0	23.0	31048.0
2008-10-23	AIQ	ETF	38.95	39.0	36.0	37.7	38309.0
2008-10-23	AIS	ETF	0.47	0.5	0.45	0.5	26300.0
2008-10-23	AIVI	ETF	36.26	37.36	35.38	37.36	37800.0
2008-10-23	ARB	ETF	31.95	32.4	28.59	29.21	640087.0
2008-10-23	BAL	ETF	30.72	30.89	30.5	30.5	1850.0
2008-10-23	BBH	ETF	55.91	57.18	54.16	56.0	1313100.0
2008-10-23	BIL	ETF	91.74	91.86	91.74	91.86	151700.0
2008-10-23	BITS	ETF	15.88	17.16	14.68	16.96	2385.0
2008-10-23	BIV	ETF	72.21	72.28	71.79	72.1	24700.0
2008-10-23	BJK	ETF	17.06	17.06	16.06	16.15	2500.0
2008-10-23	BKF	ETF	22.01	22.671	21.1184	22.1599	80477.0
2008-10-23	BLV	ETF	68.05	68.58	67.81	68.38	14800.0
2008-10-23	BMVP	ETF	10.3033	10.5401	9.8667	10.4	36947.0
2008-10-23	BND	ETF	75.4	75.4	74.47	74.96	172500.0
2008-10-23	BNE	ETF	6.21	6.44	5.82	6.41	136102.0
2008-10-23	BRF	ETF	14.82	14.82	14.79	14.79	21245.0
2008-10-23	BSV	ETF	76.29	76.29	75.59	75.94	128300.0
2008-10-23	BTF	ETF	65.0	69.1	63.849999999999994	65.35	32312.4
2008-10-23	BWX	ETF	24.405	24.7	24.35	24.56	219504.0
2008-10-23	CBON	ETF	3.8	3.8	2.82	3.18	271833.0
2008-10-23	CDL	ETF	0.33	0.33	0.2	0.26	1261621.0
2008-10-23	CEF	ETF	8.21	8.6	8.0	8.18	2026900.0
2008-10-23	CGO	ETF	9.83	9.83	9.0	9.21	43710.0
2008-10-23	CGW	ETF	14.01	14.9564	13.9	14.49	85767.0
2008-10-23	CHB	ETF	3.1	3.19	1.8	2.34	3346858.0
2008-10-23	CHI	ETF	9.14	10.21	8.87	9.3	248397.0
2008-10-23	CHIC	ETF	7.58	7.74	7.14	7.51	763289.0
2008-10-23	CHW	ETF	6.18	6.25	5.71	6.2	247233.0
2008-10-23	CHY	ETF	8.92	8.99	8.23	8.92	271200.0
2008-10-23	CMF	ETF	48.155	49.245	48.155	49.16	15756.0
2008-10-23	CNXT	ETF	2.26	2.32	1.92	1.95	700333.0
2008-10-23	COW	ETF	36.1	36.49	35.67	35.82	57550.0
2008-10-23	CPST	ETF	1.27	1.32	1.15	1.26	1697631.0
2008-10-23	CSA	ETF	11.39	11.39	9.85	10.53	137232.0
2008-10-23	CSB	ETF	15.0	15.16	13.01	13.25	59120.0
2008-10-23	CSD	ETF	12.01	12.41	12.01	12.41	3200.0
2008-10-23	CSQ	ETF	6.5	6.75	6.29	6.75	573695.0

> showing 50 of 612 rows — these rows as CSV

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