PREVIEW / etf_daily / 2006-11-27

all etf daily files

  file:    by_date/etf_daily/2006/2006-11-27.parquet
  size:    19 KB
  rows:    385

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-11-27	SPY	ETF	140.28	140.35	138.38	138.42	84545100.0
2006-11-27	QQQ	ETF	44.52	44.61	43.64	43.66	159536874.0
2006-11-27	IWM	ETF	78.51	78.54	76.72	76.8	72824600.0
2006-11-27	DIA	ETF	122.7	122.72	121.07	121.11	9329500.0
2006-11-27	GLD	ETF	63.46	63.74	63.32	63.7	5249800.0
2006-11-27	TLT	ETF	90.23	90.95	90.12	90.95	784500.0
2006-11-27	AAA	ETF	57.88	57.88	57.6	57.79	1800.0
2006-11-27	ADRE	ETF	36.6	36.65	35.82	35.83	112116.0
2006-11-27	AGG	ETF	100.52	100.73	100.41	100.64	191000.0
2006-11-27	AIQ	ETF	30.1	30.35	29.1	29.45	133360.0
2006-11-27	AIS	ETF	1.2	1.2	1.1799	1.18	216300.0
2006-11-27	ARB	ETF	44.76	44.8	44.11	44.27	102800.0
2006-11-27	BAB	ETF	94.14	94.32	92.68	92.76	68300.0
2006-11-27	BBC	ETF	5.35	5.49	5.25	5.34	366000.0
2006-11-27	BBH	ETF	62.3333	62.46	61.6667	61.9	691500.0
2006-11-27	BITS	ETF	35.6	36.36	33.6	34.4796	38551.0
2006-11-27	BNE	ETF	16.12	16.47	15.32	15.39	183100.0
2006-11-27	BOSS	ETF	38.86	39.31	38.86	39.31	100.0
2006-11-27	BRF	ETF	14.25	14.3	14.24	14.24	14900.0
2006-11-27	BTF	ETF	106.64999999999999	106.69999999999999	105.89999999999999	105.89999999999999	2040.0
2006-11-27	CBON	ETF	30.18	30.48	30.12	30.18	67944.0
2006-11-27	CDL	ETF	9.59	9.59	9.31	9.39	391800.0
2006-11-27	CEF	ETF	9.9	10.33	9.81	10.28	1987400.0
2006-11-27	CEW	ETF	25.54	25.55	25.5	25.55	2700.0
2006-11-27	CFO	ETF	10.85	10.87	10.85	10.87	5100.0
2006-11-27	CGO	ETF	16.02	16.4	15.99	16.03	30200.0
2006-11-27	CHB	ETF	9.21	9.34	8.77	8.86	1162100.0
2006-11-27	CHI	ETF	19.92	19.92	19.8	19.81	98800.0
2006-11-27	CHIC	ETF	29.74	30.23	28.78	29.36	791017.0
2006-11-27	CHY	ETF	16.85	16.99	16.85	16.93	96300.0
2006-11-27	CIL	ETF	25.93	26.13	25.93	26.0	2300.0
2006-11-27	CN	ETF	40.0	40.28	39.25	39.34	160900.0
2006-11-27	CNXT	ETF	2.24	2.28	2.18	2.18	15746499.0
2006-11-27	CPI	ETF	24.2	24.28	24.18	24.18	300.0
2006-11-27	CPST	ETF	1.34	1.35	1.28	1.29	1577760.0
2006-11-27	CSA	ETF	21.35	21.37	21.15	21.15	12200.0
2006-11-27	CSB	ETF	32.12	32.12	31.72	31.75	40200.0
2006-11-27	CSQ	ETF	15.31	15.38	14.99	15.25	810500.0
2006-11-27	CTEC	ETF	90.55	90.55	89.25	90.35	18227.600000000002
2006-11-27	CVY	ETF	26.42	26.42	26.03	26.1	34900.0
2006-11-27	DBC	ETF	25.15	25.29	24.99	25.16	165700.0
2006-11-27	DBV	ETF	25.0	25.0	24.9	24.98	46000.0
2006-11-27	DDM	ETF	7.25	7.25	7.0683	7.0708	1386000.0
2006-11-27	DES	ETF	19.1	19.1033	18.79	18.7967	99300.0
2006-11-27	DEW	ETF	59.8	59.8	59.25	59.3	13600.0
2006-11-27	DFE	ETF	61.3	61.3	60.79	60.8	5800.0
2006-11-27	DFJ	ETF	48.35	48.35	47.73	47.73	52900.0
2006-11-27	DGT	ETF	74.55	74.55	73.71	73.95	13800.0
2006-11-27	DHS	ETF	56.7	56.7	55.87	55.96	44100.0
2006-11-27	DIM	ETF	60.56	60.56	59.97	60.07	32900.0

> showing 50 of 385 rows — these rows as CSV

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