PREVIEW / etf_daily / 2007-12-14

all etf daily files

  file:    by_date/etf_daily/2007/2007-12-14.parquet
  size:    25 KB
  rows:    548

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-12-14	SPY	ETF	147.93	149.1	147.1	147.17	159152900.0
2007-12-14	QQQ	ETF	51.09	51.6	50.92	50.97	128407935.0
2007-12-14	IWM	ETF	75.76	76.87	74.95	75.0	75866900.0
2007-12-14	DIA	ETF	134.35	135.13	133.42	133.45	12506900.0
2007-12-14	GLD	ETF	78.41	78.57	77.82	78.52	6827000.0
2007-12-14	TLT	ETF	90.79	90.92	90.5	90.61	1354900.0
2007-12-14	ADRE	ETF	54.24	54.84	53.9	54.19	374344.0
2007-12-14	AGG	ETF	100.6	100.62	100.24	100.38	515300.0
2007-12-14	AIA	ETF	48.4	48.4	47.16	47.26	15400.0
2007-12-14	AIQ	ETF	45.85	46.75	44.8	45.55	51340.0
2007-12-14	AIS	ETF	1.03	1.05	1.01	1.03	94500.0
2007-12-14	AIVI	ETF	72.7	72.92	71.91	72.08	61500.0
2007-12-14	ARB	ETF	41.8	41.93	40.95	41.6	405000.0
2007-12-14	BBH	ETF	55.2367	55.5067	54.8333	54.9133	428400.0
2007-12-14	BIL	ETF	91.8	91.82	91.72	91.74	33000.0
2007-12-14	BITS	ETF	22.84	24.52	22.84	23.12	7982.0
2007-12-14	BIV	ETF	76.51	76.6	76.32	76.4	20900.0
2007-12-14	BKF	ETF	58.16	58.5	57.8	58.15	11500.0
2007-12-14	BLV	ETF	75.16	75.16	74.98	75.0	3700.0
2007-12-14	BMVP	ETF	17.55	17.55	17.3	17.3	19785.0
2007-12-14	BND	ETF	76.15	76.31	76.09	76.17	265300.0
2007-12-14	BNE	ETF	17.92	18.1	17.48	17.5	113600.0
2007-12-14	BRF	ETF	14.58	14.58	14.58	14.58	8300.0
2007-12-14	BSV	ETF	76.97	76.98	76.7	76.84	61600.0
2007-12-14	BTF	ETF	113.8	114.55	112.79999999999998	112.89999999999999	1060.0
2007-12-14	BWX	ETF	26.44	26.445	26.24	26.3	148600.0
2007-12-14	CBON	ETF	17.2	17.3501	16.51	16.51	119964.0
2007-12-14	CDL	ETF	2.13	2.13	2.02	2.05	2044574.0
2007-12-14	CEF	ETF	10.45	10.49	10.2	10.43	411500.0
2007-12-14	CGO	ETF	19.1	19.18	18.95	19.12	17400.0
2007-12-14	CGW	ETF	24.8	25.39	24.68	25.11	207700.0
2007-12-14	CHB	ETF	8.67	8.98	8.45	8.45	1056214.0
2007-12-14	CHI	ETF	14.02	14.23	13.9	14.1	225800.0
2007-12-14	CHIC	ETF	15.74	15.74	15.101	15.17	246744.0
2007-12-14	CHW	ETF	12.64	12.68	12.5	12.58	359000.0
2007-12-14	CHY	ETF	13.4	13.4	13.15	13.19	295000.0
2007-12-14	CMF	ETF	51.82	51.82	51.78	51.78	1400.0
2007-12-14	CN	ETF	61.49	62.26	60.78	61.62	347100.0
2007-12-14	CNXT	ETF	0.98	1.0	0.9151	0.92	9279621.0
2007-12-14	COW	ETF	47.85	48.69	46.28	47.61	18100.0
2007-12-14	CPST	ETF	1.64	1.67	1.52	1.53	5298492.0
2007-12-14	CSA	ETF	15.96	16.19	15.96	16.12	17900.0
2007-12-14	CSD	ETF	27.13	27.21	26.94	26.94	4400.0
2007-12-14	CSQ	ETF	14.04	14.12	13.91	14.0	268350.0
2007-12-14	CUT	ETF	23.99	23.99	23.5	23.65	14800.0
2007-12-14	CVY	ETF	23.66	23.82	23.49	23.49	74700.0
2007-12-14	CWI	ETF	28.2133	28.2133	27.7467	27.7467	120750.0
2007-12-14	CZA	ETF	25.9	25.91	25.9	25.91	3500.0
2007-12-14	DBA	ETF	32.27	32.4	31.98	32.21	465800.0
2007-12-14	DBB	ETF	22.65	22.74	22.55	22.56	29000.0

> showing 50 of 548 rows — these rows as CSV

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