PREVIEW / etf_daily / 2008-02-21

all etf daily files

  file:    by_date/etf_daily/2008/2008-02-21.parquet
  size:    26 KB
  rows:    567

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-02-21	SPY	ETF	136.66	137.01	134.07	134.79	201051200.0
2008-02-21	QQQ	ETF	44.36	44.47	43.34	43.52	127856974.0
2008-02-21	IWM	ETF	71.26	71.75	69.24	69.42	85702100.0
2008-02-21	DIA	ETF	124.68	124.98	122.47	123.2	13487600.0
2008-02-21	GLD	ETF	93.44	94.22	93.02	93.25	12952200.0
2008-02-21	TLT	ETF	92.08	92.85	92.05	92.55	4197200.0
2008-02-21	ADRE	ETF	52.78	53.2	51.75	51.9	707714.0
2008-02-21	AGG	ETF	101.76	102.19	101.51	102.13	486400.0
2008-02-21	AIA	ETF	44.94	44.94	43.12	43.12	3500.0
2008-02-21	AIQ	ETF	54.05	54.05	49.8	50.0	120761.0
2008-02-21	AIS	ETF	1.04	1.04	0.97	1.0	114600.0
2008-02-21	AIVI	ETF	63.1	63.31	62.05	62.35	31900.0
2008-02-21	ARB	ETF	42.23	42.45	41.29	41.42	246200.0
2008-02-21	BBH	ETF	55.2533	55.26	54.2867	54.3867	517500.0
2008-02-21	BIL	ETF	91.76	91.8	91.72	91.8	39200.0
2008-02-21	BITS	ETF	21.32	21.76	21.0	21.2796	11422.0
2008-02-21	BIV	ETF	78.06	78.62	77.86	78.59	93000.0
2008-02-21	BJK	ETF	42.77	42.77	42.08	42.08	900.0
2008-02-21	BKF	ETF	54.85	54.85	53.6	53.68	55400.0
2008-02-21	BLV	ETF	75.71	76.14	75.54	76.0	48200.0
2008-02-21	BMVP	ETF	16.1467	16.292	15.9633	15.99	43600.0
2008-02-21	BND	ETF	76.98	77.33	76.79	77.2	205100.0
2008-02-21	BNE	ETF	13.67	14.05	13.18	13.19	211800.0
2008-02-21	BRF	ETF	14.69	14.69	14.68	14.68	5200.0
2008-02-21	BSV	ETF	78.24	78.58	78.23	78.57	60400.0
2008-02-21	BTF	ETF	111.25	111.5	106.99999999999999	108.3	4800.0
2008-02-21	BWX	ETF	27.175	27.37	27.05	27.345	256566.0
2008-02-21	CBON	ETF	14.54	14.6	12.97	12.98	107519.0
2008-02-21	CDL	ETF	1.34	1.38	1.33	1.34	1500256.0
2008-02-21	CEF	ETF	13.09	13.15	12.92	13.03	726900.0
2008-02-21	CGO	ETF	16.35	16.5	16.0	16.5	27500.0
2008-02-21	CGW	ETF	23.69	23.69	23.19	23.42	134707.0
2008-02-21	CHB	ETF	8.2	8.7	7.82	7.91	1744611.0
2008-02-21	CHI	ETF	14.63	14.75	14.26	14.406	98089.0
2008-02-21	CHIC	ETF	20.03	20.29	19.38	19.47	1013251.0
2008-02-21	CHW	ETF	11.68	11.82	11.51	11.61	147786.0
2008-02-21	CHY	ETF	13.32	13.51	13.09	13.37	154674.0
2008-02-21	CMF	ETF	52.1701	52.275	51.845	52.1249	18800.0
2008-02-21	CN	ETF	62.0	63.38	60.95	61.0	168475.0
2008-02-21	CNXT	ETF	0.6	0.6	0.56	0.56	2545702.0
2008-02-21	COW	ETF	46.44	46.44	45.77	45.89	36400.0
2008-02-21	CPI	ETF	19.3101	19.69	19.16	19.42	6200.0
2008-02-21	CPST	ETF	1.6	1.61	1.57	1.6	1211867.0
2008-02-21	CSA	ETF	15.13	15.46	14.65	14.72	69100.0
2008-02-21	CSD	ETF	24.0	24.01	23.49	23.49	11700.0
2008-02-21	CSQ	ETF	12.93	12.98	12.7999	12.87	291743.0
2008-02-21	CUT	ETF	21.99	21.99	21.62	21.7	17400.0
2008-02-21	CVY	ETF	23.12	23.13	22.65	22.65	14700.0
2008-02-21	CWI	ETF	25.02	25.38	24.9733	25.0067	118800.0
2008-02-21	CZA	ETF	23.8	23.8	23.8	23.8	400.0

> showing 50 of 567 rows — these rows as CSV

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