PREVIEW / etf_daily / 2007-07-30

all etf daily files

  file:    by_date/etf_daily/2007/2007-07-30.parquet
  size:    23 KB
  rows:    498

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-30	SPY	ETF	145.93	147.81	145.29	147.38	283017500.0
2007-07-30	QQQ	ETF	48.21	48.73	47.95	48.55	166520723.0
2007-07-30	IWM	ETF	77.31	78.42	76.55	77.96	149169600.0
2007-07-30	DIA	ETF	132.92	133.85	132.13	133.54	22838700.0
2007-07-30	GLD	ETF	65.37	65.92	65.07	65.77	3046800.0
2007-07-30	TLT	ETF	87.19	87.36	86.91	87.03	1803900.0
2007-07-30	ADRE	ETF	45.97	46.99	45.85	46.74	261710.0
2007-07-30	AGG	ETF	98.81	98.87	98.61	98.68	389300.0
2007-07-30	AIQ	ETF	44.95	45.7	43.6	45.35	35020.0
2007-07-30	AIS	ETF	1.61	1.62	1.54	1.59	150200.0
2007-07-30	ARB	ETF	48.64	50.23	48.3401	50.05	503600.0
2007-07-30	BBH	ETF	55.55	56.06	55.41	55.9467	497700.0
2007-07-30	BIL	ETF	91.9	91.94	91.84	91.84	10300.0
2007-07-30	BITS	ETF	25.9996	26.28	25.4	26.24	7635.0
2007-07-30	BIV	ETF	74.43	74.48	74.25	74.25	3800.0
2007-07-30	BLV	ETF	73.58	73.6	73.48	73.51	2600.0
2007-07-30	BMVP	ETF	16.98	17.17	16.89	17.13	90200.0
2007-07-30	BND	ETF	74.58	74.71	74.52	74.58	33600.0
2007-07-30	BNE	ETF	17.43	17.55	16.91	17.5	296800.0
2007-07-30	BRF	ETF	14.52	14.5401	14.49	14.54	4500.0
2007-07-30	BSV	ETF	75.38	75.44	75.3	75.35	41100.0
2007-07-30	BTF	ETF	102.5	104.45	102.05	104.45	3240.0
2007-07-30	CBON	ETF	23.91	24.02	23.55	23.92	122412.0
2007-07-30	CDL	ETF	5.35	5.35	5.05	5.1	3274614.0
2007-07-30	CEF	ETF	9.13	9.3	9.13	9.21	283200.0
2007-07-30	CGO	ETF	17.17	17.28	16.95	17.23	25100.0
2007-07-30	CGW	ETF	24.7	25.05	24.49	24.83	328600.0
2007-07-30	CHB	ETF	11.77	12.23	11.67	12.18	2792900.0
2007-07-30	CHI	ETF	17.41	17.49	17.12	17.31	153100.0
2007-07-30	CHIC	ETF	18.4	18.61	17.88	18.45	880792.0
2007-07-30	CHW	ETF	14.75	14.76	14.01	14.09	722300.0
2007-07-30	CHY	ETF	15.1	15.1928	14.73	14.86	167900.0
2007-07-30	CN	ETF	51.85	52.33	51.22	52.2	78200.0
2007-07-30	CNXT	ETF	1.4	1.44	1.3499	1.39	12732910.0
2007-07-30	CPI	ETF	24.8	27.5	24.8	27.1	2400.0
2007-07-30	CPST	ETF	1.15	1.17	1.13	1.16	1089362.0
2007-07-30	CSA	ETF	17.25	17.41	17.02	17.16	441500.0
2007-07-30	CSD	ETF	29.0	29.39	28.94	29.24	46500.0
2007-07-30	CSQ	ETF	14.1	14.15	13.65	14.03	549200.0
2007-07-30	CTEC	ETF	103.14999999999999	104.45	101.5005	103.85	17005.0
2007-07-30	CVY	ETF	26.09	26.27	25.94	26.22	50800.0
2007-07-30	CWI	ETF	26.78	27.0733	26.7133	27.0	31800.0
2007-07-30	CZA	ETF	25.81	25.94	25.66	25.94	22800.0
2007-07-30	DBA	ETF	26.26	26.3	25.75	25.83	261100.0
2007-07-30	DBB	ETF	27.48	27.7	27.34	27.64	49300.0
2007-07-30	DBC	ETF	26.15	26.2299	25.8701	25.98	181900.0
2007-07-30	DBE	ETF	29.23	29.26	28.9	29.01	15600.0
2007-07-30	DBO	ETF	27.71	27.71	27.3	27.55	28200.0
2007-07-30	DBP	ETF	25.82	25.99	25.74	25.96	1300.0
2007-07-30	DBS	ETF	25.09	25.38	25.09	25.37	2600.0

> showing 50 of 498 rows — these rows as CSV

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