PREVIEW / etf_daily / 2008-02-06

all etf daily files

  file:    by_date/etf_daily/2008/2008-02-06.parquet
  size:    25 KB
  rows:    562

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-06	SPY	ETF	134.58	135.25	132.41	133.05	250792900.0
2008-02-06	QQQ	ETF	43.92	44.17	42.77	42.81	178284962.0
2008-02-06	IWM	ETF	70.42	70.88	68.84	69.02	97259100.0
2008-02-06	DIA	ETF	123.41	123.92	121.81	122.26	14255000.0
2008-02-06	GLD	ETF	89.0	89.65	88.75	88.95	8787200.0
2008-02-06	TLT	ETF	94.63	94.85	94.36	94.68	1339800.0
2008-02-06	ADRE	ETF	49.11	49.72	48.22	48.28	438840.0
2008-02-06	AGG	ETF	103.24	103.24	102.92	103.17	698600.0
2008-02-06	AIA	ETF	42.52	42.81	41.2601	41.2601	15500.0
2008-02-06	AIQ	ETF	51.85	52.5	51.5	52.35	48360.0
2008-02-06	AIS	ETF	1.1	1.1	1.02	1.04	138500.0
2008-02-06	AIVI	ETF	62.62	63.04	61.81	61.93	55000.0
2008-02-06	ARB	ETF	40.01	40.24	39.09	39.6	206578.0
2008-02-06	BBH	ETF	54.5667	55.3733	54.5	54.5367	355500.0
2008-02-06	BIL	ETF	91.7	91.74	91.66	91.74	18100.0
2008-02-06	BITS	ETF	22.36	24.0	22.19	22.44	8205.0
2008-02-06	BIV	ETF	79.4	79.41	79.16	79.33	68100.0
2008-02-06	BJK	ETF	42.45	42.6	42.24	42.25	1600.0
2008-02-06	BKF	ETF	50.84	51.46	49.7301	50.032	57600.0
2008-02-06	BLV	ETF	77.6	77.64	77.31	77.49	10800.0
2008-02-06	BMVP	ETF	15.9133	15.98	15.7	15.7	53400.0
2008-02-06	BND	ETF	78.01	78.25	78.01	78.08	149000.0
2008-02-06	BNE	ETF	13.04	13.14	12.89	12.96	203000.0
2008-02-06	BRF	ETF	14.67	14.68	14.65	14.66	14200.0
2008-02-06	BSV	ETF	78.86	78.86	78.59	78.69	108600.0
2008-02-06	BTF	ETF	108.0495	109.1	107.55	107.89999999999999	6620.0
2008-02-06	BWX	ETF	27.325	27.33	27.25	27.31	312528.0
2008-02-06	CBON	ETF	15.57	16.36	15.11	16.03	67228.0
2008-02-06	CDL	ETF	1.5	1.53	1.39	1.39	2438865.0
2008-02-06	CEF	ETF	12.28	12.34	12.17	12.22	436100.0
2008-02-06	CGO	ETF	16.58	17.4	16.34	16.35	26300.0
2008-02-06	CGW	ETF	22.96	23.39	22.86	22.87	58700.0
2008-02-06	CHB	ETF	8.75	9.23	8.25	8.55	1383159.0
2008-02-06	CHI	ETF	16.1	16.22	16.02	16.05	130814.0
2008-02-06	CHIC	ETF	17.38	17.91	16.91	17.25	359190.0
2008-02-06	CHW	ETF	12.7	12.7	12.2	12.36	131397.0
2008-02-06	CHY	ETF	14.56	14.68	14.38	14.49	183596.0
2008-02-06	CMF	ETF	52.91	53.025	52.91	52.975	25800.0
2008-02-06	CN	ETF	60.51	60.51	57.86	57.99	247682.0
2008-02-06	CNXT	ETF	0.67	0.67	0.62	0.62	2307588.0
2008-02-06	COW	ETF	46.64	46.64	46.09	46.17	24700.0
2008-02-06	CPI	ETF	20.4	20.4	20.25	20.25	1300.0
2008-02-06	CPST	ETF	1.55	1.55	1.44	1.46	1867948.0
2008-02-06	CSA	ETF	16.64	17.95	16.29	16.37	116300.0
2008-02-06	CSD	ETF	24.53	24.74	24.37	24.37	7500.0
2008-02-06	CSQ	ETF	13.6	13.64	13.45	13.59	233075.0
2008-02-06	CUT	ETF	21.29	21.29	20.98	20.98	12200.0
2008-02-06	CVY	ETF	23.14	23.26	22.89	22.92	32400.0
2008-02-06	CWI	ETF	24.2733	24.8067	24.2733	24.42	54300.0
2008-02-06	CZA	ETF	23.78	23.78	23.75	23.75	1300.0

> showing 50 of 562 rows — these rows as CSV

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