PREVIEW / etf_daily / 2007-07-19

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-19.parquet
  size:    22 KB
  rows:    490

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-07-19	SPY	ETF	155.2	155.53	154.75	155.07	145212700.0
2007-07-19	QQQ	ETF	50.41	50.66	50.31	50.32	116563764.0
2007-07-19	IWM	ETF	84.75	84.95	84.47	84.51	61461700.0
2007-07-19	DIA	ETF	139.93	140.17	139.53	139.89	8731800.0
2007-07-19	GLD	ETF	66.7	67.12	66.61	67.01	4607900.0
2007-07-19	TLT	ETF	84.9	85.26	84.8	85.19	1021000.0
2007-07-19	ADRE	ETF	49.12	49.3	49.05	49.27	162072.0
2007-07-19	AGG	ETF	98.06	98.22	98.0	98.17	321200.0
2007-07-19	AIQ	ETF	53.2	53.2	50.95	51.25	26560.0
2007-07-19	AIS	ETF	1.75	1.83	1.67	1.81	766800.0
2007-07-19	ARB	ETF	52.0	54.37	51.23	54.01	677400.0
2007-07-19	BBH	ETF	56.55	56.6233	56.1767	56.4733	219000.0
2007-07-19	BIL	ETF	91.8	91.82	91.74	91.8	13900.0
2007-07-19	BITS	ETF	28.32	28.6	27.84	28.08	12966.0
2007-07-19	BIV	ETF	73.58	73.74	73.58	73.72	18700.0
2007-07-19	BLV	ETF	72.7	72.97	72.7	72.96	313900.0
2007-07-19	BMVP	ETF	18.2967	18.2967	18.2011	18.2267	28200.0
2007-07-19	BND	ETF	74.02	74.13	73.98	74.13	23500.0
2007-07-19	BNE	ETF	20.2	20.2	19.67	19.79	125900.0
2007-07-19	BRF	ETF	14.5	14.5	14.48	14.5	4400.0
2007-07-19	BSV	ETF	74.87	74.88	74.78	74.86	19200.0
2007-07-19	BTF	ETF	107.85	107.89999999999999	107.55	107.79999999999998	1220.0
2007-07-19	CBON	ETF	26.95	27.19	26.59	26.85	37447.0
2007-07-19	CDL	ETF	6.14	6.27	6.01	6.05	3937950.0
2007-07-19	CEF	ETF	9.57	9.68	9.5	9.62	505200.0
2007-07-19	CGO	ETF	18.38	18.59	18.35	18.59	15800.0
2007-07-19	CGW	ETF	26.22	26.25	26.05	26.09	250900.0
2007-07-19	CHB	ETF	11.83	12.39	11.83	12.35	3335400.0
2007-07-19	CHI	ETF	17.45	17.8	17.39	17.67	269600.0
2007-07-19	CHIC	ETF	23.52	24.12	23.52	24.0	679249.0
2007-07-19	CHY	ETF	15.3	15.52	15.23	15.32	242400.0
2007-07-19	CN	ETF	53.52	54.77	53.52	54.56	83100.0
2007-07-19	CNXT	ETF	1.46	1.48	1.43	1.44	4967071.0
2007-07-19	CPST	ETF	1.24	1.33	1.23	1.33	4492544.0
2007-07-19	CSA	ETF	18.25	19.06	18.25	19.06	25600.0
2007-07-19	CSB	ETF	32.3	32.31	31.82	31.9	16000.0
2007-07-19	CSD	ETF	31.44	31.55	31.41	31.54	26900.0
2007-07-19	CSM	ETF	1.4375	1.4375	1.4375	1.4375	800.0
2007-07-19	CSQ	ETF	15.18	15.25	15.1	15.21	268400.0
2007-07-19	CTEC	ETF	107.5	109.55	107.44999999999999	108.49999999999999	5882.200000000001
2007-07-19	CVY	ETF	27.92	27.96	27.85	27.9	25900.0
2007-07-19	CWI	ETF	28.4467	28.5267	28.4133	28.4533	35850.0
2007-07-19	CZA	ETF	27.68	27.68	27.68	27.68	100.0
2007-07-19	DBA	ETF	26.69	26.73	26.27	26.45	307500.0
2007-07-19	DBB	ETF	28.0	28.27	27.92	28.24	36700.0
2007-07-19	DBC	ETF	26.33	26.49	26.28	26.41	107600.0
2007-07-19	DBE	ETF	29.41	29.68	29.27	29.68	36600.0
2007-07-19	DBO	ETF	27.84	27.9	27.54	27.9	127600.0
2007-07-19	DBP	ETF	26.47	26.55	26.43	26.5	16100.0
2007-07-19	DBS	ETF	26.15	26.1599	26.0	26.09	3700.0

> showing 50 of 490 rows — these rows as CSV

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