PREVIEW / etf_daily / 2007-07-16

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-16.parquet
  size:    22 KB
  rows:    486

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-16	SPY	ETF	154.99	155.53	154.58	154.83	98378700.0
2007-07-16	QQQ	ETF	49.9	50.08	49.76	49.85	77799493.0
2007-07-16	IWM	ETF	84.89	85.16	84.22	84.48	77268800.0
2007-07-16	DIA	ETF	138.98	139.86	138.92	139.46	11637900.0
2007-07-16	GLD	ETF	66.19	66.19	65.67	65.82	4579600.0
2007-07-16	TLT	ETF	84.52	85.11	84.52	85.07	952000.0
2007-07-16	ADRE	ETF	49.92	50.0	48.84	49.004	492561.0
2007-07-16	AGG	ETF	97.97	98.22	97.87	98.1	279500.0
2007-07-16	AIQ	ETF	51.4	52.65	51.1	52.45	34580.0
2007-07-16	AIS	ETF	1.73	1.73	1.67	1.72	308900.0
2007-07-16	ARB	ETF	53.58	53.8	53.35	53.48	298600.0
2007-07-16	BBH	ETF	56.8633	56.8633	56.1967	56.3633	227700.0
2007-07-16	BIL	ETF	91.78	91.78	91.72	91.76	16150.0
2007-07-16	BITS	ETF	28.72	28.84	28.08	28.48	14820.0
2007-07-16	BIV	ETF	73.46	73.63	73.43	73.6	9100.0
2007-07-16	BLV	ETF	72.52	72.97	72.48	72.97	12800.0
2007-07-16	BMVP	ETF	18.3267	18.34	18.242	18.2667	36900.0
2007-07-16	BND	ETF	73.91	74.14	73.91	74.13	66700.0
2007-07-16	BNE	ETF	19.63	19.96	19.62	19.77	135500.0
2007-07-16	BRF	ETF	14.46	14.51	14.45	14.46	15300.0
2007-07-16	BSV	ETF	74.72	74.83	74.69	74.83	53900.0
2007-07-16	BTF	ETF	109.19999999999999	109.39999999999999	108.24999999999999	108.24999999999999	2440.0
2007-07-16	CBON	ETF	27.38	27.39	26.8	26.89	35460.0
2007-07-16	CDL	ETF	6.22	6.22	6.11	6.21	2486934.0
2007-07-16	CEF	ETF	9.3	9.32	9.21	9.23	176900.0
2007-07-16	CGO	ETF	18.54	18.54	18.27	18.34	14800.0
2007-07-16	CGW	ETF	26.34	26.45	26.15	26.2	218000.0
2007-07-16	CHB	ETF	9.68	9.88	9.48	9.61	1968500.0
2007-07-16	CHI	ETF	18.37	18.38	17.45	17.86	574900.0
2007-07-16	CHIC	ETF	24.15	24.31	23.89	23.99	588568.0
2007-07-16	CHY	ETF	15.78	15.91	15.5	15.5812	302500.0
2007-07-16	CN	ETF	54.75	55.31	54.49	55.08	203300.0
2007-07-16	CNXT	ETF	1.5	1.5	1.44	1.46	8234873.0
2007-07-16	CPST	ETF	1.34	1.41	1.28	1.29	6313256.0
2007-07-16	CSA	ETF	18.56	18.83	18.46	18.7	41400.0
2007-07-16	CSB	ETF	32.65	32.86	32.41	32.52	58800.0
2007-07-16	CSD	ETF	31.38	31.48	31.31	31.41	45400.0
2007-07-16	CSQ	ETF	15.3	15.336	15.17	15.2	339500.0
2007-07-16	CTEC	ETF	110.39999999999999	110.85000000000001	108.69999999999999	108.8	29286.2
2007-07-16	CVY	ETF	28.03	28.08	27.92	27.93	53800.0
2007-07-16	CWI	ETF	28.4667	28.52	28.3467	28.4067	20550.0
2007-07-16	CZA	ETF	27.75	27.75	27.75	27.75	100.0
2007-07-16	DBA	ETF	27.08	27.21	26.5	26.64	532600.0
2007-07-16	DBB	ETF	27.5	27.64	27.34	27.36	27400.0
2007-07-16	DBC	ETF	26.52	26.52	26.09	26.18	316800.0
2007-07-16	DBE	ETF	29.58	29.58	29.11	29.19	41700.0
2007-07-16	DBO	ETF	27.67	27.69	27.36	27.48	27100.0
2007-07-16	DBP	ETF	26.1	26.17	25.98	25.99	13300.0
2007-07-16	DBS	ETF	25.56	25.6	25.5101	25.57	10700.0
2007-07-16	DBV	ETF	29.33	29.38	29.2	29.38	344600.0

> showing 50 of 486 rows — these rows as CSV

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