PREVIEW / etf_daily / 2008-02-25

all etf daily files

  file:    by_date/etf_daily/2008/2008-02-25.parquet
  size:    26 KB
  rows:    570

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-25	SPY	ETF	135.54	137.65	134.78	137.33	190107000.0
2008-02-25	QQQ	ETF	43.62	44.07	43.34	43.9	121444230.0
2008-02-25	IWM	ETF	69.38	71.0	69.03	70.77	76367400.0
2008-02-25	DIA	ETF	123.72	125.85	123.41	125.57	14534100.0
2008-02-25	GLD	ETF	93.71	93.71	92.11	92.74	11954500.0
2008-02-25	TLT	ETF	91.95	92.14	90.65	91.08	3460900.0
2008-02-25	ADRE	ETF	52.57	53.37	52.0	53.3	923079.0
2008-02-25	AGG	ETF	101.68	101.74	101.09	101.23	557900.0
2008-02-25	AIA	ETF	44.39	44.39	43.478	44.05	6100.0
2008-02-25	AIQ	ETF	49.7	50.5	49.15	49.85	94920.0
2008-02-25	AIS	ETF	1.02	1.03	1.01	1.02	62300.0
2008-02-25	AIVI	ETF	63.68	64.5	63.18	64.47	42200.0
2008-02-25	ARB	ETF	41.92	42.19	40.61	41.78	630100.0
2008-02-25	BBH	ETF	55.6567	56.6	55.6533	56.3067	1894500.0
2008-02-25	BIL	ETF	91.74	91.8	91.74	91.76	14850.0
2008-02-25	BITS	ETF	20.48	21.32	20.48	21.16	6315.0
2008-02-25	BIV	ETF	78.13	78.24	77.73	77.83	39200.0
2008-02-25	BJK	ETF	42.45	42.95	42.45	42.95	1600.0
2008-02-25	BKF	ETF	54.15	54.59	53.6599	54.53	45300.0
2008-02-25	BLV	ETF	75.67	75.72	74.95	75.04	27700.0
2008-02-25	BMVP	ETF	16.1167	16.3799	16.0467	16.3471	68600.0
2008-02-25	BND	ETF	76.8	76.95	76.53	76.63	180900.0
2008-02-25	BNE	ETF	13.07	13.66	13.03	13.57	142400.0
2008-02-25	BRF	ETF	14.66	14.66	14.63	14.63	16300.0
2008-02-25	BSV	ETF	78.46	78.49	78.22	78.3	62600.0
2008-02-25	BTF	ETF	107.94999999999999	109.0	107.00049999999999	108.75	18100.0
2008-02-25	BWX	ETF	27.35	27.395	27.275	27.32	354698.0
2008-02-25	CBON	ETF	12.6	13.2	12.4	12.9	80438.0
2008-02-25	CDL	ETF	1.48	1.54	1.41	1.5	1417076.0
2008-02-25	CEF	ETF	13.37	13.37	13.12	13.21	772500.0
2008-02-25	CGO	ETF	16.54	16.77	16.45	16.77	41481.0
2008-02-25	CGW	ETF	23.45	24.08	22.9	23.95	140026.0
2008-02-25	CHB	ETF	8.17	8.49	8.03	8.45	1607336.0
2008-02-25	CHI	ETF	14.86	15.01	14.75	14.96	100090.0
2008-02-25	CHIC	ETF	19.5	20.61	19.5	20.54	1166886.0
2008-02-25	CHW	ETF	11.68	11.8322	11.6377	11.74	121826.0
2008-02-25	CHY	ETF	13.62	13.73	13.5001	13.64	158500.0
2008-02-25	CMF	ETF	51.75	51.75	51.5001	51.5666	11200.0
2008-02-25	CN	ETF	62.0	63.61	61.66	63.58	217101.0
2008-02-25	CNXT	ETF	0.57	0.6	0.55	0.58	3018706.0
2008-02-25	COW	ETF	45.54	45.54	44.87	44.99	29600.0
2008-02-25	CPI	ETF	19.6499	20.1	19.6	20.1	3500.0
2008-02-25	CPST	ETF	1.6	1.82	1.59	1.78	5368786.0
2008-02-25	CSA	ETF	14.81	15.11	14.71	14.94	32800.0
2008-02-25	CSD	ETF	23.77	23.88	23.58	23.88	36200.0
2008-02-25	CSQ	ETF	12.89	13.08	12.8166	13.06	234480.0
2008-02-25	CUT	ETF	21.31	22.15	21.31	22.15	41400.0
2008-02-25	CVY	ETF	22.96	23.32	22.92	23.31	27200.0
2008-02-25	CWI	ETF	24.42	25.7467	24.42	25.7	64350.0
2008-02-25	CZA	ETF	24.0	24.14	24.0	24.14	1300.0

> showing 50 of 570 rows — these rows as CSV

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