PREVIEW / etf_daily / 2006-03-16

all etf daily files

  file:    by_date/etf_daily/2006/2006-03-16.parquet
  size:    16 KB
  rows:    308

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-03-16	SPY	ETF	131.01	131.47	130.84	131.03	65526400.0
2006-03-16	QQQ	ETF	41.85	41.9201	41.33	41.37	101385916.0
2006-03-16	IWM	ETF	74.2	74.5	73.77	73.77	32559900.0
2006-03-16	DIA	ETF	112.49	112.96	112.43	112.77	6334700.0
2006-03-16	GLD	ETF	55.15	55.34	54.49	55.34	3342200.0
2006-03-16	TLT	ETF	88.51	89.33	88.43	89.12	1048000.0
2006-03-16	AAA	ETF	60.02	60.61	59.75	59.75	5200.0
2006-03-16	ADRE	ETF	129.87	129.87	127.7601	128.26	67036.0
2006-03-16	AFK	ETF	25.06	25.14	25.06	25.13	8400.0
2006-03-16	AGG	ETF	99.61	99.88	99.53	99.82	122000.0
2006-03-16	AIQ	ETF	30.2	30.7	30.0	30.5	18920.0
2006-03-16	AIS	ETF	1.45	1.58	1.45	1.55	1216800.0
2006-03-16	AOM	ETF	6.73	6.81	6.65	6.71	22200.0
2006-03-16	ARB	ETF	34.44	34.75	34.28	34.7	370400.0
2006-03-16	BAB	ETF	60.28	61.22	60.28	60.89	64500.0
2006-03-16	BBC	ETF	15.1	15.7	14.9	15.5	455300.0
2006-03-16	BBH	ETF	65.2433	65.33	64.5	64.7433	1805700.0
2006-03-16	BCM	ETF	73.45	74.05	73.3	73.51	18200.0
2006-03-16	BITS	ETF	30.36	31.08	29.08	30.12	31859.0
2006-03-16	BKF	ETF	12.92	13.08	12.8	12.84	24500.0
2006-03-16	BNE	ETF	15.04	15.22	14.98	15.02	150700.0
2006-03-16	BRF	ETF	14.11	14.32	14.11	14.32	18000.0
2006-03-16	BTF	ETF	88.0	88.55	88.0	88.49999999999999	15040.0
2006-03-16	CBON	ETF	31.82	32.0	31.1	31.46	7279.0
2006-03-16	CDL	ETF	11.45	11.49	11.32	11.33	364200.0
2006-03-16	CEF	ETF	7.91	8.0	7.82	7.9	535500.0
2006-03-16	CGO	ETF	14.41	14.44	14.33	14.4	28500.0
2006-03-16	CHB	ETF	15.32	15.64	15.2	15.32	708400.0
2006-03-16	CHI	ETF	20.74	20.85	20.7	20.73	88700.0
2006-03-16	CHIC	ETF	18.4	18.73	18.4	18.52	136779.0
2006-03-16	CHIR	ETF	45.5799	45.6999	45.2799	45.51	1251794.0
2006-03-16	CHY	ETF	16.41	16.5299	16.41	16.4301	86400.0
2006-03-16	CIL	ETF	25.59	25.59	25.59	25.59	400.0
2006-03-16	CN	ETF	34.7	34.83	34.52	34.59	32300.0
2006-03-16	CNXT	ETF	3.33	3.33	3.11	3.17	14369930.0
2006-03-16	CPI	ETF	32.0	32.0	31.51	31.6	800.0
2006-03-16	CPST	ETF	3.225	3.45	3.17	3.38	4993113.0
2006-03-16	CSA	ETF	20.2	21.25	20.2	21.15	21900.0
2006-03-16	CSB	ETF	31.32	31.57	31.21	31.4	11100.0
2006-03-16	CSQ	ETF	14.09	14.14	14.02	14.06	346300.0
2006-03-16	CTEC	ETF	58.9505	59.45	55.99999999999999	56.65	13879.0
2006-03-16	CYB	ETF	6.2	6.25	6.17	6.24	50800.0
2006-03-16	DBC	ETF	23.23	23.48	23.09	23.43	642100.0
2006-03-16	DGT	ETF	68.1	68.22	68.08	68.16	3100.0
2006-03-16	DIV	ETF	12.45	12.49	12.37	12.46	31800.0
2006-03-16	DRIV	ETF	40.82	40.97	39.69	39.84	1006633.0
2006-03-16	DSI	ETF	6.285	6.295	6.285	6.285	6200.0
2006-03-16	DUSA	ETF	7.2	7.2	6.8	6.88	275021.0
2006-03-16	DVY	ETF	63.73	64.18	63.73	64.0	456900.0
2006-03-16	EDEN	ETF	0.82	0.85	0.77	0.8	56117.0

> showing 50 of 308 rows — these rows as CSV

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