PREVIEW / etf_daily / 2005-04-19

all etf daily files

  file:    by_date/etf_daily/2005/2005-04-19.parquet
  size:    14 KB
  rows:    260

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-04-19	SPY	ETF	115.1	115.53	114.83	115.41	64930100.0
2005-04-19	QQQ	ETF	35.02	35.1	34.75	34.99	97511449.0
2005-04-19	IWM	ETF	58.555	59.17	58.48	59.15	32092800.0
2005-04-19	DIA	ETF	101.01	101.5	100.8	101.25	7633400.0
2005-04-19	GLD	ETF	42.79	43.36	42.72	43.28	3145400.0
2005-04-19	TLT	ETF	91.34	92.04	91.32	91.9	1733600.0
2005-04-19	AAA	ETF	66.63	67.18	66.57	67.16	4600.0
2005-04-19	ADRE	ETF	80.75	82.38	80.75	82.38	1748.0
2005-04-19	AFK	ETF	25.63	25.9	25.63	25.9	7600.0
2005-04-19	AGG	ETF	101.87	102.2	101.71	102.07	100600.0
2005-04-19	AIQ	ETF	48.2	50.5	47.4	48.65	28640.0
2005-04-19	ARB	ETF	42.5	42.6	42.15	42.27	276600.0
2005-04-19	BAB	ETF	48.24	48.49	48.1	48.37	15200.0
2005-04-19	BBH	ETF	51.0	51.5333	50.9667	51.2667	3503400.0
2005-04-19	BCM	ETF	58.65	59.11	58.65	59.11	6300.0
2005-04-19	BIS	ETF	580.8	624.0	580.8	616.0	21.25
2005-04-19	BITS	ETF	11.24	11.92	10.92	11.68	7580.0
2005-04-19	BKF	ETF	37.75	37.75	37.3	37.42	8700.0
2005-04-19	BNE	ETF	14.21	14.41	14.17	14.26	300600.0
2005-04-19	BRF	ETF	15.44	15.44	15.37	15.41	4600.0
2005-04-19	BTF	ETF	85.5	86.89999999999999	85.5	86.89999999999999	1420.0
2005-04-19	CBON	ETF	25.15	25.5	24.96	24.96	4061.0
2005-04-19	CDC	ETF	7.95	8.06	7.9	8.06	1500.0
2005-04-19	CDL	ETF	13.3	13.3	13.12	13.17	175700.0
2005-04-19	CEF	ETF	5.34	5.44	5.3	5.42	311400.0
2005-04-19	CEW	ETF	26.41	26.41	26.41	26.41	700.0
2005-04-19	CHB	ETF	8.4	8.48	8.34	8.4	576600.0
2005-04-19	CHIC	ETF	11.45	11.53	11.3	11.38	240367.0
2005-04-19	CHIR	ETF	35.52	35.7201	34.2201	34.7799	1856407.0
2005-04-19	CID	ETF	9.9	9.9	9.55	9.55	1200.0
2005-04-19	CIL	ETF	26.05	26.05	26.05	26.05	200.0
2005-04-19	CIZ	ETF	20.4	20.4	20.4	20.4	1400.0
2005-04-19	CN	ETF	25.8	25.98	25.8	25.9	4700.0
2005-04-19	CNXT	ETF	1.245	1.3	1.22	1.29	5433938.0
2005-04-19	CPI	ETF	18.6	18.6	18.6	18.6	500.0
2005-04-19	CSB	ETF	32.56	33.0	32.56	32.89	3900.0
2005-04-19	CTEC	ETF	51.65	57.5	51.65	57.449999999999996	7786.400000000001
2005-04-19	CURE	ETF	0.3225	0.3275	0.3225	0.325	466888.0
2005-04-19	CYA	ETF	162.0	162.6	160.6	162.2	515.0
2005-04-19	CYB	ETF	4.25	4.34	4.25	4.28	3200.0
2005-04-19	DGT	ETF	62.6	62.83	62.6	62.83	1400.0
2005-04-19	DIG	ETF	11.5625	11.7125	11.5625	11.7	2800.0
2005-04-19	DIV	ETF	12.99	13.1	12.93	13.07	27100.0
2005-04-19	DJP	ETF	27.11	27.11	27.11	27.11	2000.0
2005-04-19	DRIV	ETF	28.75	29.58	28.75	29.07	635756.0
2005-04-19	DSI	ETF	5.87	5.87	5.865	5.865	24800.0
2005-04-19	DUSA	ETF	9.0	9.8	9.0	9.73	153063.0
2005-04-19	DVY	ETF	58.94	59.05	58.64	59.0	655600.0
2005-04-19	EDEN	ETF	0.59	0.7	0.53	0.606	55923.0
2005-04-19	EDV	ETF	25.84	26.06	25.78	25.89	10400.0

> showing 50 of 260 rows — these rows as CSV

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