PREVIEW / etf_daily / 2007-04-19

all etf daily files

  file:    by_date/etf_daily/2007/2007-04-19.parquet
  size:    21 KB
  rows:    448

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-19	SPY	ETF	146.55	147.4	146.36	147.23	102947700.0
2007-04-19	QQQ	ETF	44.81	45.25	44.72	45.15	95510366.0
2007-04-19	IWM	ETF	81.14	81.83	80.8	81.36	69360400.0
2007-04-19	DIA	ETF	127.33	128.27	127.27	128.23	8618600.0
2007-04-19	GLD	ETF	68.0	68.04	67.25	67.53	5344600.0
2007-04-19	TLT	ETF	88.66	88.71	88.2	88.38	1305900.0
2007-04-19	AAA	ETF	69.17	70.53	69.05	70.4	19500.0
2007-04-19	ADRE	ETF	40.4	41.28	40.01	41.15	146329.0
2007-04-19	AGG	ETF	100.3	100.3	100.05	100.19	223500.0
2007-04-19	AIQ	ETF	44.85	45.45	44.1	44.75	45220.0
2007-04-19	AIS	ETF	1.48	1.51	1.46	1.51	184800.0
2007-04-19	ARB	ETF	49.25	51.18	49.0	49.19	410200.0
2007-04-19	BAB	ETF	102.36	103.0	102.25	102.36	24600.0
2007-04-19	BBH	ETF	61.6667	62.29	61.3767	61.7733	955800.0
2007-04-19	BITS	ETF	32.84	33.44	32.44	32.84	12723.0
2007-04-19	BIV	ETF	75.36	75.36	75.3	75.31	3400.0
2007-04-19	BLV	ETF	75.76	75.76	75.55	75.61	11800.0
2007-04-19	BND	ETF	75.36	75.36	75.25	75.28	59700.0
2007-04-19	BNE	ETF	16.75	16.83	16.44	16.78	183000.0
2007-04-19	BRF	ETF	14.51	14.6	14.51	14.56	4300.0
2007-04-19	BSV	ETF	75.23	75.23	75.19	75.21	39000.0
2007-04-19	BTF	ETF	111.75	111.95	111.6	111.89999999999999	1320.0
2007-04-19	CBON	ETF	29.25	29.43	29.08	29.09	34169.0
2007-04-19	CDL	ETF	9.62	9.68	9.56	9.66	263900.0
2007-04-19	CEF	ETF	9.63	9.68	9.5	9.52	313100.0
2007-04-19	CGO	ETF	17.76	17.78	17.65	17.65	21900.0
2007-04-19	CHB	ETF	10.84	10.88	10.18	10.2	2230474.0
2007-04-19	CHI	ETF	20.09	20.3	20.09	20.24	83600.0
2007-04-19	CHIC	ETF	30.03	30.4	29.69	29.88	311124.0
2007-04-19	CHY	ETF	17.0	17.14	16.98	17.05	91800.0
2007-04-19	CIL	ETF	25.76	25.76	25.76	25.76	500.0
2007-04-19	CN	ETF	51.0	52.29	50.86	52.05	110100.0
2007-04-19	CNXT	ETF	1.44	1.46	1.42	1.43	4480086.0
2007-04-19	CPI	ETF	21.24	21.24	21.24	21.24	200.0
2007-04-19	CPST	ETF	1.12	1.18	1.11	1.17	2435323.0
2007-04-19	CSA	ETF	21.06	21.06	20.71	20.9	17000.0
2007-04-19	CSB	ETF	33.18	33.62	33.18	33.53	8100.0
2007-04-19	CSD	ETF	28.14	28.36	28.12	28.2	13000.0
2007-04-19	CSM	ETF	1.3625	1.3625	1.36	1.36	48000.0
2007-04-19	CSQ	ETF	15.44	15.54	15.37	15.53	315600.0
2007-04-19	CTEC	ETF	88.85	90.25	87.14999999999999	90.25	11120.2
2007-04-19	CVY	ETF	27.42	27.49	27.35	27.42	11100.0
2007-04-19	CWI	ETF	26.28	26.52	26.24	26.42	13950.0
2007-04-19	DBA	ETF	25.1	25.43	25.1	25.43	123400.0
2007-04-19	DBB	ETF	27.11	27.29	26.6	27.23	37100.0
2007-04-19	DBC	ETF	25.2	25.3	25.05	25.18	271500.0
2007-04-19	DBE	ETF	27.17	27.3	27.05	27.11	33600.0
2007-04-19	DBO	ETF	26.2	26.2	25.66	25.74	35100.0
2007-04-19	DBP	ETF	26.85	26.97	26.01	26.89	9900.0
2007-04-19	DBS	ETF	26.74	27.0	26.73	26.84	5800.0

> showing 50 of 448 rows — these rows as CSV

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