PREVIEW / etf_daily / 2008-01-16

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-16.parquet
  size:    26 KB
  rows:    566

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
2008-01-16	SPY	ETF	137.36	139.12	136.28	136.98	378802600.0
2008-01-16	QQQ	ETF	46.19	46.91	45.46	46.05	265725123.0
2008-01-16	IWM	ETF	69.24	70.71	68.72	69.57	135714800.0
2008-01-16	DIA	ETF	124.64	126.14	123.94	124.65	25572000.0
2008-01-16	GLD	ETF	88.17	88.66	86.32	86.7	26919000.0
2008-01-16	TLT	ETF	95.68	95.89	94.73	94.92	3505100.0
2008-01-16	ADRE	ETF	50.03	50.6199	48.07	49.06	1188477.0
2008-01-16	AGG	ETF	102.96	103.07	102.6	102.65	620900.0
2008-01-16	AIA	ETF	43.25	43.52	42.27	42.79	19700.0
2008-01-16	AIQ	ETF	48.5	50.15	48.5	49.45	63920.0
2008-01-16	AIS	ETF	0.9501	0.98	0.94	0.98	16900.0
2008-01-16	AIVI	ETF	66.44	66.96	65.51	65.74	55300.0
2008-01-16	ARB	ETF	40.93	42.33	40.87	41.36	181325.0
2008-01-16	BBH	ETF	55.4867	56.5167	55.4867	55.84	1046100.0
2008-01-16	BIL	ETF	91.7	91.72	91.54	91.68	254500.0
2008-01-16	BITS	ETF	21.838	23.16	21.24	22.72	9606.0
2008-01-16	BIV	ETF	78.92	79.03	78.63	78.8	45200.0
2008-01-16	BKF	ETF	55.0	55.3	53.17	53.47	63200.0
2008-01-16	BLV	ETF	78.0	78.24	77.57	77.57	13600.0
2008-01-16	BMVP	ETF	16.1133	16.3133	16.0067	16.1033	257514.0
2008-01-16	BND	ETF	77.92	78.21	77.9	78.0	173700.0
2008-01-16	BNE	ETF	13.26	13.49	13.185	13.27	334000.0
2008-01-16	BRF	ETF	14.63	14.63	14.6	14.63	20500.0
2008-01-16	BSV	ETF	78.12	78.12	77.96	78.06	56600.0
2008-01-16	BTF	ETF	106.5	106.56499999999998	102.55	104.55	6680.0
2008-01-16	BWX	ETF	27.39	27.515	27.275	27.34	135254.0
2008-01-16	CBON	ETF	14.76	15.33	14.65	15.01	52285.0
2008-01-16	CDL	ETF	1.51	1.7	1.51	1.62	1609274.0
2008-01-16	CEF	ETF	11.16	11.48	11.03	11.25	923000.0
2008-01-16	CGO	ETF	18.54	18.59	18.02	18.12	37400.0
2008-01-16	CGW	ETF	23.51	24.0	23.2	23.58	85300.0
2008-01-16	CHB	ETF	7.64	8.04	7.52	7.67	1398529.0
2008-01-16	CHI	ETF	15.94	15.94	15.64	15.82	184395.0
2008-01-16	CHIC	ETF	14.46	14.55	13.55	14.35	2376042.0
2008-01-16	CHW	ETF	12.95	12.95	12.62	12.89	166350.0
2008-01-16	CHY	ETF	14.12	14.22	13.91	14.2	207592.0
2008-01-16	CMF	ETF	53.095	53.12	52.9849	52.9849	27400.0
2008-01-16	CN	ETF	61.01	61.73	59.13	60.74	366897.0
2008-01-16	CNXT	ETF	0.7	0.7395	0.69	0.7199	15703344.0
2008-01-16	COW	ETF	45.13	45.19	44.42	44.56	13500.0
2008-01-16	CPI	ETF	22.5	22.5	21.9858	22.0	4300.0
2008-01-16	CPST	ETF	1.46	1.53	1.37	1.53	2885899.0
2008-01-16	CSA	ETF	15.9	16.0	15.13	15.94	46300.0
2008-01-16	CSD	ETF	23.99	24.34	23.87	24.15	15200.0
2008-01-16	CSQ	ETF	13.81	13.94	13.72	13.85	344466.0
2008-01-16	CUT	ETF	21.51	21.55	20.91	21.05	27100.0
2008-01-16	CVY	ETF	22.03	22.3	21.84	22.09	37300.0
2008-01-16	CWI	ETF	25.1533	25.76	24.9133	25.2467	151500.0
2008-01-16	CZA	ETF	23.81	24.02	23.76	24.02	8100.0
2008-01-16	DBA	ETF	36.12	36.45	35.58	36.43	2867500.0

> showing 50 of 566 rows — these rows as CSV

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