PREVIEW / etf_daily / 2007-06-26

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-26.parquet
  size:    22 KB
  rows:    487

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-06-26	SPY	ETF	150.21	150.46	148.28	148.29	198445700.0
2007-06-26	QQQ	ETF	47.32	47.32	46.74	46.82	128211834.0
2007-06-26	IWM	ETF	82.84	82.93	81.74	81.88	91436900.0
2007-06-26	DIA	ETF	133.81	134.43	132.8	132.8	21826500.0
2007-06-26	GLD	ETF	64.2	64.25	63.39	63.62	8276400.0
2007-06-26	TLT	ETF	84.29	84.32	83.97	84.24	2187800.0
2007-06-26	ADRE	ETF	45.32	45.44	44.76	44.83	176180.0
2007-06-26	AGG	ETF	98.17	98.27	98.01	98.05	639900.0
2007-06-26	AIQ	ETF	42.95	44.9	42.8	44.8	47280.0
2007-06-26	AIS	ETF	1.75	1.78	1.65	1.77	439200.0
2007-06-26	ARB	ETF	52.2	52.8	52.11	52.53	469300.0
2007-06-26	BBH	ETF	58.2333	58.33	57.6933	57.94	588900.0
2007-06-26	BIL	ETF	91.92	91.94	91.9	91.94	5100.0
2007-06-26	BITS	ETF	30.08	30.84	28.24	28.56	19727.0
2007-06-26	BIV	ETF	73.69	73.71	73.46	73.61	7200.0
2007-06-26	BLV	ETF	72.7	72.7	72.45	72.56	6800.0
2007-06-26	BMVP	ETF	17.8	17.8	17.6371	17.6633	48800.0
2007-06-26	BND	ETF	74.14	74.18	74.03	74.07	163100.0
2007-06-26	BNE	ETF	19.22	19.3	18.94	19.18	234000.0
2007-06-26	BRF	ETF	14.51	14.61	14.5	14.54	6100.0
2007-06-26	BSV	ETF	74.9	74.93	74.87	74.92	36200.0
2007-06-26	BTF	ETF	107.39999999999999	107.54949999999998	106.5005	106.8	740.0
2007-06-26	CBON	ETF	27.79	27.88	27.56	27.83	66763.0
2007-06-26	CDL	ETF	6.0	6.05	5.88	6.0	12378252.0
2007-06-26	CEF	ETF	8.96	9.03	8.78	8.83	524200.0
2007-06-26	CGO	ETF	17.93	18.1	17.67	17.67	35300.0
2007-06-26	CGW	ETF	25.19	25.35	25.0	25.07	187000.0
2007-06-26	CHB	ETF	10.28	10.39	9.88	9.89	1822900.0
2007-06-26	CHI	ETF	19.52	19.72	18.37	18.84	422800.0
2007-06-26	CHIC	ETF	26.68	26.82	25.26	25.35	1174954.0
2007-06-26	CHY	ETF	15.73	15.92	15.57	15.58	231900.0
2007-06-26	CN	ETF	57.35	57.52	56.67	56.93	99100.0
2007-06-26	CNXT	ETF	1.42	1.44	1.36	1.42	9761549.0
2007-06-26	CPI	ETF	22.7	22.7	22.7	22.7	700.0
2007-06-26	CPST	ETF	1.07	1.14	1.06	1.13	5209452.0
2007-06-26	CSA	ETF	19.83	19.85	19.37	19.65	42100.0
2007-06-26	CSB	ETF	32.26	32.48	31.97	32.06	29400.0
2007-06-26	CSD	ETF	30.74	30.74	30.44	30.51	36400.0
2007-06-26	CSQ	ETF	14.87	14.98	14.79	14.89	451900.0
2007-06-26	CTEC	ETF	108.0	111.3	107.39999999999999	109.89999999999999	61623.8
2007-06-26	CVY	ETF	27.5	27.5	27.28	27.29	20100.0
2007-06-26	CWI	ETF	27.2067	27.2067	26.9267	26.9267	19200.0
2007-06-26	CZA	ETF	26.86	26.86	26.86	26.86	500.0
2007-06-26	DBA	ETF	26.46	26.81	26.42	26.67	308400.0
2007-06-26	DBB	ETF	26.29	26.43	26.06	26.1	65800.0
2007-06-26	DBC	ETF	25.96	25.9999	25.72	25.84	283000.0
2007-06-26	DBE	ETF	28.68	28.71	28.36	28.5	19200.0
2007-06-26	DBO	ETF	26.92	26.92	26.62	26.76	8200.0
2007-06-26	DBP	ETF	25.35	25.35	25.0	25.06	20800.0
2007-06-26	DBS	ETF	24.86	24.86	23.92	24.12	47600.0

> showing 50 of 487 rows — these rows as CSV

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