PREVIEW / etf_daily / 2008-01-22

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-22.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-22	SPY	ETF	127.21	132.43	126.0	130.72	435923700.0
2008-01-22	QQQ	ETF	42.83	44.77	42.73	44.18	325732226.0
2008-01-22	IWM	ETF	64.47	68.13	64.19	66.74	150963700.0
2008-01-22	DIA	ETF	116.31	120.69	115.8	119.22	38318000.0
2008-01-22	GLD	ETF	86.14	88.44	85.77	88.17	20679600.0
2008-01-22	TLT	ETF	96.41	96.62	95.3	96.51	5423500.0
2008-01-22	ADRE	ETF	44.82	48.18	42.01	47.48	1375076.0
2008-01-22	AGG	ETF	103.97	105.49	102.88	103.41	793000.0
2008-01-22	AIA	ETF	43.99	44.28	38.85	43.32	8500.0
2008-01-22	AIQ	ETF	48.2	49.75	48.2	48.8	57736.0
2008-01-22	AIS	ETF	0.94	0.95	0.9	0.93	201600.0
2008-01-22	AIVI	ETF	60.32	62.84	59.0	62.49	112500.0
2008-01-22	ARB	ETF	38.69	41.13	38.69	40.16	334804.0
2008-01-22	BBH	ETF	51.7167	54.0367	51.7167	53.5333	1823700.0
2008-01-22	BIL	ETF	91.76	91.82	91.66	91.74	116400.0
2008-01-22	BITS	ETF	20.92	21.72	19.56	21.16	22414.0
2008-01-22	BIV	ETF	79.91	79.91	79.35	79.85	57900.0
2008-01-22	BKF	ETF	48.48	54.53	47.9	50.2886	62900.0
2008-01-22	BLV	ETF	78.3	78.3	77.76	77.91	8400.0
2008-01-22	BMVP	ETF	14.43	15.4833	12.3367	15.22	226566.0
2008-01-22	BND	ETF	78.61	78.77	78.25	78.77	205700.0
2008-01-22	BNE	ETF	12.23	12.62	12.13	12.26	836400.0
2008-01-22	BRF	ETF	14.57	14.66	14.57	14.6	16700.0
2008-01-22	BSV	ETF	78.78	78.78	78.43	78.72	105200.0
2008-01-22	BTF	ETF	99.0	101.75	97.5	101.75	4000.0
2008-01-22	BWX	ETF	27.415	27.415	26.755	27.27	178042.0
2008-01-22	CBON	ETF	13.32	14.71	12.79	14.32	116900.0
2008-01-22	CDL	ETF	1.51	1.6	1.41	1.52	1421740.0
2008-01-22	CEF	ETF	10.99	11.51	10.96	11.3	1418200.0
2008-01-22	CGO	ETF	15.27	16.63	15.25	16.47	148765.0
2008-01-22	CGW	ETF	20.5	22.51	19.0	22.36	197314.0
2008-01-22	CHB	ETF	7.4	8.95	7.38	8.45	2420012.0
2008-01-22	CHI	ETF	14.22	15.03	13.19	14.96	255447.0
2008-01-22	CHIC	ETF	13.69	15.43	13.37	14.95	861092.0
2008-01-22	CHW	ETF	11.74	11.75	10.85	11.63	263655.0
2008-01-22	CHY	ETF	13.0	13.39	12.54	13.25	363835.0
2008-01-22	CMF	ETF	53.23	53.395	53.23	53.395	3200.0
2008-01-22	CN	ETF	54.84	59.19	54.2	56.91	602524.0
2008-01-22	CNXT	ETF	0.6	0.6396	0.5503	0.62	3757232.0
2008-01-22	COW	ETF	44.46	45.3	44.46	44.98	18600.0
2008-01-22	CPI	ETF	22.4	22.4	22.0	22.0	1600.0
2008-01-22	CPST	ETF	1.22	1.38	1.2	1.34	2587445.0
2008-01-22	CSA	ETF	15.16	16.36	15.15	15.71	54100.0
2008-01-22	CSD	ETF	21.87	23.13	21.87	22.97	31400.0
2008-01-22	CSQ	ETF	12.41	13.09	12.25	13.09	463077.0
2008-01-22	CUT	ETF	18.49	21.95	13.15	20.2	68400.0
2008-01-22	CVY	ETF	20.11	21.53	20.04	21.37	28500.0
2008-01-22	CWI	ETF	23.34	24.38	22.3667	24.24	263100.0
2008-01-22	CZA	ETF	22.57	22.69	22.38	22.69	1800.0
2008-01-22	DBA	ETF	35.51	36.32	34.96	35.64	3400800.0

> showing 50 of 566 rows — these rows as CSV

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