PREVIEW / etf_daily / 2008-07-23

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-23.parquet
  size:    27 KB
  rows:    607

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-07-23	SPY	ETF	127.89	129.15	127.55	128.17	311698400.0
2008-07-23	QQQ	ETF	44.84	45.89	44.72	45.37	169259091.0
2008-07-23	IWM	ETF	71.38	72.49	71.18	71.93	118339100.0
2008-07-23	DIA	ETF	115.95	116.88	115.49	116.23	24761000.0
2008-07-23	GLD	ETF	92.64	92.79	90.44	90.57	25791800.0
2008-07-23	TLT	ETF	90.22	90.37	89.75	90.17	2871900.0
2008-07-23	ACWI	ETF	48.61	48.98	48.61	48.78	4100.0
2008-07-23	ACWX	ETF	49.36	49.51	49.35	49.41	3405.0
2008-07-23	ADRE	ETF	48.63	48.75	48.17	48.28	559717.0
2008-07-23	AFK	ETF	41.36	41.36	40.3	40.3	17228.0
2008-07-23	AGG	ETF	99.2	99.3	99.03	99.28	405700.0
2008-07-23	AIA	ETF	41.85	42.67	41.85	42.3	16042.0
2008-07-23	AIQ	ETF	44.3	45.8	44.3	44.65	32867.0
2008-07-23	AIS	ETF	0.72	0.72	0.63	0.7	26450.0
2008-07-23	AIVI	ETF	61.04	61.51	60.86	61.14	44200.0
2008-07-23	ARB	ETF	47.64	48.1	45.48	46.3	564816.0
2008-07-23	BAL	ETF	44.39	45.37	44.39	45.37	1100.0
2008-07-23	BBH	ETF	64.99	65.1667	64.4967	64.66	1522500.0
2008-07-23	BIL	ETF	91.78	91.84	91.72	91.84	223150.0
2008-07-23	BITS	ETF	23.08	23.92	23.08	23.2	2389.0
2008-07-23	BIV	ETF	75.49	75.56	75.3	75.56	36400.0
2008-07-23	BJK	ETF	31.74	32.72	31.74	32.72	4100.0
2008-07-23	BKF	ETF	49.81	50.52	49.81	50.18	18272.0
2008-07-23	BLV	ETF	72.66	72.91	72.33	72.84	15100.0
2008-07-23	BMVP	ETF	14.8167	15.039	14.8167	14.97	56459.0
2008-07-23	BND	ETF	75.17	75.32	75.03	75.25	163400.0
2008-07-23	BNE	ETF	13.0	13.37	12.73	13.01	135103.0
2008-07-23	BRF	ETF	14.73	14.74	14.73	14.74	8000.0
2008-07-23	BSV	ETF	76.88	76.96	76.61	76.95	94100.0
2008-07-23	BTF	ETF	84.7	85.64999999999999	84.39999999999999	84.7	9485.0
2008-07-23	BWX	ETF	27.665	27.7	27.575	27.655	196772.0
2008-07-23	CBON	ETF	5.31	5.94	4.91	5.22	350682.0
2008-07-23	CDL	ETF	0.99	1.16	0.99	1.04	1707995.0
2008-07-23	CEF	ETF	13.24	13.24	12.5	12.62	1240700.0
2008-07-23	CGO	ETF	15.23	15.25	15.09	15.25	14060.0
2008-07-23	CGW	ETF	23.87	23.9	23.5201	23.8	68717.0
2008-07-23	CHB	ETF	3.24	3.84	3.2	3.55	3638894.0
2008-07-23	CHI	ETF	13.51	13.65	13.45	13.55	201507.0
2008-07-23	CHIC	ETF	14.04	15.0	13.9	14.63	835956.0
2008-07-23	CHW	ETF	11.06	11.08	10.88	11.08	129169.0
2008-07-23	CHY	ETF	13.1	13.2	12.92	13.07	168577.0
2008-07-23	CMF	ETF	50.895	51.255	50.895	51.2	7942.0
2008-07-23	CN	ETF	63.96	63.96	61.79	62.17	378563.0
2008-07-23	COW	ETF	43.15	43.25	42.61	43.25	103629.0
2008-07-23	CPST	ETF	3.4	3.41	3.07	3.12	7968792.0
2008-07-23	CSA	ETF	18.38	18.88	18.33	18.65	60822.0
2008-07-23	CSB	ETF	18.03	18.47	17.87	17.89	43850.0
2008-07-23	CSD	ETF	21.25	21.41	21.25	21.41	2200.0
2008-07-23	CSQ	ETF	11.12	11.22	11.0	11.17	498608.0
2008-07-23	CUT	ETF	18.69	18.99	18.69	18.83	19000.0

> showing 50 of 607 rows — these rows as CSV

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