PREVIEW / etf_daily / 2007-01-08

all etf daily files

  file:    by_date/etf_daily/2007/2007-01-08.parquet
  size:    19 KB
  rows:    387

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-08	SPY	ETF	140.82	141.41	140.25	141.19	71655000.0
2007-01-08	QQQ	ETF	43.88	44.12	43.64	43.88	106558842.0
2007-01-08	IWM	ETF	76.95	77.3	76.23	76.43	46117200.0
2007-01-08	DIA	ETF	123.87	124.39	123.25	124.14	8092400.0
2007-01-08	GLD	ETF	60.38	60.54	59.85	60.48	3478700.0
2007-01-08	TLT	ETF	89.12	89.37	89.05	89.37	414200.0
2007-01-08	AAA	ETF	61.7	61.81	61.51	61.69	23200.0
2007-01-08	ADRE	ETF	37.71	38.12	37.71	38.04	224996.0
2007-01-08	AGG	ETF	100.15	100.15	100.01	100.11	281700.0
2007-01-08	AIQ	ETF	31.6	32.95	30.5	32.85	99280.0
2007-01-08	AIS	ETF	1.22	1.25	1.14	1.25	313600.0
2007-01-08	ARB	ETF	43.11	43.69	42.45	43.52	95300.0
2007-01-08	BAB	ETF	106.39	107.0	104.83	107.0	111800.0
2007-01-08	BBC	ETF	5.13	5.55	5.0	5.4	1291900.0
2007-01-08	BBH	ETF	62.8333	63.1667	62.6667	62.9733	524400.0
2007-01-08	BITS	ETF	34.0	34.32	33.2	33.8	10668.0
2007-01-08	BNE	ETF	15.57	15.72	15.15	15.58	125000.0
2007-01-08	BRF	ETF	14.55	14.67	14.5175	14.55	14500.0
2007-01-08	BTF	ETF	105.6	106.75	101.99999999999999	106.05	2620.0
2007-01-08	CBON	ETF	29.8	29.94	29.7	29.84	81133.0
2007-01-08	CDL	ETF	9.65	9.8	9.56	9.76	178500.0
2007-01-08	CEF	ETF	8.91	8.99	8.73	8.81	468000.0
2007-01-08	CGO	ETF	17.0	17.0	16.76	16.89	12100.0
2007-01-08	CHB	ETF	8.23	8.23	8.0	8.1	1172000.0
2007-01-08	CHI	ETF	20.05	20.06	19.91	20.0	99000.0
2007-01-08	CHIC	ETF	30.59	30.6	30.2	30.52	415275.0
2007-01-08	CHY	ETF	17.0	17.09	16.98	17.02	105500.0
2007-01-08	CIL	ETF	25.39	25.48	25.39	25.48	7000.0
2007-01-08	CN	ETF	52.1	54.18	51.62	53.68	253300.0
2007-01-08	CNXT	ETF	2.13	2.18	2.09	2.14	8942848.0
2007-01-08	CPI	ETF	23.8	23.8	23.02	23.6	3400.0
2007-01-08	CPST	ETF	1.15	1.15	1.1	1.1	1227332.0
2007-01-08	CSA	ETF	20.9	20.98	20.65	20.8	60600.0
2007-01-08	CSB	ETF	32.5	32.56	32.05	32.54	39500.0
2007-01-08	CSD	ETF	24.88	24.98	24.84	24.98	11900.0
2007-01-08	CSQ	ETF	15.59	15.65	15.53	15.63	423900.0
2007-01-08	CTEC	ETF	91.5	92.5	91.19999999999999	92.35	16264.0
2007-01-08	CVY	ETF	26.14	26.2	26.05	26.18	16100.0
2007-01-08	DBA	ETF	25.94	25.94	24.84	24.98	143600.0
2007-01-08	DBB	ETF	34.11	34.11	23.39	23.39	10200.0
2007-01-08	DBC	ETF	23.5	23.56	22.99	23.22	275200.0
2007-01-08	DBE	ETF	24.76	24.76	24.21	24.34	1400.0
2007-01-08	DBO	ETF	35.94	35.94	23.98	24.33	73200.0
2007-01-08	DBP	ETF	24.24	24.35	24.12	24.3	8400.0
2007-01-08	DBS	ETF	24.25	24.39	24.12	24.39	16400.0
2007-01-08	DBV	ETF	26.0	26.01	25.92	25.95	177900.0
2007-01-08	DDM	ETF	6.7858	6.8792	6.7583	6.8567	609600.0
2007-01-08	DEF	ETF	24.79	24.9299	24.7501	24.9299	11400.0
2007-01-08	DES	ETF	18.8233	18.9	18.7067	18.87	96600.0
2007-01-08	DEW	ETF	61.46	61.58	61.31	61.49	8500.0

> showing 50 of 387 rows — these rows as CSV

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