PREVIEW / etf_daily / 2008-02-08

all etf daily files

  file:    by_date/etf_daily/2008/2008-02-08.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-08	SPY	ETF	133.09	134.22	132.1	133.07	221643500.0
2008-02-08	QQQ	ETF	43.18	43.77	42.94	43.6	173781243.0
2008-02-08	IWM	ETF	69.95	70.64	69.0	69.67	86493200.0
2008-02-08	DIA	ETF	122.18	122.88	121.08	121.75	15522000.0
2008-02-08	GLD	ETF	90.0	91.0	89.99	91.0	9128200.0
2008-02-08	TLT	ETF	93.25	93.73	93.09	93.7	2832800.0
2008-02-08	ADRE	ETF	48.78	49.3499	48.49	49.06	481040.0
2008-02-08	AGG	ETF	102.64	102.9	102.48	102.75	543400.0
2008-02-08	AIA	ETF	42.23	42.23	41.67	41.91	8000.0
2008-02-08	AIQ	ETF	52.0	53.0	50.75	52.25	38900.0
2008-02-08	AIS	ETF	1.0	1.02	0.95	1.0	77900.0
2008-02-08	AIVI	ETF	60.64	61.55	60.54	61.1	53400.0
2008-02-08	ARB	ETF	39.4	40.07	38.85	39.54	176400.0
2008-02-08	BBH	ETF	54.2367	54.2367	53.88	54.1333	507600.0
2008-02-08	BIL	ETF	91.72	91.72	91.62	91.72	14250.0
2008-02-08	BITS	ETF	21.96	23.324	21.96	22.68	12550.0
2008-02-08	BIV	ETF	78.98	79.06	78.72	79.06	41200.0
2008-02-08	BJK	ETF	42.4	42.4	42.36	42.4	500.0
2008-02-08	BKF	ETF	52.73	52.73	49.98	50.24	47200.0
2008-02-08	BLV	ETF	76.54	76.91	76.42	76.91	17100.0
2008-02-08	BMVP	ETF	15.8367	15.91	15.7167	15.8033	91600.0
2008-02-08	BND	ETF	77.8	77.91	77.66	77.83	88000.0
2008-02-08	BNE	ETF	13.0	13.68	12.89	12.99	375700.0
2008-02-08	BRF	ETF	14.7001	14.71	14.7001	14.71	401.0
2008-02-08	BSV	ETF	78.61	78.71	78.54	78.66	87600.0
2008-02-08	BTF	ETF	107.5	108.64999999999999	107.5	108.2	6020.0
2008-02-08	BWX	ETF	27.05	27.2	27.05	27.185	226802.0
2008-02-08	CBON	ETF	16.32	16.38	15.57	15.61	51809.0
2008-02-08	CDL	ETF	1.43	1.49	1.35	1.38	1618601.0
2008-02-08	CEF	ETF	12.37	12.6	12.37	12.57	549900.0
2008-02-08	CGO	ETF	16.35	16.5	16.3	16.4	16200.0
2008-02-08	CGW	ETF	22.7	22.98	22.5	22.68	48998.0
2008-02-08	CHB	ETF	8.79	9.05	8.28	8.88	1232499.0
2008-02-08	CHI	ETF	16.0	16.11	15.81	15.9719	158292.0
2008-02-08	CHIC	ETF	17.91	18.5	17.65	18.31	981982.0
2008-02-08	CHW	ETF	11.99	12.19	11.97	12.15	102300.0
2008-02-08	CHY	ETF	14.45	14.53	14.36	14.41	131122.0
2008-02-08	CMF	ETF	52.85	52.955	52.85	52.94	24400.0
2008-02-08	CN	ETF	58.55	59.33	57.52	58.39	155614.0
2008-02-08	CNXT	ETF	0.6	0.61	0.57	0.58	2749938.0
2008-02-08	COW	ETF	46.33	46.6	46.21	46.26	14100.0
2008-02-08	CPST	ETF	1.45	1.49	1.42	1.49	965364.0
2008-02-08	CSA	ETF	16.13	16.25	15.73	15.99	207400.0
2008-02-08	CSD	ETF	24.14	24.35	24.14	24.23	10900.0
2008-02-08	CSQ	ETF	13.37	13.43	13.09	13.27	285009.0
2008-02-08	CUT	ETF	21.03	21.15	20.93	21.1	9600.0
2008-02-08	CVY	ETF	23.07	23.2	22.8	22.95	19400.0
2008-02-08	CWI	ETF	23.8	24.3667	23.8	24.2267	140850.0
2008-02-08	CZA	ETF	23.69	23.716	23.69	23.716	6500.0
2008-02-08	DBA	ETF	38.65	39.4	38.4	39.03	2587200.0

> showing 50 of 568 rows — these rows as CSV

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