PREVIEW / etf_daily / 2007-02-26

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-26.parquet
  size:    21 KB
  rows:    441

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-02-26	SPY	ETF	145.83	145.95	144.75	145.17	69192800.0
2007-02-26	QQQ	ETF	45.48	45.5	43.15	45.04	102249641.0
2007-02-26	IWM	ETF	82.32	82.41	81.19	81.89	78736400.0
2007-02-26	DIA	ETF	126.86	127.0	126.09	126.34	7599500.0
2007-02-26	GLD	ETF	67.97	68.23	67.63	68.1	5254200.0
2007-02-26	TLT	ETF	89.15	89.44	89.11	89.43	763400.0
2007-02-26	AAA	ETF	60.9	61.18	60.9	61.11	19500.0
2007-02-26	ADRE	ETF	40.62	40.62	40.072	40.27	234877.0
2007-02-26	AGG	ETF	100.41	100.54	100.35	100.51	222700.0
2007-02-26	AIQ	ETF	39.8	39.8	38.1	38.1	57689.0
2007-02-26	AIS	ETF	1.2399	1.26	1.22	1.25	126658.0
2007-02-26	ARB	ETF	45.7	45.79	45.35	45.43	338801.0
2007-02-26	BAB	ETF	110.67	110.68	109.09	109.34	66200.0
2007-02-26	BBC	ETF	4.36	4.37	4.31	4.33	57200.0
2007-02-26	BBH	ETF	62.36	62.7333	62.22	62.47	180300.0
2007-02-26	BITS	ETF	45.52	45.8	42.28	43.64	39839.0
2007-02-26	BNE	ETF	15.89	16.17	15.84	16.04	230360.0
2007-02-26	BRF	ETF	14.52	14.53	14.5199	14.53	2000.0
2007-02-26	BTF	ETF	113.64999999999999	113.64999999999999	112.89999999999999	112.89999999999999	1840.0
2007-02-26	CBON	ETF	33.61	33.61	32.01	32.4	50750.0
2007-02-26	CDL	ETF	10.37	10.45	10.34	10.45	277600.0
2007-02-26	CEF	ETF	9.94	10.0	9.88	9.95	377800.0
2007-02-26	CGO	ETF	17.2	17.39	16.83	16.92	28000.0
2007-02-26	CHB	ETF	7.5	8.72	7.46	8.64	4388949.0
2007-02-26	CHI	ETF	20.2	20.3	20.17	20.3	90700.0
2007-02-26	CHIC	ETF	31.17	31.17	30.11	30.64	285941.0
2007-02-26	CHY	ETF	17.04	17.08	16.96	17.05	101700.0
2007-02-26	CIL	ETF	25.47	25.47	25.45	25.45	2300.0
2007-02-26	CN	ETF	49.75	49.95	49.59	49.63	53000.0
2007-02-26	CNXT	ETF	2.06	2.08	2.04	2.07	10105095.0
2007-02-26	CPI	ETF	22.9	23.18	22.9	23.1	600.0
2007-02-26	CPST	ETF	1.01	1.04	0.97	0.98	2776684.0
2007-02-26	CSA	ETF	22.6	22.82	22.4	22.82	84300.0
2007-02-26	CSB	ETF	34.06	34.06	33.63	33.75	15810.0
2007-02-26	CSD	ETF	26.88	26.88	26.6	26.7	18100.0
2007-02-26	CSQ	ETF	15.27	15.34	15.2	15.34	277289.0
2007-02-26	CTEC	ETF	83.94999999999999	85.89999999999999	83.0	85.74999999999999	22047.4
2007-02-26	CVY	ETF	27.36	27.41	27.18	27.3	30700.0
2007-02-26	CWI	ETF	25.72	25.72	25.6067	25.6933	11400.0
2007-02-26	DBA	ETF	27.5	27.54	27.15	27.16	231900.0
2007-02-26	DBB	ETF	25.3	25.31	25.1	25.25	19300.0
2007-02-26	DBC	ETF	25.4	25.49	25.2	25.31	555440.0
2007-02-26	DBE	ETF	26.53	26.53	26.22	26.42	18600.0
2007-02-26	DBO	ETF	25.87	25.94	25.55	25.85	27300.0
2007-02-26	DBP	ETF	27.5	27.58	27.35	27.52	27300.0
2007-02-26	DBS	ETF	28.85	28.9601	28.6	28.9601	24700.0
2007-02-26	DBV	ETF	26.76	26.81	26.67	26.71	84650.0
2007-02-26	DDM	ETF	7.1658	7.1658	7.0358	7.0658	667200.0
2007-02-26	DEF	ETF	26.46	26.46	26.25	26.33	12570.0
2007-02-26	DES	ETF	19.83	19.85	19.56	19.7267	91200.0

> showing 50 of 441 rows — these rows as CSV

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