PREVIEW / etf_daily / 2006-04-19

all etf daily files

  file:    by_date/etf_daily/2006/2006-04-19.parquet
  size:    17 KB
  rows:    317

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-04-19	SPY	ETF	130.75	131.07	130.24	130.95	87269000.0
2006-04-19	QQQ	ETF	42.54	42.65	42.3	42.65	79128313.0
2006-04-19	IWM	ETF	76.69	77.34	76.27	77.26	44101500.0
2006-04-19	DIA	ETF	112.82	113.04	112.35	112.86	6002100.0
2006-04-19	GLD	ETF	61.96	63.95	61.9	63.75	11285100.0
2006-04-19	TLT	ETF	84.45	84.59	84.06	84.38	1830300.0
2006-04-19	AAA	ETF	60.3	61.19	60.3	61.16	6300.0
2006-04-19	ADRE	ETF	137.67	138.69	137.346	138.69	64480.0
2006-04-19	AFK	ETF	25.1	25.19	25.1	25.12	8300.0
2006-04-19	AGG	ETF	98.41	98.45	98.1	98.39	233000.0
2006-04-19	AIQ	ETF	25.9	26.7	25.7	25.9	13700.0
2006-04-19	AIS	ETF	1.7	1.7	1.62	1.67	246600.0
2006-04-19	AOM	ETF	6.78	6.78	6.56	6.56	24200.0
2006-04-19	ARB	ETF	33.75	33.99	33.4	33.64	173200.0
2006-04-19	BAB	ETF	60.54	61.22	60.54	60.95	10000.0
2006-04-19	BBC	ETF	15.14	15.7	15.14	15.57	250800.0
2006-04-19	BBH	ETF	62.3333	62.4133	61.71	62.2	1412700.0
2006-04-19	BCM	ETF	72.78	73.68	72.7	73.67	16300.0
2006-04-19	BITS	ETF	37.6	37.6	33.6	34.8	58769.0
2006-04-19	BKF	ETF	8.99	9.1	8.87	8.9	73700.0
2006-04-19	BNE	ETF	16.49	16.65	16.36	16.62	91400.0
2006-04-19	BOSS	ETF	34.59	34.59	34.41	34.54	100.0
2006-04-19	BRF	ETF	13.79	13.88	13.79	13.88	15100.0
2006-04-19	BTF	ETF	86.54999999999998	87.6	86.54999999999998	87.6	500.0
2006-04-19	CBON	ETF	31.96	32.95	31.64	32.81	75557.0
2006-04-19	CDL	ETF	10.4	10.42	10.23	10.25	583500.0
2006-04-19	CEF	ETF	9.6	9.97	9.5	9.86	1316500.0
2006-04-19	CEW	ETF	25.45	25.45	25.45	25.45	100.0
2006-04-19	CFO	ETF	10.2	10.27	10.2	10.27	18200.0
2006-04-19	CGO	ETF	14.4	14.41	14.29	14.37	40800.0
2006-04-19	CHB	ETF	15.37	15.88	15.27	15.8	1250400.0
2006-04-19	CHI	ETF	19.89	20.12	19.89	20.06	173400.0
2006-04-19	CHIC	ETF	20.28	21.0	20.27	21.0	480737.0
2006-04-19	CHIR	ETF	47.9901	48.0	47.9499	47.9799	10146487.0
2006-04-19	CHY	ETF	15.76	15.9	15.75	15.82	154200.0
2006-04-19	CIL	ETF	25.7	25.7	25.7	25.7	100.0
2006-04-19	CIZ	ETF	23.7	23.7	23.7	23.7	300.0
2006-04-19	CN	ETF	38.97	39.0	38.27	38.94	41100.0
2006-04-19	CNXT	ETF	3.69	3.72	3.52	3.65	16446520.0
2006-04-19	COMB	ETF	8.65	8.65	8.5	8.5	2584.0
2006-04-19	CPST	ETF	4.24	4.47	4.22	4.4	6484796.0
2006-04-19	CSA	ETF	19.73	19.79	19.61	19.61	6800.0
2006-04-19	CSB	ETF	30.4	30.69	30.34	30.66	8200.0
2006-04-19	CSM	ETF	2.495	2.495	2.49	2.49	8000.0
2006-04-19	CSQ	ETF	13.78	13.94	13.78	13.93	317100.0
2006-04-19	CTEC	ETF	63.8	63.8	62.75	63.65	6634.400000000001
2006-04-19	CYB	ETF	6.0	6.2	6.0	6.15	16100.0
2006-04-19	DBC	ETF	25.69	26.0	25.55	25.9	558500.0
2006-04-19	DGT	ETF	67.85	68.18	67.85	68.09	8400.0
2006-04-19	DIG	ETF	17.75	17.7875	17.75	17.7875	8000.0

> showing 50 of 317 rows — these rows as CSV

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