PREVIEW / etf_daily / 2005-01-04

all etf daily files

  file:    by_date/etf_daily/2005/2005-01-04.parquet
  size:    14 KB
  rows:    255

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-04	SPY	ETF	120.46	120.54	118.44	118.83	69167600.0
2005-01-04	QQQ	ETF	39.69	39.74	38.55	38.78	136759292.0
2005-01-04	IWM	ETF	64.035	64.085	62.43	62.54	27450000.0
2005-01-04	DIA	ETF	107.5	107.6	105.89	106.3	10628300.0
2005-01-04	GLD	ETF	42.8	42.91	42.46	42.74	3456800.0
2005-01-04	TLT	ETF	88.72	88.75	87.81	87.81	1935400.0
2005-01-04	AAA	ETF	62.21	62.21	61.77	61.8	2100.0
2005-01-04	ADRE	ETF	85.95	85.95	80.38	80.38	13016.0
2005-01-04	AFK	ETF	26.58	26.58	26.44	26.47	5700.0
2005-01-04	AGG	ETF	102.46	102.5	102.07	102.3	190500.0
2005-01-04	AIQ	ETF	64.75	66.0	61.5	62.4	177140.0
2005-01-04	ARB	ETF	38.9	39.03	37.93	38.0	211900.0
2005-01-04	BAB	ETF	44.55	44.72	43.94	43.94	43400.0
2005-01-04	BBH	ETF	50.34	50.5	49.1833	49.7333	3121800.0
2005-01-04	BCM	ETF	59.62	59.62	58.99	59.12	26800.0
2005-01-04	BIS	ETF	968.0	968.0	928.0	940.8	96.0
2005-01-04	BITS	ETF	11.48	11.52	10.08	10.44	20640.0
2005-01-04	BKF	ETF	37.6	37.75	36.85	36.89	46600.0
2005-01-04	BNE	ETF	15.98	15.98	15.53	15.55	532600.0
2005-01-04	BRF	ETF	15.86	16.04	15.86	16.04	8400.0
2005-01-04	BTF	ETF	92.94999999999999	92.94999999999999	91.5	91.95	1940.0
2005-01-04	CBON	ETF	29.8	30.1	29.8	29.92	11601.0
2005-01-04	CDC	ETF	12.4	12.4	12.28	12.31	6900.0
2005-01-04	CDL	ETF	15.52	15.56	15.2	15.3	654700.0
2005-01-04	CEF	ETF	5.32	5.35	5.26	5.31	441200.0
2005-01-04	CEW	ETF	27.16	27.35	27.16	27.35	1200.0
2005-01-04	CHB	ETF	12.05	12.25	11.9	12.03	899200.0
2005-01-04	CHIC	ETF	10.11	10.43	9.94	10.32	625993.0
2005-01-04	CHIR	ETF	33.9399	34.8999	33.93	34.68	5372308.0
2005-01-04	CID	ETF	9.61	9.61	9.53	9.53	1500.0
2005-01-04	CIL	ETF	26.3	26.3	26.3	26.3	200.0
2005-01-04	CIZ	ETF	20.5	20.9	20.5	20.9	4100.0
2005-01-04	CN	ETF	26.2	26.25	25.94	26.15	102400.0
2005-01-04	CNXT	ETF	1.95	1.98	1.81	1.84	10871768.0
2005-01-04	CSB	ETF	37.46	37.47	37.0	37.14	7000.0
2005-01-04	CSM	ETF	2.375	2.375	2.3725	2.3725	1600.0
2005-01-04	CTEC	ETF	42.099999999999994	42.099999999999994	39.849999999999994	40.294999999999995	9086.0
2005-01-04	CURE	ETF	0.8337	0.9	0.7675	0.8751	4340864.0
2005-01-04	CYA	ETF	246.2	250.0	246.0	249.6	3205.0
2005-01-04	CYB	ETF	4.05	4.09	4.05	4.09	700.0
2005-01-04	CZA	ETF	10.33	10.33	10.33	10.33	400.0
2005-01-04	DGT	ETF	64.22	64.22	63.8	63.8	5200.0
2005-01-04	DIG	ETF	12.2125	12.4375	12.2125	12.4375	1200.0
2005-01-04	DIV	ETF	14.42	14.48	14.3	14.3	41600.0
2005-01-04	DJP	ETF	26.64	26.64	26.62	26.62	2800.0
2005-01-04	DRIV	ETF	39.91	40.29	35.7	36.42	2234882.0
2005-01-04	DSI	ETF	5.995	5.995	5.94	5.94	7400.0
2005-01-04	DTH	ETF	25.18	25.27	25.17	25.26	2800.0
2005-01-04	DUSA	ETF	14.38	14.45	14.11	14.33	144357.0
2005-01-04	DVY	ETF	60.76	60.81	59.95	60.15	1715900.0

> showing 50 of 255 rows — these rows as CSV

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