PREVIEW / etf_daily / 2007-11-13

all etf daily files

  file:    by_date/etf_daily/2007/2007-11-13.parquet
  size:    24 KB
  rows:    532

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-13	SPY	ETF	145.37	148.31	145.22	148.08	191117400.0
2007-11-13	QQQ	ETF	49.39	50.79	49.35	50.74	255625879.0
2007-11-13	IWM	ETF	77.18	78.74	77.13	78.5	105192100.0
2007-11-13	DIA	ETF	130.84	133.4	130.8	133.14	15043400.0
2007-11-13	GLD	ETF	79.4	79.93	77.86	79.12	11438200.0
2007-11-13	TLT	ETF	91.42	91.49	91.17	91.32	1116600.0
2007-11-13	ADRE	ETF	52.65	55.4399	52.65	55.29	702958.0
2007-11-13	AGG	ETF	100.75	100.81	100.55	100.67	276100.0
2007-11-13	AIQ	ETF	45.95	46.1	44.35	44.8	57620.0
2007-11-13	AIS	ETF	1.08	1.1	1.05	1.1	429100.0
2007-11-13	AIVI	ETF	73.28	74.3	71.35	74.29	83600.0
2007-11-13	ARB	ETF	51.07	51.92	50.89	51.53	461200.0
2007-11-13	BBH	ETF	57.7633	58.0367	57.0867	58.0133	637200.0
2007-11-13	BIL	ETF	91.76	91.8	91.72	91.76	31400.0
2007-11-13	BITS	ETF	24.24	24.96	22.0	23.0	26936.0
2007-11-13	BIV	ETF	76.95	76.95	76.39	76.41	12800.0
2007-11-13	BLV	ETF	76.5	76.56	76.32	76.34	6900.0
2007-11-13	BMVP	ETF	16.92	17.1367	16.87	17.1067	64600.0
2007-11-13	BND	ETF	76.32	76.35	76.19	76.24	66900.0
2007-11-13	BNE	ETF	16.9	16.96	16.68	16.89	136200.0
2007-11-13	BRF	ETF	14.68	14.68	14.62	14.62	28400.0
2007-11-13	BSV	ETF	76.71	76.71	76.5	76.5	42600.0
2007-11-13	BTF	ETF	111.8	113.35000000000001	111.3	113.35000000000001	2400.0
2007-11-13	BWX	ETF	27.075	27.075	26.9642	27.015	305600.0
2007-11-13	CBON	ETF	20.21	21.08	19.68	20.69	210932.0
2007-11-13	CDL	ETF	2.68	3.0	2.68	2.97	5945110.0
2007-11-13	CEF	ETF	10.4	10.55	10.25	10.45	552100.0
2007-11-13	CGO	ETF	18.69	18.86	18.64	18.64	27000.0
2007-11-13	CGW	ETF	25.2	25.54	25.12	25.48	88200.0
2007-11-13	CHB	ETF	10.15	10.92	10.01	10.78	1345400.0
2007-11-13	CHI	ETF	14.82	15.11	14.74	15.11	163201.0
2007-11-13	CHIC	ETF	13.99	14.53	13.82	14.35	479851.0
2007-11-13	CHW	ETF	12.37	12.69	12.15	12.6	292100.0
2007-11-13	CHY	ETF	13.3	13.386	13.15	13.33	201000.0
2007-11-13	CMF	ETF	51.6	51.635	51.6	51.6	9600.0
2007-11-13	CN	ETF	51.51	53.95	51.36	53.66	371200.0
2007-11-13	CNXT	ETF	1.18	1.23	1.17	1.22	4372529.0
2007-11-13	COW	ETF	48.35	48.89	48.35	48.86	4900.0
2007-11-13	CPI	ETF	24.3	25.0	24.3	25.0	1000.0
2007-11-13	CPST	ETF	1.18	1.27	1.18	1.26	1946529.0
2007-11-13	CSA	ETF	16.61	16.83	16.1	16.68	60400.0
2007-11-13	CSD	ETF	27.18	27.52	27.12	27.46	8600.0
2007-11-13	CSM	ETF	1.4725	1.4725	1.4725	1.4725	12400.0
2007-11-13	CSQ	ETF	13.61	13.88	13.61	13.85	237100.0
2007-11-13	CUT	ETF	26.43	27.75	24.45	24.65	37900.0
2007-11-13	CVY	ETF	24.29	25.03	24.29	25.03	22100.0
2007-11-13	CWI	ETF	28.4133	28.8133	28.4067	28.8067	24300.0
2007-11-13	CZA	ETF	25.79	26.02	25.79	26.02	2100.0
2007-11-13	DBA	ETF	29.75	29.75	29.35	29.39	217500.0
2007-11-13	DBB	ETF	24.47	24.65	24.27	24.42	23100.0

> showing 50 of 532 rows — these rows as CSV

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