PREVIEW / etf_daily / 2007-08-15

all etf daily files

  file:    by_date/etf_daily/2007/2007-08-15.parquet
  size:    23 KB
  rows:    500

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-08-15	SPY	ETF	142.72	144.46	140.62	141.04	323834000.0
2007-08-15	QQQ	ETF	46.68	47.09	45.813	45.9	214854094.0
2007-08-15	IWM	ETF	75.97	77.4	74.74	75.2	145850300.0
2007-08-15	DIA	ETF	130.21	131.29	128.47	128.85	28964000.0
2007-08-15	GLD	ETF	65.78	66.43	65.57	66.13	5886400.0
2007-08-15	TLT	ETF	86.65	86.75	86.25	86.25	1101700.0
2007-08-15	ADRE	ETF	42.54	42.959	41.07	41.156	582765.0
2007-08-15	AGG	ETF	98.79	98.8	98.47	98.73	224900.0
2007-08-15	AIQ	ETF	43.75	44.6	41.6	41.9	39680.0
2007-08-15	AIS	ETF	1.28	1.39	1.28	1.3501	573200.0
2007-08-15	ARB	ETF	51.0	52.27	50.79	51.4	268200.0
2007-08-15	BBH	ETF	54.5667	55.0	53.9467	54.1467	576600.0
2007-08-15	BIL	ETF	91.8	91.84	91.76	91.78	40400.0
2007-08-15	BITS	ETF	26.76	26.88	25.4	25.84	12208.0
2007-08-15	BIV	ETF	74.67	74.77	74.42	74.64	15100.0
2007-08-15	BLV	ETF	73.45	73.45	73.11	73.26	10100.0
2007-08-15	BMVP	ETF	16.2933	16.44	16.0067	16.0333	119700.0
2007-08-15	BND	ETF	74.72	74.72	74.31	74.65	33600.0
2007-08-15	BNE	ETF	16.87	16.87	15.64	15.67	408300.0
2007-08-15	BRF	ETF	14.47	14.49	14.47	14.48	23700.0
2007-08-15	BSV	ETF	75.46	75.55	75.4	75.55	22500.0
2007-08-15	BTF	ETF	100.5	101.44999999999999	98.85	99.35	4660.0
2007-08-15	CBON	ETF	23.22	23.95	22.78	22.78	45457.0
2007-08-15	CDL	ETF	4.4	4.43	4.23	4.26	2769288.0
2007-08-15	CEF	ETF	9.16	9.35	9.13	9.18	393400.0
2007-08-15	CGO	ETF	15.5	15.63	14.52	14.67	74800.0
2007-08-15	CGW	ETF	23.51	23.7599	23.05	23.05	166700.0
2007-08-15	CHB	ETF	10.56	11.07	9.78	9.83	2636400.0
2007-08-15	CHI	ETF	15.1	15.44	14.91	15.3799	504700.0
2007-08-15	CHIC	ETF	17.0	17.25	16.6	16.63	461763.0
2007-08-15	CHW	ETF	12.6	12.8	11.71	12.05	325600.0
2007-08-15	CHY	ETF	13.44	13.45	12.77	12.93	677100.0
2007-08-15	CN	ETF	46.45	47.23	45.27	45.51	211800.0
2007-08-15	CNXT	ETF	1.26	1.29	1.2	1.2	9108725.0
2007-08-15	CPI	ETF	27.98	27.98	27.25	27.25	1200.0
2007-08-15	CPST	ETF	1.02	1.05	1.01	1.01	593541.0
2007-08-15	CSA	ETF	16.44	16.74	16.19	16.2	70300.0
2007-08-15	CSD	ETF	28.17	28.36	27.65	27.68	21200.0
2007-08-15	CSQ	ETF	13.5	13.5999	12.83	13.0	626100.0
2007-08-15	CTEC	ETF	100.25	103.2	100.0	100.74999999999999	22484.2
2007-08-15	CVY	ETF	24.82	25.19	24.53	24.53	73200.0
2007-08-15	CWI	ETF	25.5067	25.7	24.76	25.0933	117000.0
2007-08-15	CZA	ETF	24.8	24.8	24.8	24.8	600.0
2007-08-15	DBA	ETF	26.43	26.51	26.04	26.13	264500.0
2007-08-15	DBB	ETF	25.76	25.88	25.6	25.85	51800.0
2007-08-15	DBC	ETF	25.58	25.81	25.4	25.62	313100.0
2007-08-15	DBE	ETF	28.23	28.71	28.23	28.37	7600.0
2007-08-15	DBO	ETF	26.41	26.9	26.41	26.66	42800.0
2007-08-15	DBP	ETF	25.85	26.08	25.78	25.99	5900.0
2007-08-15	DBS	ETF	24.52	24.9	24.52	24.6724	2100.0

> showing 50 of 500 rows — these rows as CSV

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