PREVIEW / etf_daily / 2007-09-13

all etf daily files

  file:    by_date/etf_daily/2007/2007-09-13.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-09-13	SPY	ETF	148.55	149.45	148.2	148.91	154079000.0
2007-09-13	QQQ	ETF	49.29	49.35	48.94	49.18	80807499.0
2007-09-13	IWM	ETF	78.02	78.53	77.17	77.69	72390100.0
2007-09-13	DIA	ETF	133.88	134.78	133.67	134.3	8318400.0
2007-09-13	GLD	ETF	70.07	70.26	69.61	70.08	4612400.0
2007-09-13	TLT	ETF	90.3	90.33	89.58	89.78	2020600.0
2007-09-13	ADRE	ETF	47.34	48.0	47.19	47.75	178401.0
2007-09-13	AGG	ETF	99.8	99.94	99.63	99.83	790400.0
2007-09-13	AIQ	ETF	44.65	45.05	43.8	43.8	48180.0
2007-09-13	AIS	ETF	1.4	1.44	1.38	1.42	134100.0
2007-09-13	ARB	ETF	46.6	46.66	45.84	45.93	245500.0
2007-09-13	BBH	ETF	57.8	58.1067	57.61	58.1067	456000.0
2007-09-13	BIL	ETF	91.64	91.76	91.64	91.76	25300.0
2007-09-13	BITS	ETF	28.176	29.0	28.04	28.24	10469.0
2007-09-13	BIV	ETF	75.67	75.67	75.35	75.45	15100.0
2007-09-13	BLV	ETF	75.45	75.45	74.99	75.04	5200.0
2007-09-13	BMVP	ETF	16.7367	16.8267	16.6967	16.76	48700.0
2007-09-13	BND	ETF	75.6	75.63	75.47	75.54	77800.0
2007-09-13	BNE	ETF	16.2	16.2	15.77	15.82	148200.0
2007-09-13	BRF	ETF	14.56	14.56	14.56	14.56	4300.0
2007-09-13	BSV	ETF	75.9	75.92	75.79	75.82	17300.0
2007-09-13	BTF	ETF	103.24999999999999	105.0	103.24999999999999	104.1	3620.0
2007-09-13	CBON	ETF	24.09	24.32	23.78	24.03	44327.0
2007-09-13	CDL	ETF	4.2	4.23	4.08	4.09	2270300.0
2007-09-13	CEF	ETF	9.35	9.37	9.26	9.34	334200.0
2007-09-13	CGO	ETF	17.1	17.1	16.92	16.95	7600.0
2007-09-13	CGW	ETF	23.21	24.9	23.21	24.8	34000.0
2007-09-13	CHB	ETF	10.98	11.35	10.87	11.02	1341100.0
2007-09-13	CHI	ETF	16.59	16.71	16.31	16.35	126300.0
2007-09-13	CHIC	ETF	17.21	17.3	16.74	17.05	383340.0
2007-09-13	CHW	ETF	13.28	13.38	13.15	13.29	83900.0
2007-09-13	CHY	ETF	14.77	14.77	14.37	14.38	168400.0
2007-09-13	CN	ETF	46.88	47.55	46.62	47.15	228600.0
2007-09-13	CNXT	ETF	1.3	1.3	1.23	1.23	4549122.0
2007-09-13	CPST	ETF	1.14	1.16	1.11	1.12	1014314.0
2007-09-13	CSA	ETF	18.17	18.98	18.06	18.64	46300.0
2007-09-13	CSD	ETF	28.5	28.62	28.41	28.51	16300.0
2007-09-13	CSM	ETF	1.45	1.45	1.45	1.45	8000.0
2007-09-13	CSQ	ETF	14.1	14.2	14.02	14.04	267100.0
2007-09-13	CVY	ETF	25.82	25.95	25.78	25.84	14000.0
2007-09-13	CWI	ETF	26.8067	27.04	26.7333	26.9067	39750.0
2007-09-13	DBA	ETF	27.4	27.49	26.88	27.16	789000.0
2007-09-13	DBB	ETF	24.95	25.28	24.94	25.26	17200.0
2007-09-13	DBC	ETF	26.55	26.68	26.32	26.42	468600.0
2007-09-13	DBE	ETF	29.71	29.86	29.55	29.73	4900.0
2007-09-13	DBO	ETF	27.97	28.23	27.97	28.23	4600.0
2007-09-13	DBP	ETF	27.05	27.24	27.0	27.16	45900.0
2007-09-13	DBS	ETF	24.61	24.7899	24.5	24.6	28700.0
2007-09-13	DBV	ETF	27.49	27.72	27.45	27.65	247700.0
2007-09-13	DDM	ETF	7.6717	7.7675	7.6458	7.7467	3747600.0

> showing 50 of 498 rows — these rows as CSV

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