PREVIEW / etf_daily / 2005-05-18

all etf daily files

  file:    by_date/etf_daily/2005/2005-05-18.parquet
  size:    15 KB
  rows:    261

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-05-18	SPY	ETF	118.09	119.08	118.01	118.79	77944900.0
2005-05-18	QQQ	ETF	36.8	37.36	36.71	37.2	128146759.0
2005-05-18	IWM	ETF	59.62	60.56	59.605	60.525	36759800.0
2005-05-18	DIA	ETF	103.92	105.06	103.86	104.84	8503700.0
2005-05-18	GLD	ETF	41.99	42.11	41.83	42.05	2207100.0
2005-05-18	TLT	ETF	93.7	93.8	93.34	93.57	1092300.0
2005-05-18	AAA	ETF	59.25	59.92	59.19	59.92	7300.0
2005-05-18	ADRE	ETF	84.4	85.61	84.38	85.589	5668.0
2005-05-18	AFK	ETF	26.44	26.44	26.28	26.36	1100.0
2005-05-18	AGG	ETF	102.4	102.55	102.24	102.5	330800.0
2005-05-18	AIQ	ETF	51.5	53.35	51.5	52.75	57200.0
2005-05-18	ARB	ETF	40.05	40.96	39.98	40.96	388400.0
2005-05-18	BAB	ETF	49.63	50.4	49.58	50.37	19500.0
2005-05-18	BBH	ETF	54.4667	54.7533	54.1433	54.3833	2218500.0
2005-05-18	BCM	ETF	59.14	59.56	59.14	59.44	16500.0
2005-05-18	BIS	ETF	638.4	652.8	624.0	640.0	36.9
2005-05-18	BITS	ETF	10.8	10.8	10.24	10.4	1725.0
2005-05-18	BKF	ETF	32.05	33.17	32.01	33.0	42800.0
2005-05-18	BNE	ETF	12.36	12.66	12.36	12.43	276400.0
2005-05-18	BRF	ETF	15.35	15.36	15.33	15.33	14700.0
2005-05-18	BTF	ETF	83.8	84.49999999999999	83.8	84.45	3780.0
2005-05-18	CBON	ETF	27.07	27.07	26.89	27.06	4650.0
2005-05-18	CDC	ETF	6.83	7.3	6.82	7.3	4100.0
2005-05-18	CDL	ETF	11.61	11.68	11.57	11.62	221600.0
2005-05-18	CEF	ETF	5.15	5.2	5.14	5.16	722400.0
2005-05-18	CEW	ETF	26.6	26.61	26.6	26.61	3500.0
2005-05-18	CGW	ETF	27.25	27.64	27.25	27.64	1000.0
2005-05-18	CHB	ETF	9.64	10.13	9.64	10.12	930700.0
2005-05-18	CHIC	ETF	10.6	10.82	10.6	10.77	175722.0
2005-05-18	CHIR	ETF	35.7399	36.5301	35.49	36.2901	1022549.0
2005-05-18	CIL	ETF	26.42	26.42	26.25	26.35	1100.0
2005-05-18	CIZ	ETF	21.05	21.05	21.05	21.05	1200.0
2005-05-18	CN	ETF	27.08	27.13	26.67	27.1	20700.0
2005-05-18	CNXT	ETF	1.2	1.24	1.18	1.19	5077343.0
2005-05-18	CPI	ETF	22.68	22.68	22.68	22.68	2300.0
2005-05-18	CSB	ETF	30.27	30.44	30.27	30.43	9400.0
2005-05-18	CTEC	ETF	49.74999999999999	50.8	48.15	49.0	22877.2
2005-05-18	CURE	ETF	0.26	0.2712	0.2545	0.2612	561360.0
2005-05-18	CYA	ETF	137.8	150.0	137.8	144.0	600.0
2005-05-18	CYB	ETF	3.2	3.21	3.12	3.17	3800.0
2005-05-18	CZA	ETF	10.23	10.25	10.21	10.24	22800.0
2005-05-18	DGT	ETF	63.3	63.82	63.3	63.73	8600.0
2005-05-18	DIG	ETF	10.6875	10.7125	10.6875	10.7125	2560.0
2005-05-18	DIV	ETF	13.21	13.29	13.2	13.26	11100.0
2005-05-18	DRIV	ETF	23.75	25.2	23.51	25.19	1979905.0
2005-05-18	DSI	ETF	6.02	6.04	5.99	5.99	22000.0
2005-05-18	DUSA	ETF	10.4	10.93	10.28	10.93	65325.0
2005-05-18	DVY	ETF	60.99	61.24	60.87	61.16	673000.0
2005-05-18	EDEN	ETF	0.7	0.77	0.66	0.759	73793.0
2005-05-18	EDV	ETF	26.33	26.37	26.23	26.23	12200.0

> showing 50 of 261 rows — these rows as CSV

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