PREVIEW / etf_daily / 2007-01-04

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-04.parquet
  size:    19 KB
  rows:    389

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-01-04	SPY	ETF	141.23	142.05	140.61	141.67	69620600.0
2007-01-04	QQQ	ETF	43.3	44.21	43.15	44.06	137380464.0
2007-01-04	IWM	ETF	77.89	78.59	77.28	78.37	45577600.0
2007-01-04	DIA	ETF	124.48	124.95	123.89	124.68	10318700.0
2007-01-04	GLD	ETF	62.07	62.5	61.52	61.65	4858600.0
2007-01-04	TLT	ETF	89.22	89.65	89.22	89.6	1697000.0
2007-01-04	AAA	ETF	62.71	62.71	62.5	62.65	1800.0
2007-01-04	ADRE	ETF	38.7	38.75	38.27	38.58	181738.0
2007-01-04	AGG	ETF	100.03	100.19	99.94	100.12	1745500.0
2007-01-04	AIQ	ETF	32.8	33.1	32.25	32.5	44920.0
2007-01-04	AIS	ETF	1.2	1.22	1.19	1.19	94900.0
2007-01-04	ARB	ETF	44.0	44.49	43.43	44.2	133700.0
2007-01-04	BAB	ETF	105.6	106.74	105.18	106.5	102100.0
2007-01-04	BBC	ETF	5.29	5.45	4.88	4.97	254200.0
2007-01-04	BBH	ETF	61.4367	63.1967	61.3533	62.99	1638900.0
2007-01-04	BITS	ETF	35.0	35.1712	34.52	34.52	19672.0
2007-01-04	BNE	ETF	15.81	15.97	15.73	15.92	191300.0
2007-01-04	BRF	ETF	14.32	14.49	14.32	14.49	18300.0
2007-01-04	BTF	ETF	108.64999999999999	109.02499999999999	106.5	106.54999999999998	7160.0
2007-01-04	CBON	ETF	29.73	30.09	29.71	29.83	28824.0
2007-01-04	CDL	ETF	10.07	10.08	9.87	9.9	337700.0
2007-01-04	CEF	ETF	9.17	9.25	9.08	9.12	440200.0
2007-01-04	CGO	ETF	16.65	16.9	16.599	16.87	25700.0
2007-01-04	CHB	ETF	9.0	9.0	8.4	8.65	3051100.0
2007-01-04	CHI	ETF	20.14	20.18	20.04	20.12	123900.0
2007-01-04	CHIC	ETF	32.04	32.04	30.98	31.21	593427.0
2007-01-04	CHY	ETF	17.05	17.12	16.95	16.96	173000.0
2007-01-04	CIL	ETF	25.37	25.38	25.37	25.38	400.0
2007-01-04	CN	ETF	53.93	54.38	52.76	53.82	360100.0
2007-01-04	CNXT	ETF	2.08	2.2	2.07	2.19	15073361.0
2007-01-04	CPST	ETF	1.15	1.18	1.15	1.15	1434317.0
2007-01-04	CSA	ETF	20.9	20.9	20.65	20.84	21600.0
2007-01-04	CSB	ETF	33.2	33.23	32.93	33.0501	34600.0
2007-01-04	CSD	ETF	24.9	25.01	24.74	25.01	2800.0
2007-01-04	CSM	ETF	1.2875	1.2875	1.2875	1.2875	6400.0
2007-01-04	CSQ	ETF	15.56	15.59	15.51	15.59	366800.0
2007-01-04	CTEC	ETF	91.5	91.5	90.15	91.05	12835.800000000001
2007-01-04	CVY	ETF	26.34	26.36	26.26	26.35	31000.0
2007-01-04	DBC	ETF	23.55	23.7	23.06	23.18	428900.0
2007-01-04	DBV	ETF	26.05	26.12	26.01	26.1	179000.0
2007-01-04	DDM	ETF	6.885	6.9383	6.8383	6.915	788400.0
2007-01-04	DEF	ETF	25.17	25.17	24.98	25.07	42800.0
2007-01-04	DES	ETF	19.1467	19.2833	19.0433	19.2633	168900.0
2007-01-04	DEW	ETF	62.17	62.37	62.16	62.3	10900.0
2007-01-04	DFE	ETF	65.5	65.73	65.4	65.6	22200.0
2007-01-04	DFJ	ETF	51.15	51.62	50.96	51.58	58300.0
2007-01-04	DGT	ETF	76.09	76.47	76.04	76.43	13400.0
2007-01-04	DHS	ETF	57.6	58.05	57.55	57.93	19900.0
2007-01-04	DIM	ETF	63.69	63.94	63.6	63.85	15100.0
2007-01-04	DIV	ETF	13.61	13.66	13.61	13.65	22000.0

> showing 50 of 389 rows — these rows as CSV

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