PREVIEW / etf_daily / 2007-10-02

all etf daily files

  file:    by_date/etf_daily/2007/2007-10-02.parquet
  size:    23 KB
  rows:    496

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-10-02	SPY	ETF	154.61	154.65	153.81	154.09	112978800.0
2007-10-02	QQQ	ETF	52.04	52.06	51.72	52.01	71045968.0
2007-10-02	IWM	ETF	82.3	82.87	82.18	82.56	53654700.0
2007-10-02	DIA	ETF	140.8	140.91	140.0	140.12	12705600.0
2007-10-02	GLD	ETF	72.45	72.68	71.63	72.35	10720000.0
2007-10-02	TLT	ETF	88.75	89.37	88.68	89.16	887800.0
2007-10-02	ADRE	ETF	55.56	55.6	54.7	55.35	358454.0
2007-10-02	AGG	ETF	99.18	99.74	99.18	99.65	282100.0
2007-10-02	AIQ	ETF	46.7	46.9	45.5	46.45	41420.0
2007-10-02	AIS	ETF	1.4	1.4	1.36	1.39	75900.0
2007-10-02	ARB	ETF	46.4	46.47	45.84	45.99	225100.0
2007-10-02	BBH	ETF	58.94	58.94	58.1433	58.35	447600.0
2007-10-02	BIL	ETF	91.54	91.62	91.52	91.52	78200.0
2007-10-02	BITS	ETF	26.56	26.6	25.84	26.6	5556.0
2007-10-02	BIV	ETF	75.4	75.65	75.39	75.59	23400.0
2007-10-02	BLV	ETF	74.93	75.23	74.87	75.19	5000.0
2007-10-02	BMVP	ETF	17.5	17.5	17.39	17.46	85400.0
2007-10-02	BND	ETF	75.47	75.63	75.39	75.63	214300.0
2007-10-02	BNE	ETF	17.1	17.31	17.01	17.2	177700.0
2007-10-02	BRF	ETF	14.7	14.7	14.7	14.7	200.0
2007-10-02	BSV	ETF	75.79	75.96	75.79	75.89	17400.0
2007-10-02	BTF	ETF	107.24999999999999	108.45	107.05	108.05	2180.0
2007-10-02	CBON	ETF	25.52	25.81	25.36	25.79	28567.0
2007-10-02	CDL	ETF	4.19	4.2699	4.15	4.2	975200.0
2007-10-02	CEF	ETF	9.71	9.71	9.55	9.66	464000.0
2007-10-02	CGO	ETF	18.11	18.11	17.93	17.99	22200.0
2007-10-02	CGW	ETF	26.17	26.2	25.84	26.2	46600.0
2007-10-02	CHB	ETF	11.39	12.1	11.31	12.0	1983200.0
2007-10-02	CHI	ETF	18.01	18.01	16.95	17.05	126800.0
2007-10-02	CHIC	ETF	15.43	15.7	15.38	15.66	409635.0
2007-10-02	CHW	ETF	13.32	13.46	13.17	13.46	153000.0
2007-10-02	CHY	ETF	15.49	15.53	15.24	15.37	104749.0
2007-10-02	CN	ETF	55.0	55.45	54.66	54.95	419000.0
2007-10-02	CNXT	ETF	1.32	1.38	1.31	1.34	13228787.0
2007-10-02	CPI	ETF	23.85	23.85	23.85	23.85	100.0
2007-10-02	CPST	ETF	1.2	1.21	1.12	1.15	2937965.0
2007-10-02	CSA	ETF	18.99	19.44	18.82	19.39	39800.0
2007-10-02	CSD	ETF	29.4	29.51	29.34	29.51	9200.0
2007-10-02	CSQ	ETF	14.82	14.88	14.71	14.8	260000.0
2007-10-02	CVY	ETF	26.27	26.47	26.26	26.46	69400.0
2007-10-02	CWI	ETF	28.8933	28.92	28.7533	28.8933	70800.0
2007-10-02	CZA	ETF	26.73	26.75	26.73	26.75	300.0
2007-10-02	DBA	ETF	29.23	29.28	28.2	28.2	494000.0
2007-10-02	DBB	ETF	26.73	26.76	26.43	26.51	47500.0
2007-10-02	DBC	ETF	27.56	27.63	27.14	27.26	218300.0
2007-10-02	DBE	ETF	29.8	30.03	29.72	30.03	86400.0
2007-10-02	DBO	ETF	28.57	28.84	28.5	28.84	7100.0
2007-10-02	DBP	ETF	28.03	28.2	27.79	28.04	29900.0
2007-10-02	DBS	ETF	26.03	26.21	25.809	26.1201	33700.0
2007-10-02	DBV	ETF	28.66	28.69	28.53	28.65	89900.0

> showing 50 of 496 rows — these rows as CSV

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