PREVIEW / etf_daily / 2006-03-20

all etf daily files

  file:    by_date/etf_daily/2006/2006-03-20.parquet
  size:    16 KB
  rows:    311

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-03-20	SPY	ETF	130.64	130.9	130.21	130.41	45538500.0
2006-03-20	QQQ	ETF	41.58	41.68	41.4	41.55	60240179.0
2006-03-20	IWM	ETF	74.19	74.33	73.71	74.03	25640700.0
2006-03-20	DIA	ETF	112.72	113.01	112.5	112.69	6846500.0
2006-03-20	GLD	ETF	55.01	55.4	54.98	55.17	1884000.0
2006-03-20	TLT	ETF	89.23	89.24	88.98	88.99	576000.0
2006-03-20	AAA	ETF	59.99	60.3	59.5101	59.6101	2700.0
2006-03-20	ADRE	ETF	128.99	129.239	128.117	128.44	36008.0
2006-03-20	AFK	ETF	25.08	25.19	25.08	25.19	8300.0
2006-03-20	AGG	ETF	99.7	99.75	99.54	99.56	460900.0
2006-03-20	AIQ	ETF	32.25	33.3	31.8	32.8	30060.0
2006-03-20	AIS	ETF	1.89	1.89	1.65	1.8	907000.0
2006-03-20	AOM	ETF	6.91	6.96	6.72	6.81	31700.0
2006-03-20	ARB	ETF	34.4	34.4	33.852	34.34	755400.0
2006-03-20	BAB	ETF	62.35	62.71	61.85	62.71	16700.0
2006-03-20	BBC	ETF	16.25	18.0	16.25	17.99	653200.0
2006-03-20	BBH	ETF	66.33	66.5267	65.7633	66.4533	1662300.0
2006-03-20	BCM	ETF	72.5	73.32	72.21	73.03	17100.0
2006-03-20	BITS	ETF	31.48	33.36	31.24	32.6	58296.0
2006-03-20	BKF	ETF	12.8	12.84	12.62	12.83	71400.0
2006-03-20	BNE	ETF	15.6	15.98	15.46	15.91	233200.0
2006-03-20	BRF	ETF	14.18	14.28	14.06	14.27	15100.0
2006-03-20	BTF	ETF	88.75	89.04999999999998	88.75	89.04999999999998	1580.0
2006-03-20	CBON	ETF	31.14	32.0	31.14	31.7	3548.0
2006-03-20	CDL	ETF	11.54	11.62	11.41	11.49	209900.0
2006-03-20	CEF	ETF	7.9	7.9	7.68	7.77	300800.0
2006-03-20	CEW	ETF	25.57	25.57	25.57	25.57	100.0
2006-03-20	CFO	ETF	9.75	9.8	9.75	9.8	4700.0
2006-03-20	CGO	ETF	14.38	14.48	14.35	14.43	21600.0
2006-03-20	CHB	ETF	15.86	15.9	15.47	15.8	711500.0
2006-03-20	CHI	ETF	20.72	20.82	20.68	20.75	64000.0
2006-03-20	CHIC	ETF	18.73	18.73	18.42	18.59	203941.0
2006-03-20	CHIR	ETF	45.6699	45.78	45.3999	45.6399	774657.0
2006-03-20	CHY	ETF	16.44	16.55	16.39	16.51	72200.0
2006-03-20	CIL	ETF	25.6	25.6	25.6	25.6	600.0
2006-03-20	CN	ETF	34.75	34.75	34.37	34.52	21700.0
2006-03-20	CNXT	ETF	3.16	3.18	3.12	3.16	6877751.0
2006-03-20	CPI	ETF	31.4	31.4	31.0	31.0	800.0
2006-03-20	CPST	ETF	3.3	3.39	3.18	3.18	1757351.0
2006-03-20	CSA	ETF	21.0	21.42	20.95	21.35	76800.0
2006-03-20	CSB	ETF	31.26	31.44	31.2	31.28	14600.0
2006-03-20	CSM	ETF	2.485	2.485	2.485	2.485	10400.0
2006-03-20	CSQ	ETF	14.14	14.2	14.04	14.12	374600.0
2006-03-20	CTEC	ETF	57.0	59.74999999999999	55.99999999999999	59.45	8469.4
2006-03-20	CYB	ETF	6.1001	6.2	6.1	6.2	5800.0
2006-03-20	DBC	ETF	23.22	23.35	22.76	22.84	495500.0
2006-03-20	DGT	ETF	67.65	67.91	67.65	67.7	8900.0
2006-03-20	DIG	ETF	17.125	17.125	17.125	17.125	800.0
2006-03-20	DIV	ETF	12.51	12.59	12.51	12.56	24000.0
2006-03-20	DRIV	ETF	41.22	42.1	41.16	41.78	748717.0

> showing 50 of 311 rows — these rows as CSV

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