PREVIEW / etf_daily / 2007-10-17

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-17.parquet
  size:    23 KB
  rows:    512

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
2007-10-17	SPY	ETF	154.98	155.09	152.47	154.25	216687300.0
2007-10-17	QQQ	ETF	53.62	53.66	52.68	53.55	183985125.0
2007-10-17	IWM	ETF	82.8	82.92	81.06	82.22	90253500.0
2007-10-17	DIA	ETF	140.11	140.18	137.74	139.16	20261500.0
2007-10-17	GLD	ETF	75.31	75.66	74.31	74.5	9355300.0
2007-10-17	TLT	ETF	87.77	88.95	87.77	88.64	2377000.0
2007-10-17	ADRE	ETF	57.18	57.571	56.21	57.5	262563.0
2007-10-17	AGG	ETF	99.66	100.03	99.62	99.98	243600.0
2007-10-17	AIQ	ETF	46.7	47.2	45.6	45.95	70780.0
2007-10-17	AIS	ETF	1.4	1.42	1.34	1.38	219100.0
2007-10-17	AIVI	ETF	74.97	75.0	74.18	74.77	27400.0
2007-10-17	ARB	ETF	45.0	45.0	44.34	44.79	341500.0
2007-10-17	BBH	ETF	59.7667	60.0267	59.0167	59.6267	383400.0
2007-10-17	BIL	ETF	91.72	91.76	91.68	91.76	59350.0
2007-10-17	BITS	ETF	26.16	26.48	26.12	26.12	2562.0
2007-10-17	BIV	ETF	75.47	75.91	75.47	75.87	92900.0
2007-10-17	BLV	ETF	74.69	75.37	74.59	75.26	89500.0
2007-10-17	BMVP	ETF	17.5767	17.5767	17.3067	17.4633	107500.0
2007-10-17	BND	ETF	75.53	75.83	75.45	75.83	90200.0
2007-10-17	BNE	ETF	17.91	17.94	17.57	17.81	193100.0
2007-10-17	BRF	ETF	14.6	14.6	14.6	14.6	12500.0
2007-10-17	BSV	ETF	75.81	76.11	75.81	76.09	61900.0
2007-10-17	BTF	ETF	110.55	111.1	110.05	111.1	120.0
2007-10-17	BWX	ETF	25.94	25.98	25.9332	25.975	88800.0
2007-10-17	CBON	ETF	23.55	23.82	21.87	22.48	119095.0
2007-10-17	CDL	ETF	4.32	4.32	4.17	4.23	3373700.0
2007-10-17	CEF	ETF	10.05	10.08	9.91	9.95	314400.0
2007-10-17	CGO	ETF	18.72	18.79	18.55	18.75	24600.0
2007-10-17	CGW	ETF	26.0	26.45	26.0	26.22	62600.0
2007-10-17	CHB	ETF	13.18	14.59	12.87	13.47	5072200.0
2007-10-17	CHI	ETF	16.91	17.02	16.76	16.85	200400.0
2007-10-17	CHIC	ETF	15.24	15.4985	14.64	14.8	667444.0
2007-10-17	CHW	ETF	13.3	13.5	13.26	13.26	128450.0
2007-10-17	CHY	ETF	15.1	15.2	14.75	14.95	180200.0
2007-10-17	CMF	ETF	51.7	51.875	51.7	51.845	5000.0
2007-10-17	CN	ETF	65.25	68.97	64.53	67.7	684400.0
2007-10-17	CNXT	ETF	1.46	1.47	1.44	1.45	4001304.0
2007-10-17	CPI	ETF	24.7	24.7	24.7	24.7	300.0
2007-10-17	CPST	ETF	1.08	1.09	1.02	1.03	3499435.0
2007-10-17	CSA	ETF	17.81	17.96	16.8	17.67	73800.0
2007-10-17	CSD	ETF	29.46	29.47	29.01	29.22	25200.0
2007-10-17	CSQ	ETF	14.88	14.89	14.72	14.89	315200.0
2007-10-17	CVY	ETF	26.18	26.18	25.76	25.94	10800.0
2007-10-17	CWI	ETF	29.08	29.1333	28.8133	28.9867	125100.0
2007-10-17	CZA	ETF	27.1	27.1	26.88	26.91	2100.0
2007-10-17	DBA	ETF	28.99	29.12	28.7	28.93	540300.0
2007-10-17	DBB	ETF	26.2	26.27	25.85	26.01	29300.0
2007-10-17	DBC	ETF	28.68	28.68	28.38	28.48	254100.0
2007-10-17	DBE	ETF	32.0	32.2	31.7	31.8	19400.0
2007-10-17	DBO	ETF	31.04	31.32	30.77	30.87	7900.0

> showing 50 of 512 rows — these rows as CSV

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