PREVIEW / etf_daily / 2007-07-31

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-31.parquet
  size:    23 KB
  rows:    501

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-31	SPY	ETF	148.33	149.46	145.04	145.72	316976700.0
2007-07-31	QQQ	ETF	48.97	48.99	47.43	47.53	260322670.0
2007-07-31	IWM	ETF	78.93	79.15	76.74	77.1	187777400.0
2007-07-31	DIA	ETF	134.28	134.83	131.7	132.17	23253600.0
2007-07-31	GLD	ETF	66.18	66.39	65.12	65.79	4006500.0
2007-07-31	TLT	ETF	87.13	87.75	86.95	87.66	2467600.0
2007-07-31	ADRE	ETF	47.5	47.78	46.285	46.285	272127.0
2007-07-31	AGG	ETF	98.63	99.01	98.6	98.99	529100.0
2007-07-31	AIQ	ETF	45.75	46.6	44.25	44.55	29320.0
2007-07-31	AIS	ETF	1.61	1.62	1.55	1.58	58800.0
2007-07-31	ARB	ETF	50.45	50.56	49.63	49.8	411200.0
2007-07-31	BBH	ETF	55.9667	56.0467	54.9267	54.9367	941400.0
2007-07-31	BIL	ETF	91.96	91.96	91.92	91.96	54000.0
2007-07-31	BITS	ETF	26.1596	26.36	25.8	26.24	14778.0
2007-07-31	BIV	ETF	74.38	74.69	74.37	74.69	4200.0
2007-07-31	BLV	ETF	73.57	73.67	73.57	73.67	16700.0
2007-07-31	BMVP	ETF	17.26	17.32	16.9367	16.9667	64200.0
2007-07-31	BND	ETF	74.5	74.73	74.34	74.73	24300.0
2007-07-31	BNE	ETF	17.61	17.85	17.26	17.34	262200.0
2007-07-31	BRF	ETF	14.52	14.58	14.5	14.51	16100.0
2007-07-31	BSV	ETF	75.26	75.36	75.22	75.36	30200.0
2007-07-31	BTF	ETF	105.0	105.0	103.1	103.1	1000.0
2007-07-31	CBON	ETF	24.34	24.34	23.31	23.41	200181.0
2007-07-31	CDL	ETF	5.29	5.29	5.0	5.02	2181500.0
2007-07-31	CEF	ETF	9.29	9.33	9.16	9.16	224800.0
2007-07-31	CGO	ETF	17.34	17.66	17.33	17.44	24100.0
2007-07-31	CGW	ETF	25.45	25.45	24.76	24.76	122100.0
2007-07-31	CHB	ETF	12.26	12.31	11.69	11.72	1802800.0
2007-07-31	CHI	ETF	17.4	17.74	17.26	17.586	151200.0
2007-07-31	CHIC	ETF	18.42	18.5	17.72	17.77	1139170.0
2007-07-31	CHW	ETF	14.02	14.45	14.0	14.06	165000.0
2007-07-31	CHY	ETF	14.9	15.22	14.8801	15.09	167100.0
2007-07-31	CN	ETF	52.3	52.75	51.35	51.35	61300.0
2007-07-31	CNXT	ETF	1.41	1.41	1.28	1.31	15490748.0
2007-07-31	CPI	ETF	26.81	27.05	26.6	26.8	1000.0
2007-07-31	CPST	ETF	1.2	1.2	1.13	1.13	1691702.0
2007-07-31	CSA	ETF	17.27	17.55	17.25	17.3	136600.0
2007-07-31	CSD	ETF	29.62	29.68	29.06	29.06	32300.0
2007-07-31	CSQ	ETF	14.14	14.34	14.11	14.13	379200.0
2007-07-31	CTEC	ETF	106.64999999999999	107.69999999999999	105.05	105.05	19339.4
2007-07-31	CVY	ETF	26.45	26.59	26.08	26.08	26900.0
2007-07-31	CWI	ETF	27.2667	27.3067	26.98	26.9867	25650.0
2007-07-31	CZA	ETF	26.26	26.3	25.77	25.77	2000.0
2007-07-31	DBA	ETF	26.26	26.26	26.0	26.21	110600.0
2007-07-31	DBB	ETF	27.9	28.05	27.74	28.05	86600.0
2007-07-31	DBC	ETF	26.21	26.45	26.09	26.19	388600.0
2007-07-31	DBE	ETF	29.12	29.55	29.09	29.53	24900.0
2007-07-31	DBO	ETF	27.62	27.92	27.54	27.84	12100.0
2007-07-31	DBP	ETF	25.99	26.08	25.99	25.99	18700.0
2007-07-31	DBS	ETF	25.5	25.53	25.31	25.31	4700.0

> showing 50 of 501 rows — these rows as CSV

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