PREVIEW / etf_daily / 2006-06-09

all etf daily files

  file:    by_date/etf_daily/2006/2006-06-09.parquet
  size:    17 KB
  rows:    325

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-06-09	SPY	ETF	126.36	126.96	125.29	125.35	94972200.0
2006-06-09	QQQ	ETF	38.54	38.74	38.11	38.15	144146189.0
2006-06-09	IWM	ETF	70.55	71.1	69.42	69.54	63028400.0
2006-06-09	DIA	ETF	109.43	109.75	108.68	108.83	7295800.0
2006-06-09	GLD	ETF	61.17	61.38	59.71	60.45	7414800.0
2006-06-09	TLT	ETF	85.35	85.82	85.35	85.72	657200.0
2006-06-09	AAA	ETF	56.82	57.01	56.52	56.62	9300.0
2006-06-09	ADRE	ETF	116.75	118.236	114.99	114.99	90064.0
2006-06-09	AFK	ETF	25.26	25.37	25.26	25.32	5600.0
2006-06-09	AGG	ETF	98.11	98.41	98.11	98.37	166800.0
2006-06-09	AIQ	ETF	28.45	29.25	28.0	28.8	16340.0
2006-06-09	AIS	ETF	1.3	1.33	1.25	1.3	162000.0
2006-06-09	AOM	ETF	7.09	7.27	7.08	7.27	3600.0
2006-06-09	ARB	ETF	39.02	39.05	38.29	38.49	210200.0
2006-06-09	BAB	ETF	62.76	63.15	62.29	62.3	22900.0
2006-06-09	BBC	ETF	8.95	9.45	8.95	9.17	272100.0
2006-06-09	BBH	ETF	58.2367	58.77	57.6733	57.6733	2697900.0
2006-06-09	BCM	ETF	71.26	71.56	70.77	71.28	30200.0
2006-06-09	BITS	ETF	24.08	24.64	23.16	24.2	20196.0
2006-06-09	BKF	ETF	6.43	6.75	6.39	6.71	78600.0
2006-06-09	BNE	ETF	14.34	14.45	13.64	13.86	202900.0
2006-06-09	BRF	ETF	13.93	14.04	13.93	13.93	12100.0
2006-06-09	BTF	ETF	88.49999999999999	88.85	88.1	88.85	1540.0
2006-06-09	CBON	ETF	31.0	31.0	30.57	30.6	8766.0
2006-06-09	CDL	ETF	9.75	10.08	8.85	8.87	243500.0
2006-06-09	CEF	ETF	8.75	9.05	8.75	8.78	550100.0
2006-06-09	CEW	ETF	25.75	25.75	25.75	25.75	100.0
2006-06-09	CFO	ETF	10.0	10.0	10.0	10.0	10000.0
2006-06-09	CGO	ETF	14.54	14.7	14.4	14.55	17300.0
2006-06-09	CHB	ETF	11.44	11.44	11.05	11.15	1044700.0
2006-06-09	CHI	ETF	19.55	19.69	19.55	19.69	50200.0
2006-06-09	CHIC	ETF	20.13	20.53	20.1	20.33	210026.0
2006-06-09	CHY	ETF	16.65	16.67	16.55	16.65	115600.0
2006-06-09	CIL	ETF	25.05	25.05	25.05	25.05	200.0
2006-06-09	CN	ETF	32.08	32.81	32.0	32.0	34300.0
2006-06-09	CNXT	ETF	2.585	2.65	2.4	2.42	15277374.0
2006-06-09	COMB	ETF	10.0	10.0	9.88	9.88	18800.0
2006-06-09	CPST	ETF	2.69	2.78	2.6	2.63	1871608.0
2006-06-09	CSA	ETF	18.3	18.6	18.25	18.4	2800.0
2006-06-09	CSB	ETF	27.89	27.89	27.57	27.6	3500.0
2006-06-09	CSQ	ETF	14.05	14.05	13.9	13.98	182800.0
2006-06-09	CTEC	ETF	70.44999999999999	71.25	69.8	70.55	8442.0
2006-06-09	CYB	ETF	5.69	5.85	5.69	5.75	18100.0
2006-06-09	DBC	ETF	25.15	25.3	25.0	25.02	343800.0
2006-06-09	DGT	ETF	66.25	66.26	65.85	65.97	1600.0
2006-06-09	DIG	ETF	17.7125	17.7125	17.7	17.7	400.0
2006-06-09	DIV	ETF	12.0	12.03	11.96	11.97	10100.0
2006-06-09	DJP	ETF	49.45	49.62	48.85	48.85	41200.0
2006-06-09	DRIV	ETF	39.24	40.19	38.79	39.17	623679.0
2006-06-09	DSI	ETF	6.325	6.325	6.325	6.325	6000.0

> showing 50 of 325 rows — these rows as CSV

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