PREVIEW / etf_daily / 2008-01-24

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-24.parquet
  size:    25 KB
  rows:    563

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-24	SPY	ETF	134.48	135.46	133.31	134.99	259949300.0
2008-01-24	QQQ	ETF	44.19	44.93	44.06	44.91	250249051.0
2008-01-24	IWM	ETF	69.48	70.23	68.28	68.97	113683300.0
2008-01-24	DIA	ETF	122.9	123.92	122.26	123.43	20563200.0
2008-01-24	GLD	ETF	89.72	90.25	89.13	90.08	10627200.0
2008-01-24	TLT	ETF	95.55	95.75	94.34	94.36	5676700.0
2008-01-24	ADRE	ETF	48.0	49.52	47.99	49.03	627215.0
2008-01-24	AGG	ETF	103.45	103.45	102.71	102.84	469200.0
2008-01-24	AIA	ETF	42.79	43.51	42.79	43.49	16300.0
2008-01-24	AIQ	ETF	50.2	51.15	49.75	50.0	41920.0
2008-01-24	AIS	ETF	0.82	0.9	0.82	0.88	185836.0
2008-01-24	AIVI	ETF	62.67	64.9	62.37	64.9	82400.0
2008-01-24	ARB	ETF	41.84	42.1	39.83	40.31	923300.0
2008-01-24	BBH	ETF	53.0867	53.95	53.0867	53.6333	1082100.0
2008-01-24	BIL	ETF	91.76	91.88	91.74	91.88	47750.0
2008-01-24	BITS	ETF	20.68	21.1996	20.68	21.08	5736.0
2008-01-24	BIV	ETF	79.56	79.58	78.94	78.99	38300.0
2008-01-24	BJK	ETF	41.4	41.4	41.35	41.35	700.0
2008-01-24	BKF	ETF	50.68	51.51	50.3	51.17	143000.0
2008-01-24	BLV	ETF	77.93	78.11	77.34	77.38	53500.0
2008-01-24	BMVP	ETF	15.5	15.7066	15.5	15.6867	48650.0
2008-01-24	BND	ETF	78.38	78.53	78.0	78.13	136200.0
2008-01-24	BNE	ETF	12.48	13.06	12.31	12.84	515500.0
2008-01-24	BSV	ETF	78.59	78.76	78.2	78.46	332600.0
2008-01-24	BTF	ETF	104.14999999999999	106.19999999999999	104.14999999999999	105.6995	3480.0
2008-01-24	BWX	ETF	27.38	27.38	27.25	27.36	175590.0
2008-01-24	CBON	ETF	15.59	16.41	14.26	16.37	132364.0
2008-01-24	CDL	ETF	1.63	1.69	1.58	1.63	1344709.0
2008-01-24	CEF	ETF	11.48	11.7	11.48	11.7	667300.0
2008-01-24	CGO	ETF	17.05	17.2	16.7201	17.03	25696.0
2008-01-24	CGW	ETF	23.37	23.37	22.2	22.97	190535.0
2008-01-24	CHB	ETF	8.91	9.56	8.68	9.07	2510682.0
2008-01-24	CHI	ETF	15.26	15.64	15.26	15.63	111553.0
2008-01-24	CHIC	ETF	15.95	16.54	15.75	16.1	1857121.0
2008-01-24	CHW	ETF	11.95	12.15	11.8	12.09	157658.0
2008-01-24	CHY	ETF	13.78	13.95	13.66	13.95	162092.0
2008-01-24	CMF	ETF	52.97	53.0	52.925	52.985	2200.0
2008-01-24	CN	ETF	59.58	61.5	58.7	60.5	423454.0
2008-01-24	CNXT	ETF	0.67	0.69	0.63	0.63	5140342.0
2008-01-24	COW	ETF	45.07	45.54	45.07	45.2	12051.0
2008-01-24	CPI	ETF	21.5	21.5	21.25	21.25	2300.0
2008-01-24	CPST	ETF	1.38	1.48	1.36	1.46	2097856.0
2008-01-24	CSA	ETF	15.95	15.95	15.21	15.61	83101.0
2008-01-24	CSD	ETF	24.0	24.22	23.85	24.22	8400.0
2008-01-24	CSQ	ETF	13.21	13.57	13.14	13.39	305600.0
2008-01-24	CUT	ETF	21.17	21.17	20.66	20.9	35900.0
2008-01-24	CVY	ETF	22.39	22.74	22.39	22.63	33100.0
2008-01-24	CWI	ETF	24.4533	24.94	24.4533	24.9333	70950.0
2008-01-24	CZA	ETF	23.2	23.2	23.2	23.2	800.0
2008-01-24	DBA	ETF	35.0	35.6	34.77	35.5	2298200.0

> showing 50 of 563 rows — these rows as CSV

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