PREVIEW / etf_daily / 2008-09-16

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-16.parquet
  size:    27 KB
  rows:    618

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-09-16	SPY	ETF	117.2	122.32	117.0	122.1	581744300.0
2008-09-16	QQQ	ETF	41.47	42.84	41.43	42.41	349551310.0
2008-09-16	IWM	ETF	67.8	71.0	67.73	71.0	252238200.0
2008-09-16	DIA	ETF	107.88	111.16	107.58	110.66	48722600.0
2008-09-16	GLD	ETF	76.69	77.29	76.3	76.79	17192100.0
2008-09-16	TLT	ETF	100.71	100.86	97.91	98.0	6684400.0
2008-09-16	AAXJ	ETF	41.96	42.0	41.0	41.58	3800.0
2008-09-16	ACWI	ETF	41.81	42.93	41.69	42.93	37100.0
2008-09-16	ACWX	ETF	39.69	40.54	39.53	40.5	120658.0
2008-09-16	ADRE	ETF	36.05	38.36	35.53	38.2	763426.0
2008-09-16	AFK	ETF	34.75	34.75	33.54	33.95	1606.0
2008-09-16	AGG	ETF	102.02	102.08	100.58	100.58	676000.0
2008-09-16	AIA	ETF	33.51	34.54	32.79	34.126	57549.0
2008-09-16	AIQ	ETF	55.65	56.15	53.25	55.35	56335.0
2008-09-16	AIS	ETF	0.65	0.68	0.52	0.65	102750.0
2008-09-16	AIVI	ETF	49.46	51.4	48.23	51.17	141400.0
2008-09-16	ARB	ETF	46.26	47.2	45.14	46.27	517654.0
2008-09-16	BAL	ETF	37.69	37.69	37.69	37.69	500.0
2008-09-16	BBH	ETF	62.5033	64.6633	62.3433	64.3533	598200.0
2008-09-16	BIL	ETF	91.76	91.96	91.76	91.94	424750.0
2008-09-16	BITS	ETF	21.08	21.12	20.4	20.8	11886.0
2008-09-16	BIV	ETF	78.3	78.3	76.43	76.76	87800.0
2008-09-16	BJK	ETF	26.64	26.64	26.6	26.6	400.0
2008-09-16	BKF	ETF	33.98	35.44	33.25	35.41	208470.0
2008-09-16	BLV	ETF	77.79	77.79	75.35	75.35	13500.0
2008-09-16	BMVP	ETF	13.91	14.31	13.82	14.22	68017.0
2008-09-16	BND	ETF	77.83	78.02	76.67	76.67	166400.0
2008-09-16	BNE	ETF	11.76	12.3705	11.73	12.34	203230.0
2008-09-16	BRF	ETF	14.74	14.77	14.73	14.76	11934.0
2008-09-16	BSV	ETF	78.39	78.83	77.5	77.73	234400.0
2008-09-16	BTF	ETF	78.89999999999999	80.35	78.6	79.69999999999999	11249.6
2008-09-16	BWX	ETF	26.265	26.4825	25.93	26.285	174334.0
2008-09-16	CBON	ETF	4.5	5.1	4.4	4.87	82841.0
2008-09-16	CDL	ETF	0.83	0.89	0.78	0.82	952370.0
2008-09-16	CEF	ETF	9.61	9.61	9.09	9.28	1867400.0
2008-09-16	CGO	ETF	11.85	12.26	11.55	11.73	38439.0
2008-09-16	CGW	ETF	20.03	21.15	20.01	21.1	161000.0
2008-09-16	CHB	ETF	4.85	5.69	4.5	5.67	1797049.0
2008-09-16	CHI	ETF	10.76	10.85	10.09	10.31	665700.0
2008-09-16	CHIC	ETF	11.76	12.5	11.76	11.99	463518.0
2008-09-16	CHW	ETF	7.91	8.4	7.91	8.16	572181.0
2008-09-16	CHY	ETF	11.2	11.2	10.08	10.45	488247.0
2008-09-16	CMF	ETF	51.59	51.665	51.5	51.5	9760.0
2008-09-16	CN	ETF	38.25	41.07	38.06	40.92	538090.0
2008-09-16	CNXT	ETF	4.66	4.74	4.3	4.5	538537.0
2008-09-16	COW	ETF	40.95	41.38	40.02	40.93	334235.0
2008-09-16	CPI	ETF	23.2	23.2	23.2	23.2	500.0
2008-09-16	CPST	ETF	1.65	1.9	1.63	1.87	2838827.0
2008-09-16	CSA	ETF	16.91	17.7	16.91	17.5	230494.0
2008-09-16	CSB	ETF	13.75	15.0	12.33	13.75	111145.0

> showing 50 of 618 rows — these rows as CSV

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