PREVIEW / etf_daily / 2008-02-04

all etf daily files

  file:    by_date/etf_daily/2008/2008-02-04.parquet
  size:    26 KB
  rows:    568

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-02-04	SPY	ETF	139.21	139.3	137.64	137.82	124694300.0
2008-02-04	QQQ	ETF	45.58	45.61	44.94	44.95	100209834.0
2008-02-04	IWM	ETF	72.54	72.6	71.68	71.79	54583900.0
2008-02-04	DIA	ETF	127.21	127.26	125.98	126.03	11722300.0
2008-02-04	GLD	ETF	88.51	89.52	88.05	89.1	10285000.0
2008-02-04	TLT	ETF	94.39	94.66	94.13	94.25	1729600.0
2008-02-04	ADRE	ETF	51.82	52.0	51.27	51.55	218541.0
2008-02-04	AGG	ETF	102.85	103.01	102.66	102.93	336200.0
2008-02-04	AIA	ETF	45.41	45.41	44.49	44.629	6100.0
2008-02-04	AIQ	ETF	52.95	53.0	50.25	51.25	76182.0
2008-02-04	AIS	ETF	1.09	1.1	1.02	1.08	111300.0
2008-02-04	AIVI	ETF	65.43	65.53	64.78	64.81	29700.0
2008-02-04	ARB	ETF	40.97	41.4799	39.69	40.13	230405.0
2008-02-04	BBH	ETF	55.3133	55.8033	55.25	55.65	497700.0
2008-02-04	BIL	ETF	91.62	91.72	91.62	91.72	50300.0
2008-02-04	BITS	ETF	23.2	23.2	21.76	21.88	11350.0
2008-02-04	BIV	ETF	79.0	79.17	78.79	79.15	110600.0
2008-02-04	BJK	ETF	43.54	43.54	43.35	43.35	2900.0
2008-02-04	BKF	ETF	53.76	53.85	53.15	53.17	39100.0
2008-02-04	BLV	ETF	77.33	77.52	77.23	77.4	14400.0
2008-02-04	BMVP	ETF	16.2133	16.32	16.2133	16.2467	146460.0
2008-02-04	BND	ETF	78.2	78.2	77.86	78.03	181700.0
2008-02-04	BNE	ETF	13.35	13.45	13.25	13.3	328000.0
2008-02-04	BOSS	ETF	38.51	39.0	38.51	39.0	100.0
2008-02-04	BSV	ETF	78.58	78.59	78.39	78.54	185600.0
2008-02-04	BTF	ETF	112.3	113.55	110.5	110.7	17500.0
2008-02-04	BWX	ETF	27.315	27.5038	27.315	27.4937	238138.0
2008-02-04	CBON	ETF	17.01	17.09	16.5	16.55	39783.0
2008-02-04	CDL	ETF	1.6	1.61	1.52	1.53	1071919.0
2008-02-04	CEF	ETF	12.09	12.29	11.92	12.27	808800.0
2008-02-04	CGO	ETF	17.89	18.0	17.41	17.49	22600.0
2008-02-04	CGW	ETF	24.03	24.24	23.8201	23.85	44527.0
2008-02-04	CHB	ETF	9.64	9.73	9.1	9.12	1235279.0
2008-02-04	CHI	ETF	16.24	16.47	16.22	16.34	112025.0
2008-02-04	CHIC	ETF	18.19	18.3	17.32	17.62	662713.0
2008-02-04	CHW	ETF	12.85	12.94	12.73	12.8	69824.0
2008-02-04	CHY	ETF	14.43	14.7699	14.43	14.67	146250.0
2008-02-04	CMF	ETF	52.915	52.94	52.8735	52.91	10080.0
2008-02-04	CN	ETF	65.0	65.55	64.07	65.08	226183.0
2008-02-04	CNXT	ETF	0.67	0.69	0.6511	0.66	3507333.0
2008-02-04	COW	ETF	46.41	46.57	46.25	46.57	9000.0
2008-02-04	CPI	ETF	20.9	20.9	20.52	20.52	18500.0
2008-02-04	CPST	ETF	1.47	1.53	1.47	1.53	1120517.0
2008-02-04	CSA	ETF	16.55	17.2499	16.53	17.18	22020.0
2008-02-04	CSD	ETF	25.51	25.51	25.33	25.33	29500.0
2008-02-04	CSQ	ETF	13.87	13.96	13.77	13.8	168535.0
2008-02-04	CUT	ETF	23.12	23.12	21.9	21.9	26700.0
2008-02-04	CVY	ETF	24.09	24.09	23.74	23.75	19400.0
2008-02-04	CWI	ETF	25.7867	25.7867	25.58	25.6333	214650.0
2008-02-04	CZA	ETF	24.46	24.58	24.46	24.52	1800.0

> showing 50 of 568 rows — these rows as CSV

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