PREVIEW / etf_daily / 2006-07-26

all etf daily files

  file:    by_date/etf_daily/2006/2006-07-26.parquet
  size:    18 KB
  rows:    356

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-07-26	SPY	ETF	126.59	127.45	126.18	126.83	84525800.0
2006-07-26	QQQ	ETF	36.5	36.87	36.23	36.59	107193127.0
2006-07-26	IWM	ETF	68.93	69.6	68.12	68.9	59831300.0
2006-07-26	DIA	ETF	110.8	111.48	110.39	110.91	6206200.0
2006-07-26	GLD	ETF	61.35	62.36	60.93	62.0	3376000.0
2006-07-26	TLT	ETF	84.91	85.37	84.87	85.34	717100.0
2006-07-26	AAA	ETF	54.7	55.4	54.566	55.39	9600.0
2006-07-26	ADRE	ETF	31.17	31.42	30.98	31.29	605136.0
2006-07-26	AFK	ETF	25.06	25.07	25.0101	25.07	2400.0
2006-07-26	AGG	ETF	98.06	98.33	97.95	98.15	117200.0
2006-07-26	AIQ	ETF	30.4	32.5	29.3	31.75	15120.0
2006-07-26	AIS	ETF	1.1	1.15	1.1	1.1399	26400.0
2006-07-26	AOM	ETF	6.41	6.42	6.3201	6.41	4500.0
2006-07-26	ARB	ETF	36.48	36.62	36.0	36.37	125700.0
2006-07-26	BAB	ETF	69.99	71.03	69.65	70.28	47800.0
2006-07-26	BBC	ETF	12.3	13.15	12.28	13.15	200800.0
2006-07-26	BBH	ETF	59.42	60.1	58.9667	59.8267	1652100.0
2006-07-26	BITS	ETF	17.52	18.68	17.52	18.16	10359.0
2006-07-26	BKF	ETF	4.13	4.15	4.05	4.13	197100.0
2006-07-26	BNE	ETF	13.3	13.66	13.25	13.45	180700.0
2006-07-26	BOSS	ETF	33.25	33.72	33.25	33.72	100.0
2006-07-26	BRF	ETF	14.0	14.0	13.99	14.0	7300.0
2006-07-26	BTF	ETF	86.64999999999999	86.64999999999999	86.64999999999999	86.64999999999999	300.0
2006-07-26	CBON	ETF	32.74	32.766	32.27	32.73	69523.0
2006-07-26	CDL	ETF	8.78	9.05	8.7	8.98	165500.0
2006-07-26	CEF	ETF	8.7	8.7	8.57	8.68	353100.0
2006-07-26	CFO	ETF	9.9	10.0	9.9	10.0	13700.0
2006-07-26	CGO	ETF	14.82	14.85	14.6	14.82	53100.0
2006-07-26	CHB	ETF	6.64	6.75	6.51	6.63	3078700.0
2006-07-26	CHI	ETF	19.77	19.89	19.77	19.88	78100.0
2006-07-26	CHIC	ETF	25.79	25.99	25.5	25.55	468404.0
2006-07-26	CHY	ETF	16.1	16.15	16.06	16.1	132200.0
2006-07-26	CN	ETF	36.1	36.3	36.1	36.24	35600.0
2006-07-26	CNXT	ETF	1.99	2.11	1.95	2.08	10231835.0
2006-07-26	COMB	ETF	9.79	9.79	9.55	9.79	20900.0
2006-07-26	CPST	ETF	1.88	1.92	1.8	1.85	1762885.0
2006-07-26	CSA	ETF	18.8	18.8	18.8	18.8	800.0
2006-07-26	CSB	ETF	27.05	27.25	27.0	27.19	11100.0
2006-07-26	CSQ	ETF	14.09	14.14	14.04	14.14	339700.0
2006-07-26	CTEC	ETF	59.699999999999996	60.4	59.0	59.4	14542.6
2006-07-26	CYB	ETF	5.38	5.4	5.15	5.24	78800.0
2006-07-26	DBC	ETF	25.23	25.58	25.18	25.21	224900.0
2006-07-26	DDM	ETF	5.95	6.0208	5.9075	5.9683	1159200.0
2006-07-26	DES	ETF	17.1533	17.2867	17.0333	17.2033	71700.0
2006-07-26	DEW	ETF	52.02	52.5	52.02	52.45	1700.0
2006-07-26	DFE	ETF	52.36	52.37	52.36	52.37	1000.0
2006-07-26	DFJ	ETF	47.52	47.7	47.52	47.7	400.0
2006-07-26	DGT	ETF	67.76	68.41	67.75	68.34	2600.0
2006-07-26	DHS	ETF	52.35	52.64	52.34	52.6	6700.0
2006-07-26	DIM	ETF	52.19	52.7	52.0	52.7	4300.0

> showing 50 of 356 rows — these rows as CSV

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