PREVIEW / etf_daily / 2006-02-09

all etf daily files

  file:    by_date/etf_daily/2006/2006-02-09.parquet
  size:    16 KB
  rows:    300

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-02-09	SPY	ETF	126.92	127.6	126.37	126.41	62023300.0
2006-02-09	QQQ	ETF	41.2	41.37	40.63	40.71	78220268.0
2006-02-09	IWM	ETF	71.78	72.34	71.24	71.33	33152400.0
2006-02-09	DIA	ETF	108.81	109.56	108.67	108.84	7852600.0
2006-02-09	GLD	ETF	55.72	56.45	55.55	56.18	5299300.0
2006-02-09	TLT	ETF	90.14	90.9	90.06	90.8	1119200.0
2006-02-09	AAA	ETF	54.3	54.3	54.0	54.041	2900.0
2006-02-09	ADRE	ETF	127.0	128.0705	126.5101	126.85	26184.0
2006-02-09	AFK	ETF	25.35	25.41	25.35	25.35	7900.0
2006-02-09	AGG	ETF	100.13	100.25	99.91	100.15	144200.0
2006-02-09	AIQ	ETF	20.9	22.0	20.7	21.25	24960.0
2006-02-09	AIS	ETF	1.4	1.44	1.36	1.43	58200.0
2006-02-09	AOM	ETF	5.56	5.56	5.5	5.53	12300.0
2006-02-09	ARB	ETF	38.85	39.16	38.55	38.82	164500.0
2006-02-09	BAB	ETF	56.33	56.7	55.88	56.29	22700.0
2006-02-09	BBC	ETF	16.45	16.54	15.8	16.06	198400.0
2006-02-09	BBH	ETF	63.8667	64.1533	62.9867	63.1333	2767500.0
2006-02-09	BCM	ETF	68.79	68.97	68.41	68.6	78600.0
2006-02-09	BITS	ETF	24.48	24.716	23.828	24.4	46513.0
2006-02-09	BKF	ETF	13.85	13.94	13.51	13.63	127000.0
2006-02-09	BNE	ETF	15.0	15.1	14.9	14.95	81800.0
2006-02-09	BOSS	ETF	34.58	34.58	34.22	34.22	200.0
2006-02-09	BRF	ETF	15.5	15.5	15.36	15.36	1100.0
2006-02-09	BTF	ETF	84.74999999999999	85.25	84.45	85.25	56200.0
2006-02-09	CBON	ETF	30.7	30.7	30.32	30.33	1700.0
2006-02-09	CDL	ETF	11.65	11.89	11.65	11.71	596400.0
2006-02-09	CEF	ETF	7.48	7.77	7.47	7.71	670900.0
2006-02-09	CEW	ETF	26.35	26.6	26.35	26.6	600.0
2006-02-09	CFO	ETF	10.05	10.05	10.04	10.04	20200.0
2006-02-09	CGO	ETF	14.17	14.25	14.09	14.18	35600.0
2006-02-09	CHB	ETF	14.52	14.83	14.32	14.66	2056400.0
2006-02-09	CHI	ETF	20.4	20.55	20.4	20.46	91200.0
2006-02-09	CHIC	ETF	16.93	17.2	16.89	17.11	255892.0
2006-02-09	CHIR	ETF	45.57	45.6999	45.42	45.57	915654.0
2006-02-09	CHY	ETF	16.1	16.18	16.061	16.15	82500.0
2006-02-09	CIL	ETF	25.47	25.47	25.47	25.47	1000.0
2006-02-09	CN	ETF	32.52	32.76	32.41	32.66	28000.0
2006-02-09	CNXT	ETF	3.06	3.1001	2.96	2.98	19080936.0
2006-02-09	COMB	ETF	8.56	8.56	8.56	8.56	4000.0
2006-02-09	CPST	ETF	3.57	3.6491	3.4415	3.55	2898827.0
2006-02-09	CSA	ETF	18.69	18.69	18.5	18.5	12600.0
2006-02-09	CSB	ETF	31.6	31.79	31.6	31.64	6600.0
2006-02-09	CSM	ETF	2.485	2.485	2.4725	2.4725	42000.0
2006-02-09	CSQ	ETF	13.92	13.93	13.81	13.93	309300.0
2006-02-09	CTEC	ETF	54.199999999999996	54.199999999999996	53.75	54.1	7041.0
2006-02-09	CURE	ETF	0.03	0.0311	0.0288	0.03	1078056.0
2006-02-09	CYB	ETF	4.2	4.25	4.15	4.15	91600.0
2006-02-09	DBC	ETF	23.56	23.82	23.51	23.62	694000.0
2006-02-09	DGT	ETF	65.94	66.22	65.94	65.97	30800.0
2006-02-09	DIG	ETF	17.025	17.025	17.0	17.0	2800.0

> showing 50 of 300 rows — these rows as CSV

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