PREVIEW / etf_daily / 2007-05-31

all etf daily files

  file:    by_date/etf_daily/2007/2007-05-31.parquet
  size:    22 KB
  rows:    481

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-05-31	SPY	ETF	153.67	153.89	153.12	153.32	114866700.0
2007-05-31	QQQ	ETF	47.32	47.52	47.21	47.41	110730232.0
2007-05-31	IWM	ETF	83.99	84.45	83.78	84.27	68767400.0
2007-05-31	DIA	ETF	136.4	136.66	136.08	136.29	8996400.0
2007-05-31	GLD	ETF	65.16	65.58	65.07	65.54	7530700.0
2007-05-31	TLT	ETF	86.56	86.58	86.04	86.38	1725900.0
2007-05-31	ADRE	ETF	44.27	44.46	44.025	44.1	119782.0
2007-05-31	AGG	ETF	99.25	99.35	99.12	99.16	506000.0
2007-05-31	AIQ	ETF	43.25	44.75	42.7	43.8	97120.0
2007-05-31	AIS	ETF	1.79	1.93	1.77	1.88	654200.0
2007-05-31	ARB	ETF	51.9	52.57	51.74	52.36	243202.0
2007-05-31	BBH	ETF	60.17	60.8967	60.1433	60.85	786300.0
2007-05-31	BIL	ETF	91.58	91.6	91.58	91.6	11200.0
2007-05-31	BITS	ETF	33.8	33.828	33.28	33.44	4271.0
2007-05-31	BIV	ETF	74.59	74.59	74.38	74.49	18000.0
2007-05-31	BLV	ETF	74.29	74.29	74.03	74.26	24000.0
2007-05-31	BMVP	ETF	18.1833	18.2467	18.17	18.2	116000.0
2007-05-31	BND	ETF	74.83	74.83	74.67	74.77	52200.0
2007-05-31	BNE	ETF	19.45	19.5	19.2	19.39	539600.0
2007-05-31	BRF	ETF	14.52	14.55	14.52	14.52	5900.0
2007-05-31	BSV	ETF	75.05	75.05	74.96	75.05	42200.0
2007-05-31	BTF	ETF	110.35	110.55	109.55	109.85	1360.0
2007-05-31	CBON	ETF	29.73	30.17	29.48	29.68	43276.0
2007-05-31	CDL	ETF	8.84	8.84	8.11	8.3	3014100.0
2007-05-31	CEF	ETF	9.18	9.29	9.09	9.16	369400.0
2007-05-31	CGO	ETF	18.23	18.3	18.04	18.29	32400.0
2007-05-31	CGW	ETF	25.6	25.7	25.5	25.58	329200.0
2007-05-31	CHB	ETF	11.19	11.41	11.04	11.37	1749216.0
2007-05-31	CHI	ETF	20.32	20.37	20.25	20.35	88400.0
2007-05-31	CHIC	ETF	27.54	28.0	27.32	27.85	579569.0
2007-05-31	CHY	ETF	17.26	17.37	17.26	17.32	120700.0
2007-05-31	CN	ETF	51.23	51.74	50.98	51.28	82600.0
2007-05-31	CNXT	ETF	1.26	1.31	1.26	1.29	7272292.0
2007-05-31	CPST	ETF	0.94	1.0	0.94	0.96	4197612.0
2007-05-31	CSA	ETF	21.1	21.34	20.75	21.24	171000.0
2007-05-31	CSB	ETF	32.16	32.42	32.13	32.15	14800.0
2007-05-31	CSD	ETF	30.68	30.94	30.64	30.79	171700.0
2007-05-31	CSQ	ETF	15.58	15.65	15.52	15.56	303200.0
2007-05-31	CTEC	ETF	83.6	85.25	83.55	83.75	8688.2
2007-05-31	CVY	ETF	28.43	28.44	28.29	28.33	32600.0
2007-05-31	CWI	ETF	27.24	27.28	27.1733	27.2333	15450.0
2007-05-31	CZA	ETF	27.18	27.19	27.15	27.18	12000.0
2007-05-31	DBA	ETF	26.36	26.5	26.0	26.35	278900.0
2007-05-31	DBB	ETF	27.01	27.18	26.66	27.18	52000.0
2007-05-31	DBC	ETF	25.33	25.52	25.23	25.51	323700.0
2007-05-31	DBE	ETF	27.63	27.92	27.33	27.92	6900.0
2007-05-31	DBO	ETF	25.84	26.01	25.51	26.01	22000.0
2007-05-31	DBP	ETF	26.17	26.17	26.05	26.11	4700.0
2007-05-31	DBS	ETF	26.51	26.57	26.335	26.47	6500.0
2007-05-31	DBV	ETF	28.14	28.23	28.1	28.2	293200.0

> showing 50 of 481 rows — these rows as CSV

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