PREVIEW / etf_daily / 2005-03-18

all etf daily files

  file:    by_date/etf_daily/2005/2005-03-18.parquet
  size:    15 KB
  rows:    262

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-18	SPY	ETF	119.11	119.53	118.15	118.54	60232000.0
2005-03-18	QQQ	ETF	36.75	36.785	36.35	36.51	109185283.0
2005-03-18	IWM	ETF	62.28	62.35	61.74	61.9	24139800.0
2005-03-18	DIA	ETF	106.38	106.44	105.44	105.96	10700300.0
2005-03-18	GLD	ETF	43.61	43.95	43.6	43.89	1207500.0
2005-03-18	TLT	ETF	88.9	88.98	88.67	88.67	722700.0
2005-03-18	AAA	ETF	65.35	65.75	64.97	65.57	64600.0
2005-03-18	ADRE	ETF	89.99	89.99	87.301	87.51	5544.0
2005-03-18	AFK	ETF	25.7	25.7	25.51	25.57	12800.0
2005-03-18	AGG	ETF	101.2	101.3	100.95	101.2	80800.0
2005-03-18	AIQ	ETF	49.5	49.85	48.75	49.65	50860.0
2005-03-18	ARB	ETF	42.0	42.14	41.85	42.03	608400.0
2005-03-18	BAB	ETF	51.8	51.8	51.35	51.6	9500.0
2005-03-18	BBH	ETF	46.25	46.4333	45.9433	46.3	2139000.0
2005-03-18	BCM	ETF	60.0	60.25	59.92	60.06	7200.0
2005-03-18	BIS	ETF	664.0	670.4	664.0	670.4	11.9
2005-03-18	BITS	ETF	12.04	13.8	11.48	13.8	43534.0
2005-03-18	BKF	ETF	39.75	39.75	39.15	39.4	36000.0
2005-03-18	BNE	ETF	15.18	15.3	15.06	15.25	257300.0
2005-03-18	BRF	ETF	15.61	15.61	15.55	15.55	4600.0
2005-03-18	BTF	ETF	89.25	89.25	88.64999999999999	89.0	1820.0
2005-03-18	CBON	ETF	26.75	27.11	26.75	26.75	7996.0
2005-03-18	CDC	ETF	7.85	7.9	7.85	7.9	1300.0
2005-03-18	CDL	ETF	14.08	14.14	13.85	13.86	94600.0
2005-03-18	CEF	ETF	5.58	5.66	5.55	5.63	276700.0
2005-03-18	CEW	ETF	26.66	26.69	26.66	26.68	1300.0
2005-03-18	CGW	ETF	30.0	30.0	30.0	30.0	3000.0
2005-03-18	CHB	ETF	9.74	9.74	9.42	9.58	802200.0
2005-03-18	CHIC	ETF	12.04	12.04	11.66	11.79	254154.0
2005-03-18	CHIR	ETF	35.79	36.4899	35.55	35.7801	5861034.0
2005-03-18	CID	ETF	9.4	9.4	9.4	9.4	600.0
2005-03-18	CIZ	ETF	21.3	21.3	21.3	21.3	200.0
2005-03-18	CN	ETF	28.2	28.2	27.64	27.72	14400.0
2005-03-18	CNXT	ETF	1.58	1.6101	1.55	1.6	2997143.0
2005-03-18	CSB	ETF	33.71	33.75	33.51	33.71	7400.0
2005-03-18	CSM	ETF	2.3925	2.3925	2.3925	2.3925	2400.0
2005-03-18	CTEC	ETF	50.949999999999996	51.25	50.05	50.65	6655.200000000001
2005-03-18	CURE	ETF	0.4138	0.4213	0.4025	0.4075	810272.0
2005-03-18	CYA	ETF	166.6	166.6	160.0	160.0	385.0
2005-03-18	CYB	ETF	3.44	3.68	3.44	3.57	14500.0
2005-03-18	CZA	ETF	10.45	10.45	10.41	10.41	1000.0
2005-03-18	DGT	ETF	64.28	64.69	63.5	64.47	14700.0
2005-03-18	DIG	ETF	13.0	13.0125	13.0	13.0125	160.0
2005-03-18	DIV	ETF	13.15	13.19	13.0	13.13	30300.0
2005-03-18	DRIV	ETF	34.0	34.12	31.23	31.48	2371562.0
2005-03-18	DUSA	ETF	10.1	10.13	9.87	9.96	193242.0
2005-03-18	DVY	ETF	61.0	61.0	60.22	60.65	356200.0
2005-03-18	EDEN	ETF	0.79	0.821	0.72	0.81	28351.0
2005-03-18	EDV	ETF	25.99	26.0	25.81	26.0	20100.0
2005-03-18	EEM	ETF	23.5556	23.5556	23.2233	23.2944	3633300.0

> showing 50 of 262 rows — these rows as CSV

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