PREVIEW / etf_daily / 2005-01-27

all etf daily files

  file:    by_date/etf_daily/2005/2005-01-27.parquet
  size:    14 KB
  rows:    251

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-01-27	SPY	ETF	117.19	117.75	116.98	117.43	55878800.0
2005-01-27	QQQ	ETF	37.07	37.27	36.87	37.1	109788764.0
2005-01-27	IWM	ETF	61.19	61.865	61.075	61.45	20795400.0
2005-01-27	DIA	ETF	104.45	104.83	104.21	104.57	8393800.0
2005-01-27	GLD	ETF	42.48	42.65	42.4	42.62	571200.0
2005-01-27	TLT	ETF	90.52	90.7	90.34	90.54	463900.0
2005-01-27	AAA	ETF	58.47	58.9	58.47	58.9	2100.0
2005-01-27	ADRE	ETF	80.97	81.07	80.76	81.03	2400.0
2005-01-27	AFK	ETF	26.41	26.5	26.4	26.5	5400.0
2005-01-27	AGG	ETF	102.69	102.71	102.54	102.68	83900.0
2005-01-27	AIQ	ETF	66.25	66.25	64.9	64.95	19800.0
2005-01-27	ARB	ETF	40.9	41.53	40.02	40.25	333900.0
2005-01-27	BAB	ETF	48.68	48.9	48.38	48.66	28500.0
2005-01-27	BBH	ETF	47.6733	48.5667	47.5867	47.9167	1948800.0
2005-01-27	BCM	ETF	55.81	55.81	55.33	55.65	27800.0
2005-01-27	BIS	ETF	936.0	936.0	936.0	936.0	6.25
2005-01-27	BITS	ETF	9.32	9.56	8.52	8.68	24319.0
2005-01-27	BKF	ETF	37.02	37.02	36.75	36.9	4300.0
2005-01-27	BNE	ETF	14.25	14.49	14.25	14.43	69000.0
2005-01-27	BRF	ETF	15.61	15.7	15.61	15.68	6400.0
2005-01-27	BTF	ETF	90.19999999999999	90.6	90.19999999999999	90.6	460.0
2005-01-27	CBON	ETF	27.55	27.8	27.45	27.69	62685.0
2005-01-27	CDC	ETF	9.44	9.55	9.44	9.45	15600.0
2005-01-27	CDL	ETF	14.05	14.13	13.9	13.94	582600.0
2005-01-27	CEF	ETF	5.34	5.34	5.24	5.27	175900.0
2005-01-27	CEW	ETF	27.45	27.5	27.45	27.5	200.0
2005-01-27	CGW	ETF	27.2	27.2	27.2	27.2	200.0
2005-01-27	CHB	ETF	10.75	10.83	10.49	10.67	243600.0
2005-01-27	CHIC	ETF	10.19	10.55	10.06	10.5	664200.0
2005-01-27	CHIR	ETF	32.7	34.4499	32.3001	33.57	4073517.0
2005-01-27	CID	ETF	8.93	9.02	8.93	9.0	17000.0
2005-01-27	CIL	ETF	26.16	26.17	26.16	26.17	1200.0
2005-01-27	CN	ETF	27.81	27.85	27.65	27.83	183800.0
2005-01-27	CNXT	ETF	1.59	1.6702	1.56	1.64	10712065.0
2005-01-27	CSB	ETF	35.84	36.0	35.83	35.84	800.0
2005-01-27	CTEC	ETF	57.15	61.55	56.74999999999999	61.55	60751.4
2005-01-27	CURE	ETF	0.6012	0.625	0.6012	0.6112	1218840.0
2005-01-27	CYA	ETF	188.0	189.8	186.2	187.0	445.0
2005-01-27	CYB	ETF	4.13	4.17	4.1	4.1	1100.0
2005-01-27	CZA	ETF	10.45	10.45	10.45	10.45	100.0
2005-01-27	DGT	ETF	62.96	63.1	62.83	63.02	3000.0
2005-01-27	DIG	ETF	12.0625	12.0625	12.0625	12.0625	80.0
2005-01-27	DIV	ETF	14.16	14.23	14.16	14.19	7700.0
2005-01-27	DRIV	ETF	39.4	40.17	38.27	39.19	5006749.0
2005-01-27	DSI	ETF	5.91	5.915	5.895	5.905	10200.0
2005-01-27	DTH	ETF	25.3	25.38	25.3	25.38	1600.0
2005-01-27	DUSA	ETF	13.47	13.72	13.16	13.46	113832.0
2005-01-27	DVY	ETF	59.3	59.49	59.01	59.21	448100.0
2005-01-27	EDEN	ETF	1.19	1.229	1.19	1.191	46213.0
2005-01-27	EDV	ETF	26.58	26.58	26.45	26.45	11100.0

> showing 50 of 251 rows — these rows as CSV

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