PREVIEW / etf_daily / 2005-03-17

all etf daily files

  file:    by_date/etf_daily/2005/2005-03-17.parquet
  size:    14 KB
  rows:    260

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
2005-03-17	SPY	ETF	119.31	119.74	118.98	119.36	62584200.0
2005-03-17	QQQ	ETF	36.61	36.89	36.54	36.71	101801139.0
2005-03-17	IWM	ETF	62.26	62.62	61.92	62.235	19603400.0
2005-03-17	DIA	ETF	106.56	106.68	106.04	106.29	4476200.0
2005-03-17	GLD	ETF	43.97	43.97	43.67	43.82	1525200.0
2005-03-17	TLT	ETF	89.35	89.58	89.12	89.23	1025300.0
2005-03-17	AAA	ETF	62.91	63.49	62.74	63.4	6500.0
2005-03-17	ADRE	ETF	86.9	88.13	86.89	88.119	3928.0
2005-03-17	AFK	ETF	25.5	25.66	25.5	25.59	15000.0
2005-03-17	AGG	ETF	101.49	101.56	101.11	101.27	191700.0
2005-03-17	AIQ	ETF	50.5	50.7	48.5	49.85	84580.0
2005-03-17	ARB	ETF	40.9	41.52	40.78	41.41	171800.0
2005-03-17	BAB	ETF	51.08	51.96	51.08	51.71	16000.0
2005-03-17	BBH	ETF	46.45	46.4967	45.8567	46.3333	2421000.0
2005-03-17	BCM	ETF	60.29	60.54	60.14	60.42	28500.0
2005-03-17	BIS	ETF	657.6	672.0	656.0	672.0	6.9
2005-03-17	BITS	ETF	13.0	13.0	11.24	12.2	34187.0
2005-03-17	BKF	ETF	40.2	40.2	39.6	39.7	26100.0
2005-03-17	BNE	ETF	14.9	15.18	14.8	15.15	131200.0
2005-03-17	BRF	ETF	15.61	15.61	15.6	15.6	5800.0
2005-03-17	BTF	ETF	90.0	90.0	89.0	89.25	2200.0
2005-03-17	CBON	ETF	26.56	26.81	26.56	26.75	14130.0
2005-03-17	CDC	ETF	8.18	8.18	8.0	8.0	3700.0
2005-03-17	CDL	ETF	13.99	14.15	13.94	14.04	204800.0
2005-03-17	CEF	ETF	5.6	5.61	5.56	5.58	187800.0
2005-03-17	CGW	ETF	29.95	30.24	29.75	29.8	16400.0
2005-03-17	CHB	ETF	9.63	9.71	9.25	9.58	1137900.0
2005-03-17	CHIC	ETF	12.17	12.34	11.82	11.98	242815.0
2005-03-17	CHIR	ETF	36.0501	36.3099	35.7801	35.94	942072.0
2005-03-17	CID	ETF	9.32	9.42	9.32	9.42	9200.0
2005-03-17	CIL	ETF	26.45	26.45	26.18	26.18	2100.0
2005-03-17	CN	ETF	28.31	28.4	28.17	28.4	15600.0
2005-03-17	CNXT	ETF	1.55	1.65	1.54	1.57	5046788.0
2005-03-17	CPI	ETF	18.1	18.1	18.02	18.02	3800.0
2005-03-17	CSB	ETF	34.2	34.36	34.12	34.34	4600.0
2005-03-17	CSM	ETF	2.375	2.375	2.375	2.375	400.0
2005-03-17	CTEC	ETF	50.35	53.3	50.0	50.3	8721.2
2005-03-17	CURE	ETF	0.4138	0.42	0.41	0.4125	1130464.0
2005-03-17	CYA	ETF	166.0	167.0	163.0	167.0	470.0
2005-03-17	CYB	ETF	3.38	3.42	3.33	3.4	43800.0
2005-03-17	DGT	ETF	64.67	64.78	64.58	64.58	3700.0
2005-03-17	DIG	ETF	13.1125	13.125	13.0	13.125	9440.0
2005-03-17	DIV	ETF	13.13	13.24	13.12	13.23	31100.0
2005-03-17	DJP	ETF	27.04	27.04	27.04	27.04	200.0
2005-03-17	DRIV	ETF	33.52	35.15	33.4	33.84	5993838.0
2005-03-17	DSI	ETF	5.92	5.92	5.92	5.92	400.0
2005-03-17	DUSA	ETF	10.0	10.09	9.68	10.0	144645.0
2005-03-17	DVY	ETF	60.56	60.84	60.4	60.82	388100.0
2005-03-17	EDEN	ETF	0.77	0.77	0.72	0.75	109550.0
2005-03-17	EDV	ETF	25.82	25.96	25.8	25.89	15500.0

> showing 50 of 260 rows — these rows as CSV

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