PREVIEW / etf_daily / 2007-02-01

all etf daily files

  file:    by_date/etf_daily/2007/2007-02-01.parquet
  size:    20 KB
  rows:    428

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-01	SPY	ETF	144.15	144.66	143.91	144.61	69312400.0
2007-02-01	QQQ	ETF	44.27	44.4	43.85	44.02	147412948.0
2007-02-01	IWM	ETF	79.67	80.25	79.54	80.2	50571100.0
2007-02-01	DIA	ETF	126.46	126.77	126.17	126.74	8707400.0
2007-02-01	GLD	ETF	65.45	65.63	65.06	65.22	6284700.0
2007-02-01	TLT	ETF	87.65	87.76	87.0	87.09	986200.0
2007-02-01	AAA	ETF	61.32	61.63	61.32	61.62	3000.0
2007-02-01	ADRE	ETF	39.45	39.68	39.37	39.63	198335.0
2007-02-01	AGG	ETF	99.76	99.76	99.22	99.29	821500.0
2007-02-01	AIQ	ETF	34.7	36.95	34.55	35.25	45760.0
2007-02-01	AIS	ETF	1.21	1.23	1.17	1.22	227300.0
2007-02-01	ARB	ETF	46.55	47.31	46.44	47.28	328900.0
2007-02-01	BAB	ETF	107.46	109.04	107.35	108.39	111500.0
2007-02-01	BBC	ETF	4.97	5.04	4.9203	4.96	85900.0
2007-02-01	BBH	ETF	64.0933	64.33	63.8433	64.1433	494100.0
2007-02-01	BITS	ETF	41.28	42.12	40.88	41.32	20606.0
2007-02-01	BNE	ETF	15.1	15.3	15.07	15.23	97300.0
2007-02-01	BRF	ETF	14.45	14.52	14.45	14.45	12600.0
2007-02-01	BTF	ETF	108.75	108.75	108.45	108.49999999999999	2360.0
2007-02-01	CBON	ETF	33.54	33.54	33.18	33.33	48850.0
2007-02-01	CDL	ETF	10.7	10.8	10.47	10.5	787000.0
2007-02-01	CEF	ETF	9.6	9.73	9.6	9.71	580700.0
2007-02-01	CEW	ETF	26.0	26.3	26.0	26.2	4000.0
2007-02-01	CGO	ETF	17.26	17.39	17.17	17.17	15200.0
2007-02-01	CHB	ETF	8.24	8.48	8.01	8.04	1372700.0
2007-02-01	CHI	ETF	20.3	20.39	20.27	20.33	66500.0
2007-02-01	CHIC	ETF	30.67	31.19	30.48	31.02	486829.0
2007-02-01	CHY	ETF	17.34	17.4	17.29	17.36	117100.0
2007-02-01	CIL	ETF	25.29	25.3	25.28	25.3	5000.0
2007-02-01	CN	ETF	51.55	52.25	51.1	51.8	191100.0
2007-02-01	CNXT	ETF	1.86	1.94	1.86	1.92	12170564.0
2007-02-01	CPST	ETF	0.95	0.95	0.89	0.8999	2623866.0
2007-02-01	CSA	ETF	22.6	22.65	22.49	22.51	12700.0
2007-02-01	CSB	ETF	33.83	34.01	33.76	33.93	19000.0
2007-02-01	CSD	ETF	26.04	26.06	25.86	26.02	49800.0
2007-02-01	CSQ	ETF	15.49	15.53	15.42	15.51	344600.0
2007-02-01	CTEC	ETF	84.3	88.75	84.1	87.44999999999999	42776.4
2007-02-01	CVY	ETF	26.98	27.1	26.98	27.1	26300.0
2007-02-01	CWI	ETF	24.9067	24.9267	24.86	24.92	49050.0
2007-02-01	DBA	ETF	25.96	26.06	25.77	25.8	110600.0
2007-02-01	DBB	ETF	23.55	23.68	23.28	23.34	8500.0
2007-02-01	DBC	ETF	24.15	24.3	23.81	23.9	410000.0
2007-02-01	DBE	ETF	25.01	25.12	24.67	24.73	7100.0
2007-02-01	DBO	ETF	24.49	24.62	24.04	24.06	33400.0
2007-02-01	DBP	ETF	26.35	26.36	26.18	26.23	11900.0
2007-02-01	DBS	ETF	27.07	27.07	26.88	26.88	6600.0
2007-02-01	DBV	ETF	26.13	26.1399	25.98	26.06	206900.0
2007-02-01	DDM	ETF	7.0775	7.1092	7.05	7.0975	745200.0
2007-02-01	DEF	ETF	25.99	26.09	25.96	26.05	23500.0
2007-02-01	DES	ETF	19.45	19.5667	19.4133	19.5633	97200.0

> showing 50 of 428 rows — these rows as CSV

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