PREVIEW / etf_daily / 2005-06-20

all etf daily files

  file:    by_date/etf_daily/2005/2005-06-20.parquet
  size:    15 KB
  rows:    267

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-06-20	SPY	ETF	121.08	121.84	120.94	121.4	41019400.0
2005-06-20	QQQ	ETF	37.72	38.08	37.58	37.87	68165272.0
2005-06-20	IWM	ETF	63.72	64.01	63.56	63.68	17148400.0
2005-06-20	DIA	ETF	105.68	106.27	105.54	105.96	3709900.0
2005-06-20	GLD	ETF	43.94	43.94	43.66	43.66	1433700.0
2005-06-20	TLT	ETF	93.82	94.2	93.6	94.17	453000.0
2005-06-20	AAA	ETF	57.68	57.99	57.55	57.55	1500.0
2005-06-20	ADRE	ETF	94.0	94.0	90.54	91.869	5384.0
2005-06-20	AFK	ETF	25.95	26.09	25.91	26.09	4100.0
2005-06-20	AGG	ETF	102.51	102.6	102.31	102.4	72300.0
2005-06-20	AIQ	ETF	51.6	53.0	51.15	52.75	13660.0
2005-06-20	AIS	ETF	1.09	1.15	0.98	0.98	223300.0
2005-06-20	ARB	ETF	43.9	44.02	43.63	43.69	187800.0
2005-06-20	BAB	ETF	49.65	49.97	49.46	49.77	21300.0
2005-06-20	BBH	ETF	56.9833	57.6233	56.9167	57.2733	1086300.0
2005-06-20	BCM	ETF	61.21	61.46	61.21	61.46	5500.0
2005-06-20	BIS	ETF	630.4	630.4	598.4	598.4	18.75
2005-06-20	BITS	ETF	13.0	13.0	12.64	12.64	5254.0
2005-06-20	BKF	ETF	39.15	39.39	38.9	38.91	42800.0
2005-06-20	BNE	ETF	13.89	13.99	13.82	13.87	59700.0
2005-06-20	BRF	ETF	15.5	15.5	15.45	15.45	4700.0
2005-06-20	BTF	ETF	86.4	86.69999999999999	86.05	86.69999999999999	1460.0
2005-06-20	CBON	ETF	31.25	31.55	30.73	31.46	31015.0
2005-06-20	CDC	ETF	7.2	7.2	6.95	6.95	3900.0
2005-06-20	CDL	ETF	11.97	12.2	11.93	12.05	400600.0
2005-06-20	CEF	ETF	5.35	5.43	5.31	5.35	560500.0
2005-06-20	CEW	ETF	26.75	26.75	26.55	26.55	800.0
2005-06-20	CGW	ETF	28.15	28.15	28.15	28.15	100.0
2005-06-20	CHB	ETF	10.5	10.5	9.95	10.0	336200.0
2005-06-20	CHI	ETF	19.53	19.69	19.51	19.6	72600.0
2005-06-20	CHIC	ETF	12.3	12.46	11.9	12.46	112507.0
2005-06-20	CHIR	ETF	35.9901	36.1899	35.7201	35.8899	759156.0
2005-06-20	CHY	ETF	16.17	16.25	16.13	16.23	163400.0
2005-06-20	CIL	ETF	25.7	25.7	25.7	25.7	600.0
2005-06-20	CN	ETF	27.5	27.98	27.5	27.81	48900.0
2005-06-20	CNXT	ETF	1.53	1.55	1.5	1.53	2456415.0
2005-06-20	CPI	ETF	24.01	24.01	24.01	24.01	900.0
2005-06-20	CPST	ETF	1.27	1.39	1.25	1.36	2076049.0
2005-06-20	CSB	ETF	30.39	30.39	30.28	30.39	7100.0
2005-06-20	CSQ	ETF	13.87	13.92	13.82	13.89	307000.0
2005-06-20	CTEC	ETF	50.0	50.49999999999999	49.55	50.199999999999996	5448.8
2005-06-20	CURE	ETF	0.2487	0.2525	0.2375	0.25	887048.0
2005-06-20	CYA	ETF	145.0	147.0	136.0	139.0	520.0
2005-06-20	CYB	ETF	3.15	3.3	3.15	3.28	35500.0
2005-06-20	DGT	ETF	64.29	64.46	64.09	64.27	13900.0
2005-06-20	DIG	ETF	12.6875	12.6875	12.5625	12.5625	1600.0
2005-06-20	DIV	ETF	13.79	13.88	13.75	13.77	21800.0
2005-06-20	DRIV	ETF	29.33	29.66	28.98	29.41	457902.0
2005-06-20	DSI	ETF	5.98	5.98	5.98	5.98	10000.0
2005-06-20	DUSA	ETF	9.98	10.02	9.62	9.85	107065.0

> showing 50 of 267 rows — these rows as CSV

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