PREVIEW / etf_daily / 2007-08-17

all etf daily files

  file:    by_date/etf_daily/2007/2007-08-17.parquet
  size:    23 KB
  rows:    499

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-08-17	SPY	ETF	145.5	145.81	141.39	144.71	388218100.0
2007-08-17	QQQ	ETF	46.31	46.5895	45.589	46.31	223247137.0
2007-08-17	IWM	ETF	79.21	80.06	76.59	78.41	215542300.0
2007-08-17	DIA	ETF	131.24	131.86	128.95	130.55	33292800.0
2007-08-17	GLD	ETF	64.56	65.73	64.56	65.01	6374300.0
2007-08-17	TLT	ETF	86.4	86.91	86.05	86.79	2114400.0
2007-08-17	ADRE	ETF	41.3	42.15	40.6	41.93	574780.0
2007-08-17	AGG	ETF	98.67	98.97	98.42	98.89	311800.0
2007-08-17	AIQ	ETF	44.4	44.7	41.25	42.9	40860.0
2007-08-17	AIS	ETF	1.3399	1.35	1.29	1.2999	354100.0
2007-08-17	ARB	ETF	53.4	53.4	51.37	51.77	470400.0
2007-08-17	BBH	ETF	54.0767	54.3133	53.1433	53.7967	899400.0
2007-08-17	BIL	ETF	91.7	91.98	91.68	91.96	84750.0
2007-08-17	BITS	ETF	26.08	26.36	25.32	25.6796	8360.0
2007-08-17	BIV	ETF	74.75	74.87	74.67	74.79	31000.0
2007-08-17	BLV	ETF	73.06	73.42	73.06	73.42	9700.0
2007-08-17	BMVP	ETF	16.5267	16.64	16.17	16.4433	72300.0
2007-08-17	BND	ETF	74.75	74.89	74.69	74.87	37300.0
2007-08-17	BNE	ETF	15.57	16.11	15.57	15.76	493800.0
2007-08-17	BRF	ETF	14.46	14.6	14.46	14.53	5200.0
2007-08-17	BSV	ETF	75.75	75.77	75.63	75.72	38500.0
2007-08-17	BTF	ETF	99.49999999999999	100.99999999999999	98.64999999999999	99.45	4740.0
2007-08-17	CBON	ETF	25.49	27.53	24.82	25.57	203701.0
2007-08-17	CDL	ETF	4.5	4.84	4.26	4.3	2465322.0
2007-08-17	CEF	ETF	8.13	9.26	8.13	9.13	479400.0
2007-08-17	CGO	ETF	14.55	15.53	14.55	15.53	48700.0
2007-08-17	CGW	ETF	23.17	29.86	22.74	23.1	188700.0
2007-08-17	CHB	ETF	10.27	11.71	9.7	10.7	3214854.0
2007-08-17	CHI	ETF	15.54	16.8	15.44	16.8	329400.0
2007-08-17	CHIC	ETF	18.011	18.2	17.26	17.69	510781.0
2007-08-17	CHW	ETF	12.7	13.49	12.0	13.35	262400.0
2007-08-17	CHY	ETF	13.5	14.84	13.5	14.65	650400.0
2007-08-17	CN	ETF	46.0	48.21	46.0	48.11	212900.0
2007-08-17	CNXT	ETF	1.23	1.25	1.15	1.17	10742408.0
2007-08-17	CPST	ETF	1.02	1.04	0.97	1.0099	1243750.0
2007-08-17	CSA	ETF	16.56	17.25	16.51	17.0	66000.0
2007-08-17	CSD	ETF	27.61	28.07	27.58	28.01	15200.0
2007-08-17	CSM	ETF	1.4025	1.4025	1.4025	1.4025	400.0
2007-08-17	CSQ	ETF	13.5	13.8	13.28	13.75	506800.0
2007-08-17	CTEC	ETF	102.44999999999999	104.19999999999999	99.7	100.64999999999999	20910.800000000003
2007-08-17	CVY	ETF	25.52	25.53	25.1	25.44	30900.0
2007-08-17	CWI	ETF	25.0267	25.3733	24.9733	25.3533	19350.0
2007-08-17	CZA	ETF	24.55	24.55	24.55	24.55	100.0
2007-08-17	DBA	ETF	25.52	25.99	25.0	25.78	422000.0
2007-08-17	DBB	ETF	25.03	25.05	24.71	24.93	29200.0
2007-08-17	DBC	ETF	24.28	25.35	23.62	25.16	374500.0
2007-08-17	DBE	ETF	27.91	28.25	27.91	28.16	158500.0
2007-08-17	DBO	ETF	29.0	29.0	26.1	26.34	91100.0
2007-08-17	DBP	ETF	25.49	25.49	25.17	25.29	3900.0
2007-08-17	DBS	ETF	25.87	25.87	22.3	23.32	31900.0

> showing 50 of 499 rows — these rows as CSV

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