PREVIEW / etf_daily / 2007-10-22

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-22.parquet
  size:    24 KB
  rows:    521

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-22	SPY	ETF	148.86	150.76	148.66	150.54	261989800.0
2007-10-22	QQQ	ETF	52.16	53.1185	52.02	53.07	207086958.0
2007-10-22	IWM	ETF	78.54	80.94	78.35	80.76	138153000.0
2007-10-22	DIA	ETF	134.06	135.76	133.92	135.45	16391200.0
2007-10-22	GLD	ETF	74.09	74.77	73.84	74.6	8636500.0
2007-10-22	TLT	ETF	90.58	90.65	90.07	90.47	1866500.0
2007-10-22	ADRE	ETF	53.64	55.03	53.11	55.03	419650.0
2007-10-22	AGG	ETF	100.81	100.81	100.5	100.7	284500.0
2007-10-22	AIQ	ETF	45.25	47.3	45.1	46.4	39100.0
2007-10-22	AIS	ETF	1.29	1.3199	1.26	1.29	113200.0
2007-10-22	AIVI	ETF	72.5	73.23	72.3	73.23	45500.0
2007-10-22	ARB	ETF	47.3	50.29	47.24	49.76	748700.0
2007-10-22	BBH	ETF	58.9233	59.92	58.9033	59.4933	291000.0
2007-10-22	BIL	ETF	91.78	91.82	91.72	91.8	185050.0
2007-10-22	BITS	ETF	25.44	25.44	24.8	25.04	5989.0
2007-10-22	BIV	ETF	76.44	76.44	76.19	76.32	18800.0
2007-10-22	BLV	ETF	76.32	76.33	75.99	76.29	2800.0
2007-10-22	BMVP	ETF	16.95	17.2613	16.95	17.2367	68300.0
2007-10-22	BND	ETF	76.2	76.27	76.13	76.24	90200.0
2007-10-22	BNE	ETF	16.57	17.16	16.56	17.05	135600.0
2007-10-22	BRF	ETF	14.6	14.6	14.6	14.6	1600.0
2007-10-22	BSV	ETF	76.42	76.42	76.28	76.3	23800.0
2007-10-22	BTF	ETF	113.0	116.35	112.94999999999999	114.35	3600.0
2007-10-22	BWX	ETF	26.255	26.255	26.125	26.165	70200.0
2007-10-22	CBON	ETF	19.5	21.05	19.5	20.21	260788.0
2007-10-22	CDL	ETF	4.15	4.5	4.15	4.44	2663400.0
2007-10-22	CEF	ETF	9.8	9.95	9.73	9.93	453300.0
2007-10-22	CGO	ETF	18.5	18.5899	18.15	18.48	21700.0
2007-10-22	CGW	ETF	25.5	25.69	25.36	25.69	90300.0
2007-10-22	CHB	ETF	12.4	13.17	12.26	12.84	2554580.0
2007-10-22	CHI	ETF	16.77	16.915	16.76	16.77	97800.0
2007-10-22	CHIC	ETF	13.93	14.42	13.72	14.25	596361.0
2007-10-22	CHW	ETF	13.14	13.46	13.01	13.31	228800.0
2007-10-22	CHY	ETF	14.91	15.05	14.75	14.76	175100.0
2007-10-22	CMF	ETF	52.125	52.125	52.05	52.055	23600.0
2007-10-22	CN	ETF	62.55	63.16	60.06	63.03	642300.0
2007-10-22	CNXT	ETF	1.32	1.35	1.3	1.32	7378688.0
2007-10-22	CPI	ETF	24.1	24.1	23.05	23.5	1900.0
2007-10-22	CPST	ETF	1.05	1.07	1.04	1.07	1205993.0
2007-10-22	CSA	ETF	17.67	17.68	17.01	17.53	72600.0
2007-10-22	CSD	ETF	28.22	28.68	28.17	28.4	25300.0
2007-10-22	CSQ	ETF	14.44	14.73	14.32	14.68	240300.0
2007-10-22	CVY	ETF	25.27	25.55	25.11	25.48	19900.0
2007-10-22	CWI	ETF	28.2333	28.42	28.1533	28.42	44700.0
2007-10-22	CZA	ETF	26.44	26.56	26.38	26.55	3600.0
2007-10-22	DBA	ETF	29.0	29.42	28.85	29.42	384500.0
2007-10-22	DBB	ETF	25.66	25.98	25.53	25.81	33100.0
2007-10-22	DBC	ETF	28.65	28.92	28.4701	28.83	293700.0
2007-10-22	DBE	ETF	31.75	32.0	31.58	31.83	48200.0
2007-10-22	DBO	ETF	31.08	31.32	30.71	31.2	32400.0

> showing 50 of 521 rows — these rows as CSV

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