PREVIEW / etf_daily / 2005-07-18

all etf daily files

  file:    by_date/etf_daily/2005/2005-07-18.parquet
  size:    15 KB
  rows:    272

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-07-18	SPY	ETF	122.5	122.63	122.05	122.35	56598400.0
2005-07-18	QQQ	ETF	38.77	38.89	38.688	38.733	59117177.0
2005-07-18	IWM	ETF	65.91	66.08	65.37	65.62	14741300.0
2005-07-18	DIA	ETF	106.05	106.25	105.66	105.92	6084600.0
2005-07-18	GLD	ETF	41.96	42.17	41.94	42.01	956400.0
2005-07-18	TLT	ETF	93.85	93.97	93.1	93.27	1204500.0
2005-07-18	AAA	ETF	50.63	50.83	50.51	50.67	3100.0
2005-07-18	ADRE	ETF	94.6	94.6	93.2	93.34	2900.0
2005-07-18	AFK	ETF	25.82	25.92	25.77	25.77	16900.0
2005-07-18	AGG	ETF	102.24	102.28	102.04	102.11	74300.0
2005-07-18	AIQ	ETF	55.5	55.6	54.95	55.05	19660.0
2005-07-18	AIS	ETF	1.15	1.15	1.01	1.04	163800.0
2005-07-18	ARB	ETF	43.17	43.48	42.83	43.04	120600.0
2005-07-18	BAB	ETF	48.5	48.56	48.19	48.5	22400.0
2005-07-18	BBH	ETF	61.7833	61.9733	61.37	61.6333	2087100.0
2005-07-18	BCM	ETF	63.13	63.85	63.13	63.65	15600.0
2005-07-18	BIS	ETF	664.0	664.0	662.4	664.0	35.6
2005-07-18	BITS	ETF	13.84	14.16	13.72	14.0	6008.0
2005-07-18	BKF	ETF	35.05	35.41	35.05	35.28	17600.0
2005-07-18	BNE	ETF	14.26	14.26	13.8	13.92	127000.0
2005-07-18	BRF	ETF	15.43	15.49	15.4	15.4	2400.0
2005-07-18	BTF	ETF	87.75	87.75	86.25	86.8	4100.0
2005-07-18	CBON	ETF	31.59	32.35	31.59	32.23	11253.0
2005-07-18	CDC	ETF	6.86	7.0	6.81	6.9	3200.0
2005-07-18	CDL	ETF	11.35	11.46	11.17	11.27	467900.0
2005-07-18	CEF	ETF	5.2	5.23	5.16	5.18	221500.0
2005-07-18	CEW	ETF	26.55	26.75	26.55	26.75	2500.0
2005-07-18	CHB	ETF	10.5	10.52	10.2	10.29	128200.0
2005-07-18	CHI	ETF	19.84	19.9	19.76	19.85	58400.0
2005-07-18	CHIC	ETF	13.87	13.95	13.77	13.94	157484.0
2005-07-18	CHIR	ETF	36.0	36.45	35.724	36.0	954703.0
2005-07-18	CHY	ETF	16.58	16.64	16.45	16.49	179700.0
2005-07-18	CIL	ETF	25.72	25.76	25.72	25.74	600.0
2005-07-18	CN	ETF	30.51	30.51	30.05	30.19	27700.0
2005-07-18	CNXT	ETF	1.91	1.93	1.87	1.89	4351509.0
2005-07-18	CPI	ETF	23.8	23.8	23.6	23.7	1300.0
2005-07-18	CPST	ETF	1.9	1.9	1.8	1.84	841989.0
2005-07-18	CSB	ETF	29.43	29.66	29.4	29.63	24800.0
2005-07-18	CSM	ETF	2.4196	2.4196	2.415	2.415	2000.0
2005-07-18	CSQ	ETF	14.25	14.29	14.17	14.25	338800.0
2005-07-18	CTEC	ETF	52.75	54.199999999999996	51.39999999999999	53.05	5049.6
2005-07-18	CURE	ETF	0.3362	0.3375	0.3237	0.3287	331792.0
2005-07-18	CYA	ETF	140.8	140.8	138.2	138.2	265.0
2005-07-18	CYB	ETF	2.99	2.99	2.8	2.91	10000.0
2005-07-18	DGT	ETF	64.14	64.34	64.14	64.32	2600.0
2005-07-18	DIV	ETF	13.85	13.91	13.85	13.86	7800.0
2005-07-18	DRIV	ETF	35.88	36.22	35.01	35.15	452410.0
2005-07-18	DUSA	ETF	9.11	9.13	8.5	8.56	394531.0
2005-07-18	DVY	ETF	63.38	63.4	63.15	63.25	364800.0
2005-07-18	EDEN	ETF	0.9	0.92	0.84	0.87	50388.0

> showing 50 of 272 rows — these rows as CSV

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