PREVIEW / etf_daily / 2007-04-18

all etf daily files

  file:    by_date/etf_daily/2007/2007-04-18.parquet
  size:    21 KB
  rows:    449

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-18	SPY	ETF	146.6	147.7	146.57	147.27	88345300.0
2007-04-18	QQQ	ETF	44.93	45.23	44.83	45.01	82051504.0
2007-04-18	IWM	ETF	81.91	82.22	81.66	81.75	48993700.0
2007-04-18	DIA	ETF	127.44	128.34	127.29	128.04	9222000.0
2007-04-18	GLD	ETF	68.1	68.45	67.95	68.38	4933500.0
2007-04-18	TLT	ETF	88.37	88.56	88.36	88.53	450800.0
2007-04-18	AAA	ETF	68.74	68.8	68.5	68.6496	7300.0
2007-04-18	ADRE	ETF	41.68	41.7481	41.35	41.61	170694.0
2007-04-18	AGG	ETF	100.19	100.24	100.06	100.23	160100.0
2007-04-18	AIQ	ETF	43.65	45.75	43.4	45.15	44300.0
2007-04-18	AIS	ETF	1.46	1.5	1.46	1.48	167400.0
2007-04-18	ARB	ETF	48.35	48.86	48.35	48.5	126100.0
2007-04-18	BAB	ETF	103.58	103.92	102.7	103.36	30000.0
2007-04-18	BBH	ETF	60.9667	61.1333	60.7667	60.86	257700.0
2007-04-18	BITS	ETF	33.08	33.64	32.48	33.2	14247.0
2007-04-18	BIV	ETF	75.28	75.34	75.28	75.33	1600.0
2007-04-18	BLV	ETF	75.6	75.76	75.6	75.65	12000.0
2007-04-18	BND	ETF	75.25	75.33	75.25	75.31	30400.0
2007-04-18	BNE	ETF	16.9	17.03	16.83	16.83	125600.0
2007-04-18	BOSS	ETF	48.99	48.99	48.52	48.52	200.0
2007-04-18	BRF	ETF	14.54	14.57	14.534	14.56	3800.0
2007-04-18	BSV	ETF	75.14	75.23	75.12	75.19	52200.0
2007-04-18	BTF	ETF	111.4	111.89999999999999	111.4	111.75	2220.0
2007-04-18	CBON	ETF	29.37	29.69	29.25	29.25	29333.0
2007-04-18	CDL	ETF	9.69	9.74	9.62	9.69	135500.0
2007-04-18	CEF	ETF	9.76	9.78	9.7	9.75	208400.0
2007-04-18	CGO	ETF	17.83	17.9	17.71	17.87	29200.0
2007-04-18	CHB	ETF	9.35	10.88	9.1	10.76	6734349.0
2007-04-18	CHI	ETF	20.13	20.26	20.12	20.19	84500.0
2007-04-18	CHIC	ETF	29.49	30.2	29.26	30.15	427608.0
2007-04-18	CHY	ETF	17.08	17.15	16.96	17.06	132700.0
2007-04-18	CN	ETF	53.5	53.6	53.11	53.24	26600.0
2007-04-18	CNXT	ETF	1.44	1.46	1.42	1.44	7257293.0
2007-04-18	CPST	ETF	1.16	1.19	1.13	1.14	2527415.0
2007-04-18	CSA	ETF	21.1299	21.13	20.92	21.0	15400.0
2007-04-18	CSB	ETF	33.68	33.98	33.57	33.86	12600.0
2007-04-18	CSD	ETF	28.52	28.58	28.45	28.55	34300.0
2007-04-18	CSM	ETF	1.3875	1.3875	1.3875	1.3875	2800.0
2007-04-18	CSQ	ETF	15.4	15.755	15.4	15.45	296200.0
2007-04-18	CTEC	ETF	89.55	91.54999999999998	88.3	89.04999999999998	10171.400000000001
2007-04-18	CVY	ETF	27.43	27.55	27.4	27.55	15100.0
2007-04-18	CWI	ETF	26.4867	26.6667	26.4867	26.58	90150.0
2007-04-18	CZA	ETF	25.82	25.82	25.82	25.82	300.0
2007-04-18	DBA	ETF	25.34	25.34	25.03	25.12	178100.0
2007-04-18	DBB	ETF	27.5	27.72	27.31	27.57	18100.0
2007-04-18	DBC	ETF	25.08	25.32	25.03	25.25	173400.0
2007-04-18	DBE	ETF	26.99	27.26	26.79	27.26	10500.0
2007-04-18	DBO	ETF	25.87	26.02	25.6	26.01	3800.0
2007-04-18	DBP	ETF	27.26	27.28	27.15	27.25	5200.0
2007-04-18	DBS	ETF	27.5	27.52	27.34	27.52	8500.0

> showing 50 of 449 rows — these rows as CSV

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