PREVIEW / etf_daily / 2006-07-03

all etf daily files

  file:    by_date/etf_daily/2006/2006-07-03.parquet
  size:    17 KB
  rows:    343

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-03	SPY	ETF	127.43	128.01	127.31	127.8	23914000.0
2006-07-03	QQQ	ETF	38.88	39.0	38.81	39.0	21598542.0
2006-07-03	IWM	ETF	72.0	72.63	71.76	72.63	22967800.0
2006-07-03	DIA	ETF	111.95	112.25	111.86	112.2	1052200.0
2006-07-03	GLD	ETF	61.96	62.37	61.88	62.18	3078500.0
2006-07-03	TLT	ETF	83.9	83.96	83.73	83.91	716800.0
2006-07-03	AAA	ETF	55.42	55.63	55.24	55.55	15900.0
2006-07-03	ADRE	ETF	126.53	127.76	125.19	127.76	38576.0
2006-07-03	AFK	ETF	24.8	24.83	24.76	24.76	10900.0
2006-07-03	AGG	ETF	96.99	97.36	96.99	97.2	88800.0
2006-07-03	AIQ	ETF	32.0	33.05	31.95	32.75	7580.0
2006-07-03	AIS	ETF	1.11	1.17	1.11	1.15	52700.0
2006-07-03	AOM	ETF	5.65	5.8	5.65	5.75	26700.0
2006-07-03	ARB	ETF	38.33	38.42	38.11	38.4	92600.0
2006-07-03	BAB	ETF	64.2	64.45	64.08	64.25	12400.0
2006-07-03	BBC	ETF	13.85	13.96	13.35	13.68	241700.0
2006-07-03	BBH	ETF	59.0667	59.38	58.16	59.38	383400.0
2006-07-03	BCM	ETF	67.27	67.61	67.11	67.61	13600.0
2006-07-03	BITS	ETF	18.8	19.8	18.48	19.64	10916.0
2006-07-03	BKF	ETF	6.25	6.25	6.13	6.2	33300.0
2006-07-03	BNE	ETF	14.21	14.3	14.03	14.3	68400.0
2006-07-03	BOSS	ETF	33.34	33.34	33.34	33.34	100.0
2006-07-03	BRF	ETF	14.0	14.06	13.98	14.06	7800.0
2006-07-03	BTF	ETF	90.25	90.25	89.6005	89.6005	120.0
2006-07-03	CBON	ETF	31.33	32.35	31.33	32.05	90573.0
2006-07-03	CDL	ETF	8.89	8.93	8.85	8.93	70000.0
2006-07-03	CEF	ETF	8.72	8.87	8.7	8.84	276500.0
2006-07-03	CEW	ETF	25.7	25.81	25.7	25.81	400.0
2006-07-03	CGO	ETF	14.8	14.8	14.5	14.59	7000.0
2006-07-03	CHB	ETF	10.6	10.6	10.08	10.26	652900.0
2006-07-03	CHI	ETF	19.22	19.38	19.19	19.33	19300.0
2006-07-03	CHIC	ETF	24.06	24.73	24.03	24.71	268785.0
2006-07-03	CHY	ETF	16.04	16.1	16.04	16.1	68300.0
2006-07-03	CIZ	ETF	22.75	22.75	22.75	22.75	300.0
2006-07-03	CN	ETF	35.95	36.27	35.85	36.27	59500.0
2006-07-03	CNXT	ETF	2.46	2.47	2.4	2.42	4938104.0
2006-07-03	COMB	ETF	10.0	10.0	9.95	9.95	682.0
2006-07-03	CPST	ETF	2.28	2.43	2.28	2.36	666134.0
2006-07-03	CSA	ETF	19.2	19.2	19.01	19.1	1600.0
2006-07-03	CSB	ETF	28.0	28.29	27.94	28.2	5500.0
2006-07-03	CSQ	ETF	13.97	13.98	13.9	13.95	83500.0
2006-07-03	CTEC	ETF	63.8	64.45	62.35	64.0	5405.8
2006-07-03	CYB	ETF	6.5	6.6	6.49	6.54	35300.0
2006-07-03	DBC	ETF	25.65	25.99	25.42	25.97	144500.0
2006-07-03	DDM	ETF	6.0958	6.1333	6.0958	6.1333	331200.0
2006-07-03	DES	ETF	17.2433	17.3467	17.2433	17.3467	7500.0
2006-07-03	DEW	ETF	52.3	52.3	52.3	52.3	600.0
2006-07-03	DFE	ETF	53.29	53.43	53.29	53.43	1600.0
2006-07-03	DGT	ETF	67.23	67.41	67.23	67.41	1000.0
2006-07-03	DHS	ETF	51.05	51.29	51.0	51.29	6000.0

> showing 50 of 343 rows — these rows as CSV

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