PREVIEW / etf_daily / 2007-11-23

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-23.parquet
  size:    23 KB
  rows:    505

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-11-23	SPY	ETF	143.07	144.34	142.7	144.13	77688400.0
2007-11-23	QQQ	ETF	49.63	49.97	49.3724	49.84	46472533.0
2007-11-23	IWM	ETF	74.36	76.0	74.11	75.06	50849400.0
2007-11-23	DIA	ETF	128.72	129.68	128.61	129.42	7232400.0
2007-11-23	GLD	ETF	80.04	81.61	80.02	81.25	5259700.0
2007-11-23	TLT	ETF	93.44	93.8	93.31	93.73	437400.0
2007-11-23	ADRE	ETF	52.01	52.57	52.01	52.57	107089.0
2007-11-23	AGG	ETF	101.54	101.78	101.25	101.25	137700.0
2007-11-23	AIQ	ETF	44.8	46.7	44.75	46.7	19620.0
2007-11-23	AIS	ETF	1.0301	1.08	1.03	1.04	57100.0
2007-11-23	AIVI	ETF	71.7	72.42	70.98	72.34	13900.0
2007-11-23	ARB	ETF	51.0	51.2	50.42	50.59	84300.0
2007-11-23	BBH	ETF	57.7667	58.2	57.48	58.0333	193200.0
2007-11-23	BIL	ETF	91.82	91.9	91.82	91.9	7650.0
2007-11-23	BITS	ETF	22.64	23.0	22.36	22.88	8352.0
2007-11-23	BIV	ETF	77.38	77.48	77.35	77.47	9000.0
2007-11-23	BKF	ETF	55.91	55.91	55.91	55.91	100.0
2007-11-23	BLV	ETF	77.22	77.37	77.21	77.21	2300.0
2007-11-23	BMVP	ETF	16.5633	16.73	16.5633	16.67	31900.0
2007-11-23	BND	ETF	76.9	76.9	76.68	76.85	15000.0
2007-11-23	BNE	ETF	16.03	16.71	16.0	16.44	147200.0
2007-11-23	BRF	ETF	14.6	14.6	14.6	14.6	600.0
2007-11-23	BSV	ETF	77.34	77.34	77.27	77.33	19300.0
2007-11-23	BTF	ETF	111.14999999999999	111.85	111.14999999999999	111.8495	220.0
2007-11-23	BWX	ETF	27.42	27.425	27.3984	27.415	74200.0
2007-11-23	CBON	ETF	18.45	19.12	17.58	18.96	67681.0
2007-11-23	CDL	ETF	2.25	2.35	2.25	2.27	940970.0
2007-11-23	CEF	ETF	10.7	10.92	10.65	10.9	549400.0
2007-11-23	CGO	ETF	18.0	18.11	17.97	18.07	5800.0
2007-11-23	CGW	ETF	25.0	25.11	24.7801	25.009	23800.0
2007-11-23	CHB	ETF	8.43	8.74	8.3	8.67	501200.0
2007-11-23	CHI	ETF	14.73	14.8	14.61	14.71	63201.0
2007-11-23	CHIC	ETF	14.78	15.36	14.72	15.22	182969.0
2007-11-23	CHW	ETF	12.15	12.3	12.0	12.3	104200.0
2007-11-23	CHY	ETF	13.0	13.0	12.82	12.94	85102.0
2007-11-23	CN	ETF	55.5	56.41	55.14	56.01	76000.0
2007-11-23	CNXT	ETF	1.1	1.18	1.1	1.17	2438009.0
2007-11-23	COW	ETF	49.57	49.57	49.48	49.48	1200.0
2007-11-23	CPST	ETF	1.2	1.22	1.17	1.21	575870.0
2007-11-23	CSA	ETF	16.3	16.43	15.72	16.15	50700.0
2007-11-23	CSD	ETF	26.23	26.49	26.23	26.44	4600.0
2007-11-23	CSQ	ETF	13.2	13.42	13.2	13.34	111200.0
2007-11-23	CUT	ETF	23.75	23.75	23.7	23.75	2900.0
2007-11-23	CVY	ETF	23.7	24.08	23.7	24.08	2200.0
2007-11-23	CWI	ETF	27.8467	27.9667	27.7733	27.9533	28500.0
2007-11-23	CZA	ETF	25.18	25.18	25.18	25.18	100.0
2007-11-23	DBA	ETF	30.65	30.77	30.32	30.74	288100.0
2007-11-23	DBB	ETF	22.51	22.89	22.51	22.72	9300.0
2007-11-23	DBC	ETF	31.58	31.67	31.14	31.64	501308.0
2007-11-23	DBE	ETF	35.79	36.0	35.6	35.93	13100.0

> showing 50 of 505 rows — these rows as CSV

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