PREVIEW / etf_daily / 2006-02-27

all etf daily files

  file:    by_date/etf_daily/2006/2006-02-27.parquet
  size:    16 KB
  rows:    306

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
2006-02-27	SPY	ETF	129.4	130.04	129.28	129.46	35858600.0
2006-02-27	QQQ	ETF	41.37	41.87	41.33	41.72	64960242.0
2006-02-27	IWM	ETF	73.41	73.88	73.32	73.55	20584000.0
2006-02-27	DIA	ETF	110.78	111.33	110.75	110.85	2547500.0
2006-02-27	GLD	ETF	55.26	55.32	55.01	55.22	2291600.0
2006-02-27	TLT	ETF	91.35	91.35	90.73	90.9	446200.0
2006-02-27	AAA	ETF	53.29	53.75	53.29	53.75	1400.0
2006-02-27	ADRE	ETF	130.98	130.98	129.51	129.75	83292.0
2006-02-27	AFK	ETF	25.47	25.47	25.42	25.43	2300.0
2006-02-27	AGG	ETF	100.39	100.42	100.03	100.11	189300.0
2006-02-27	AIQ	ETF	28.9	30.35	28.604	29.8	34520.0
2006-02-27	AIS	ETF	1.41	1.46	1.39	1.4199	128200.0
2006-02-27	AOM	ETF	6.24	6.39	6.13	6.3	45000.0
2006-02-27	ARB	ETF	38.77	39.5	38.77	39.37	114000.0
2006-02-27	BAB	ETF	58.1	58.16	57.83	58.05	21000.0
2006-02-27	BBC	ETF	16.36	16.72	16.36	16.44	229400.0
2006-02-27	BBH	ETF	65.7167	67.1333	65.7167	66.7333	1414200.0
2006-02-27	BCM	ETF	69.22	70.5	69.22	70.19	14900.0
2006-02-27	BITS	ETF	23.96	24.12	21.0	23.32	30459.0
2006-02-27	BKF	ETF	13.6	13.75	13.5	13.7	22000.0
2006-02-27	BNE	ETF	15.11	15.19	14.96	15.02	103100.0
2006-02-27	BRF	ETF	15.45	15.45	15.45	15.45	8000.0
2006-02-27	BTF	ETF	87.35	88.55	86.95	88.05	3980.0
2006-02-27	CBON	ETF	30.53	30.53	30.17	30.35	2600.0
2006-02-27	CDL	ETF	11.3	11.3	11.17	11.3	638700.0
2006-02-27	CEF	ETF	7.7	7.7	7.56	7.58	580200.0
2006-02-27	CEW	ETF	25.51	25.51	25.51	25.51	300.0
2006-02-27	CFO	ETF	9.85	9.95	9.85	9.9	3200.0
2006-02-27	CGO	ETF	14.28	14.5	14.231	14.45	53700.0
2006-02-27	CHB	ETF	15.34	15.8	15.14	15.49	519000.0
2006-02-27	CHI	ETF	21.0	21.0	20.78	20.91	97000.0
2006-02-27	CHIC	ETF	17.7	18.35	17.63	18.16	207507.0
2006-02-27	CHIR	ETF	45.3999	45.6999	45.39	45.6999	709870.0
2006-02-27	CHY	ETF	16.47	16.47	16.3101	16.39	95000.0
2006-02-27	CIL	ETF	25.51	25.51	25.51	25.51	500.0
2006-02-27	CN	ETF	35.2	35.32	35.12	35.29	18000.0
2006-02-27	CNXT	ETF	2.93	3.06	2.9	3.02	11025407.0
2006-02-27	COMB	ETF	8.31	8.45	8.31	8.44	2900.0
2006-02-27	CPI	ETF	30.4	30.4	30.28	30.28	700.0
2006-02-27	CPST	ETF	3.39	3.4	3.26	3.32	1744653.0
2006-02-27	CSA	ETF	19.65	19.7	19.5	19.5	7400.0
2006-02-27	CSB	ETF	30.86	30.98	30.74	30.8	12700.0
2006-02-27	CSQ	ETF	14.26	14.29	14.17	14.19	328700.0
2006-02-27	CTEC	ETF	57.85	57.99999999999999	55.49999999999999	57.699999999999996	8148.400000000001
2006-02-27	CYB	ETF	6.13	6.19	6.07	6.13	48400.0
2006-02-27	DBC	ETF	23.2	23.25	22.92	22.98	664500.0
2006-02-27	DGT	ETF	66.81	66.98	66.69	66.91	4100.0
2006-02-27	DIG	ETF	17.25	17.25	17.25	17.25	800.0
2006-02-27	DIV	ETF	12.69	12.7999	12.6	12.74	40300.0
2006-02-27	DRIV	ETF	38.26	38.7	38.21	38.41	420281.0

> showing 50 of 306 rows — these rows as CSV

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