PREVIEW / etf_daily / 2008-02-07

all etf daily files

  file:    by_date/etf_daily/2008/2008-02-07.parquet
  size:    26 KB
  rows:    562

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-07	SPY	ETF	131.8	134.79	131.73	133.93	297368100.0
2008-02-07	QQQ	ETF	42.35	43.79	42.15	43.11	286342201.0
2008-02-07	IWM	ETF	68.64	70.52	68.47	70.11	125972100.0
2008-02-07	DIA	ETF	121.6	123.39	121.25	122.73	21041800.0
2008-02-07	GLD	ETF	88.95	89.94	88.81	89.85	8971300.0
2008-02-07	TLT	ETF	94.53	94.53	92.05	92.64	5419700.0
2008-02-07	ADRE	ETF	48.1	49.52	47.6	49.044	402986.0
2008-02-07	AGG	ETF	103.13	103.15	102.05	102.26	622300.0
2008-02-07	AIA	ETF	41.42	42.25	40.7148	41.84	3500.0
2008-02-07	AIQ	ETF	51.95	52.6	50.35	52.25	59420.0
2008-02-07	AIS	ETF	1.04	1.04	0.99	1.01	141301.0
2008-02-07	AIVI	ETF	61.42	62.15	60.95	61.67	83600.0
2008-02-07	ARB	ETF	39.45	40.3	38.98	39.42	328900.0
2008-02-07	BBH	ETF	54.2467	54.7633	53.7433	54.2967	724200.0
2008-02-07	BIL	ETF	91.66	91.76	91.64	91.72	30350.0
2008-02-07	BITS	ETF	22.64	23.4	22.64	22.68	8657.0
2008-02-07	BIV	ETF	79.3	79.3	78.42	78.46	111400.0
2008-02-07	BJK	ETF	42.08	42.4	41.7	42.4	1800.0
2008-02-07	BKF	ETF	49.62	50.84	49.01	50.84	81400.0
2008-02-07	BLV	ETF	77.47	77.47	76.0	76.03	24000.0
2008-02-07	BMVP	ETF	15.6567	15.91	15.5934	15.8267	66900.0
2008-02-07	BND	ETF	78.15	78.16	77.46	77.6	135100.0
2008-02-07	BNE	ETF	12.93	13.1999	12.9	13.04	272618.0
2008-02-07	BRF	ETF	14.7	14.7	14.7	14.7	200.0
2008-02-07	BSV	ETF	78.77	78.82	78.43	78.46	179700.0
2008-02-07	BTF	ETF	107.5	108.75	106.85	107.9495	7200.0
2008-02-07	BWX	ETF	27.2	27.21	27.0251	27.13	202442.0
2008-02-07	CBON	ETF	15.97	16.31	15.55	16.31	49836.0
2008-02-07	CDL	ETF	1.37	1.46	1.37	1.43	1404222.0
2008-02-07	CEF	ETF	12.48	12.48	12.22	12.35	875100.0
2008-02-07	CGO	ETF	16.08	16.45	15.95	16.45	19052.0
2008-02-07	CGW	ETF	22.61	22.98	22.48	22.72	132262.0
2008-02-07	CHB	ETF	8.4	9.25	8.3	8.8	1791576.0
2008-02-07	CHI	ETF	15.94	16.0	15.8	15.91	120700.0
2008-02-07	CHIC	ETF	17.2	18.36	17.2	17.93	659990.0
2008-02-07	CHW	ETF	12.1	12.31	11.92	12.03	157279.0
2008-02-07	CHY	ETF	14.4	14.48	14.27	14.44	125259.0
2008-02-07	CMF	ETF	52.975	53.045	52.7	52.705	27400.0
2008-02-07	CN	ETF	57.99	59.44	57.0	59.05	223133.0
2008-02-07	CNXT	ETF	0.61	0.62	0.586	0.6	4272426.0
2008-02-07	COW	ETF	46.2	46.53	46.17	46.46	4700.0
2008-02-07	CPI	ETF	20.02	20.02	20.0	20.0	1300.0
2008-02-07	CPST	ETF	1.47	1.47	1.39	1.419	1583948.0
2008-02-07	CSA	ETF	16.42	16.42	15.95	16.1	259000.0
2008-02-07	CSD	ETF	24.34	24.34	24.0	24.14	6500.0
2008-02-07	CSQ	ETF	13.42	13.524	13.26	13.43	273755.0
2008-02-07	CUT	ETF	20.99	21.0	20.6	20.7	56000.0
2008-02-07	CVY	ETF	22.82	23.14	22.82	23.13	18300.0
2008-02-07	CWI	ETF	23.74	24.5533	23.74	24.3667	186900.0
2008-02-07	DBA	ETF	37.9	38.21	37.65	38.08	1450500.0

> showing 50 of 562 rows — these rows as CSV

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