PREVIEW / etf_daily / 2006-10-26

all etf daily files

  file:    by_date/etf_daily/2006/2006-10-26.parquet
  size:    19 KB
  rows:    379

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-10-26	SPY	ETF	138.66	139.0	137.98	138.78	66843700.0
2006-10-26	QQQ	ETF	42.57	42.92	42.22	42.82	130871862.0
2006-10-26	IWM	ETF	76.64	77.15	75.87	77.04	49379500.0
2006-10-26	DIA	ETF	121.45	121.55	120.84	121.43	6657000.0
2006-10-26	GLD	ETF	59.03	59.45	58.98	59.29	5241100.0
2006-10-26	TLT	ETF	88.15	88.52	88.15	88.46	1558300.0
2006-10-26	AAA	ETF	55.42	55.85	55.3	55.72	4300.0
2006-10-26	ADRE	ETF	35.07	35.07	34.56	34.82	194537.0
2006-10-26	AGG	ETF	99.69	99.86	99.6	99.84	185900.0
2006-10-26	AIQ	ETF	41.2	41.95	41.0	41.85	10920.0
2006-10-26	AIS	ETF	1.24	1.25	1.2	1.2199	380100.0
2006-10-26	ARB	ETF	41.7	42.08	41.31	41.92	221100.0
2006-10-26	BAB	ETF	87.59	87.98	87.03	87.89	35400.0
2006-10-26	BBC	ETF	9.15	9.4	9.11	9.11	116200.0
2006-10-26	BBH	ETF	63.44	64.13	63.1667	64.13	725400.0
2006-10-26	BITS	ETF	42.12	42.8	41.72	41.88	53824.0
2006-10-26	BNE	ETF	15.77	16.09	15.73	16.09	161500.0
2006-10-26	BRF	ETF	14.25	14.27	14.23	14.25	14400.0
2006-10-26	BTF	ETF	100.99999999999999	101.89999999999999	100.85000000000001	101.89999999999999	19380.0
2006-10-26	CBON	ETF	29.33	29.42	28.99	29.28	69959.0
2006-10-26	CDL	ETF	9.92	10.41	9.9	10.38	475800.0
2006-10-26	CEF	ETF	8.31	8.43	8.31	8.36	314000.0
2006-10-26	CGO	ETF	15.8	15.91	15.7	15.72	31800.0
2006-10-26	CHB	ETF	8.53	9.89	8.49	9.35	3649500.0
2006-10-26	CHI	ETF	19.6	19.7	19.58	19.7	117100.0
2006-10-26	CHIC	ETF	28.31	28.97	28.09	28.88	208856.0
2006-10-26	CHY	ETF	17.15	17.25	17.11	17.22	156800.0
2006-10-26	CIL	ETF	25.9	25.9	25.9	25.9	100.0
2006-10-26	CN	ETF	35.23	35.48	35.164	35.44	19700.0
2006-10-26	CNXT	ETF	1.89	2.04	1.86	2.02	24937157.0
2006-10-26	COMB	ETF	9.86	10.0	9.86	10.0	4560.0
2006-10-26	CPI	ETF	23.1	23.6	23.1	23.51	2900.0
2006-10-26	CPST	ETF	1.52	1.54	1.48	1.49	944649.0
2006-10-26	CSA	ETF	22.14	22.9199	22.14	22.66	27800.0
2006-10-26	CSB	ETF	31.04	31.05	30.78	30.99	9500.0
2006-10-26	CSM	ETF	1.2425	1.2425	1.2425	1.2425	800.0
2006-10-26	CSQ	ETF	14.93	14.97	14.88	14.97	500100.0
2006-10-26	CTEC	ETF	68.75	75.5	68.49999999999999	75.5	64612.4
2006-10-26	CVY	ETF	26.18	26.18	25.97	26.08	93000.0
2006-10-26	CYB	ETF	7.4	7.45	7.35	7.36	147700.0
2006-10-26	DBC	ETF	24.68	24.71	24.34	24.53	243800.0
2006-10-26	DBV	ETF	25.42	25.44	25.29	25.38	71300.0
2006-10-26	DDM	ETF	7.1058	7.1183	7.0383	7.1025	566400.0
2006-10-26	DES	ETF	18.73	18.8267	18.6367	18.8267	35100.0
2006-10-26	DEW	ETF	58.18	58.36	57.93	58.32	4500.0
2006-10-26	DFE	ETF	58.55	59.01	58.53	59.01	3700.0
2006-10-26	DFJ	ETF	50.11	50.33	49.87	50.28	26100.0
2006-10-26	DGT	ETF	74.33	74.44	73.8	74.3	74200.0
2006-10-26	DHS	ETF	56.7	56.7	56.41	56.67	14200.0
2006-10-26	DIM	ETF	58.75	59.08	58.66	59.03	11800.0

> showing 50 of 379 rows — these rows as CSV

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