PREVIEW / etf_daily / 2007-11-15

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-15.parquet
  size:    24 KB
  rows:    533

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-11-15	SPY	ETF	146.57	147.49	144.52	145.54	263111100.0
2007-11-15	QQQ	ETF	50.0	50.54	49.37	49.82	251548792.0
2007-11-15	IWM	ETF	77.62	77.89	76.24	76.94	114145000.0
2007-11-15	DIA	ETF	132.16	132.89	130.82	131.47	18693600.0
2007-11-15	GLD	ETF	79.18	79.5	77.3	77.95	10908200.0
2007-11-15	TLT	ETF	91.61	92.56	91.49	92.28	1312900.0
2007-11-15	ADRE	ETF	55.0	55.22	53.65	54.16	419563.0
2007-11-15	AGG	ETF	100.81	101.11	100.63	101.06	493500.0
2007-11-15	AIQ	ETF	44.75	45.35	44.3	44.75	57120.0
2007-11-15	AIS	ETF	1.17	1.17	1.09	1.11	211700.0
2007-11-15	AIVI	ETF	72.75	73.08	71.55	71.94	327000.0
2007-11-15	ARB	ETF	50.65	51.03	49.68	50.53	240000.0
2007-11-15	BBH	ETF	58.3	59.0067	58.23	58.4	411300.0
2007-11-15	BIL	ETF	91.74	91.82	91.68	91.78	230900.0
2007-11-15	BITS	ETF	22.6	23.8	21.4	23.12	27008.0
2007-11-15	BIV	ETF	76.71	76.91	76.45	76.89	24000.0
2007-11-15	BLV	ETF	76.6	76.74	76.3	76.72	27200.0
2007-11-15	BMVP	ETF	17.02	17.08	16.8	16.87	95700.0
2007-11-15	BND	ETF	76.36	76.52	76.27	76.51	94400.0
2007-11-15	BNE	ETF	16.93	17.18	16.86	16.96	202400.0
2007-11-15	BRF	ETF	14.64	14.64	14.64	14.64	6200.0
2007-11-15	BSV	ETF	76.74	76.87	76.71	76.79	31000.0
2007-11-15	BTF	ETF	112.85	112.85	111.99999999999999	111.99999999999999	1000.0
2007-11-15	BWX	ETF	27.09	27.1	27.06	27.075	77400.0
2007-11-15	CBON	ETF	20.13	20.35	19.58	19.6	41365.0
2007-11-15	CDL	ETF	2.55	2.7	2.48	2.56	3534550.0
2007-11-15	CEF	ETF	10.65	10.65	10.47	10.49	400800.0
2007-11-15	CGO	ETF	18.73	18.77	18.16	18.21	21800.0
2007-11-15	CGW	ETF	25.45	25.5	25.02	25.45	74100.0
2007-11-15	CHB	ETF	10.51	10.65	9.98	10.07	1336230.0
2007-11-15	CHI	ETF	15.12	15.3099	14.95	15.04	206901.0
2007-11-15	CHIC	ETF	16.0	16.41	15.35	15.72	2031168.0
2007-11-15	CHW	ETF	12.39	12.5	12.22	12.27	197500.0
2007-11-15	CHY	ETF	13.8	13.8	13.16	13.24	224838.0
2007-11-15	CMF	ETF	51.7	51.75	51.7	51.75	2400.0
2007-11-15	CN	ETF	52.46	53.03	51.71	52.15	192000.0
2007-11-15	CNXT	ETF	1.18	1.23	1.17	1.21	6935182.0
2007-11-15	COW	ETF	48.56	48.93	48.56	48.75	3200.0
2007-11-15	CPST	ETF	1.22	1.26	1.2	1.25	1783246.0
2007-11-15	CSA	ETF	17.3	17.89	17.3	17.6	175100.0
2007-11-15	CSD	ETF	27.36	27.36	27.0	27.07	9000.0
2007-11-15	CSQ	ETF	13.87	13.87	13.4215	13.5	314700.0
2007-11-15	CUT	ETF	24.65	24.75	24.35	24.4	14100.0
2007-11-15	CVY	ETF	24.83	24.83	24.36	24.43	20400.0
2007-11-15	CWI	ETF	28.3467	28.4533	27.9267	28.1467	28950.0
2007-11-15	CZA	ETF	25.78	25.78	25.68	25.68	1200.0
2007-11-15	DBA	ETF	29.95	30.1	29.46	29.46	334900.0
2007-11-15	DBB	ETF	24.34	24.46	24.04	24.19	51900.0
2007-11-15	DBC	ETF	30.37	30.37	29.97	30.22	341532.0
2007-11-15	DBE	ETF	34.12	34.41	33.62	34.41	79700.0

> showing 50 of 533 rows — these rows as CSV

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