PREVIEW / etf_daily / 2007-10-09

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-09.parquet
  size:    23 KB
  rows:    506

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-09	SPY	ETF	155.6	156.5	155.03	156.48	94054300.0
2007-10-09	QQQ	ETF	53.27	53.45	53.03	53.3801	94210279.0
2007-10-09	IWM	ETF	83.93	84.33	83.3	84.18	57974000.0
2007-10-09	DIA	ETF	140.67	141.65	140.3	141.57	9070400.0
2007-10-09	GLD	ETF	72.29	73.3	72.1	73.09	7416100.0
2007-10-09	TLT	ETF	88.16	88.36	87.78	88.1	901000.0
2007-10-09	ADRE	ETF	56.04	56.21	55.34	56.21	226023.0
2007-10-09	AGG	ETF	99.53	99.59	99.16	99.44	182700.0
2007-10-09	AIQ	ETF	46.5	47.6	46.05	47.35	31420.0
2007-10-09	AIS	ETF	1.32	1.3258	1.26	1.3	988500.0
2007-10-09	ARB	ETF	46.87	48.03	46.75	47.53	185900.0
2007-10-09	BBH	ETF	59.16	59.2033	58.92	59.12	246600.0
2007-10-09	BIL	ETF	91.66	91.7	91.62	91.62	364450.0
2007-10-09	BITS	ETF	26.2	26.2	25.68	26.04	5395.0
2007-10-09	BIV	ETF	75.33	75.39	75.12	75.16	24600.0
2007-10-09	BLV	ETF	74.7	74.72	74.33	74.61	34700.0
2007-10-09	BMVP	ETF	17.6333	17.7424	17.6	17.7267	54500.0
2007-10-09	BND	ETF	75.4	75.45	75.27	75.32	67200.0
2007-10-09	BNE	ETF	17.56	17.78	17.32	17.62	260500.0
2007-10-09	BRF	ETF	14.63	14.63	14.62	14.62	500.0
2007-10-09	BSV	ETF	75.8	75.85	75.7	75.72	74200.0
2007-10-09	BTF	ETF	109.85	110.0	109.49999999999999	109.55	280.0
2007-10-09	BWX	ETF	25.99	26.17	25.98	26.14	125400.0
2007-10-09	CBON	ETF	25.86	25.98	25.46	25.65	26294.0
2007-10-09	CDL	ETF	4.27	4.43	4.2	4.38	2733000.0
2007-10-09	CEF	ETF	9.81	9.89	9.77	9.89	270000.0
2007-10-09	CGO	ETF	18.08	18.27	17.99	18.22	22600.0
2007-10-09	CGW	ETF	26.28	26.34	26.1301	26.34	83600.0
2007-10-09	CHB	ETF	12.19	12.5	12.0	12.22	983900.0
2007-10-09	CHI	ETF	16.99	17.0882	16.93	17.03	158000.0
2007-10-09	CHIC	ETF	15.49	15.52	14.68	14.9	843777.0
2007-10-09	CHW	ETF	13.7	13.7	13.26	13.54	150300.0
2007-10-09	CHY	ETF	15.45	15.45	15.35	15.43	92500.0
2007-10-09	CMF	ETF	51.68	51.75	51.68	51.7	26400.0
2007-10-09	CN	ETF	61.2	61.9	60.62	61.7	340300.0
2007-10-09	CNXT	ETF	1.45	1.48	1.42	1.44	11094280.0
2007-10-09	CPST	ETF	1.14	1.16	1.12	1.16	2228538.0
2007-10-09	CSA	ETF	18.73	18.73	18.26	18.57	38000.0
2007-10-09	CSD	ETF	30.04	30.1	29.85	30.05	8000.0
2007-10-09	CSQ	ETF	14.67	14.74	14.601	14.71	257700.0
2007-10-09	CVY	ETF	26.67	26.83	26.6	26.78	262700.0
2007-10-09	CWI	ETF	28.9333	29.2067	28.9333	29.2067	22800.0
2007-10-09	CZA	ETF	27.21	27.23	27.2	27.22	1200.0
2007-10-09	DBA	ETF	28.0	28.41	27.95	28.2	436400.0
2007-10-09	DBB	ETF	25.82	26.07	25.8	25.91	25000.0
2007-10-09	DBC	ETF	27.06	27.52	27.06	27.36	242600.0
2007-10-09	DBE	ETF	30.04	30.43	29.9	30.26	17600.0
2007-10-09	DBO	ETF	28.99	29.32	28.79	29.23	7600.0
2007-10-09	DBP	ETF	28.19	28.47	28.19	28.38	7600.0
2007-10-09	DBS	ETF	26.25	26.53	26.25	26.37	8400.0

> showing 50 of 506 rows — these rows as CSV

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