PREVIEW / etf_daily / 2008-01-07

all etf daily files

  file:    by_date/etf_daily/2008/2008-01-07.parquet
  size:    25 KB
  rows:    561

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-07	SPY	ETF	141.81	142.23	140.1	141.19	234991000.0
2008-01-07	QQQ	ETF	48.41	48.6	47.43	48.17	235083589.0
2008-01-07	IWM	ETF	72.28	72.85	71.07	72.25	139672900.0
2008-01-07	DIA	ETF	128.54	128.74	127.22	128.06	19666500.0
2008-01-07	GLD	ETF	85.24	85.26	84.57	84.77	6944300.0
2008-01-07	TLT	ETF	94.18	94.78	94.03	94.68	1315500.0
2008-01-07	ADRE	ETF	52.81	53.27	51.7901	52.77	694962.0
2008-01-07	AGG	ETF	102.21	102.36	101.83	102.26	693600.0
2008-01-07	AIA	ETF	47.44	47.44	45.69	46.42	11700.0
2008-01-07	AIQ	ETF	47.25	48.3	47.25	47.75	35720.0
2008-01-07	AIS	ETF	0.96	1.0	0.95	1.0	107600.0
2008-01-07	AIVI	ETF	68.88	69.43	68.82	69.24	107900.0
2008-01-07	ARB	ETF	39.66	40.14	38.77	39.94	338500.0
2008-01-07	BBH	ETF	53.3267	54.23	53.3267	54.1167	854400.0
2008-01-07	BIL	ETF	91.6	91.66	91.58	91.66	30300.0
2008-01-07	BITS	ETF	23.6	24.04	21.84	22.68	11160.0
2008-01-07	BIV	ETF	78.35	78.38	78.09	78.38	57200.0
2008-01-07	BKF	ETF	58.07	60.5	57.3	57.95	21500.0
2008-01-07	BLV	ETF	77.65	77.93	77.43	77.93	15200.0
2008-01-07	BMVP	ETF	16.8333	16.8381	16.6233	16.7667	59400.0
2008-01-07	BND	ETF	77.7	77.7	77.37	77.57	186300.0
2008-01-07	BNE	ETF	15.8	16.31	15.61	16.16	302700.0
2008-01-07	BRF	ETF	14.68	14.68	14.65	14.66	16700.0
2008-01-07	BSV	ETF	77.75	77.75	77.44	77.62	37600.0
2008-01-07	BTF	ETF	109.1	109.45	108.39999999999999	108.69999999999999	3300.0
2008-01-07	BWX	ETF	27.125	27.155	27.075	27.15	299198.0
2008-01-07	CBON	ETF	15.17	15.68	15.1	15.26	60048.0
2008-01-07	CDL	ETF	1.73	1.83	1.58	1.74	1585696.0
2008-01-07	CEF	ETF	11.33	11.33	11.08	11.18	365300.0
2008-01-07	CGO	ETF	19.05	19.1299	18.73	18.94	8572.0
2008-01-07	CGW	ETF	25.5	25.55	25.12	25.31	118773.0
2008-01-07	CHB	ETF	8.08	8.39	7.88	8.01	2158300.0
2008-01-07	CHI	ETF	15.1	15.23	14.99	15.05	170300.0
2008-01-07	CHIC	ETF	14.42	14.6	13.7	14.04	798285.0
2008-01-07	CHW	ETF	12.76	12.94	12.52	12.53	163642.0
2008-01-07	CHY	ETF	13.74	13.78	13.4	13.62	275606.0
2008-01-07	CMF	ETF	52.625	52.625	52.625	52.625	99400.0
2008-01-07	CN	ETF	60.12	61.6	59.9	61.0	369963.0
2008-01-07	CNXT	ETF	0.7	0.71	0.6221	0.6607	6277680.0
2008-01-07	COW	ETF	46.53	46.54	46.33	46.41	3500.0
2008-01-07	CPST	ETF	1.8	1.82	1.68	1.76	3107358.0
2008-01-07	CSA	ETF	15.84	15.84	15.45	15.74	33100.0
2008-01-07	CSD	ETF	25.13	25.45	24.97	25.16	13800.0
2008-01-07	CSQ	ETF	13.73	13.87	13.63	13.86	252240.0
2008-01-07	CUT	ETF	23.2	23.26	22.88	22.9	159700.0
2008-01-07	CVY	ETF	22.45	22.61	22.31	22.51	23500.0
2008-01-07	CWI	ETF	27.46	27.46	26.6	26.7667	88050.0
2008-01-07	DBA	ETF	34.5	34.5	34.0	34.12	1889500.0
2008-01-07	DBB	ETF	22.79	22.93	22.66	22.93	40200.0
2008-01-07	DBC	ETF	32.23	32.44	31.6601	31.9	664600.0

> showing 50 of 561 rows — these rows as CSV

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