PREVIEW / etf_daily / 2007-04-05

all etf daily files

  file:    by_date/etf_daily/2007/2007-04-05.parquet
  size:    21 KB
  rows:    438

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-04-05	SPY	ETF	143.67	144.44	143.61	144.24	46822800.0
2007-04-05	QQQ	ETF	44.29	44.58	44.23	44.56	54260779.0
2007-04-05	IWM	ETF	80.45	80.81	80.35	80.44	24666800.0
2007-04-05	DIA	ETF	125.12	125.7	124.95	125.46	4046000.0
2007-04-05	GLD	ETF	66.7	66.96	66.59	66.86	3592700.0
2007-04-05	TLT	ETF	88.1	88.12	87.71	87.75	436400.0
2007-04-05	AAA	ETF	66.51	67.43	66.51	67.35	32500.0
2007-04-05	ADRE	ETF	40.38	40.79	40.38	40.79	134094.0
2007-04-05	AGG	ETF	100.01	100.02	99.82	99.92	269600.0
2007-04-05	AIQ	ETF	43.85	46.1	43.67	46.05	69400.0
2007-04-05	AIS	ETF	1.6	1.62	1.48	1.5	704900.0
2007-04-05	ARB	ETF	47.97	48.14	47.65	48.09	97400.0
2007-04-05	BAB	ETF	100.65	101.23	100.24	100.99	36800.0
2007-04-05	BBH	ETF	59.3033	60.18	59.3033	60.1167	565200.0
2007-04-05	BITS	ETF	32.04	32.04	31.32	31.6	14680.0
2007-04-05	BNE	ETF	15.9	15.98	15.82	15.9	86600.0
2007-04-05	BOSS	ETF	46.9	46.9	46.9	46.9	100.0
2007-04-05	BRF	ETF	14.55	14.55	14.52	14.547	6200.0
2007-04-05	BTF	ETF	110.44999999999999	110.85000000000001	110.39999999999999	110.6	5800.0
2007-04-05	CBON	ETF	30.46	30.8	29.85	29.85	49563.0
2007-04-05	CDL	ETF	9.55	9.65	9.54	9.64	121400.0
2007-04-05	CEF	ETF	9.53	9.6	9.51	9.53	276300.0
2007-04-05	CGO	ETF	17.1899	17.28	17.16	17.2	15100.0
2007-04-05	CHB	ETF	9.03	9.46	9.03	9.2	2603100.0
2007-04-05	CHI	ETF	20.37	20.49	20.35	20.4	61600.0
2007-04-05	CHIC	ETF	30.0	30.7	29.75	30.7	478334.0
2007-04-05	CHY	ETF	16.98	17.16	16.98	17.1	114900.0
2007-04-05	CN	ETF	50.9	51.4	50.86	51.4	36200.0
2007-04-05	CNXT	ETF	1.63	1.66	1.63	1.65	7533196.0
2007-04-05	CPI	ETF	21.71	21.71	21.71	21.71	900.0
2007-04-05	CPST	ETF	0.95	0.99	0.95	0.987	1558178.0
2007-04-05	CSA	ETF	21.16	21.38	21.1	21.29	16300.0
2007-04-05	CSB	ETF	33.46	33.66	33.46	33.66	4600.0
2007-04-05	CSD	ETF	27.85	27.98	27.82	27.94	46800.0
2007-04-05	CSM	ETF	1.36	1.3625	1.36	1.3625	1200.0
2007-04-05	CSQ	ETF	15.2	15.35	15.17	15.34	250800.0
2007-04-05	CTEC	ETF	86.5	86.69999999999999	85.05	86.1	12549.400000000001
2007-04-05	CVY	ETF	26.83	26.85	26.77	26.8	20100.0
2007-04-05	CWI	ETF	25.88	26.02	25.88	26.02	9900.0
2007-04-05	CZA	ETF	25.45	25.45	25.45	25.45	200.0
2007-04-05	DBA	ETF	25.2	25.54	25.12	25.43	171800.0
2007-04-05	DBB	ETF	26.29	26.44	26.0	26.03	20200.0
2007-04-05	DBC	ETF	25.38	25.4256	25.23	25.36	219100.0
2007-04-05	DBE	ETF	27.85	27.87	27.69	27.85	22400.0
2007-04-05	DBO	ETF	26.7	26.81	26.43	26.58	83700.0
2007-04-05	DBP	ETF	26.7	26.74	26.62	26.7	6400.0
2007-04-05	DBS	ETF	26.9	27.45	26.85	27.01	33100.0
2007-04-05	DBV	ETF	27.23	27.24	27.16	27.24	79000.0
2007-04-05	DDM	ETF	6.8525	6.9175	6.8458	6.9042	424800.0
2007-04-05	DEF	ETF	26.35	26.38	26.3001	26.36	10800.0

> showing 50 of 438 rows — these rows as CSV

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