PREVIEW / etf_daily / 2008-04-23

all etf daily files

  file:    by_date/etf_daily/2008/2008-04-23.parquet
  size:    26 KB
  rows:    579

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-04-23	SPY	ETF	138.09	138.78	137.12	137.72	193309000.0
2008-04-23	QQQ	ETF	46.68	47.06	46.2736	46.85	131086179.0
2008-04-23	IWM	ETF	70.53	71.02	69.95	70.55	48056900.0
2008-04-23	DIA	ETF	127.49	128.24	126.91	127.3	10443200.0
2008-04-23	GLD	ETF	89.0	89.55	88.44	89.22	18170500.0
2008-04-23	TLT	ETF	93.09	93.63	92.53	93.15	1221100.0
2008-04-23	ACWI	ETF	52.6	52.84	52.18	52.49	21500.0
2008-04-23	ACWX	ETF	53.59	53.82	53.59	53.66	2268.0
2008-04-23	ADRE	ETF	54.4	54.5699	53.92	54.487	410158.0
2008-04-23	AGG	ETF	102.03	102.09	101.81	102.06	496300.0
2008-04-23	AIA	ETF	46.92	47.64	46.88	47.5	17320.0
2008-04-23	AIQ	ETF	40.35	42.5	39.9	42.2	52580.0
2008-04-23	AIS	ETF	0.8901	0.9074	0.89	0.9	49400.0
2008-04-23	AIVI	ETF	66.94	67.45	66.72	67.14	12000.0
2008-04-23	ARB	ETF	47.7	48.57	47.65	48.17	341383.0
2008-04-23	BBH	ETF	56.5067	56.6467	55.9467	56.0867	236100.0
2008-04-23	BIL	ETF	91.78	91.78	91.7	91.74	23800.0
2008-04-23	BITS	ETF	23.6	23.76	22.52	23.08	6890.0
2008-04-23	BIV	ETF	78.4	78.51	78.2	78.37	52600.0
2008-04-23	BJK	ETF	38.41	38.86	37.41	38.4	2800.0
2008-04-23	BKF	ETF	55.58	56.15	55.248	56.13	34020.0
2008-04-23	BLV	ETF	76.22	76.22	75.86	76.16	2000.0
2008-04-23	BMVP	ETF	15.8	15.915	15.753	15.873	28579.0
2008-04-23	BND	ETF	77.15	77.21	76.92	77.16	118600.0
2008-04-23	BNE	ETF	16.39	16.83	16.33	16.7	220664.0
2008-04-23	BOSS	ETF	33.62	33.95	33.62	33.95	100.0
2008-04-23	BRF	ETF	14.65	14.68	14.65	14.68	12300.0
2008-04-23	BSV	ETF	78.12	78.22	78.1	78.19	153600.0
2008-04-23	BTF	ETF	100.95	101.3	100.8505	101.19999999999999	2428.2000000000003
2008-04-23	BWX	ETF	28.745	28.745	28.64	28.6975	179202.0
2008-04-23	CBON	ETF	11.1	11.41	10.89	11.39	48138.0
2008-04-23	CDL	ETF	1.3	1.3	1.25	1.26	764950.0
2008-04-23	CEF	ETF	12.51	12.54	12.33	12.46	585400.0
2008-04-23	CGO	ETF	16.35	16.47	16.3101	16.4	14931.0
2008-04-23	CGW	ETF	24.5	24.5	24.03	24.28	69482.0
2008-04-23	CHB	ETF	10.01	10.06	9.55	9.76	1329942.0
2008-04-23	CHI	ETF	15.0	15.2	14.9701	15.16	108625.0
2008-04-23	CHIC	ETF	16.71	17.27	16.58	16.75	414937.0
2008-04-23	CHW	ETF	11.53	11.71	11.51	11.61	178340.0
2008-04-23	CHY	ETF	13.99	14.072	13.85	14.03	133336.0
2008-04-23	CMF	ETF	52.3	52.56	52.214	52.56	12400.0
2008-04-23	CN	ETF	58.75	60.63	58.11	60.45	493940.0
2008-04-23	CNXT	ETF	0.43	0.4699	0.43	0.44	3803516.0
2008-04-23	COW	ETF	43.21	43.61	43.12	43.56	109113.0
2008-04-23	CPI	ETF	18.25	19.65	18.25	19.65	1600.0
2008-04-23	CPST	ETF	3.01	3.02	2.86	2.94	6065781.0
2008-04-23	CSA	ETF	16.69	16.69	16.44	16.52	25129.0
2008-04-23	CSB	ETF	23.48	23.5	22.62	22.9	47978.0
2008-04-23	CSD	ETF	23.19	23.19	23.18	23.18	500.0
2008-04-23	CSQ	ETF	12.39	12.54	12.37	12.5	233459.0

> showing 50 of 579 rows — these rows as CSV

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